Tag: databases

Questions Related to databases

XQuery is used to retrieve what type of data?
technology databases

  1. LOB

  2. XML

  3. Image

  4. Video

Show answer
Correct Option: B

Which of the following utility is recommended after REORG is performed on tablespaces?
technology databases

  1. Recover

  2. Repair

  3. Rebuild

  4. Runstats

Show answer
Correct Option: D

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

  1. Tablespace

  2. Sequence

  3. Views

  4. Index

Show answer
Correct Option: C

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

  1. True

  2. False

Show answer
Correct Option: A

Pick the odd one out
technology databases

  1. AVG

  2. SUM

  3. STDDEV

  4. ABS

Show answer
Correct Option: D

Which of the following contains Database Descriptors(DBD)
technology databases

  1. DB2 Directory

  2. DB2 Catalog

  3. Optimizer

  4. Data Manager

Show answer
Correct Option: A

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

  1. DSN_STATEMNT_TABLE

  2. PLAN_TABLE

  3. SYSPLAN

  4. SYSPACKAGE

Show answer
Correct Option: B

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

  1. SUBSTR

  2. VALUE

  3. COALESCE

  4. NULLIF

Show answer
Correct Option: B,C

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

  1. 9iDBA

  2. OSADM

  3. OSDBA

  4. OSOPER

Show answer
Correct Option: C

Which of the following are NOT the authorized operations of SYSOPER
technology databases

  1. CREATE SPFILE

  2. CREATE DATABASE

  3. ALTER DATABASE OPEN

  4. STARTUP

Show answer
Correct Option: B