databases Online Quiz - 20
|Description: databases Online Quiz - 20|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
What is the command code use to update the path of the segment?
What does Procopt O in PSB stand for?
What are the two types of SSA's?
What is the retrieval sequence in IMS DB?
What Status code is returned when trying to insert a segment that already exists?
Which of the following is true about a MPP processing mode in IMS?
What is the limitation on the Secondary indicies for a database?
PROCOPT cannot be used on PCB and SENSEG.
Which language is not supported by IMS?
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
Embedded SQL is which of the following?
A UNION query is which of the following?
What type of join is needed when you wish to include rows that do not have matching values?
Which of the following statements is true concerning routines and triggers?
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.
Which of the following is a correlated subquery?