Question 101

Which statement is true about the ALTER SESSION SET CONTAINER command to switch between containers?
  • Question 102

    Which three statements are true about the database instance startup after an instance failure?
  • Question 103

    Examine the RMAN command:
    RMAN> BACKUP VALIDATE DATABASE;
    Which statement is true about the execution of the command?
  • Question 104

    You must unload data from the orders, order_items, and products database tables to four filesusing the External Tables.
    CREATE TABLE orders_ext
    (order_id, order_date, product_id, product_name,quantity)
    ORGANIZATION EXTERNAL ( TYPE ORACLE_DATAPUMP DEFAULT DIRECTORY ext.dir LOCATION ('ordersl.dmp','orders2.dmp','orders3.dmp','lorders4.dmp') ) PARALLEL AS SELECT o.order_id,o.order_date,p.product_id,p.product_name,i.quantity FROM orders o,productsp,order_itemsi WHERE o.orderjd = i.order_id and i.product_id = p.product_id;
    You execute the command shown in the Exhibit, but only two files are created. Which parameter must be changed so that four files are created?
  • Question 105

    Your database is running in ARCHIVELOG mode. Complete database backups are performed daily at midnight. A user accidentally truncates an important table at 10 AM after the last backup. After that, a few important transactions are performed on the database.
    Which two best methods for recovering the truncated table data? (Choose two.)