Sail E0 Webinar

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




Latest Videos
Chapter 1 - GLOBAL STEEL SCENARIO & INDIAN STEEL INDUSTRY 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
Cube & Cuboid Part 1 Reasoning (Hindi)
Data Interpretation (DI) Basic Concept Reasoning (Hindi)
Counting Figures Part 1 Counting Of Straight Lines Reasoning (Hindi)
Sail E0 free webinar Webinars
Real Numbers Part 7 Class 10 Maths
Real Numbers Part 1 Class 10 Maths
Polynomials Part 1 Class 10 Maths

Latest Test Papers

DSP Combined 1 Free Revision Test SAIL JO E-0
GPOE / GPA Combined 1 Free Revision Test SAIL JO E-0
BSP Plant Specific Review Test SAIL JO E-0
BSL Combined 1 Free Revision Test SAIL JO E-0
GFM Combined 1 Free Revision Test SAIL JO E-0