Passtcert Microsoft MTA 98-364 certification guides praised by the majority of candidates is not a recent thing. This shows Passtcert Microsoft MTA 98-364 certification guides can indeed help the candidates to pass the exam. Compared to other questions providers, Passtcert Microsoft MTA 98-364 certification guides have been far ahead. uestions broad consumer recognition and reputation, it has gained a public praise.
Share some MTA 98-364 exam questions and answers below.
Which key uniquely identifies a row in a table?
A. foreiqn
B. primary
C. local
D. superkey
Answer: B
You have the following table definition:
CREATE TABLE Road
(RoadID INTEGER NOT NULL,
Distance INTEGER NOT NULL)
The Road table contains the following data:
You execute the following statement:
INSERT INTO Road VALUES (1234, 36)
What is the result?
A. an error stating that NULL values are not allowed
B. a new row in the table
C. an error stating that duplicate IDs are not allowed
D. a syntax error
Answer: B
You have a table named Product. You create a view that includes all the products from the Product table that are in the Furniture category. You execute a statement on the Product table that deletes all the products in the Furniture category.
After you execute the statement, the result set of the view is:
A. empty.
B. deleted.
C. unchanged.
D. archived.
Answer: A
Which statement will result in the creation of an index?
A. Option A
B. Option B
C. Option C
D. Option D
Answer: A
You have two tables. Each table has three rows.
How many rows will be included in the Cartesian product of these two tables?
A. 0
B. 3
C. 6
D. 9
Answer: D
No comments:
Post a Comment