A DBA issues the command:-DIS DB(DSNDB06) SPACE(*) LOCKS. In the LOCKINFO field the following data is reported: H-IS,S,C. When Will the lock first be released by DB2?
COMMIT 0%
Deallocation 0%
When the table space is stopped 0%
When DB2 moves to the next page in the table 0%
Can you update a view which is based on more than one table?
Can you use LOCK TABLE on a view?
How do you perform the EXPLAIN of a dynamic SQL statement?
EXPLAIN of a dynamic SQL cannot be done 0%
By using SPUFI or QMF to EXPLAIN the dynamic SQL statement 0%
By including EXPLAIN command in the embedded dynamic SQL statements 0%
None of above 0%
How does DB2 determine which lock-size to use?
It is based on the lock-size given while creating the tablespace 0%
The programmer may direct the DB2 on which lock-size to use 0%
It is not possible to dertermine the lock-size 0%
None of above 0%
How many clustering indexes can be defined for a table?
Two 0%
four 0%
One 0%
Six 0%
If a user accidentally drops a table and commits work, which of the following recovers the dropped table?
Once commited the dropped table cannot be recovered 0%
If ALTER TABLESPACE..DROPPED TABLE RECOVERY on enabled,restore tablespace,role forward 0%
If ALTER TABLESPACE..DROPPED TABLE RECOVERY on not enabled, first alter tablespace and then restore database and rollforward 0%
If ALTER TABLESPACE..DROPPED TABLE RECOVERY on not enabled, first alter tablespace and then restore tablespace and rollforward 0%
Index cardinality represents:
The number of distinct values a column Contains 0%
The number of duplicate values a column Contains 0%
The Index which is on more than one key 0%
None of above 0%
The various locking levels available are:
User, Schema 0%
Page, Table, Tablespace 0%
Database, Segment 0%
Segment, Extent 0%
The various locks available are _____________.
Share 0%
Exclusive 0%
Update 0%
All of the above 0%
What are partitioned table spaces?
Table spaces divided into segments 0%
Table spaces divided into parts 0%
Table spaces containing one or more tables 0%
All of the above 0%
What are segmented table spaces?
Table spaces divided into segments of 1 to 10 pages 0%
Table spaces divided into segments of 4 to 64 pages 0%
Table spaces containing only one table 0%
None of the above 0%
What do you need to do before you perform EXPLAIN?
Create PLAN_TABLE under the AUTHID 0%
Create EXPLAIN under the AUTHID 0%
Create SPUFI under the AUTHID 0%
Create QMF under the AUTHID 0%
What does sqlcode -922 denote?
Database failure 0%
Network failure 0%
Authorization failure 0%
Instance failure 0%
What does the term EXPLAIN denote?
A precompiler 0%
A utility to run a DB2 batch program 0%
It displays the access path as determined by the optimizer 0%
A BIND step for embedded SQL 0%
What does the term IMAGECOPY mean?
It is a full backup of a DB2 database 0%
It is a full backup of a DB2 redolog 0%
It is a full backup of a DB2 table 0%
All of the above 0%
What happens during a DB2 Checkpoint?
Resource managers are invoked to write their status to the log 0%
Data Manager writes DBE table log records 0%
Both a and b 0%
None of above 0%
What is a clustering index?
An index that stores only unique values 0%
A mandatory index defined on a partitioned table space 0%
An index Which is on more than one key 0%
None of the above 0%
What is a DB2 access path?
It is a method used to access data specified in DB2 0%
It is an application 0%
It is a package 0%
It is a method user to show the execution plan 0%
What is a DB2 bind?
A process that builds an access path to DB2 tables 0%
A process that accesses index 0%
A process that defines table structure 0%
None of the above 0%
What is a deadlock?
A deadlock occurs when two or more programs are read simultaneously 0%
When transaction fails it is called a deadlock 0%
A deadlock occurs when transactions are executed at the same time 0%
None of the above 0%
What is dynamic SQL?
An SQL statement written in procedure 0%
An SQL statement written in cursor 0%
An SQL statement created at program execution time 0%
None of the above 0%
What is RUNSTATS?
It is a package 0%
It is a utility used to collect statistics 0%
It is a Collection 0%
It is a DB2 Procedure 0%
what is the root page in DB2?
It is a simple DB2 index 0%
It is a B-tree 0%
It is a B-tree's top page 0%
It is a clustered index 0%
When is the access path determined for dynamic SQL?
At run time 0%
At compile time 0%
At bind time 0%
All of the above 0%
When is the authorization check on DB2 objects done - at BIND time or run time?
At bind time 0%
It is never done 0%
At run time 0%
At compile time 0%
Where is the output of EXPLAIN stored?
In SYSIBM schema 0%
In userid.PLAN_TABLE 0%
IN SPUFI 0%
None of above 0%
Which DB2 catalog table can be used to determine if a user has authorization to bind a new plan?
SYSDBAUTH 0%
SYSTABAUTH 0%
SYSUSERAUTH 0%
SYSPLANAUTH 0%
Which function does QUIESCE perform?
It flushes all DB2 buffers on to the disk 0%
It gives a correct snapshot of the database 0%
It is a LOAD utility 0%
None of the above 0%
Which of the following ALTER TABLESPACE statements causes DB2 to record data page changes in the space map pages of a segmented table space DSN8D71A.DSN8S71E?
ALTER TABLESPAcE dsn8d71a.dsn8s7ie log yes; 0%
ALTER TABLESPAcE dsn8d71a.dsn8s7ie close yes; 0%
ALTER TABLESPAcE dsn8d71a.dsn8s7ie Trackmod yes; 0%
ALTER TABLESPAcE dsn8d71a.dsn8s7ie changemod yes; 0%
Which of the following can a DBA do to determine what an image copies, active logs and archive logs will be required for the recovery of a table space?
Read the SYSIBM.SYSCOPY table 0%
Run the Report Recovery utility 0%
Run the COPY TABLESPACE utility 0%
Run the MERGECOPY TABLESPACE utility 0%
Which of the following cannot be done with the ALTER TABLE statement?
Change the cache value for an identity column 0%
Turn on auditing for the table 0%
Add a primary key to the table 0%
Add a column to the end of a table row 0%
Which of the following commands will give the minimum point in time recovery for table spaces of a recoverable database?
Get dbm cfg 0%
List minimum point in time 0%
List tablespace show detail 0%
Get db cfg for <database-alias> 0%
Which of the following COPY utility statements will backup table space DBTAB1.TS1 preparing 2 copies for local use and 2 copies for disater recovery use?
Copy Tablespace DBTAB1.TS1 LOCAL(2) OFFSITE(2)... 0%
Copy Tablespace DBTAB1.TS1 COPYDDN(DD1,DD2,DD3,DD4)... 0%
Copy Tablespace DBTAB1.TS1 LOCAL(DD1,DD2) OFFSITE(DD3,DD4)... 0%
Copy Tablespace DBTAB1.TS1 COPYDDN(DD1,DD2)RECOVERYDDN(DD3,DD4)... 0%
Which of the following index type will cause the rows of the table to be arranged on the disk according to the ordering of their index keys?
Unique Index 0%
Clustered Index 0%
Non-unique Index 0%
Index with include column 0%
Which of the following is not true for a segmented table space?
It is more efficient for table spaces greater than 4 GB 0%
It makes free pages available immediately after a commit 0%
It generally skips empty pages when a table scan is being processed 0%
It has more efficient space map processing than a simple tablespace 0%
Which of the following is required to import data into a table?
SYSCTRL 0%
LOAD authority on the table 0%
ALTER privilege on the table 0%
IMPORT authority on the table 0%
INSERT privilege on the table 0%
Which of the following is true when joining a table with DB2 Relational Connect function?
DB2's cost based optomizer is turned off for Federated database requests 0%
The DB2 optimizer is not aware that all tables are not in the same DB2 instance 0%
The DB2 optimizer is aware that some tables are on remote machines, but will not perform any optimization on SQL sent to the remote database 0%
The DB2 optimizer is aware that some tables are on remote machines, and where appropriate will rewrite SQL before sending it to the remote machine 0%
Which of the following statements will gather only the index statistics for the table john.table1?
Runstats on table john.table1 indexes all 0%
Runstats on table john.table1 for indexes all 0%
Runstats on table john.table1 on indexes all 0%
Runstats on table john.table1 and indexes all 0%
Which of the following table space characteristics for a system Managed (SMS) table space can be modified with the ALTER TABLESPACE Statements?
Extent Size 0%
Prefetch Size 0%
Number of containers 0%
Size of an existing container 0%