Share some MTA 98-364 exam questions and answers below.
The terms "bitmap," "b-tree," and "hash" refer to which type of database structure?
A. view
B. function
C. index
D. stored procedure
E. trigger
Answer: C
You are writing an SQL statement to retrieve rows from a table.
Which data manipulation language (DML) command should you use?
A. READ
B. SELECT
C. OUTPUT
D. GET
Answer: B
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 a table that contains the following data.
Which database term is used to describe the relationship between ProductID and ProductCategory?
A. cohort
B. relationally dependent
C. deterministic
D. functionally dependent
E. compositional
Answer: D
Which statement creates a composite key?
A. Option A
B. Option B
C. Option C
D. Option D
Answer: D
No comments:
Post a Comment