Examine this data in the EMPLOYEES table:

Which statement will execute successfully?
Which statement will execute successfully?

• A.SELECT dept_id, LENGTH (last: name) , SUM(salary) FROM employees GROUP BV dept_id;
• B.SELECT dept_id( INSTR(last_name, 'A'), SUM (salary) FROM employees GROUP BY dept_id;
• C.SELECT dept_id, MAX (last_name) . SUM(salary) FROM employees GROUP BY dept_id;
• D.SELECT dept_id, STDDEV(last_name), SUM( salary) FROM employees GROUP BV dept_id;

Comment: *

Name: *

Email: *

Verification: *

Which three tasks can be performed by DDL statements? (Choose three.)

• A.creating multiple savepoints to enable partial rollback of a transaction
• B.preventing data retrieval from a table outside of office hours
• C.preventing any data modification to a table
• D.providing an alternative name for a table
• E.modifying a table to prevent data that violate certain conditions from being entered in a column

Comment: *

Name: *

Email: *

Verification: *

Which three are true about system and object privileges? (Choose three.)

• A.WITH GRANT OPTION can be used when granting an object privilege to both users and roles
• B.Adding a primary key constraint to an existing table in another schema requires a system privilege
• C.Adding a foreign key constraint pointing to a table in another schema requires the REFERENCES object privilege
• D.Revoking a system privilege that was granted with WITH ADMIN OPTION has a cascading effect
• E.Revoking an object privilege that was granted with the WITH GRANT OPTION clause has a cascading effect.
• F.WITH GRANT OPTION cannot be used when granting an object privilege to PUBLIC

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the structure of ORDERS and CUSTOMERS tables.
(Choose the best answer.)

You executed this UPDATE statement:
UPDATE
( SELECT order_date, order_total, customer_id FROM orders)
Set order_date = '22-mar-2007'
WHERE customer_id IN
(SELECT customer_id FROM customers
WHERE cust_last_name = 'Roberts' AND credit_limit = 600);
Which statement is true regarding the execution?

• A.It would not execute because a SELECT statement cannot be used in place of a table name.
• B.It would not execute because a subquery cannot be used in the WHERE clause of an UPDATE statement.
• C.It would execute and restrict modifications to the columns specified in the SELECT statement.
• D.It would not execute because two tables cannot be referenced in a single UPDATE statement.

Comment: *

Name: *

Email: *

Verification: *

Evaluate the following query

What is the correct output of the above query?

• A.+25-00, +00-650, +00 11:12:10.123457
• B.+00-300, +00-650, +00 11:12:10.123457
• C.+00-300, +54-02, +00 11:12:10.123457
• D.+25-00, +54-02, +00 11:12:10.123457

Comment: *

Name: *

Email: *

Verification: *