×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
In an SQL Server, which of the following will ensure that the backup mode contains only the updated data since the last backup?
2.
What is the output of the following command:
In an SQL Server, consider the following trigger on the sales table:
Create trigger trgSalesDel
On DB_Sales
For delete
As
Rollback transactionDelete DB_Sales
Where datepart(yy,tran_dt) < 20003.
You are mastering a database, with an SQL Server computer named SQLTEST1. The master database on SQLTEST1 is down. An SQL Server agent job should be included in the SQLTEST1. The whole database should be backed up every day. Which of the following will you perform to rebuild and restore the master database and make sure that SQLTEST1 functioned as it did before the database was lost?
4.
You are mastering the company database. You should back up the database every day. You should also make transaction log backups every afternoon and morning. You should know that the content of the log will get larger and larger. You should take measure to do the log file. Which of the following is the correct answer?
5.
You are a professional level SQL Sever 2008 Database Administrator. All data changes are implemented through stored procedures, and only the INSERT, UPDATE, or DELETE statements are utilized by the procedures. A backup strategy should be implemented. The business requirements listed below should be satisfied: Point-in-time recovery for failure is supported by the backup strategy at any time of day. The least amount of disk space should be utilized by the transaction log. Which action should you perform to finish the task?
6.
You are a professional level SQL Sever 2008 Database Administrator. The computer on which the instance run has the following three features: 64-GB RAM, four quad-core processors, and several independent physical raid volumes A transactional database will be implemented on the instance. In addition, the database should have a high volume of INSERT, UPDATE, and DELETE activities, creation of new tables is contained by the activities. You need to maximize disk bandwidth and decrease the contention in the storage allocation structures so as to have the performance of the database optimized. Which action will you perform to finish the task?
7.
You are a professional level SQL Sever 2008 Database Administrator. You are experienced in managing databases in an enterprise-level organization,optimizing and sustaining the database life cycle. In the company, your job is to implement solutions on security, troubleshooting, deployment and optimization. A SQL Server 2008 infrastructure is managed by you. A database is utilized by the instance, and the database is utilized by a Web-based application. 15,000 transactions are processed by the application every minute. A column is contained by a table in the database, and the column is utilized only by the application. Sensitive data is stored in this column. The sensitive data should be stored with the highest security level. In addition, the least amount of memory space and processor time should be utilized. From the following four encryption types, which one should you utilize?
8.
You are a professional level SQL Sever 2008 Database Administrator. A maintenance strategy should be designed for a mission-critical database, and a large table named Orders is contained by the database. Index maintenance operations are contained in the design plan. When you design the strategy, the facts listed below should be taken into consideration. First, the users continuously access to the Orders table in the database. Secondly, a column of the xml data type is contained by Orders table. Thirdly, the new rows are regularly added to the Orders table. Fourthly, the average fragmentation for the clustered index of the Orders table is no more than 2 percent. A strategy should be designed to have the performance of the queries on the table optimized. Which action will you perform?
9.
You are a professional level SQL Sever 2008 Database Administrator in an international
corporation named Wiikigo.
You are experienced in managing databases in an enterprise-level organization,optimizing and
sustaining the database life cycle. In the company, your job is to implement solutions on security,
troubleshooting, deployment and optimization.
A SQL Server 2008 infrastructure is managed by you. A corporate backup and recovery strategy
that has to be validated is designed.
You are required to make sure that any single database can be restored successfully from a
severe failure, and during the restoration, a backup data center should not be required in a
different location.
Which three actions should be contained by your solution? (Choose more than one)
10.
You are a professional level SQL Sever 2008 Database Administrator in an international corporation named Wiikigo. A 32-bit version is utilized by the instance on a Windows Server 2008 64-bit server. You activate the awe enabled option. A predictable increase in query activity will be experienced by the instance. You are required to figure out the most proper and beneficial time to have the databases migrated to a 64-bit SQL Server 2008 server on the same hardware. A data collector type that proper information is provided should be identified. What kind of collector should you utilize?