0

databases Online Quiz - 135

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

Which of the following objects could not be modified using ALTER statement

  1. Tablespace

  2. Sequence

  3. Views

  4. Index


Correct Option: C
  1. AVG

  2. SUM

  3. STDDEV

  4. ABS


Correct Option: D

Which of the following contains Database Descriptors(DBD)

  1. DB2 Directory

  2. DB2 Catalog

  3. Optimizer

  4. Data Manager


Correct Option: A
  1. CREATE SPFILE

  2. CREATE DATABASE

  3. ALTER DATABASE OPEN

  4. STARTUP


Correct Option: B

The initial password of CHANGE_ON_INSTALL is used by which of the following user accounts?

  1. SYSTEM

  2. SYS

  3. SYSOPER

  4. MANAGER


Correct Option: B
  1. It provides a security scan against all user accounts

  2. It provides a SID scan against all rows

  3. It provides a central means of updating all user accounts

  4. It provides a mechanism for switching between Oracle9i databases with ease


Correct Option: C
  1. DB_CACHE_SIZE

  2. DB_FILES

  3. BACKGROUND_DUMP_DEST

  4. DB_BLOCK_SIZE


Correct Option: C
  1. modify the parameter, backup the init file and the database, and restart the instance

  2. modify the parameter and restart the instance

  3. re-create the database

  4. modify the parameter, backup the init file and restart the instance


Correct Option: C
  1. Sequel query language

  2. Structured query language

  3. Shortened query language

  4. Simplified query language


Correct Option: C
  1. sinh()

  2. to_number()

  3. sqrt()

  4. round()


Correct Option: B
- Hide questions