Menu
Popular Courses
Search

MCQs


Total Questions : 10
Question 1. How many clustering index we can have for a single table?
  1.    15
  2.    10
  3.    1
  4.    No Limit
 Discuss Question
Answer: Option C. -> 1




Question 2. The final result of a DB2 BIND is
  1.    Load module
  2.    DB2 catalog
  3.    Data base request module
  4.    DB2 (application) Plan
 Discuss Question
Answer: Option D. -> DB2 (application) Plan




Question 3. An INSERT statement:
  1.    May contain a subquery
  2.    Must contain a VALUES list
  3.    Must contain a column list
  4.    May create multiple table rows
 Discuss Question
Answer: Option A. -> May contain a subquery




Question 4. AUTOMATIC RECOMPILATION occurs when
  1.    A existing index is dropped
  2.    A new index is created
  3.    Both A and B
  4.    None of the above
 Discuss Question
Answer: Option B. -> A new index is created




Question 5. Which of the following allow you to perform administrative tasks against database objects?
  1.    Control Center
  2.    Journal
  3.    Task Center
  4.    Health Center
 Discuss Question
Answer: Option A. -> Control Center




Question 6. Which of the following DB2 objects allows multiple users to access data in a table with each only being able to access certain portions of the data?
  1.    Views
  2.    Aliases
  3.    Indexes
  4.    Mirrored tables
 Discuss Question
Answer: Option A. -> Views




Question 7. How can the locks be classified?
  1.    Size
  2.    Duration
  3.    Mode
  4.    All of these
 Discuss Question
Answer: Option D. -> All of these




Question 8. Which of the following DB2 tools allows a user to set DB2 registry parameters?
  1.    Task Center
  2.    Visual Explain
  3.    Configuration Assistant
  4.    Satellite Administration Center
 Discuss Question
Answer: Option C. -> Configuration Assistant




Question 9. In DB2, DATA is physically stored in
  1.    VSAM ESDS
  2.    VSAM KSDS
  3.    VSAM LDS
  4.    TABLES
 Discuss Question
Answer: Option C. -> VSAM LDS




Question 10. SQL was first developed:
  1.    In the 1970s
  2.    In 1982
  3.    By IBM
  4.    By ANSI
 Discuss Question
Answer: Option A. -> In the 1970s




Share this page with your friends!

Share this page with your friends!

Latest Videos

Chapter 1 - GLOBAL STEEL SCENARIO & INDI Part 1 : (13-04-2024) INDUSTRY AND COMPANY AWARENESS (ICA)
Direction Sense Test Part 1 Reasoning (Hindi)
Chapter 1 - RMHP / OHP / OB & BP Part 1 : (14-02-2024) GPOE 2024
Cube & Cuboid Part 1 Reasoning (Hindi)
Data Interpretation (DI) Basic Concept Reasoning (Hindi)
Counting Figures Part 1 Counting Of Straight Lines Reasoning (Hindi)
Real Numbers Part 7 Class 10 Maths
Real Numbers Part 1 Class 10 Maths
Polynomials Part 1 Class 10 Maths

Latest Test Papers

Chapter 1.1 : INTRODUCTION Chapter 1 : Raw Material Handling Plant GPOE/GPA 2024
Chapter 1.1 : Personnel Functions- An ov Chapter 1 : Personnel Management GFM 2024
Chapter 3.1 : INTRODUCTION Chapter 3 : Sinter Plant GPOE/GPA 2024
Chapter 2.3 : COAL HANDLING PLANT - Set Chapter 2 : Coke Ovens and Coal Chemicals GPOE/GPA 2024
Chapter 2.1 : Overview Chapter 2 : Materials Management GFM 2024