Tag: databases

Questions Related to databases

What is the prefix key for executing an OS command in the DB2 CLP?
technology databases

  1. &

  2. %

  3. !

  4. @

Show answer
Correct Option: C

Which of the following tool allows you to display data of a table?
technology databases

  1. Task Center

  2. Command Center

  3. Health Center

  4. All of above

Show answer
Correct Option: B

Which of the following tool can be used to schedule work for DB2?
technology databases

  1. Task Center

  2. Command Center

  3. Health Center

  4. Control Center

Show answer
Correct Option: A

If you use the CREATE DATABASE statement on an existing database, all data in the datafiles will be lost
technology databases

  1. True

  2. False

Show answer
Correct Option: A

In Oracle, BLOBs have full transactional support
technology databases

  1. True

  2. False

Show answer
Correct Option: A

It is a good practice to use ROWID as a table's primary key
technology databases

  1. True

  2. False

Show answer
Correct Option: B

ALL scalar functions in Oracle return null when given a null argument.
technology databases

  1. True

  2. False

Show answer
Correct Option: B

Within a single SQL statement, Oracle will increment the sequence only twice for each row.

technology databases

  1. True

  2. False

Show answer
Correct Option: B

Oracle DATE columns always contain the date but not the time fields
technology databases

  1. True

  2. False

Show answer
Correct Option: B

You may use two consecutive minus signs in arithmetic expressions to indicate the subtraction of a negative value

technology databases

  1. True

  2. False

Show answer
Correct Option: B