0

databases Online Quiz - 196

Description: databases Online Quiz - 196
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. records

  2. fields

  3. articles

  4. names


Correct Option: A
  1. one magazine, journal or newspaper

  2. one author

  3. one article from a magazine, journal or newspaper

  4. all of the above


Correct Option: C
  1. one book, journal, video, CD, etc.

  2. one author

  3. one subject

  4. all of the above


Correct Option: A

You are searching an electronic article index that contains citations to journal articles. What part of each article does the database contain?

  1. the whole article

  2. a summary of the article

  3. the title of the article

  4. the author, title and source of the article


Correct Option: D
  1. DB2 Everyplace

  2. DB2 Express Edition

  3. DB2 Workgroup Server Edition

  4. DB2 Enterprise Server Edition


Correct Option: B

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

  1. A select operation

  2. An update operation

  3. An insert operation

  4. A delete operation


Correct Option: A

Which of the following DB2 data types does NOT have a fixed length?

  1. INT

  2. XML

  3. CHAR

  4. DOUBLE


Correct Option: B

Which of the following DB2 data types can NOT be used to create an identity column?

  1. SMALLINT

  2. NUMERIC

  3. INTEGER

  4. DOUBLE


Correct Option: D

Which of the following are optional and do not have to be specified when creating a table?

  1. Default constraint

  2. Column data type

  3. Column name

  4. Table name


Correct Option: A

Which of the following can NOT be used to restrict specific values from being inserted into a column in a particular table?

  1. Index

  2. Check constraint

  3. Default constraint

  4. Referential constraint


Correct Option: C
  1. When it is created

  2. When it is referenced in an INSERT statement

  3. Any time an executable SQL statement references it

  4. The first time any executable SQL statement references it


Correct Option: C
- Hide questions