Tag: databases

Questions Related to databases

Which of the following is true about a MPP processing mode in IMS?
technology databases

  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.

Show answer
Correct Option: C

What is the limitation on the Secondary indicies for a database?
technology databases

  1. 255

  2. 1000

  3. No Limit

  4. 32

Show answer
Correct Option: B

After database is loaded in HSAM which of the following operation becomes invalid?
technology databases

  1. GU

  2. GN

  3. GNP

  4. GHNP

Show answer
Correct Option: D

PROCOPT cannot be used on PCB and SENSEG.

technology databases

  1. True

  2. False

Show answer
Correct Option: B

Which language is not supported by IMS?
technology databases

  1. COBOL

  2. JAVA

  3. REXX

  4. VS PASCAL

Show answer
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
technology databases

  1. Equi-join

  2. Natural join

  3. Outer join

  4. Cartesian join

Show answer
Correct Option: A

Embedded SQL is which of the following?
technology databases

  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.

Show answer
Correct Option: A

A UNION query is which of the following?
technology databases

  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.

Show answer
Correct Option: C

What type of join is needed when you wish to include rows that do not have matching values?

technology databases

  1. Equi-join

  2. Natural join

  3. Outer join

  4. All of the above.

Show answer
Correct Option: C

Which of the following statements is true concerning routines and triggers?
technology databases

  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.

Show answer
Correct Option: A