Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.)
Examine the values for the following initialization parameters: FAST_START_MTTR_TARGET=0 LOG_CHECKPOINT_INTERVAL=0Which two will be the implications of these values in your database? (Choose two.)
SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL;What is the effect of this command?
A user, who is authenticated externally, logs in to a remote machine and connects to the database instance. What action would you take to ensure that a user cannot connect to the database instance by merely logging in to a remote machine?
Which two statements are true about Shared SQL Area and Private SQL Area? (Choose two.)
While observing the index statistics, you find that an index is highly fragmented, thereby resulting in poor database performance. Which option would you use to reduce fragmentation without affecting the users who are currently using the index?
You executed the following command to create a password file in the database server: $ orapwd file = orapworcl entries = 5 ignorecase=NWhich statement describes the purpose of the above password file?
Which two statements correctly describe the relation between a data file and the logical database structures? (Choose two.)
You want to access employee details contained in flat files as part of the EMPLOYEE table. You plan to add a new column to the EMPLOYEE table to achieve this.Which data types would you use for the new column?
You configured the Flash Recovery Area for your database. The database instance has been started in ARCHIVELOG mode and the LOG_ARCHIVE_DEST_1 parameter is not set. What will be the implications on the archiving and the location of archive redo log files?