Tag: databases

Questions Related to databases

The HAVING clause was added to SQL because the WHERE keyword could be used with aggregate functions.
technology databases

  1. True

  2. False

Show answer
Correct Option: A

The FULL JOIN keyword return rows when there is a match in one of the tables.
technology databases

  1. True

  2. False

Show answer
Correct Option: A

For auto-increment in oracle,sql command is written with the keyword?
technology databases

  1. auto_increment

  2. sequence

  3. identity

  4. increment

Show answer
Correct Option: B

Memo is an sql data type in oracle.
technology databases

  1. True

  2. False

Show answer
Correct Option: B

Which of the following DB2 tools allows a user to execute an SQL statement and view a graphical representation of the access plan?
technology databases

  1. Task Center

  2. Command Editor

  3. Design Advisor

  4. Command Line Processor

Show answer
Correct Option: B

Which of the following is the lowest cost DB2 product that can be legally installed on an AIX server?
technology databases

  1. DB2 Express Edition

  2. DB2 Personal Edition

  3. DB2 Workgroup Server Edition

  4. DB2 Enterprise Server Edition

Show answer
Correct Option: C

Which of the following is NOT a valid method of authentication that can be used by DB2 9?
technology databases

  1. SERVER

  2. SERVER_ENCRYPT

  3. CLIENT

  4. DCS

Show answer
Correct Option: D

An alias can be an alternate name for which of the following DB2 objects?
technology databases

  1. Sequence

  2. View

  3. Trigger

  4. Schema

Show answer
Correct Option: B

Which of the following DB2 objects can be referenced by an INSERT statement to generate values for a column?
technology databases

  1. Sequence

  2. Identity column

  3. Trigger

  4. Table function

Show answer
Correct Option: A

Which of the following events will NOT cause a trigger to be activated?
technology databases

  1. A select operation

  2. An insert operation

  3. An update operation

  4. A delete operation

Show answer
Correct Option: A