其他类 - Oracle认证考试

单选题

Evaluatethefollowingcommand: Whichstatementistrueregardingtheabovecommand?（）

A. TheLOBmaticallycompressed.
B. TheLOBvaluesarecachedbvaluesareautoydefaultinthebuffercache.
C. TheLOBvaluesareautomaticallystoredinencryptedmode.
D. AllLOBdatathatisidenticalintwoormorerowsinaLOBcolumnsharethesamedatablocks.

查看答案

单选题

YouaremanagingtheAPPPRODdatabaseasaDBAwhichisnotusingtheOracle-managedfiles.YouplantoduplicatethisdatabaseinthesamesystemwiththenameDUPDB.Youwanttocreatethesamedirectorystructureforduplicatedatabasefilesasofthetargetdatabase. YouexecutedthefollowingRMANcommands: Whataretheimplicationsofthiscommand?（）

A. ItcreatesdatabasefilesfortheduplicatedatabaseundertheOraclebasewithadifferentdirectoryfortheduplicatedatabase.
B. Itoverwritesdatafilesofthetargetdatabasebecauseadifferentlocationfordatafilesisnotmentionedfortheduplicatedatabase.
C. ItcreatesdatabasefilesfortheduplicatedatabaseunderthesameOraclehomeasthatofthetargetdatabasewiththesamedirectorystructure.
D. ItcreatesdatabasefilesfortheduplicatedatabaseunderthesameOraclehomeasthatofthetargetbutwithadifferentdirectoryfortheduplicatedatabase.

查看答案

多选题

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.

查看答案

单选题

Before a Flashback Table operation，you execute the following command： ALTER TABLE employees ENABLE ROW MOVEMENT； Why would you need this to be executed？（）

A. Because row IDs may change during the flashback operation
Because the object number changes after the flashback operation
C. Because the rows are retrieved from the recycle bin during the flashback operation
D. Because the table is moved forward and back to a temporary during the flashback opertion

查看答案

单选题

Inyourdatabase,theLDAP_DIRECTORY_SYSAUTHinitializationparameterhasbeensettoYESandtheuserswhoneedtoaccessthedatabaseasDBAshavebeengrantedSYSDBAenterpriseroleinOracleInternetDirectory(OID).SSLandthepasswordfilehavebeenconfigured.AuserSCOTTwiththeSYSDBAprivilegetriestoconnecttothedatabaseinstancefromaremotemachineusingthecommand: Whichauthenticationmethodwouldbeusedfirst?（）

A. authenticationbypasswordfile
B. authenticationbyusingcertificatesoverSSL
C. authenticationbyusingtheOracleInternetDirectory
D. authenticationbyusingthelocalOSofthedatabaseserver

查看答案

单选题

View the Exhibit and examine the Flashback Database architecture. Identify the missing component （shown with a "？"） in the Flashback Database architecture.（）

A. DBWn
B. RVWR
C. ARCH
D. RECO
E. TRWR

查看答案

单选题

In Recovery Manager （RMAN）， you are taking image copies of the data files of your production database and rolling them forward at regular intervals. You attempt to restart your database. After a regular maintenance task， you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the data file by using the image copy. Because a media failure caused the data file to be damaged， you want to place the data file in a different location while resto ing the file. Which option must you consider for this task？（）

A. using only the RMAN SWITCH command to set the new location for the data file
B. placing the database in the MOUNT state for the restore and recovery operations
C. using an RMAN RUN block with the SET NEWNAME and then the SWITCH command
D. configuring two channels： one for the restore operation and the other for the recovery operation

查看答案

多选题

Given: WhichtwostatementsaretrueabouttheresultifthedefaultlocaleisLocale.US?（）

A. Thevalueofbis2.
B. Thevalueofais3.14.
C. Thevalueofbis2.00.
D. Thevalueofais3.141.
E. Thevalueofais3.1415.
F. Thevalueofais3.1416.
G. Thevalueofbis2.0000.

查看答案