What command would you use to ensure that backup records in the control file are pointing to actual physical files on the backup media?()
时间:2022-11-11
When setting arguments for a job, which procedure do you use for types that cannot be implicitly converted to and from a VARCHAR2 datatype?()
时间:2022-11-10
You issued the following command on the temporary tablespace LMTEMP in your database: SQL>ALTER TABLESPACE lmtemp SHRINK SPACE KEEP 20M; Which requirement must be fulfilled for this command to succeed?()
Which is not a valid way of backing up a control file?()
Which are the two prerequisites before setting up Flashback Data Archive? ()(Choose two.)
Which tuning tool recommends how to optimize materialized views so that these views can take advantage of the general query rewrite feature?()
You want to use the automatic management of backup and recovery operations features for your database. Which configuration must you set?()
You perform a backup using the following BACKUP command: RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE; Which statement is true of this command?()
时间:2022-11-09
Which two statements are true about a job chain? ()(Choose two.)
For which two database objects can the VERSIONS clause of the Flashback Versions Query be used?()(Choose two.)
When manually configuring the SGA,which of the following parameter changes requires an instance restart to take effect?() "First Test, First Pass" - www.lead2pass.com 97 Oracle 1Z0-053 Exam
Before a Flashback Table operation,you execute the following command: ALTER TABLE employees ENABLE ROW MOVEMENT; Why would you need this to be executed?()
Which two statements are correct about database transportation?()
Which command would you use to determine what database backups are currently available for restore?()
On Friday at 11:30 am you decided to flash back the database because of a user error that occurred at 8:30am. Which option must you use to check whether a flashback operation can recover the database to the specified time?()