Choose the best answer. Examine this schema information: -1. EMPLOYEES.DEPARTMENT_ID has a foreign key referencing DEPARTMENTS.DEPARTMENT_ID. -2. EMP_VIEW is based on the EMPLOYEES and DEPARTMENTS tables. -3 . EMP_VIEW has columns EMPLOYEE_ID, EMPLOYEE_NAME and DEPARTMENT_NAME. You must add a new column, MANAGER_ID, from the EMPLOYEES table, to the view, showing each employee's manager. Which statement will do this?

Choose the best answer. You need to allow user ANDREW to: -1. Modify the TITLE and ADDRESS columns of your CUSTOMERS table. -2. GRANT that permission to other users. Which statement will do this?

Choose the best answer. Which statement is true about TRUNCATE and DELETE?

Choose the best answer. Table HR. EMPLOYEES contains a row where the EMPLOYEE_ID is 109 . User ALICE has no privileges to access HR . EMPLOYEES. User ALICE starts a session. User HR starts a session and successfully executes these statements: GRANT DELETE ON employees TO alice; UPDATE employees SET salary = 24000 WHERE employee_id = 109; In her existing session ALICE then executes: DELETE FROM hr. employees WHERE employee_id = 109; What is the result?

Choose the best answer.

Choose the best answer. User HR has CREATE SESSION, CREATE ANY TABLE and UNLIMITED TABLESPACE privileges . User SCOTT has CREATE SESSION, CREATE TABLE and UNLIMITED TABLESPACE privileges . HR successfully executes this statement: CREATE TABLE scott. products ( prod_id NUMBER(2) , Prod_name VARCHAR2 (20)); HR attempts to execute: -1. INSERT INTO scott.products VALUES (1 , 'LAPTOP') ; SCOTT attempts to execute: -2 . SELECT ∗ FROM products; -3. INSERT INTO scott. products VALUES (2 , 'HDD'); -4. CREATE SYNONYM prod FOR products; Which will execute successfully?

Choose the best answer. Which statement will compute the total annual compensation for each employee?

Choose the best answer. Which statement is true about using functions in WHERE and HAVING?

Choose the best answer. Which query is valid?

QUESTION 1 You issued this command : DROP TABLE hr employees; Which three statements are true?

QUESTION 2 Which three statements are true about the naming methods and their features supported by Oracle database used to resolve connection information?

QUESTION 3 Which three statements are true about multiple row subqueries?

QUESTION4 Which two WHERE conditions give the same result?

QUESTION 5 Which two statements are true about the Oracle join and ANSI join syntax?

QUESTION 6 Which two statements are true?