Oracle 12c SQL Post-Assessment

Identify SELECT statements that execute successfully? (choose 2 answers)

• SELECT first_name, last_name, job_id, salary*12 AS

  Yearly Sal FROM employees;

• SELECT first_name, last_name, job_id, salary*12

  "yearly sal" FROM employees;

• SELECT first_name, last_name, job_id, salary AS

  "yearly sal" FROM employees;

• SELECT first_name+last_name AS name, job_Id, salary*12

  yearly sal FROM employees;

Which of the following are valid operators for the WHERE clause? (Choose 2 answers)

• =>

• IS NULL

• !=

• IS LIKE

• IN BETWEEN

In Oracle 12c, a single instance can have more than one database?

• True

• False

In Oracle 12c, which of the following are shared among all the PDBs (Choose 2 answers)?

• Memory Structures

• Background Processess

• Database Files

What are the new features of Oracle 12c Database? (Choose 2 answers)

• Invisible Columns

• SQL Row Limiting Clause

• Group By Clause

• Where Clause

Using a subquery is equivalent to performing two sequential queries and using the result of the inner query as the search criteria for the outer query?

• True

• False

The following statements make the table empty, leaving the table structure intact:

DELETE FROM copy_emp;

TRUNCATE TABLE copy_emp;

• True

• False

Indexes must be created manually and serve to speed up access to rows in a table.

• True

• False

Which of the following character functions can be used for case conversions? (choose 3 answers)

• upper()

• lower()

• Initcap()

• uppercase()

• lowercase()

Identify the correct aggregate functions that can be used in Oracle? (choose 3 answers)

• sum()

• avg()

• total()

• minimum()

• min()