최신 IBM certifications I C2090-541 무료샘플문제:

1. Click the Exhibit button.

What does the SQL in the exhibit show?

A) The SQL shows the most frequently used indexes on the SYSIBM.SYSTABLES table since the last database activation.
B) THE SQL shows indexes on SYSIBM.SYSINDEXES table that have not been used since the last database activation.
C) The SQL shows the most frequently used indexes on the SYSIBM.SYSINDEXES table since the last database activation
D) The SQL shows indexes on the SYSIBM.SYSTABLES table that are used for index-only access.

2. 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?

A) INSERT INTO v2 VALUES (35)
B) INSERT INTO v1 VALUES (5)
C) INSERT INTO v3 VALUES (25)
D) INSERT INTO v3 VALUES (200)

3. 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?

A) ROLLFORWARD DATABASE payroll TO END OF LOGS AND STOPTABLESPACE(empinfo_tbsp)
B) ROLLFORWARD DATABASE payroll TO END OF LOGS AND STOPTABLESPACE(tbspl)
C) ROLLFORWARD DATABASE payroll TO END OF LOGS AND STOPTABLESPACE(tbsp 1 TO empinfo_tbsp)
D) ROLLFORWARD DATABASE payroll TO END OF LOGS AND STOPTABLESPACE(tbsp 1 RENAME empinfo_tbsp)

4. Which statement is correct when describing the AUTOCONFIGURE command?

A) It calculates and displays initial values for buffer pool sizes, the database manager configuration parameters, and database configuration parameters for all databases within an instance, with the option of applying these values.
B) 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.
C) It calculates and displays initial values for the database manager configuration parameters and database configuration parameters for all databases within an instance, with the option of applying these values.
D) It calculates and displays initial values for buffer pool sizes, the database manager configuration parameters, and database configuration parameters for a single database, with the option of applying these values.

5. Given the following CREATE TABLE statement:
CREATE TABLE applicant (id INTEGER NOT NULL PRIMARY KEY, lastname VARCHAR(50));
Which SQL statement will execute successfully?

A) ALTER TABLE applicant ADD COLUMN resumeXML(1000) CHECK (resume IS VALIDATED)
B) ALTER TABLE applicant ADD COLUMN resume XML CHECK (resume IS VALIDATED)
C) ALTER TABLE applicant ADD COLUMN resumeXML(1000) WITH DEFAULT
D) ALTER TABLE applicant ADD COLUMNresume XML WITH DEFAULT

질문과 대답: