0

databases Online Quiz - 130

Description: databases Online Quiz - 130
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

Stored procedures are compiled the first time they’re run but are not stored in a system table of the current database.

  1. True

  2. False


Correct Option: B
  1. Syntax Checking

  2. Semantic Analysis

  3. Both

  4. Checking the shared pool

  5. All of the above


Correct Option: E

Select the steps involved in executing statements in Oracle

  1. Parsing

  2. Optimization

  3. Row source generation

  4. Statement execution

  5. All of the above


Correct Option: E

What is a catalog??

  1. Multiple rows

  2. Multiple coulumns

  3. Multiple schemas

  4. Multiple tables


Correct Option: C

How many default instances can you install on a single SQL Server server?

  1. 1

  2. 2

  3. 3

  4. 4


Correct Option: A

Which authentication mode lets you use both SQL Server logins and Windows logins?

  1. Kerebos authentication

  2. Windows

  3. Mixed Mode

  4. Network Service account


Correct Option: C

Which SQL Server 2005 services require that you install them with their own account? (Choose all that apply.)

  1. SQL Server Agent

  2. Log Reader Agent

  3. SQL Server

  4. Replication Agent


Correct Option: A,C

The term “in-place upgrade” refers to which type of upgrade?

  1. Installing SQL Server 2005 in the same directory as the current installation and replacing the SQL Server files

  2. Installing a new instance of SQL Server 2005 and sharing the older databases between the new instance and the old instance

  3. Installing a new instance of SQL Server 2005 on the same server as the old instance and moving the databases from the old instance to the new instance

  4. Installing a new instance of SQL Server 2005 on a different server from the old instance and moving the databases from the old server to the new server


Correct Option: A

Which of the following statements can you use to create a filegroup?

  1. ALTER DATABASE … ADD FILE

  2. ALTER DATABASE … MODIFY FILEGROUP

  3. ALTER DATABASE … ADD FILEGROUP

  4. ALTER DATABASE … REMOVE FILEGROUP


Correct Option: C
- Hide questions