IBM DB2 9.7 DBA for Linux UNIX and Windows - C2090-541무료 덤프문제 풀어보기
Which two actions can you perform when using Optim Database Administrator? (Choose two.)
정답: C,D
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?
정답: B
Which statement is true about unique constraints?
정답: B
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?
정답: C
Which command is used to configure the administrative task scheduler to execute tasks?
정답: C
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?
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?
정답: B