0

databases Online Quiz - 20

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

What is the command code use to update the path of the segment?

  1. Q

  2. D

  3. N

  4. I


Correct Option: B
  1. Horizontal and Vertical

  2. Forward and Backward

  3. Left and Right

  4. Front and Back


Correct Option: B
  1. Sequential Initial Load

  2. Access only Key of segment

  3. Used with G to Indicate that Hold is not allowed

  4. None of the above


Correct Option: C

What are the two types of SSA's?

  1. Basic and Complex

  2. General and Specific

  3. Qualified and Unqualified

  4. None of these


Correct Option: C

What is the retrieval sequence in IMS DB?

  1. Top to Bottom, Front to back, Left to right

  2. Front to back, Left to right, Top to Bottom

  3. Left to right, Top to Bottom, Front to back

  4. Left to right, Front to back, Top to Bottom


Correct Option: A
  1. Databases accessed must be online.

  2. No data communication services are used.

  3. Transactions are entered at the terminal and stored in a message queue.

  4. True batch processing.


Correct Option: C

Which language is not supported by IMS?

  1. COBOL

  2. JAVA

  3. REXX

  4. VS PASCAL


Correct Option: B

The following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T WHERE CUSTOMER_T. CUSTOMER_ID = ORDER_T. CUSTOMER_ID

  1. Equi-join

  2. Natural join

  3. Outer join

  4. Cartesian join


Correct Option: A

Embedded SQL is which of the following?

  1. Hard-coded SQL statements in a program language such as Java

  2. The process of making an application capable of generating specific SQL code on the fly.

  3. Hard-coded SQL statements in a procedure.

  4. Hard-coded SQL statements in a trigger.


Correct Option: A
  1. Combines the output from no more than two queries and must include the same number of columns.

  2. Combines the output from no more than two queries and does not include the same number of columns.

  3. Combines the output from multiple queries and must include the same number of columns.

  4. Combines the output from multiple queries and does not include the same number of columns.


Correct Option: C
  1. Both consist of procedural code

  2. Both have to be called to operate.

  3. Both run automatically.

  4. Both are stored in the database.


Correct Option: A
  1. Uses the result of an inner query to determine the processing of an outer query.

  2. Uses the result of an outer query to determine the processing of an inner query.

  3. Uses the result of an inner query to determine the processing of an inner query.

  4. Uses the result of an outer query to determine the processing of an outer query.


Correct Option: B
- Hide questions