Subscribe

Share

Database, SQL and PL/SQL

Oracle Database 12c SQL Certified Associate

Test your Oracle Database 12c SQL skills.

By Joel Goodman

May/June 2016

The new Oracle Database 12c SQL exam tests your depth of knowledge of SQL and how to use it with Oracle Database 12c. By passing this exam, an Oracle certified associate proves fluency in and a solid understanding of the SQL language and data modeling and demonstrates how to use SQL to create and manipulate tables in Oracle Database. Successful exam candidates will gain Oracle Database 12c SQL Certified Associate certification.

Interested in getting Oracle Database 12c SQL–certified? Take the next step. Test your Oracle Database 12c SQL skills with the following three practice exam questions.

Question 1

You successfully execute the following SQL statement:

GRANT UPDATE (quantity, sales_date)
ON jim.sales
TO david
WITH GRANT OPTION;

Which two statements are true?

a. DAVID may grant this privilege to all users in the database, but he may not grant it to PUBLIC.

b. DAVID may grant this privilege to a role that has been granted to him.

c. DAVID may revoke this privilege from users who have been granted this privilege by him.

d. JIM may revoke this privilege from roles that have been granted this privilege by DAVID.

e. JIM may revoke this privilege from users who have been granted this privilege by DAVID.

Question 2

Which three statements are true about roles?

a. A password may be specified for a role only when the role is created.

b. A role may be granted both system and object privileges.

c. A role may be dropped only after it is revoked manually from all users and roles to which it has been granted.

d. Multiple roles may be granted to a role.

e. Multiple roles granted to a user may be enabled as default roles for that user.

Question 3

Which three statements are true about indexes in Oracle Database 12c?

a. There may be more than one index on a single column.

b. Indexes may not always speed up data access to table data.

c. Invisible indexes are not maintained by data manipulation language (DML) operations.

d. Multiple invisible indexes may exist on a column.

e. Indexes may be created on a view.

Badge Me In

LEARN more about the Oracle Certification Program.

Certification demonstrates your understanding of fundamental concepts and gets you noticed for new projects and jobs. Becoming Oracle-certified helps you better present your skills, too. In addition to a certificate, Oracle certifications now include a digital badge, suitable for posting on your social media accounts.

 

 


Next Steps

 LEARN more about the Oracle Certification Program.

 GET CERTIFIED as an Oracle Database 12c SQL Certified Associate.

 READ Inside OCP columns.

 

Photography by Scott Webb, Unsplash