Popular Courses
Sail E0 Package
Valid Till Next Exam
Fast Math Tricks
165 videos
Quantitative Aptitude
645 Videos
Reasoning Aptitude
161 Videos
CLASS 8 MATHS(CBSE)
417 Videos
CLASS 9 MATHS(CBSE)
40 hours, 647 questions
Check All Courses
Resources
Store
Blog
More
About Us
Contact Us
Register / Login
Menu
Home
Blog
Store
About Us
Contact Us
Profile Settings
Attempted Tests
My Purchases
Popular Courses
Sail E0 Package
Valid Till Next Exam
Fast Math Tricks
165 videos
Quantitative Aptitude
645 Videos
Reasoning Aptitude
161 Videos
CLASS 8 MATHS(CBSE)
417 Videos
CLASS 9 MATHS(CBSE)
40 hours, 647 questions
Check All Courses
Search
Search
Home
Topics
MCQs
Total Questions : 10
Question 1.
How many clustering index we can have for a single table?
15
10
1
No Limit
See Solution
Discuss Question
Answer: Option C. ->
1
Question 2.
The final result of a DB2 BIND is
Load module
DB2 catalog
Data base request module
DB2 (application) Plan
See Solution
Discuss Question
Answer: Option D. ->
DB2 (application) Plan
Question 3.
An INSERT statement:
May contain a subquery
Must contain a VALUES list
Must contain a column list
May create multiple table rows
See Solution
Discuss Question
Answer: Option A. ->
May contain a subquery
Question 4.
AUTOMATIC RECOMPILATION occurs when
A existing index is dropped
A new index is created
Both A and B
None of the above
See Solution
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?
Control Center
Journal
Task Center
Health Center
See Solution
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?
Views
Aliases
Indexes
Mirrored tables
See Solution
Discuss Question
Answer: Option A. ->
Views
Question 7.
How can the locks be classified?
Size
Duration
Mode
All of these
See Solution
Discuss Question
Answer: Option D. ->
All of these
Question 8.
Which of the following DB2 tools allows a user to set DB2 registry parameters?
Task Center
Visual Explain
Configuration Assistant
Satellite Administration Center
See Solution
Discuss Question
Answer: Option C. ->
Configuration Assistant
Question 9.
In DB2, DATA is physically stored in
VSAM ESDS
VSAM KSDS
VSAM LDS
TABLES
See Solution
Discuss Question
Answer: Option C. ->
VSAM LDS
Question 10.
SQL was first developed:
In the 1970s
In 1982
By IBM
By ANSI
See Solution
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)
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
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