Tag: databases

Questions Related to databases

According to the Oracle recommended prioritized approach for designing, implementing, and maintaining an Oracle Database, which of the following is the task for the DBA to perform before tuning the database?

technology databases

  1. Install the Oracle Software

  2. Plan the Database

  3. Implement the Database Design

  4. Back Up the Fully Functional Database

Show answer
Correct Option: D

According to the Oracle recommended prioritized approach for designing, implementing, and maintaining an Oracle Database, which of the following is the first task for the DBA to perform?

technology databases

  1. Install the Oracle Software

  2. Evaluate the Database Server Hardware

  3. Implement the Database Design

  4. Plan the Database

Show answer
Correct Option: B

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

technology databases

  1. SYSTEM

  2. SYS

  3. SYSOPER

  4. MANAGER

Show answer
Correct Option: B

What environment variable can have direct influence towards the output of the date command?

technology databases

  1. TZ

  2. TMP

  3. TMPDIR

  4. SHLIB_PATH

Show answer
Correct Option: A

Which of the following are the functions of the oraenv script

technology databases

  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

Show answer
Correct Option: C

A directory name can be a valid value for which of the following parameters?

technology databases

  1. DB_CACHE_SIZE

  2. DB_FILES

  3. BACKGROUND_DUMP_DEST

  4. DB_BLOCK_SIZE

Show answer
Correct Option: C

How do you change the block size specified by DB_BLOCK_SIZE?

technology databases

  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

Show answer
Correct Option: C

What is used in Oracle 9i to represent the value of the ORACLE_HOME environment variable?

technology databases

  1. #

  2. &

  3. !

  4. ?

Show answer
Correct Option: D

Abbreviation of SQL

technology databases

  1. Sequel query language

  2. Structured query language

  3. Shortened query language

  4. Simplified query language

Show answer
Correct Option: C

What is necessary in the SQL query when we are using aggregate functions?

technology databases

  1. Group by

  2. Order by

  3. Where

  4. Update

Show answer
Correct Option: D