当前分类: 1Z0-053
问题:Consider the following code snippet: BEGIN DBMS_SCHEDULER...
查看答案
问题:多选题Which statements are true regarding SecureFile LOBs?()AThe amount of undo retained is user controlled.BSecureFile LOBs can be used only for nonpartitioned tables.CFragmentation is minimized by using variable-sized chunks dynamically.DSecureFile encrypt...
问题:单选题A shoot-out has erupted between your MS development teams using .NET and your Linux development teams using Java. Knowing that your database is in danger,which command would you use to back up your NOARCHIVELOG mode database using RMAN with compressio...
问题:At the request of a user, you issue the following command to...
问题:单选题you can perform an active database duplication when the database is in NOARCHIVELOG mode.()A TrueB False...
问题:单选题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 operationB Because the object number changes af...
问题:单选题Examine the following PL/SQL block: SET SERVEROUTPUT ON SET LONG 10000 ECLARE report clob; BEGIN report := DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE(); DBMS_OUTPUT.PUT_LINE(report); END; Which statement describes the effect of the execution of the above P...
问题:You executed the following command to drop a user: DROP US...
问题:多选题What information does the report schema command not provide?()ASize of the datafilesBSize of the tempfilesCDate of last backup for datafiles and tempfilesDFilenames for each datafileECheckpoint SCN associated with the last RMAN backup...
问题:单选题Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of the DATA1 tablespace. You place the DATA1 tablespace in backup mode by issuing the following statement: ALTER TABLESPACE data1 BEGIN BACKUP; While you are performi...
问题:单选题What is the impact of the results of the output of the following command?() RMAN report unrecoverable database; Report of files that need backup due to unrecoverable operations File Type of Backup Required Name 4 full or incremental C:///ORACLE/OR...
问题:多选题Using the LIST command in Recovery Manager (RMAN), which two pieces of information in the RMANrepository can be listed?() (Choose two.)Astored scripts in the recovery catalog.Bbackups that can be deleted from disk.Cbackup sets and image copies are obso...
问题:单选题When performing a database duplication, which duplicate database parameter would you set to ensure that the online redo logs are created in the correct location?()A log_file_name_convertB convert_log_file_nameC file_name_convert_logD redo_log_file_...
问题:单选题What is the correct order of steps to perform an online database backup?() a. alter database begin backup b. alter database end backup c. Back up the database datafiles d. Back up the archive log files e. alter system switch logfileA a, b, c, d, eB e...
问题:多选题Which of the following are valid until command options when attempting point-in-time recovery in RMAN?()Auntil timeBuntil changeCuntil sequenceDuntil SCNEuntil commit...
问题:You issue the following command: RMAN>CONFIGURE BACKUP OPT...
问题:单选题Tape streaming is not happening while performing RMAN tape backup. On investigation, you find that it is not because of the incremental backup or the empty file backup and that RMAN is sending data blocks to the tape drive fast enough. What could be a ...
问题:单选题Which command would you use to determine what database backups are currently available for restore?()A list database backupB report database backupC list backup of databaseD list summary backupE report backup of database...
问题:Which statement about Automatic Memory Management with Oracl...
问题:单选题Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query: SQL SELECT * FROM sales; Which process would retrieve the result from the database and return it to the client program?()A User processB ...