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

AI Explanation

To answer this question, you need to understand the concepts of routines and triggers.

Option A) Both consist of procedural code - This option is correct because both routines and triggers are pieces of procedural code that can be executed in a database.

Option B) Both have to be called to operate - This option is incorrect. Routines are called explicitly by a user or program, while triggers are automatically executed in response to a specific event or action.

Option C) Both run automatically - This option is incorrect. Routines require explicit invocation, while triggers are automatically executed when a defined event or action occurs.

Option D) Both are stored in the database - This option is incorrect. Routines can be stored in the database as stored procedures, functions, or packages, but triggers are stored as part of the database schema.

The correct answer is Option A) Both consist of procedural code. This option is correct because both routines and triggers are pieces of procedural code that can be executed in a database.