Tag: databases

Questions Related to databases

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

  1. Tablespace

  2. Sequence

  3. Views

  4. Index


Correct Option: C

Load utility will rebuild the index of the table that is loaded?

  1. True

  2. False


Correct Option: A

Pick the odd one out

  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

Which table gives access path information for a plan/query when EXPLAIN command is used

  1. DSN_STATEMNT_TABLE

  2. PLAN_TABLE

  3. SYSPLAN

  4. SYSPACKAGE


Correct Option: B

Which of the following functions can be used to determine whether a column value is NULL

  1. SUBSTR

  2. VALUE

  3. COALESCE

  4. NULLIF


Correct Option: B,C

Which of the following groups allows its members to connect to a 9i database using the SYSDBA privilege?

  1. 9iDBA

  2. OSADM

  3. OSDBA

  4. OSOPER


Correct Option: C

Which of the following are NOT the authorized operations of SYSOPER

  1. CREATE SPFILE

  2. CREATE DATABASE

  3. ALTER DATABASE OPEN

  4. STARTUP


Correct Option: B