问题:多选题On which two database objects can the VERSIONS clause of the Flashback Versions Query be used?()Afixed tablesBheap tablesCexternal tablesDtemporary tablesEIndex-Organized Tables (IOTs)...
查看答案
问题:Identify the persistent configuration setting for the target...
问题:You backed up the database at 8 a.m. today using an online b...
问题:单选题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...
问题:You issue the following command: RMAN>CONFIGURE BACKUP OPT...
问题:You want to use RMAN to create compressed backups.Which stat...
问题:单选题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...
问题:单选题Which of the following statements best describes Flashback Versions Query?()A Flashback Versions Query is used to make changes to multiple versions of data that existed between two points in time.B Flashback Versions Query is used to view all version...
问题:You executed the following command to drop a user: DROP US...
问题:At the request of a user, you issue the following command to...
问题:单选题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...
问题:单选题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 statement about Automatic Memory Management with Oracl...
问题:单选题Which statement is true when Automatic Workload Repository (AWR) baselines are created using baseline templates?()A AWR baselines are always created as repeating baselines.B AWR baselines can be created on the basis of two time values.C AWR baseline...
问题:单选题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...
问题:Which type of backup contains only the blocks that have chan...
问题:多选题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 of these appropriately describes the results of a manu...
问题:多选题Which of the following are valid settings for the NLS_COMP parameter?()AASCIIBANSICBINARYDMONOLINGUALEMULTILINGUAL...