Which two statements are true about the Automatic Diagnostic Repository (ADR)?
Which two options can be configured for an existing database by using the Database Configuration Assistant (DBCA)?
Your database is running in archivelog mode. Examine the initialization parameters you plan to set for your database instance.LOG_ARCHIVE_DEST_1 = 'LOCATION=/disk1/arch'LOG_ARCHIVE_DEST_2 = 'L0CATI0N=/disk2/3rch'LOG_ARCHIVE_DEST_3 = 'LOCATION=/disk3/arch'L0G_ARCHIVE_DEST_4 = 'L0CATI0N=/disk4/3rch MANDATORY'Identify the statement that correctly describes these settings.
What can be automatically implemented after the SQL Tuning Advisor is run as part of the Automated Maintenance Task?
Examine the commands:SQL> ALTER SESSION SET RECYCLBIN = ON;Session altered.SQL> DROP TABLE emp; --(First EMP table)Total dropped.SQL> CREATE TABLE emp (id NUMBER CONSTRAINT emp_id_idx PRIMARY KEY, name VARCHAR2 (15), salary NUMBER(7,2) );Table created.You then execute multiple INSERT statements to insert rows into EMP table and drop the table again:SQL> DROP TABLE emp; -- (Second EMP table)Table dropped.SQL> FLASHBACK TABLE emp TO BEFORE DROP;Which statement is true about the FLASHBACK command?
A telecom company wishes to generate monthly bills to include details of customer calls, listed in order of time of call.Which table organization allows for generating the bills with minimum degree of row sorting?
