Online Access Free 1z0-061 Practice Test

Examine the structure of the MARKS table:
Exhibit:

Which two statements would execute successfully? (Choose two.)

• A.SELECT student_name, subject1FROM marksWHERE subject1 > AVG(subject1);
• B.SELECT SUM(DISTINCT NVL(subject1, 0)), MAX(subject1)FROM marksWHERE
  subject1 > subject2;
• C.SELECT SUM(subject1+subject2+subject3)FROM marksWHERE student_name IS NULL;
• D.SELECT student_name, SUM(subject1)FROM marksWHERE student_name LIKE 'R%';

You work as a database administrator at ABC.com. You study the exhibit carefully.
Exhibit:

You want to create a SALE_PROD view by executing the following SQL statements:

Which statement is true regarding the execution of the above statement?

• A.The view will be created and you can perform DLM operations on the view
• B.The view will not be created because the GROUP BY clause is not allowed for creating a view
• C.The view will not be created because the join statements are not allowed for creating a view
• D.The view will be created but no DML operations will be allowed on the view

Which statement is true regarding synonyms?

• A.The DROP SYNONYM statement removes the synonym and the table on which the synonym has been created becomes invalid
• B.Synonyms can be created only for a table
• C.Synonyms are used to reference only those tables that are owned by another user
• D.A public synonym and a private synonym can exist with the same name for the same table

Which two statements are true regarding savepoints? (Choose two.)

• A.Savepoints are effective for both COMMIT and ROLLBACK.
• B.Savepoints are effective only for COMMIT.
• C.Savepoints may be used to ROLLBACK.
• D.Savepoints can be used for only DML statements.
• E.Savepoints can be used for both DML and DDL statements.

See the Exhibit and examine the structure of ORD table:
Exhibit:

Evaluate the following SQL statements that are executed in a user session in the specified order:
CREATE SEQUENCE ord_seq;
SELECT ord_seq.nextval
FROM dual;
INSERT INTO ord
VALUES (ord_seq.CURRVAL, '25-jan-2007, 101);
UPDATE ord
SET ord_no= ord_seq.NEXTVAL
WHERE cust_id =101;
What would be the outcome of the above statements?

• A.All the statements would execute successfully and the ORD_NO column would have the value 20 for the CUST_ID 101 because the default CACHE value is 20.
• B.All the statements would execute successfully and the ORD_NO column would contain the value 2 for the CUST_ID 101.
• C.The CREATE SEQUENCE command would not execute because the minimum value and maximum value for the sequence have not been specified.
• D.The CREATE SEQUENCE command would not execute because the starting value of the sequence and the increment value have not been specified.