单项选择题

You need to ensure that old data and current data can be queried according to the business requirements. What should you do?（）

A.Specify a view based on the archival data table and current data tables.
B.Specify that the data must be queried by using a stored procedure.
C.Specify that both the archival data table and the current data tables must have indexes created on the same columns.
D.Specify that a SQL Server Agent job must be used to copy current data into the archival data table each night.

点击查看答案

上一题目录下一题

相关考题

多项选择题

You need to design the database permissions for access from the terminals to the database server. Which action or actions should you perform?（）

A.Create a database role named BankTerminals.
B.Grant the BankTerminals role the Execute permission for the WoodgroveBanking database.
C.Grant database access to the Windows Bank Terminals group， and add the group to the BankTerminals role.
D.Grant the BankTerminals role the Execute permission for the Bank schema.
E.Grant the Windows Bank Terminals group the Execute permission for the Bank schema.
F.Grant the BankTerminals role the Execute permission for all stored procedures and user-defined functions in the Bank schema.

多项选择题

You need to design the restrictions on the Bank.Customers table. Which three actions should you perform?（）

A.Design a trigger that verifies that the first names and surnames are not empty strings.
B.Design a check constraint that verifies that the first names and surnames are not empty strings.
C.Design a check constraint that uses a CLR user-defined function to verify that either the phone number is a null value or the format of the phone number is valid.
D.Design a trigger that uses a CLR user-defined function to verify that either the phone number is a null value or the format of the phone number is valid.
E.Design a check constraint that ensures that the phone number cannot be changed from a valid format to a null value or to an invalid format.
F.Design a trigger that ensures that the phone number cannot be changed from a valid format to a null value.

多项选择题

You need to design the storage of the loan response message. Which actions or actions should you perform?（）

A.Use the xml data type to store the message.
B.Use a user-defined data type to store the message.
C.Use the nvarchar（max） data type to store the message.
D.Use a check constraint to validate that the correct tags are used.
E.Use an XML schema definition （XSD） to validate that the correct tags are used.
F.Use a foreign key constraint to validate that the correct tags are used.