DB2 Mock Test
Questa sezione presenta varie serie di test fittizi relativi a DB2. Puoi scaricare questi test fittizi di esempio sul tuo computer locale e risolverli offline a tuo piacimento. Ogni test di simulazione viene fornito con una chiave di prova di simulazione per consentirti di verificare il punteggio finale e valutare tu stesso.
DB2 Mock Test I
D 1 - Quale componente gestisce l'avvio e l'arresto di DB2?
A - Componente dei servizi di blocco
B - Componente dei servizi di sistema
Risposta: B
Spiegazione
Il componente dei servizi di sistema gestisce l'avvio e l'arresto di DB2.
D 2 - Quale componente è responsabile dell'esecuzione delle istruzioni SQL?
A - Componente dei servizi di blocco
B - Componente dei servizi di sistema
Risposta: C
Spiegazione
Il componente dei servizi di database è responsabile dell'esecuzione delle istruzioni SQL e gestisce anche il pool di buffer.
D 3 - Quale componente controlla i deadlock DB2?
A - Componente dei servizi di blocco
B - Componente dei servizi di sistema
Risposta: A
Spiegazione
I servizi di blocco vengono forniti dal componente dei servizi di blocco noto come IRLM (Internal Resource Lock Manager) e gestisce i problemi di concorrenza e i dead lock.
D 4 - Quale componente fornisce supporto per l'esecuzione di stored procedure?
A - Componente dei servizi di blocco
B - Componente dei servizi di sistema
Risposta: D.
Spiegazione
I componenti di stored procedure forniscono supporto per l'esecuzione di stored procedure.
Risposta: B
Spiegazione
Sì, un sistema DB2 può avere più di un database.
Q 6 - Which DB2 component is used for remote database server connection?
A - Locking Services Component
Answer : D
Explanation
Distributed Data Facility Component is responsible for handling remote database server connections.
Q 7 - Which of the following are logical objects?
Answer : D
Explanation
Tables, Views, Synonyms and Alias are logical objects which are used by users and developers.
Q 8 - Which of the following are physical objects?
Answer : D
Explanation
Database and Table space are physical objects.
Q 9 - Collection of one or more DASD volumes creates a storage group. What is the maximum limit of DASD which can be used for a storage group?
Answer : C
Explanation
This is self explanatory.
Q 10 - How many databases can a DB2 system manage?
Answer : B
Explanation
This is self explanatory.
Q 11 - Which table space can have one or more tables and can have rows from multiple tables on a single page?
Answer : A
Explanation
A simple table space can contain one or more tables and there is no limit on the number of tables. Rows from multiple tables can be on a single page.
Q 12 - Which table space is divided into segments of 4 to 64 pages in increments of 4 and each segment holds data for only one table?
Answer : B
Explanation
Segmented table space is divided into segments of equal size and segments are of 4 to 64 pages size in increments of 4 pages. It can have one or more tables. Each segment is dedicated to a table and a table can occupy multiple segments.
Q 13 - Which table space houses only one table?
Answer : C
Explanation
A partitioned table space can house one table and allows a table to be divided by rows into partitions that the system can manage separately.
Q 14 - How many numbers of tables can be created inside a table space?
Answer : C
Explanation
A table space can house any number of tables.
Q 15 - Which columns are good for indexing?
Answer : D
Explanation
The purpose of index is to retrieve the data faster. So we choose those columns which are unique.
Q 16 - Which columns are not good for indexing?
A - Frequently updated columns
Answer : D
Explanation
The purpose of index is to retrieve the data faster. So we choose those columns which are unique or less frequently updated.
Answer : C
Explanation
We can have only one clustering index for a table.
Q 18 - Which of the following can refer to both local as well as remote tables?
Answer : B
Explanation
Alias can refer to both local as well as remote tables whereas synonyms refers only to local tables.
Q 19 - Which of the following can refer only to local tables?
Answer : A
Explanation
Alias can refer to both local as well as remote tables whereas synonyms refers only to local tables.
Q 20 - Suppose a table A has an Alias named AL1. Which of the query is correct to drop the AL1 alias?
Answer : B
Explanation
DROP ALIAS alias-name is the correct syntax.
Q 21 - Which index must be present for partitioned table space?
Answer : B
Explanation
A partitioned table space must have a clustered index.
Q 22 - In which format index in stored?
Answer : B
Explanation
An indexed is stored in B-tree format.
Q 23 - What does SPUFI stands for?
A - SQL Processor Using File Input
B - Sequential Processor Using File Input
Answer : A
Explanation
SPUFI stands for SQL Processor Using File Input.
Answer : B
Explanation
Alphanumeric is a COBOL data type. We do not use this while creating DB2 objects.
Q 25 - What is the maximum size of a VARCHAR data type in DB2?
Answer : C
Explanation
Varchar data type maximum size is of 4046 bytes.
Answer Sheet
Question Number | Answer Key |
---|---|
1 | B |
2 | C |
3 | A |
4 | D |
5 | B |
6 | D |
7 | D |
8 | D |
9 | C |
10 | B |
11 | A |
12 | B |
13 | C |
14 | C |
15 | D |
16 | D |
17 | C |
18 | B |
19 | A |
20 | B |
21 | B |
22 | B |
23 | A |
24 | B |
25 | C |