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

___is the language used to put data into the database, retrieve data from the database, control transactions, and administer your database

  1. PL/SQL

  2. SQL

  3. SQL*PLUS

  4. JAVA


Correct Option: B

__is the procedural programming language of Oracle, and with it you can write custom programs and procedural code for execution inside the database

  1. PL/SQL

  2. SQL

  3. SQL*PLUS

  4. JAVA


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

___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

  1. Parsing

  2. Optimization

  3. Row source generation

  4. Statement execution

  5. All of the above


Correct Option: A
  1. Parsing

  2. Optimization

  3. Row source generation

  4. Statement execution

  5. All of the above


Correct Option: E

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

  1. True

  2. False


Correct Option: A
  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

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 upgrade data-movement method requires that users not be accessing the database you want to upgrade?

  1. Copy Database Wizard

  2. Detach/attach

  3. Backup/restore

  4. Manual scripting


Correct Option: B
  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