Which two activities indicate the need for a data warehouse? (Choose two.)
A. Summarize sales by region.
B. Identify patterns for products sold in the last five years.
C. Monitor product availability.
D. Confirm product inventory.
E. Associate one or more products with a purchase order.
正解:A,B
質問 2:
When is it appropriate to use a sequence?
A. When you want to control the order in which triggers are fired.
B. When you want to automatically generate a numeric value that is not tied to any specific column or table.
C. When you want to automatically generate a numeric value for each row that is added to a specific table.
D. When you want to control the order in which stored procedures can be invoked.
正解:B
質問 3:
The WITH CHECK OPTION clause of the CREATE VIEW statement allows you to do which of the following?
A. Ensure that any inserted or updated rows conform to the definition of the view.
B. Define a view on one or more tables or views.
C. Revalidate all invalid objects that are referenced on a view's fullselect.
D. Define a view that only consists of columns that have check constraints defined.
正解:A
質問 4:
In a trusted context environment, if a switch request is made with an authorization ID that is not allowed on a trusted connection, what state is the connection placed in?
A. Pending
B. Locked
C. Unconnected
D. Waiting
正解:C
質問 5:
Which isolation level offers the greatest protection of data but provides the least amount of concurrency?
A. Repeatable Read (RR)
B. Cursor Stability (CS)
C. Uncommitted Read (UR)
D. Read Stability (RS)
正解:A
質問 6:
What type of large object (LOB) is used to store LOB data together with the formatted rows on data pages, instead of in a separate LOB storage object?
A. internal
B. inline
C. binary
D. partitioned
正解:B