Oracle Test 5

The DESCRIBE DEPT statement displays the structure of the DEPT table.

The ROLLBACK statement frees the storage space occupies by the DEPT table.

The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist.

The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT statement introduced before the ROLLBACK statement.

The SQL statement displays the desired results.

The column in the WHERE clause should be changed to display the desired results.

The operator in the WHERE clause should be changed to display the desired results.

The WHERE clause should be changed to use an outer join to display the desired results.

0

1

0.00

An error statement

The value displayed in the CALC_VALUE column will be lower.

The value displayed in the CALC_VALUE column will be higher.

There will be no difference in the value displayed in the CALC_VALUE column.

An error will be reported.

SELECT dept_id, MIN(salary(, MAX(salary) FROM employees WHERE MIN(salary) < 5000 AND MAX(salary) > 15000;

SELECT dept_id, MIN(salary), MAX(salary) FROM employees WHERE MIN(salary) < 5000 AND MAX(salary) > 15000 GROUP BY dept_id;

SELECT dept_id, MIN(salary), MAX(salary) FROM employees HAVING MIN(salary) < 5000 AND MAX(salary) > 15000;

SELECT dept_id, MIN(salary), MAX(salary) FROM employees GROUP BY dept_id HAVING MIN(salary) < 5000 AND MAX(salary) < 15000;

SELECT dept_id, MIN(salary), MAX(salary) FROM employees GROUP BY dept_id, salary HAVING MIN(salary) < 5000 AND MAX(salary) > 15000;

The statement executes successfully and returns the student ID and sum of all marks for each student who obtained more than the average mark in each subject

The statement returns an error at the SELECT clause.

The statement returns an error at the WHERE clause.

The statement returns an error at the ORDER BY clause. SUBJ2

MERGE INTO new_employees c USING employees e ON (c.employee_id = e.employee_id) WHEN MATCHED THEN UPDATE SET c.name = e.first_name ||’,’|| e.last_name WHEN NOT MATCHED THEN INSERT VALUES(e.employee_id, e.first_name ||’, ‘||e.last_name);

MERGE new_employees c USING employees e ON (c.employee_id = e.employee_id) WHEN EXIST THEN UPDATE SET c.name = e.first_name ||’,’|| e.last_name WHEN NOT MATCHED THEN INSERT VALUES(e.employee_id, e.first_name ||’, ‘||e.last_name);

MERGE INTO new employees c USING employees e ON (c.employee_id = e.employee_id) WHEN EXISTS THEN UPDATE SET c.name = e.first_name ||’,’|| e.last_name WHEN NOT MATCHED THEN INSERT VALUES(e.employee_id, e.first_name ||’, ‘||e.last_name);

MERGE new_employees c FROM employees e ON (c.employee_id = e.employee_id) WHEN MATCHED THEN UPDATE SET c.name = e.first_name ||’,’|| e.last_name WHEN NOT MATCHED THEN INSERT INTO new_employees VALUES(e.employee_id, e.first_name ||’.’||e.last_name);

CREATE INDEX NAME_IDX (first_name, last_name);

CREATE INDEX NAME_IDX (first_name AND last_name);

CREATE INDEX NAME_IDX ON (first_name, last_name);

CREATE INDEX NAME_IDX ON employees (first_name AND last_name);

CREATE INDEX NAME_IDX ON employees(first_name, last_name);

CREATE INDEX NAME_IDX FOR employees(first_name, la st_name);

SELECT student_ id, marks, ROWNUM "Rank" FROM students WHERE ROWNUM

SELECT student_id, marks, ROWID "Rank" FROM students WHERE ROWID

SELECT student_id, marks, ROWNUM "Rank" FROM (SELECT student_id, marks FROM students WHERE ROWNUM

SELECT student_id, marks, ROWNUM "Rank: FROM (SELECT student_id, marks FROM students ORDER BY marks) WHERE ROWNUM

Immediately after the SELECT clause

. Before the WHERE clause

Before the FROM clause

After the ORDER BY clause

After the WHERE clause

The indexed column is declared as NOT NULL.

The indexed columns are used in the FROM clause

The indexed columns are part of an expression

The indexed column contains a wide range of values.

Because of a syntax problem, no row will be returned

It calculates, for each employee in the employees table, the average salary of the employees reporting to his/her respective manager

It calculates, for each employee in the employees table, the average salary of the employees reporting to his/her respective manager who were hired just before the employee

It calculates, for each employee in the employees table, the average salary of the employees reporting to the same manager who were hired in the range just before through just after the employee

It calculates, for each employee in the employees table, the average salary of the employees reporting to his/her respective manager who were hired just after the employee

You obtain the results retrieved from the public synonym HR created by the database administrator.

You obtain the results retrieved from the HR table that belongs to your schema.

You get an error message because you cannot retrieve from a table that has the same name as a public synonym.

You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a Cartesian product.

You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a FULL JOIN.

None

A change to the DEFAULT value affects only subsequent insertions to the table.

Column definitions cannot be altered to add DEFAULT values for columns with a NUMBER data type.

All the rows that have a NULL value for the SALARY column will be updated with the value 5000.

What is necessary for your query on an existing view to execute successfully?

You need SELECT privileges on the view.

The underlying tables must be in the same schema.

You need SELECT privileges only on the underlying tables

Substitution variables

Replacement variables

Prompt variables

Instead-of variables

This feature cannot be implemented through /SQL*Plus.

INSERT

UPDATE

SELECT

DESCRIBE

DELETE

RENAME

=

LIKE

BETWEEN

NOT IN

IS

SELECT ename, salary*12 ‘Annual Salary’ FROM employees;

SELECT ename, salary*12 “Annual Salary” FROM employees;

SELECT ename, salary*12 AS Annual Salary FROM employees;

SELECT ename, salary*12 AS INITCAP(“ANNUAL SALARY”) FROM employees

CREATE USER susan;

CREATE OR REPLACE USER susan;

CREATE NEW USER susan DEFAULT;

CREATE USER susan IDENTIFIED BY blue;

CREATE NEW USER susan IDENTIFIED by blue;

CREATE OR REPLACE USER susan IDENTIFIED BY blue;

Binary data up to 4 gigabytes.

Character data up to 4 gigabytes.

Raw binary data of variable length up to 2 gigabytes.

Binary data stored in an external file, up to 4 gigabytes.

A hexadecimal string representing the unique address of a row in its table.

&

ACCEPT

PROMPT

&&

MERGE

INSERT

UPDATE

ADD

ENTER

You cannot enter the phone numbers for the existing employee records.

Use the DESCRIBE command in the EMP_DEPT VU view.

Use the DEFINE VIEW command on the EMP_DEPT VU view.

Use the DESCRIBE VIEW command on the EMP_DEPT VU view.

Query the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view.

Query the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view

Query the USER_OBJECTS data dictionary view to search for the EMP_DEPT_VU view.

SELECT TO_DATE(SYSDATE, 'FMDAY, DD Month, YYYY') FROM dual;

SELECT TO_CHAR(SYSDATE, 'FMDD, DY Month, 'YYY') FROM dual;

SELECT TO_CHAR(SYSDATE, 'FMDay, DD Month, YYYY') FROM dual;

SELECT TO_CHAR(SYSDATE, 'FMDY, DDD Month, YYYY') FROM dual;

SELECT TO_DATE(SYSDATE, 'FMDY, DDD Month, YYYY') FROM dual;