Oracle 12C SQL (ICT 3722) Exam with Questions and Verified Answers

It covers key domains which include; Constraints, Data Definition Language (DDL), Data Manipulation Language (DML), Subqueries, Joins and Set Operators. A database developer is creating a simple view in Oracle 12c to display employee names and salaries from the Employees table. Which SQL statement correctly creates a basic view? a. CREATE TABLE emp_view AS SELECT name, salary FROM employees b. CREATE VIEW emp_view AS SELECT name, salary FROM employees c. CREATE OR REPLACE TABLE emp_view AS SELECT name, salary FROM employees d. ALTER VIEW emp_view AS SELECT name, salary FROM employees Correct Answer: b Rationale: A simple view in Oracle is created using the CREATE VIEW statement, not CREATE TABLE or ALTER VIEW. CREATE OR REPLACE VIEW is used when modifying an existing view definition, while CREATE VIEW is used for initial creation. A developer creates a view that joins two tables: Employees and Departments, and includes a GROUP BY clause. What is the implication of this design? a. The view is fully updatable without restrictions b. The view automatically enforces referential integrity c. The view can only be used for DML operations like INSERT d. The view is generally not updatable due to aggregation and joins Correct Answer: d Rationale: Views that contain joins, GROUP BY, aggregate functions, or DISTINCT are typically not updatable in Oracle because the database cannot uniquely map changes back to underlying base tables.