0

databases Online Quiz - 180

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

select col1 from table_a where col1 between 0 and 11 is same as :

  1. select col1 from table_a where col1 > 0 and col1 <11

  2. select col1 from table_a where col1 >= 0 and col1 <11

  3. select col1 from table_a where col1 >= 0 and col1 <= 11

  4. select col1 from table_a where col1 > 0 and col1 < =11


Correct Option: C

What are the retrieval sequences in IMS DB?

  1. Top to Bottom

  2. Front to Back

  3. Right to Left

  4. Left to Right


Correct Option: A,B,D

AI Explanation

To understand the retrieval sequences in IMS DB, let's go through each option:

A. Top to Bottom - This option is correct because in IMS DB, the retrieval sequence starts from the top level segment and goes down to the child segments. This ensures that the data is retrieved in a hierarchical manner.

B. Front to Back - This option is incorrect because the retrieval sequence in IMS DB is not based on the front-to-back order of segments. It is based on the hierarchy of segments.

C. Right to Left - This option is incorrect because the retrieval sequence in IMS DB is not based on the right-to-left order of segments. It is based on the hierarchy of segments.

D. Left to Right - This option is correct because after traversing down the hierarchy from top to bottom, IMS DB retrieves the segments from left to right within each level. This ensures that the segments at the same level are retrieved in a consistent order.

Therefore, the correct answer is A, B, D. These options represent the retrieval sequences in IMS DB, where the data is retrieved from top to bottom, from front to back, and from left to right.

What is command code 'D'?

  1. Concatenated key

  2. path call

  3. first occurrence

  4. last occurrence


Correct Option: B
  1. Concatenated key

  2. path call

  3. first occurrence

  4. last occurrence


Correct Option: A

What is command code 'F'?

  1. Concatenated key

  2. path call

  3. first occurrence

  4. last occurrence


Correct Option: C

What is command code 'L'?

  1. Concatenated key

  2. path call

  3. first occurrence

  4. last occurrence


Correct Option: D

What is command code 'N'?

  1. path call

  2. set parentage

  3. path call ignore

  4. last occurrence


Correct Option: C

What is command code 'P'?

  1. path call

  2. path call ignore

  3. set parentage

  4. Concatenated key


Correct Option: C

what are the control blocks in IMS ?

  1. DBD

  2. PSD

  3. PSB

  4. SSA


Correct Option: A,C

What are the different types of SSA's ?

  1. QUALIFIED SSA

  2. UNQUALIFIED SSA

  3. All the above

  4. None of the above


Correct Option: C

What are the control blocks of Message Format Service (MFS) ?

  1. Message Input Data

  2. Message Output Data

  3. Data Input Format

  4. Data Output Format


Correct Option: A,B,C,D

What are the parameters used in CBLTDLI call?

  1. Function code

  2. PCB mask

  3. Segment I/O Area

  4. SSA's


Correct Option: A,B,C,D

What are the the 3 essential fields required for a DL/I call ?

  1. Function Code

  2. PCB Mask

  3. SSA

  4. I/O Area


Correct Option: A,B,D

What is the limitation on the no. of levels in a DL/I database?

  1. 10

  2. 15

  3. 125

  4. 255


Correct Option: B

What is the physical nature of a database called?

  1. IO-PCD

  2. DBD

  3. IO-AREA

  4. SSA


Correct Option: B

What is the return code you get after a successful IMS call?

  1. Zeros

  2. Spaces

  3. Both

  4. None of these


Correct Option: B

which is the first statement in COBOL-IMS programs?

  1. ENTRY 'CBLDLI' USING ....

  2. ENTRY 'DLICBL' USING ....

  3. ENTRY 'DLIPLI' USING ....

  4. ENTRY 'PLICBL' USING ....


Correct Option: B
  1. End of database

  2. Segment not found

  3. Parentage not set

  4. Successful IMS call


Correct Option: B

Which of the following components of Oracle architecture stores the statistics gathered by the MMON process?

  1. ADDM

  2. AWR

  3. Data dictionary views

  4. Dynamic performance views


Correct Option: B

AI Explanation

To answer this question, you need to understand the components of Oracle architecture and their functions.

Option A) ADDM - This option is incorrect because ADDM (Automatic Database Diagnostic Monitor) is a component of Oracle that analyzes data and provides recommendations for improving database performance. It does not store statistics gathered by the MMON process.

Option B) AWR (Automatic Workload Repository) - This option is correct. AWR is a component of Oracle architecture that collects, processes, and stores performance-related data. It includes performance statistics gathered by various processes, including the MMON (Manageability Monitor) process. The statistics stored in AWR are used for performance tuning and analysis.

Option C) Data dictionary views - This option is incorrect. Data dictionary views provide information about the structure and content of the database, but they do not store statistics gathered by the MMON process.

Option D) Dynamic performance views - This option is incorrect. Dynamic performance views provide real-time information about the current state of the database, but they do not store statistics gathered by the MMON process.

The correct answer is B) AWR. This option is correct because AWR is specifically designed to store the statistics gathered by the MMON process and other performance-related data for analysis and tuning purposes.

- Hide questions