IBM DB2 9.7 DBA for Linux UNIX and Windows Set 1

Question - 15 Maximum mark : - 33

Home
All Exams
IBM DB2 9.7 DBA for Linux UNIX and Windows Online Practice Exams
IBM DB2 9.7 DBA for Linux UNIX and Windows Set 1

Given the DDL shown below:
CREATE TABLE tab1 (coll SMALLINT );
CREATE VIEW v1 AS SELECT coll FROMtabl WHERE coll > 25 ; CREATE VIEW V2 AS SELECT COI1
FROM v1 WITH CASCADED CHECK OPTION
CREATE VIEW v3 AS SELECT coll FROM v2 WHERE coll < 100 ; Which statement will fail?

INSERT INTO v2 VALUES (35)

✘

INSERT INTO v1 VALUES (5)

✘

INSERT INTO v3 VALUES (25)

✘

INSERT INTO v3 VALUES (200)

✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Which statement is correct about informational constraints?

An informational constraint can be used by the SQL compiler to improve the access to data and query performance. ✘ The database manager uses an informational constraint to enforce the uniqueness of the key duringchanges to the columns of the unique constraint. ✘ An informational constraint is a column or combination of columns that has the same properties as a uniqueconstraint. ✘ An informational constraint specifies that every row that is inserted or updated in the table must conform tothe definition of the table. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

A DBA wants to use Label Based Access Control (LBAC) to protect Individual rows in a table. Which data type must be used to create a column to hold the necessary LBAC security data?

SYSPR0C.DB2LBACU\BEL ✘ SYSPR0C.DB2SECURITYU\BEL ✘ SYSIBM.DB2LBACLABEL ✘ SYSIBM.DB2SECURITYLABEL ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Which administrative authority is needed to run the audit stored procedures and table functions such as the AUDIT_DELIM_EXTRACT stored procedure?

DBADM ✘ SECADM ✘ SQLADM ✘ SYS ADM ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

How does the DB2 Server identify the list of GSS-API plug-ins it supports?

by using the SRVCON_GSSPLUGIN_LIST database manager configuration parameter ✘ by using the SRVCON_GSSPLUGIN_LIST registry variable ✘ by using the SRVSUPP_GSSPLUGIN_LIST database manager configuration parameter ✘ by using the SRVSUPP_GSSPLUGIN_LIST registry variable ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Which HADR feature minimizes the impact of software maintenance on the Standby server?

Configure all AUTOMATIC features. ✘ Configure all AUTOMATIC maintenance parameters. ✘ Configure AUTOMATIC maintenance and perform a rolling upgrade ✘ Configure AUTOMATIC maintenance and perform a roll forward. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

A database administrator takes a full backup of the PRODUCTS database every Sunday. During the week, two other backups are taken, one on Tuesday and one on Thursday. The PRODUCTS database is about 800 GB in size, and about 20 percent of the data is modified throughout a week. Assuming that backup times need to be kept to a minimum, which command should be used to produce the Tuesday and Thursday backup images?

BACKUP DATABASE products TO /mnt/backup

✘

BACKUP DATABASE products INCREMENTAL TO /mnt/backup

✘

BACKUP DATABASE products TO /mnt/backup UTIL_IMPACT_PRIORITY 10

✘

BACKUP DATABASE products INCREMENTAL DELTA TO /mnt/backup

✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

A database named PAYROLL was backed up on Sunday. On Tuesday, a table space in the PAYROLL database was renamed from TBSP1 to EMPINFO_TBSP. On Thursday, the database was restored from the backup image created on Sunday. Which command must be issued to roll the renamed table space forward to the current date and time?

ROLLFORWARD DATABASE payroll TO END OF LOGS AND STOP TABLESPACE(tbspl)

✘

ROLLFORWARD DATABASE payroll TO END OF LOGS AND STOPTABLESPACE(empinfo_tbsp)

✘

ROLLFORWARD DATABASE payroll TO END OF LOGS AND STOP TABLESPACE(tbsp 1 TOempinfo_tbsp)

✘

ROLLFORWARD DATABASE payroll TO END OF LOGS AND STOP TABLESPACE(tbsp 1 RENAMEempinfo_tbsp)

✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

If a non-recoverable database crashes, how can a DBA successfully restart the database if a table space is damaged and cannot complete crash recovery?

The database must be restarted using the RESTART DATABASE command with the DROP PENDING TABLESPACES option specified. At that point, the database can be brought on-line and the damaged table space must be dropped and re-created. ✘ The damaged table space must be restored from the latest backup and any active transaction logs in thelog path can then be applied to it using the TABLESPACE ONLINE option of the ROLLFORWARD DATABASE command. This will bring the table space on-line and synchronize it with the rest of the database. ✘ The damaged table space must be restored from the latest backup image. Once restored from the backupimage, the RESTART DATABASE command can be issued to apply all the relevant transactions from the active logs. At that point, the database will come on-line and all table spaces will be synchronized. ✘ The damaged table space will require that the entire database be restored from the latest backup imagebecause the database is non recoverable and will not be accessible. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

10.

Which statement is correct when describing the AUTOCONFIGURE command?

It calculates and displays initial values for the database manager configuration parameters and database configuration parameters for a single database, with the option of applying these values. ✘ It calculates and displays initial values for buffer pool sizes, the database manager configurationparameters, and database configuration parameters for a single database, with the option of applying these values. ✘ It calculates and displays initial values for buffer pool sizes, the database manager configurationparameters, and database configuration parameters for all databases within an instance, with the option of applying these values. ✘ It calculates and displays initial values for the database manager configuration parameters and databaseconfiguration parameters for all databases within an instance, with the option of applying these values. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Prev Next

Congratulations

you have successfully completed the test

Back to Question View Result

Detail Form

We will send your result on your email id and phone no. please fill detail

Name

Email ID Note: Report will be send to the above Email ID

Phone No

IBM DB2 9.7 DBA for Linux UNIX and Windows Set 1

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner