You have two existing tables, one named COUNTRY and the other named STATES. The tables are defined as follows: You need to set up a rule that every STATE.Country_Abbr must match an existing record in the COUNTRY table. Develop the…
You plan to deploy two stored procedures name USP_1 and USP_2 that read data from a database. Your company identifies the following requirements for each stored procedure: USP_1 cannot allow dirty reads. USP_2 must place range locks on the data…
You plan to deploy SQL Server 2012. You must create two tables named Table1 and Table2 that will have the following specifications: Table1 will contain a date column named Column1 that will contain a null value approximately 80 percent of…
You are planning two stored procedures named SProc1 and SProc2. You identify the following requirements: SProc1 must return a table. SProc2 must return a scalar value. You need to identify which option must be implemented for each stored procedure to…
You have a SQL Server 2012 database named Database1. Database1 has a data file named database1_data.mdf and a transaction log file named database1_Log.ldf. Database1_Data.mdf is 1.5 GB. Database1_Log.ldf is 1.5 terabytes. A full backup of Database1 is performed every day.…
You plan to create a new table that will contain a column named Salary. Salary will contain highly sensitive data. Salary must meet the following requirements: Contain numeric data. Contain only encrypted data that remains encrypted in memory. You need…
Your network contains a SQL Server 2012 instance named SQL1. SQL1 contains a database named DB1. DB1 contains three tables. The tables are configured as shown in the following table. You plan to create indexes for the tables. You need…
You create a table that contains the following script: You need to prevent duplicate values in the EmployeeID field. Which five code segments should you use? To answer, move the appropriate code segments from the list of code segments to…
You have a database named database1. Each table in database1 has one index per column. Users often report that creating items takes a long time. You need to perform the following maintenance tasks: • Identify unused indexes. • Identify indexes…
You have a database that contains three tables. The tables are configured as shown in the following table. You have the following query: The execution plan for the query is shown in the exhibit. (Click the Exhibit button.) You need…