题目内容

An administrator wants to clean up the database by removing non-registered customer records using the Database Cleanup utility. Which of the following is the correct syntax to perform this task？（）

A
B
C
D
E

查看答案

搜索结果不匹配？点我反馈

更多问题

An administrator identified a problem with an AIX command and implemented a work-around. A call was made to IBM Support to report the problem. What severity level should the administrator choose（）

A. Crit-Sit
B. Severity 1
C. Severity 2
D. Severity 3

查看答案

You are managing a 24*7 database. The backup strategy for the database is to perform user-managed backups. Identify two prerequisites to perform the backups.（）

A. The database must be opened in restricted mode.
B. The database must be configured to run in ARCHIVELOG mode.
C. The tablespaces are required to be in backup mode before taking the backup.
D. The tablespaces are required to be in read-only mode before taking the backup

查看答案

View the Exhibit. One of the important tables in the USERS tablespace was dropped and purged from the recycle bin at 9：00 a.m. You noticed this at 11：00 a.m. and you want to perform an incomplete recovery to recover the table. Which statement is true？（）

A. You must recover all data files to the required system change number （SCN）.
B. You must recover all data files， except those that are offline， to the required SCN .
C. You must recover all data files belonging to the USERS tablespace to the required SC
D. You cannot recover all data files because segment space management is performed manually for the undo tablespace.

查看答案

ViewtheExhibitforsomeoftheparametersettings.Youstartasessionandissuethefollowingcommand: SQL>CREATEINDEXemp_enameONemp(ename)TABLESPACEusersINVISIBLE; Whatistheoutcomeoftheabovecommand?（）

A. TheindexisnotusedbytheoptimizerbutismaintainedduringDMLoperations.
B. TheindexisnotusedbytheoptimizerandisnotmaintainedduringDMLoperations.
C. TheindexisusedbytheoptimizeronlyifahintisspecifiedinthequerystatementandismaintainedduringDMLoperations.
D. TheindexisusedbytheoptimizeronlyifahintisspecifiedinthequerystatementbutisnotmaintainedduringDMLoperations.

查看答案

An administrator wants to clean up the database by removing non-registered customer records using the Database Cleanup utility. Which of the following is the correct syntax to perform this task？（）

A B C D E

An administrator identified a problem with an AIX command and implemented a work-around. A call was made to IBM Support to report the problem. What severity level should the administrator choose（）

You are managing a 24*7 database. The backup strategy for the database is to perform user-managed backups. Identify two prerequisites to perform the backups.（）

View the Exhibit. One of the important tables in the USERS tablespace was dropped and purged from the recycle bin at 9：00 a.m. You noticed this at 11：00 a.m. and you want to perform an incomplete recovery to recover the table. Which statement is true？（）

ViewtheExhibitforsomeoftheparametersettings.Youstartasessionandissuethefollowingcommand: SQL>CREATEINDEXemp_enameONemp(ename)TABLESPACEusersINVISIBLE; Whatistheoutcomeoftheabovecommand?（）

A
B
C
D
E