Tag: web technology

Questions Related to web technology

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

You use the bcp utility to import data during nonworking hours. After importing data into the database, you execute a full backup statement. You need to ensure that the impact on the database during the insert is reduced to a minimum. Which of the following options can help you achieve that?
technology web technology

  1. Set the recovery model to Full

  2. Set the recovery model to Simple

  3. Set the recovery model to Bulk-Logged

  4. Back up the transaction log while performing the inserts

Show answer
Correct Option: C

Which type of index physically orders the rows in a table?
technology web technology

  1. Unique Index

  2. Clustered Index

  3. Non-Clustered Index

  4. Foreign Key

Show answer
Correct Option: B

White space programming is
technology web technology

  1. Object oriented programming

  2. Subject oriented programming

  3. Video game programming

  4. Esoteric programming

Show answer
Correct Option: D

A message containing information for which no response is expected.
technology web technology

  1. Datagram

  2. Request

  3. Response

  4. Report

Show answer
Correct Option: A