Tag: web technology

Quizzes (208) Questions (4176)

Questions Related to web technology

Multiple choice technology web technology

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?

  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
Reveal answer Fill a bubble to check yourself
B Correct answer
Full explanation
Multiple choice technology web technology

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?

  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
Reveal answer Fill a bubble to check yourself
C Correct answer
Full explanation
Multiple choice technology web technology

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?

  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
Reveal answer Fill a bubble to check yourself
A Correct answer
Full explanation
Multiple choice technology web technology

What is bcp utility in SQL Server 2005?

  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
Reveal answer Fill a bubble to check yourself
A Correct answer
Full explanation
Multiple choice technology web technology

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?

  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
Reveal answer Fill a bubble to check yourself
C Correct answer
Full explanation