最新のC2090-544問題集で試験を準備する

At which two levels can events be audited? (Choose two.)

• A. Database level
• B. Node level
• C. Server level
• D. Operating System level
• E. Instance level

The DBA needs to create a table with key columns YEARDAY, YEAR, and DAY. This table needs to be partitioned by column YEARDAY with three months per data partition. Additionally, data needs to be organized so that all rows within any three month date range are clustered together based on 12 months of data. Which CREATE TABLE statement will accomplish this objective?

• A. CREATE TABLE tab1
  (yearday INT,
  year CHAR(2),
  day INT))
  PARTITION BY RANGE (year) (STARTING 201001 ENDING 201012 EVERY 3)
  ORGANIZE BY DIMENSIONS (year, day))
• B. CREATE TABLE tab1
  (yearday INT,
  year CHAR(2),
  day INT))
  PARTITION BY RANGE (yearday) (STARTING 201001 ENDING 201012 EVERY 3)
  ORGANIZE BY DIMENSIONS (year))
• C. CREATE TABLE tab1
  (yearday INT,
  year CHAR(2),
  day INT))
  PARTITION BY RANGE (yearday) (STARTING 201001 ENDING 201012 EVERY 3)
  ORGANIZE BY DIMENSIONS (year, day))
• D. CREATE TABLE tab1
  (yearday INT,
  year CHAR(2),
  day INT))
  PARTITION BY RANGE (yearday) (STARTING 201001 ENDING 201012 EVERY 3)
  ORGANIZE BY DIMENSIONS (day))

A database and a table space were created using the following commands:

Afterwards, two tables were created in table space TBSP1 and both tables were populated with 100,000 rows. If a DBA decides that database MYDB should use automatic storage, which command(s) are needed to convert both the database and table space TBSP1?

• A. ALTER DATABASE mydb AUTOMATIC STORAGE YES ON ?mnt/path_1? ?mnt/path_2? ALTER TABLESPACE tbsp1 MANAGED BY AUTOMATIC STORAGE;
• B. ALTER DATABASE mydb AUTOMATIC STORAGE YES ON ?mnt/path_1? ?mnt/path_2?
• C. ALTER DATABASE mydb ADD STORAGE ON ?mnt/path_1? ?mnt/path_2? ALTER TABLESPACE tbsp1 MANAGED BY AUTOMATIC STORAGE;
• D. ALTER DATABASE mydb ADD STORAGE ON ?mnt/path_1? ?mnt/path_2?

A Windows user with a local database is not able to connect to a zOS database. The System Database Directory and the Node Directory have the correct entries. Other users can connect to the database from their workstations without problems. What should be done resolve the problem?

• A. Catalog the zOS database in the Database Connection Services Directory.
• B. Uncatalog and re-catalog the directory entries for the zOS database and try again.
• C. Catalog the zOS database in the Distributed Data Facility Directory.
• D. Catalog the zOS database in the Local Database Directory.

Click the Exhibit button.

Refer to the table definition shown in the exhibit.
Which will improve performance based on the query SELECT c6, c9 FROM tab3 WHERE c9 = 123456?

• A. CREATE INDEX idx98 ON tab3 (c2 ASC, c6 ASC); CREATE INDEX idx99 ON tab3 (c2 ASC, c9 ASC); RUNSTATS ON TABLE myschema.tab3;
• B. CREATE INDEX idx99 ON tab3 (c6 ASC, c9 DESC); REORG TABLE myschema.tab3 AND INDEXES ALL;
• C. CREATE INDEX idx99 ON tab3 (c2 ASC, c9 DESC); REORG TABLE myschema.tab3 AND INDEXES ALL;
• D. CREATE INDEX idx98 ON tab3 (c6 ASC); CREATE INDEX idx99 ON tab3 (c9 DESC); RUNSTATS ON TABLE myschema.tab3;