0

databases Online Quiz - 74

Description: databases Online Quiz - 74
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. The user had to have knowledge of the table and index structures

  2. Navigational data access was far slower than declarative access

  3. Navigational access languages required the coder to embed their queries inside a procedural language shell

  4. Navigational languages were far slower then SQL


Correct Option: A
  1. SQL cannot support object-orientation

  2. The same query can be written in many ways, each with vastly different execution plans

  3. SQL syntax is too difficult for non-computer professionals to use

  4. SQL creates excessive locks within the database


Correct Option: B
  1. Independence of table relationships

  2. High speed of SQL

  3. Powerful GUI front-end

  4. Easy to install and use


Correct Option: A

Which of the following is an important consideration when tuning an SQL statement

  1. The number of CPUs on the server

  2. The degree of parallelism on the tables

  3. The use of bitmap indexes

  4. The quality of the SQL optimization


Correct Option: D

Which of the following database design features is most important to SQL performance?

  1. Removal of data redundancy

  2. The introduction of data redundancy

  3. The introduction of non-first normal form relations

  4. The introduction of SQL*Plus


Correct Option: B
  1. A sequence will never generate duplicate values. b.The MAXVALUE of a sequence can be equal to the MINVALUE. c.It is not possible to create a sequence that generates a constant since the INCREMENT value must be greater than zero.

  2. The MAXVALUE of a sequence can be equal to the MINVALUE

  3. It is not possible to create a sequence that generates a constant since the INCREMENT value must be greater than zero.

  4. When a sequence cycles back to either the MAXVALUE or MINVALUE, it will always be equal to the specified value of either of these two boundaries.


Correct Option: B

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

  1. Index

  2. Check constraint

  3. Referential constraint

  4. Default constraint


Correct Option: D
  1. Execute the LIST REMOTE DATABASES command on the server; look for an entry for the TEST_DB database

  2. . Execute the LIST DCS DIRECTORY command on the server; look for an entry for the TEST_DB database

  3. Execute the LIST REMOTE DATABASES command on the client; look for an entry for the TEST_DB database

  4. Execute the LIST DCS DIRECTORY command on the client; look for an entry for the TEST_DB database


Correct Option: D
  1. An error will occur

  2. Data passed between the client and the server is encrypted.

  3. User IDs and passwords are passed to the server unencrypted

  4. User IDs and passwords are encrypted before they are passed to the server.


Correct Option: A

Which of the following provides a logical grouping of database objects?

  1. View

  2. Table

  3. Schema

  4. Buffer pool


Correct Option: C

Which of the following commands is used to retrieve database names from the local catalog for DRDA host databases on System i and System z?

  1. LIST DB DIRECTORY

  2. LIST DCS DIRECTORY

  3. LIST NODE DIRECTORY

  4. LIST ACTIVE DATABASES


Correct Option: B

Which of the following are types of routine objects?

  1. Package and function

  2. Function and userexit

  3. Procedure and package

  4. Function and procedure


Correct Option: D
  1. No size is specified

  2. The buffer pool size

  3. The page size for the table space

  4. The extent size for the table space


Correct Option: A
  1. The next value will be 0 and the sequence will never use the values 101 to 105.

  2. The next value will be 101 to ensure uniqueness between existing and newly generated sequence values.

  3. Previously cached values are retained by DB2, and after the restart, will be used for values 101 to 105.

  4. The next value will be 0 and DB2 will not ensure uniqueness between existing and newly generated values.


Correct Option: D

Within the application MY_APP the following PREVIOUS VALUE expression references the sequence MY_SEQ: PREVIOUS VALUE FOR my_seq After which of the following events will the most recently generated value of MY_SEQ persist so that it can be returned to the active MY_APP application?

  1. After a ROLLBACK is issued

  2. .After the sequence is altered

  3. After the sequence is dropped

  4. After the current session ends


Correct Option: A

Which of the following describes the objects of a DB2 database and their relationships?

  1. Instance

  2. Table space

  3. System catalog

  4. Schema repository


Correct Option: C
- Hide questions