Tag: databases

Quizzes (243) Questions (4862)

Questions Related to databases

Multiple choice technology databases

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 the solve the problem?

  1. (a) Add SQL 2 as linked server to SQL 1

  2. (b) Add SQL 2 as remote Server to SQL 1

  3. (c) Reference SQL 2 by an alias

  4. (d) None of the above
Reveal answer Fill a bubble to check yourself
A Correct answer
Full explanation
Multiple choice technology databases

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 the solve the problem?

  1. (a) Add SQL 2 as linked server to SQL 1

  2. (b) Add SQL 2 as remote Server to SQL 1

  3. (c) Reference SQL 2 by an alias

  4. (d) None of the above
Reveal answer Fill a bubble to check yourself
A Correct answer
Full explanation
Multiple choice technology databases

Which is true for recovery models :

  1. (a) In the Bulk-Logged recovery model, all transactions are logged

  2. (b) In the Simple recovery model, all transactions are logged.

  3. (c) In the Full recovery model, most transactions are minimally logged

  4. (d) In the Simple recovery model, most transactions are minimally logged
Reveal answer Fill a bubble to check yourself
D Correct answer
Full explanation