تبلیغات
پایگاه داده - سوالات تفکیکی (3) :
قالب وبلاگ قالب وبلاگ

پایگاه داده
آزمایشگاه پایگاه داده
 


 
نوشته شده در تاریخ یکشنبه 15 خرداد 1390 توسط
برای دریافت پرسشهای استاندارد بخش سوم به ادامه مطلب مراجعه فرمایید:

SQL Server Administration Quiz

There are 20 questions in this quiz. Good luck! 
Passing grade is 70% = C.
1) Your SQL Server is running SQL 6.5 and you want to transfer the data from the SQL 6.5 server to a new SQL 7 Server. How can you do this?
       a)  Using DTS Import
       b)  Using bcp -out and use bcp -in to insert the data into the new SQL 7 Server
       c)  Use the DTS Export
       d)  Using bcp -copy, copy the data from the SQL 6.5 Server to the SQL 7 Server
       e)  Both A and B


2) You start SQL-Server with the -f option. Unfortunately now you can't establish a connection to your SQL-Server. What should you do?
       a)  Rebuild Master database
       b)  Edit registry
       c)  Run regrebld.exe
       d)  Restore registry from backup


3) What SQL Server protocol must be installed to communicate via SQL Server with a Unix application?
       a)  TCP/IP
       b)  Unix Command Protocol
       c)  Multiprotocol
       d)  Named Pipes


4) You friend is trying to familiarize herself with the DBCC commands with SQL server. Which command can she/he use to check if indexes are in the proper sorted order and if page offsets are reasonable?
       a)  DBCC CHECKDB
       b)  DBCC NEWALLOC
       c)  DBCC CHECKALLOC
       d)  DBCC CHECKCATALOG


5) The SQL server that you've manages crashed. The disk drives were not damaged but there was data that had not been written to some databases. Which transactions will be rolled forward in each database when his SQL server starts the automatic recovery proce
       a)  All committed transactions that are in the transaction log
       b)  All uncommitted transactions that are in the transaction log
       c)  All committed transactions that are in the transaction log between the last checkpoint and the failure
       d)  All committed transactions that are in the transaction log between the last two checkpoints


6) You want to prevent long-running queries from executing. How would you do this?
       a)  Run the stored procedure set query governor cost limit.
       b)  Modify the configuration parameter min memory per query.
       c)  Modify the configuration parameter show advanced options.
       d)  Modify the configuration parameter query governor cost limit.
       e)  Both C and D


7) You've just installed SQL Server 7 on a NT server using the Typical Installation option. When you start SQL for the first time, you get an error and it will not start. Where is one place you would check to see what is causing the error?
       a)  C:MSSQL7LOGERROR.LOG
       b)  C:MSSQL7ERROR.LOG
       c)  C:MSSQL7SQLSTP.LOG
       d)  Windows NT Event Log-Application Log
       e)  Windows NT Event Log-System Log


8) Under what occasions does the SQL Server 7 write events to the Windows NT application log?
       a)  When the xp_logevent stored procedure is invoked
       b)  When sp_addmessage or sp_altermessage define errors to be written to the NT application log
       c)  When SQL Server errors occur with severity levels between 19 and 25
       d)  When the RAISEERROR WITH LOG statement is executed
       e)  All of the above


9) After installing SQL 7, you want to connect to the SQL 7 Server to verify installation. What graphical tools would you use to verify that the server is running?
       a)  SQL Server Enterprise Manager
       b)  SQL Server Transact
       c)  SQL Server Network Client
       d)  SQL Server Query Analyzer
       e)  Both A and D


10) What functions are performed by the SQL Server Agents?
       a)  Replication management
       b)  Job execution
       c)  Notification
       d)  Alert management
       e)  All of the above


11) You define full-text indexing on the ProductName column in the Products table. You then execute a full-text query on the column. You specify a word that you know is present in the column, but the result set is empty. What is the most likely cause?
       a)  The catalog is not populated
       b)  You did not create a unique SQL Server index on the ProductName column
       c)  The SQL ServerAgent Service is not running
       d)  The Microsoft Service is not running


12) A client connecting to a SQL Server database from a Windows 98 workstation is able to connect in a Windows NT authentication mode. True or false?
       a)  True
       b)  False


13) John Doe has SQL Server 4.2 and she wants to upgrade the server, data and database objects to SQL Server 7. Which upgrade path will accomplish this goal?
       a)  Just upgrade normally to SQL Server 7
       b)  Use SQL 6.5 Transfer Management Tool to push the data and objects from version 4.2 to 7
       c)  Upgrade the server to SQL Server 6.5, then upgrade again to SQL Server 7
       d)  Use the DTS to transfer the data and objects


14) John Doe wants to establish a replication model that will allow three branch offices to update data at the corporate site. Which replication model should John Doe use?
       a)  Remote replication
       b)  Snapshot replication
       c)  Transactional replication
       d)  Merge replication


15) Which of the following SQL Server services are installed during the Typical installation option on a NT Server?
       a)  SQL Server Agent
       b)  MS DTC
       c)  MSSQL Server
       d)  All of the above


16) Exchange and SQL 7.0 are running on the same server. You notice the performance in exchange is degraded. The Min server memory, Maximum server memory and set working area are set as they were automatically in the installation. What do you do to free memor
       a)  Increase Min server memory
       b)  Set working area to 1
       c)  Set working area to 0
       d)  Increase memory allocated to the procedure cache option
       e)  Reduce Min server memory


17) The step object in a DTS (data transformation service) package can run in parallel when there are no precedence constraints on it. Which of the following are step object precedence constraints?
       a)  On failure
       b)  Return codes
       c)  On success
       d)  All of the above


18) Which of the four system databases stores all the information about alerts and jobs?
       a)  Msdb
       b)  Tempdb
       c)  Master
       d)  Model


19) You have been asked to copy a one-table Access database to another table that exists in a SQL Server 7 database. What is the best method you should use to copy the data?
       a)  The copy_db command at a command prompt
       b)  Data Transformation Services
       c)  The oslp utility
       d)  Data Transfer System
       e)  The BULK INSERT statement


20) You must restore the MASTER database from a backup on a SQL 7 computer. You attempt to start the restore process but receive an error message. What must you do before you can restore the MASTER database?
       a)  Run the rebuild.exe program
       b)  Drop the MASTER database
       c)  Run the reblddb.exe program
       d)  Run the sqlservr.eve program with the -m option




.: Weblog Themes By Pichak :.


تمامی حقوق این وبلاگ محفوظ است | طراحی : پیچک
قالب وبلاگقالب وبلاگ