Free Oracle 1z0-071 Exam Dumps Questions & Answers

Examine this description of the PRODUCTS table:

Rows exist in this table with data in all the columns. You put the PRODUCTS table in read-only mode.
Which three commands execute successfully on PRODUCTS? (Choose three.)

• A.  ALTER TABLE products SET UNUSED (expiry_date);
• B.  DROP TABLE products;
• C.  ALTER TABLE products DROP UNUSED COLUMNS;
• D.  ALTER TABLE products DROP COLUMN expiry_date;
• E.  TRUNCATE TABLE products;
• F.  CREATE INDEX price_idx ON products (price);

Examine these two queries and their output:
SELECT deptno, dname FROM dept;

SELECT emame, job, deptno FROM emp ORDER BY deptno;

Now examine this query:

How many rows will be displayed?

• A.  6
• B.  64
• C.  3
• D.  12

Which two are true about savepoints? (Choose two.)

• A.  A ROLLBACK TO SAVEPOINT command issued before the start of a transaction results in an error.
• B.  After issuing a savepoint, you cannot roll back the complete transaction.
• C.  They make uncommitted updates visible to other sessions owned by the same user.
• D.  You can commit updates done between two savepoints without committing other updates in the current transaction.
• E.  They make uncommitted updates visible to sessions owned by other users.
• F.  After issuing a savepoints, you can roll back to the savepoint name within the current transaction.

You issued this command:

Which three statements are true? (Choose three.)

• A.  Sequences used to populate columns in the HR.EMPLOYEES table are dropped.
• B.  The HR.EMPLOYEES table may be moved to the recycle bin.
• C.  All indexes defined on HR.EMPLOYEES are dropped.
• D.  Views referencing HR.EMPLOYEES are dropped.
• E.  Synonyms for HR.EMPLOYEES are dropped.
• F.  All constraints defined on HR.EMPLOYEES are dropped.

View the Exhibit and examine the structure of the ORDERStable. The columns ORDER_MODEand ORDER_TOTALhave the default values 'direct'and 0respectively.

Which two INSERTstatements are valid? (Choose two.)

• A.  INSERT INTO orders
  (order_id,order_date,order_mode,order_total)
  VALUES (1,'10-mar-2007',`online',1000);
• B.  INSERT INTO orders
  VALUES (1,'09-mar-2007', `online','', 1000);
• C.  INSERT INTO orders
  VALUES (1,'09-mar-2007', DEFAULT, 101, DEFAULT);
• D.  INSERT INTO orders
  (order_id,order_date,order_mode,
  (customer_id,order_total)
  VALUES (1,TO_DATE(NULL), `online', 101, NULL);
• E.  INSERT INTO
  (SELECT order_id,order_date,customer_id
  FROM orders)
  VALUES (1,'09-mar-2007', 101);