Which action should you take?

Correct Answer for the following Question is given below You are a database developer on an instance of SQL Server 2008. You have an Employee table created with the following statement:CREATE TABLE Employee (EmpID int IDENTITY(1,1) PRIMARY KEY,LastName varchar(35) NOT NULL,FirstName varchar(25) NOT NULL,HireDate datetime,Salary money,MgrID int);The MgrID column will contain the EmpID associated with … Read more

What should you recommend?

Correct Answer for the following Question is given below You are designing a table to store customer data. The table will contain a column to store the e-mail addresses of the customers.You need to recommend a solution to store the e-mail addresses. The solution must meet the following requirements:• E-mail addresses must contain the @ … Read more

Which isolation level should you use?

Correct Answer for the following Question is given below You are a database developer. You design a database solution by using SQL Server 2008.Your company has offices in Europe, Asia, North America, and Africa. The company data is updated for each region after business hours.The queries used by reports on the database are blocked when … Read more

You have to protect yourself against SQL injections what should you do:

Correct Answer for the following Question is given below You have to protect yourself against SQL injections what should you do:When you can, reject input that contains the following characters.• Query delimiter (;)• Character data string delimiter (‘)• Comment delimiter (–)• Comment delimiters.(/* … */) Text between /* and */ is not evaluated by the … Read more

Which action should you take?

Correct Answer for the following Question is given below You are a database developer on an instance of SQL Server 2008. Your Inventory database contains several tables that contain information related to historical inventory transactions.You have created a Transact-SQL stored procedure that will accept a component type, query the tables in the Inventory database, and … Read more

You have a table named SALES with the following columns:

Correct Answer for the following Question is given below You have a table named SALES with the following columns:SalesmanID | ProductsSold1 | 20002 | 40003 | 50004 | 50005 | 60006 | 60007 | 90008 | 9000You have to chose a query that will select all SalesmanIDs that have sold an amount of products within … Read more

Which statement should you use to create the view?

Correct Answer for the following Question is given below You are a database developer on an instance of SQL Server 2008. Your database contains the Employee table defined using the following Transact-SQL statement:CREATE TABLE dbo.Employee(EmpID int PRIMARY KEY,LastName varchar(35) NOT NULL,FirstName varchar(35) NOT NULL,HireDate datetime DEFAULT (GETDATE()),Status varchar(8) CHECK (Status IN (‘Active’, ‘Inactive’)),SSN char(9) NOT … Read more

Which action should you take?

Correct Answer for the following Question is given below You are a database developer on an instance of SQL Server 2008. Your database contains the Task and TaskType tables, which were defined with the following Transact-SQL statements:CREATE TABLE TaskType(TaskTypeID int PRIMARY KEY,Description varchar(40) NOT NULL);CREATE TABLE Task(TaskID int IDENTITY(1,1) PRIMARY KEY,Description varchar(50) NOT NULL,TaskTypeID int … Read more

Which Transact-SQL will execute successfully and create a table with a sparse column?

Correct Answer for the following Question is given below You are a database administrator on an instance of SQL Server. While creating a table, you decide to implement a sparse column.Which Transact-SQL will execute successfully and create a table with a sparse column?ID int IDENTITY(1,1),TranDate datetime,ProductID int SPARSE NOT NULL,Quantity smallint,ProdType char(2),ProdDetails varchar(max));ID int SPARSE … Read more