Tag: technology

Questions Related to technology

Which SQL Server 2005 tool helps in running T-SQL queries from command prompt?

technology web technology

  1. DTUTIL

  2. BCP

  3. Object Explorer

  4. None of the above

Show answer
Correct Option: D

Choose the third option
technology testing

  1. one

  2. 2

  3. 3

  4. 4

Show answer
Correct Option: C

What are the requirements to create a CLR based user-defined type?
technology web technology

  1. The CLR must be enable for the database

  2. The CLR must be enabled for the instance

  3. A class created with a Microsoft .NET language

  4. A class created with a CLR-compatible language

Show answer
Correct Option: B

Which TCP/IP port does SQL Server run on?
technology web technology

  1. 143

  2. 1433

  3. 1432

  4. 142

Show answer
Correct Option: B

If you want to let a member of your technical support staff back up a database without having to grant any other permission to a database or SQL Server instance, to which role should you add the staff member?
technology web technology

  1. sysadmin

  2. db_owner

  3. db_accessadmin

  4. db_backupoperator

Show answer
Correct Option: D

Which of the following objects can you use in a check constraint?

technology web technology

  1. System Function

  2. Stored procedure

  3. User-Defined-Function

  4. Views

Show answer
Correct Option: A

You perform a full backup of the Adventure Works database that completes at midnight. Differential backups are scheduled to run every four hours beginning at 04:00. Transaction log backups are scheduled to run every five minutes. What information does the transaction log backup created at 09:15 contain?
technology web technology

  1. All transactions that have been issued since 09:10

  2. Transactions that have been committed since 09:10

  3. Pages that have changed since 09:10

  4. Extents that have changed since 09:10

Show answer
Correct Option: B

One of your users has discovered some malicious updates to your data that occurred the day before at about 2 P.M. how can you return the database to the state it was in just before the update occurred?
technology web technology

  1. Perform a full database restoration with point-in-time recovery

  2. Perform a differential database restoration with point-in-time recovery

  3. Perform a transaction log restoration with point-in-time recovery

  4. You cannot return the database to the previous state

Show answer
Correct Option: C

You want to access data that is located on two SQL Server 2005 computers. One Server is SQL 1 and the other server is SQL 2. You have permissions to write a stored Procedure on SQL 1 but on SQL 2 you have only permission to select data. You write a stored procedure on SQL 1. The stored procedure accesses SQL 2 by OPENQUERY T-SQL Statement. The query fails. What should you do to solve the problem?

technology web technology

  1. Add SQL 2 as linked server to SQL 1

  2. Add SQL 2 as remote Server to SQL 1

  3. (c) Reference SQL 2 by an alias

  4. None of the above

Show answer
Correct Option: A

What is bcp utility in SQL Server 2005?
technology web technology

  1. Copies data between an instance of Microsoft SQL Server and a data file in a user-specified format

  2. Configures and executes a SQL Server Integration Services package

  3. Transact-SQL statements, system procedures, and script files at the command prompt are possible with this utility

  4. Runs scripts designed for managing Reporting Services report servers

Show answer
Correct Option: A