Tag: databases

Questions Related to databases

The HAVING clause tells the GROUP BY which groups to include.
technology databases

  1. True

  2. False

Show answer
Correct Option: A

The main reason for a composite index is for aggregate function usage in an index.
technology databases

  1. True

  2. False

Show answer
Correct Option: B

What type of join would you use to return records from one table, regardless of the existence of associated records in the related table?
technology databases

  1. OUTER JOIN

  2. RIGHT JOIN

  3. INNER JOIN

  4. LEFT JOIN

Show answer
Correct Option: A

Which of the following statements about roles are true?
technology databases

  1. Roles can be granted to other roles

  2. Privileges can be granted to roles

  3. Roles can be granted to synonyms

  4. Roles can be granted to users

Show answer
Correct Option: A,B,D

Which of the following dictionary views gives information about the position of a column in a primary key?
technology databases

  1. ALL_PRIMARY_KEYS

  2. ALL_TABLES

  3. ALL_IND_COLUMNS

  4. USER_CONSTRAINTS

Show answer
Correct Option: C

Which of the following is the transaction control that prevents more than one user from updating data in a table?
technology databases

  1. Commits

  2. Locks

  3. Savepoints

  4. Rollbacks

Show answer
Correct Option: B

Which of the following methods should you use to increase the number of nullable columns for a table?
technology databases

  1. Use the alter table statement

  2. Ensure that all column values are NULL for all rows

  3. First, increase the size of adjacent column datatypes, and then add the column

  4. Add the column, populate the column, and then add the not NULL constraint

Show answer
Correct Option: A

Once defined, how long will a variable remain defined in SQL*Plus?
technology databases

  1. Until the database is shut down

  2. Until the instance is shut down

  3. Until the statement completes

  4. Until the session completes

Show answer
Correct Option: D

Which of the following product will not accept remote database request?
technology databases

  1. DB2 UDB WSUE

  2. DB2 UDB PE

  3. DB2 UDB WSE

  4. DB2 UDB ESE

Show answer
Correct Option: B

Which of the following does DB2 Configuration Advisor recommend?
technology databases

  1. SQL statements

  2. Views

  3. DDL

  4. Database configuration parameter settings

Show answer
Correct Option: D