- All Exams Instant Download
On which column in the Employee table should you use an identity specification to include a seed of 1,000 and an increment of 1?
You administer a Microsoft SQL Server 2012 database. The database contains a table named Employee. Part of the Employee table is shown in the exhibit. (Click the Exhibit button.) Unless stated above, no columns in the Employee table reference other tables. Confidential information about the employees is stored in a...
Which stored procedure option should you use?
You are a database developer at an independent software vendor. You create stored procedures that contain proprietary code. You need to protect the code from being viewed by your customers. Which stored procedure option should you use?A . ENCRYPTBYKEYB . ENCRYPTIONC . ENCRYPTBYPASSPHRASED . ENCRYPTBYCERTView AnswerAnswer: B Explanation: Reference: http://technet.microsoft.com/en-us/library/bb510663.aspx...
What should you do?
You have three tables that contain data for dentists, psychiatrists, and physicians. You create a view that is used to look up their email addresses and phone numbers. The view has the following definition: You need to ensure that users can update only the phone numbers and email addresses by...
Which Transact- SQL statement should you use?
You are a database developer of a Microsoft SQL Server 2012 database. You are designing a table that will store Customer data from different sources. The table will include a column that contains the CustomerID from the source system and a column that contains the SourceID. A sample of this...
Which Transact-SQL query should you use?
You administer a Microsoft SQL Server 2012 database named ContosoDb. Tables are defined as shown in the exhibit. (Click the Exhibit button.) You need to display rows from the Orders table for the Customers row having the CustomerId value set to 1 in the following XML format. Which Transact-SQL query...
Which Transact-SQL query should you use?
You administer a Microsoft SQL Server 2012 database named ContosoDb. Tables are defined as shown in the exhibit. (Click the Exhibit button.) You need to display rows from the Orders table for the Customers row having the CustomerId value set to 1 in the following XML format. Which Transact-SQL query...
What should you do?
You develop a database for a travel application. You need to design tables and other database objects. You create a view that displays the dates and times of the airline schedules on a report. You need to display dates and times in several international formats. What should you do?A ....
Which code segment should you use?
CORRECT TEXT You have a database that contains the tables shown in the exhibit. (Click the Exhibit button.) You deploy a new server that has SQL Server 2012 installed. You need to create a table named Sales.OrderDetails on the new server. Sales.OrderDetails must meet the following requirements: • Write the...
Which query should you use?
Your database contains two tables named DomesticSalesOrders and InternationalSalesOrders. Both tables contain more than 100 million rows. Each table has a Primary Key column named SalesOrderId. The data in the two tables is distinct from one another. Business users want a report that includes aggregate information about the total number...
Which data type should you use?
You are developing a database that will contain price information. You need to store the prices that include a fixed precision and a scale of six digits. Which data type should you use?A . FloatB . MoneyC . SmallmoneyD . NumericView AnswerAnswer: D Explanation: Numeric is the only one in...
