Examine the following command to create an external table from EMPLOYEES and DEPARTMENTS database tables.1. CREATE TABLE employee_ext2. (employee_id, first_name, department_name)3. ORGANIZATION EXTERNAL4. (5. TYPE ORACLE_LOADER6. DEFAULT DIRECTORY ext_dir7. LOCATION ('emp1.dmp')8. )9. PARALLEL10. AS11. SELECT e.emplyee_id, e.first_name, e.last_name, d.department_name12. FROM employees e, departments d;Which line of the command would cause an error?
Tablespaces of certain types or in certain states can be renamed. Which four of these situations permit renaming a tablespace?
View the Exhibits exhibit1 and exhibit2.Both the processes use PROG_1 as the job template that is already available. The time taken by the jobs are recorded in the TEST_LOG table. While comparing the time taken to create the jobs, the process in exhibit1 takes less time than the process in exhibit2.What is the reason for this?lightweight-job-1 (exhibit):lightweight-job-2 (exhibit):
Which two statements are correct about database transportation? (Choose two.)
Evaluate the following statements:CREATE TABLE purchase_orders (po_id NUMBER(4),po_date TIMESTAMP,supplier_id NUMBER(6),po_total NUMBER(8,2),CONSTRAINT order_pk PRIMARY KEY(po_id))PARTITION BY RANGE(po_date) (PARTITION Q1 VALUES LESS THAN (TO_DATE('1-apr-2007','d-mon-yyyy'),PARTITION Q2 VALUES LESS THAN (TO_DATE('1-jul-2007','d-mon-yyyy'),PARTITION Q3 VALUES LESS THAN (TO_DATE('1-oct-2007','d-mon-yyyy'),PARTITION Q4 VALUES LESS THAN (TO_DATE('1-jan-2008','d-mon-yyyy'));CREATE TABLE purchase_order_items (po_id NUMBER(4) NOT NULL,product_id NUMBER(6) NOT NULL,unit_price NUMBER(8,2),quantity NUMBER(8),CONSTRAINT po_items_fk FOREIGN KEY (po_id)REFERENCES purchase_orders(po_id))PARTITION BY REFERENCE(po_items_fk);What are the two consequences of the above statements? (Choose two.)
You execute these RMAN commands:BACKUP VALIDATE DATABASE;BLOCKRECOVER CORRUPTION LIST;What will these commands do?
