Which options should you set?
You have a single CLR assembly in your database. The assembly only references blessed assemblies from the Microsoft .NET Framework and does not access external resources.
You need to deploy this assembly by using the minimum required permissions. You must ensure that your database remains as secure as possible.
Which options should you set?
Which Transact-SQL statement should you use?
You are responsible for a SQL Server database. You require the tables to be added or altered only on the first day of the month. You need to ensure that if the tables are attempted to be modified or created on any other day, an error is received and the attempt is not successful.
Which Transact-SQL statement should you use?
What should you do?
You need to ensure that tables are not dropped from your database. What should you do?
Which Transact-SQL statement should you use?
Your database contains two tables named Order and OrderDetails that store order information. They relate to each other using the OrderID column in each table. Your business requires that the LastModifiedDate column in the Order table must reflect the date and time when a change is made in the OrderDetails table for the related order.
You need to create a trigger to implement this business requirement.
Which Transact-SQL statement should you use?
What should you do?
You have a third-party application that inserts data directly into a table.
You add two new columns to the table. These columns cannot accept NULL values and cannot use default constraints.
You need to ensure that the new columns do not break the third-party application.
What should you do?
Which option should you use when you create the function?
You are creating a function that references a table.
You need to prevent the table from being dropped.
Which option should you use when you create the function?
Which object should you use?
You need to identify, within a given clause, if the month of February will contain 29 days for a specified year.
Which object should you use?
Which combination should you use?
You have a computed column that is implemented with a user-defined function. The user-defined function returns a formatted account number. The column must be indexed to provide adequate search performance.
You plan to create an index on the computed column. You need to identify the valid combination of ObjectPropertyEX values for the user-defined function.
Which combination should you use?
Which code segment should you use?
You need to create a stored procedure that accepts a table-valued parameter named @Customers.
Which code segment should you use?
What should you do?
You have a SQL Server database. The database contains two schemas named Marketing and Sales.
The Marketing schema is owned by a user named MarketingManager. The Sales schema is owned by a user named SalesManager.
A user named John must be able to access the Sales.Orders table by using a stored procedure named Marketing.GetSalesSummary.
John is not granted a SELECT permission on the Sales.Orders table.
A user named SalesUser does have SELECT permission on the Sales.Orders table.
You need to implement appropriate permissions for John and the stored procedure Marketing.GetSalesSummary.
What should you do?