• databases Online Quiz - 20
Back
0

databases Online Quiz - 20

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

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

technology databases

  1. Q

  2. D

  3. N

  4. I

Show answer
Correct Option: B

What are the two types of recovery?

technology databases

  1. Horizontal and Vertical

  2. Forward and Backward

  3. Left and Right

  4. Front and Back

Show answer
Correct Option: B

__________ is the smallest information that a DLI can fetch .

technology databases

  1. Field

  2. Segment

  3. Branch

  4. Character

Show answer
Correct Option: B

What is the limitation on number of segment occurrences?

technology databases

  1. 255

  2. 1000

  3. 453

  4. No Limitation

Show answer
Correct Option: D

What does Procopt O in PSB stand for?

technology databases

  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

Show answer
Correct Option: C

What are the two types of SSA's?

technology databases

  1. Basic and Complex

  2. General and Specific

  3. Qualified and Unqualified

  4. None of these

Show answer
Correct Option: C

What is the retrieval sequence in IMS DB?

technology databases

  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

Show answer
Correct Option: A

What Status code is returned when trying to insert a segment that already exists?

technology databases

  1. IX

  2. IQ

  3. II

  4. ID

Show answer
Correct Option: C

What is the status code for an invalid SSA?

technology databases

  1. AJ

  2. AI

  3. AC

  4. Ak

Show answer
Correct Option: A

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.

Which of the following is a correlated subquery?

technology databases

  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.

Show answer
Correct Option: B
- Hide questions
ADVERTISEMENT

Find more quizzes from top tags

general knowledge
3615 Quizzes
119858 Questions
 technology
307 Quizzes
36705 Questions
 sports
963 Quizzes
19148 Questions
 history
1187 Quizzes
13475 Questions
 physics
598 Quizzes
13441 Questions
 biology
1160 Quizzes
12174 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
490 Quizzes
9892 Questions
 maths
518 Quizzes
9324 Questions
 softskills
0 Quizzes
7131 Questions