Tag: databases

Questions Related to databases

Main functions in parsing process are____
technology databases

  1. Syntax Checking

  2. Semantic Analysis

  3. Both

  4. Checking the shared pool

  5. All of the above

Show answer
Correct Option: E

___is the act of breaking the submitted statement down into its component parts, determining what type of statement it is (query, DML, or DDL), and performing various checks on it
technology databases

  1. Parsing

  2. Optimization

  3. Row source generation

  4. Statement execution

  5. All of the above

Show answer
Correct Option: A

Select the steps involved in executing statements in Oracle
technology databases

  1. Parsing

  2. Optimization

  3. Row source generation

  4. Statement execution

  5. All of the above

Show answer
Correct Option: E

View has no physical existence until it is called upon in a query
technology databases

  1. True

  2. False

Show answer
Correct Option: A

What is a catalog??
technology databases

  1. Multiple rows

  2. Multiple coulumns

  3. Multiple schemas

  4. Multiple tables

Show answer
Correct Option: C

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

  1. 1

  2. 2

  3. 3

  4. 4

Show answer
Correct Option: A

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

  1. Kerebos authentication

  2. Windows

  3. Mixed Mode

  4. Network Service account

Show answer
Correct Option: C

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

  1. SQL Server Agent

  2. Log Reader Agent

  3. SQL Server

  4. Replication Agent

Show answer
Correct Option: A,C

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

  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

Show answer
Correct Option: A

Which upgrade data-movement method requires that users not be accessing the database you want to upgrade?
technology databases

  1. Copy Database Wizard

  2. Detach/attach

  3. Backup/restore

  4. Manual scripting

Show answer
Correct Option: B