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

We can not execute a stored procedure on either local or remote SQL Server.

  1. True

  2. False


Correct Option: B

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

'Select Into'Statement retrieves rows and columns from one source table to a target table.

  1. True

  2. False


Correct Option: A

____setting that indicates the number of records that must be returned in the query results for SQL*Plus to show the message

  1. LINESIZE

  2. FEEDBACK

  3. PAGESIZE

  4. PAUSE


Correct Option: B

PAUSE command is useful, when you execute a query that is longer than a page in size, the output will stop until you hit the Enter key.

  1. True

  2. False


Correct Option: A

Main functions in parsing process are____

  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
  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