70-461

You use Microsoft SQL Server 2012 to develop a database application. You create a stored procedure named DeleteJobCandidate. You need to ensure that if DeleteJobCandidate encounters an error, the execution of the stored procedure reports the error number. Which Transact-SQL statement should you use?A . DECLARE @ErrorVar INT; DECLARE @RowCountVar...

You support a database structure shown in the exhibit. (Click the Exhibit button.) You need to write a query that displays the following details: • Total sales made by sales people, year, city, and country • Sub totals only at the city level and country level • A grand total...

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...

You develop a Microsoft SQL Server 2012 database. The database is used by two web applications that access a table named Products. You want to create an object that will prevent the applications from accessing the table directly while still providing access to the required data. You need to ensure...

You develop a database for a travel application. You need to design tables and other database objects. You create a stored procedure. You need to supply the stored procedure with multiple event names and their dates as parameters. What should you do?A . Use the CAST function.B . Use the...

You develop a Microsoft SQL Server 2012 database. The database is used by two web applications that access a table named Products. You want to create an object that will prevent the applications from accessing the table directly while still providing access to the required data. You need to ensure...

You administer a Microsoft SQL Server 2012 database that includes a table named Products. The Products table has columns named ProductId, ProductName, and CreatedDateTime. The table contains a unique constraint on the combination of ProductName and CreatedDateTime. You need to modify the Products table to meet the following requirements: •...

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 . DecimalView AnswerAnswer: D Explanation: Decimal is the only one in...

You administer a Microsoft SQL Server 2012 database that has multiple tables in the Sales schema. Some users must be prevented from deleting records in any of the tables in the Sales schema. You need to manage users who are prevented from deleting records in the Sales schema. You need...

You develop a Microsoft SQL Server 2012 database. You create a view that performs the following tasks: • Joins 8 tables that contain up to 500,000 records each. • Performs aggregations on 5 fields. The view is frequently used in several reports. You need to improve the performance of the...