A.Oracle Net Manager B.Oracle Net Control Utility C.Oracle Net Configuration Assistant
单项选择题You issue this SQL statement: ALTER DATABASE RENAME FILE ’ ORADATA u02 user_data01.dbf’ TO ’ ORADATA u04 user_data01.dbf’; What does this SQL statement do?()
A.It updates the control file with the new location of the data file. B.It updates only the data dictionary with the new location of the data file. C.It changes the location of the user_data01.dbf file in the operating system. D.It changes the location of the user_data01.dbf file in the operating system and updates the control file with the new location of the data file.
单项选择题YouareconfiguringforOracleSharedServer.Whichserviceisrequired?()
A.Oracle Net Service B.Oracle HTTP Service C.Oracle Paging Service D.Internet Directory Service
单项选择题Whichstepisrequiredforrecoverfromaninstancefailure?()
A.Start up only. B.Restore needed data files, then start up. C.Complete restore from backup, then start up. D.Perform point in time recovery, then start up.
多项选择题WhenCONFIGURECONTROLFILEAUTOBACKUPissettoON,RMANautomaticallyperformsacontrolfileautobackupinwhichthreesituations?()
A.At the end of every RUN block. B.After every SET CONTROLFILE AUTOBACKUP FORMAT command. C.After every BACKUP or COPY command issued at the RMAN prompt. D.At the end of every RUN block if the last command in the block was either BACKUP or COPY. E.Whenever a BACKUP or COPY command within a RUN block is followed by a command that is neither BACKUP nor COPY. F.After every BACKUP or COPY command within a RUN block that is followed by the CONFIGURE CONTROLFILE AUTOBACKUP FORMAT command.
单项选择题You are creating a recovery catalog for use with RMAN. You have issued these commands: SQL> CREATE TABLESPACE rman_ts DATAFILE ’ DISK1 rman_ts01.dbf’ 2> SIZE 20M 3> DEFAULT STORAGE (initial 100K next 100K pctincrease 0); SQL> CREATE USER rman_db01 IDENTIFIED BY rman_db01 2> DEFAULT TABLESPACE rman_ts 3> QUOTA unlimited ON rman_ts; Which command should you issue next?()
A.RESYNC CATALOG; B.REGISTER DATABASE; C.CREATE CATALOG TABLESPACE rman_ts; D.GRANT recovery_catalog_owner TO rman_db01;