当前分类: 1Z0-053
问题:单选题You plan to collect the Automatic Workload Repository (AWR) data every Monday morning for a month. You want Oracle Database to automatically create a baseline every Monday and remove the old baseline. What is the correct action to achieve this?()A Cr...
查看答案
问题:单选题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...
问题:At the request of a user, you issue the following command to...
问题:单选题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...
问题:单选题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...
问题:Your database interface is running. A user SCOTT starts a SQ...
问题:You issue the following command: RMAN>CONFIGURE BACKUP OPT...
问题:You need to perform an online table redefinition of an exist...
问题:多选题Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN) while duplicating a running database?()ACreating the control file for the duplicate databaseBRestoring the target data files to the duplicate databaseCPerforming...
问题:多选题Which two statements regarding the Flashback Table feature are correct?()AFlashback Table can be performed on system tables.BFlashback Table operation does not shrink the segments.CFlashback Table uses log mining to extract SQL_REDO and SQL_UNDO statem...
问题:单选题Upon starting your database, you receive the following error: SQL startup ORACLE instance started. Total System Global Area 171581440 bytes Fixed Size 1298640 bytes Variable Size 146804528 bytes Database Buffers 20971520 bytes Redo Buffers 2506752 b...
问题:单选题Your database is in NOARCHIVELOG mode. You start to do a backup, but your users complain that they dont want you to shut down the database to perform the backup. What options are available to you?()A Put the database in hot backup mode and perform an ...
问题:Which two statements are true regarding an Automatic Storage...
问题:多选题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...
问题:Which statement about Automatic Memory Management with Oracl...
问题:单选题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...
问题:多选题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...
问题:If you issue the command shutdown abort prior to trying to p...
问题:You executed the following command to drop a user: DROP US...
问题:单选题Every resource plan must contain an allocation to which consumer group?()A LOW_GROUPB SYS_GROUPC DEFAULT_GROUPD BASE_GROUPE OTHER_GROUPS...