Oracle Functions And Coding Quiz Questions

It executes the DELACCOUNT PL/SQL routine.

It runs the DELACCOUNT.SQL script file.

 It creates the DELACCOUNT file using the default file extension.

It invokes the editor to edit the contents of the DELACCOUNT file.

Substitution variables

Replacement variables

Prompt variables

This feature cannot be implemented through /SQL*Plus.

 Include the ORDER_AMOUNT column in the SELECT list.

Use the table name in the ORDER BY clause.

Remove the table aliases from the WHERE clause.

Use the table aliases instead of the table names in the WHERE clause.

Convert 10 to ‘TEN’

Convert ‘10’ to 10

Convert ‘10’ to ‘10’

Convert ‘TEN’ to 10

A. Both tables have NULL values.

B. You want all unmatched data from one table.

C. You want all matched data from both tables.

D. You want all unmatched data from both tables.

E. One of the tables has more data than the other.

A. NOT

B. OR

C. IN

D. AND

Create groups of data.

Sort data in a specific order

Convert data to a different format

Retrieve data based on an unknown condition

INSERT INTO employees( first_name, last_name) VALUES(‘John’,‘Smith’);

INSERT INTO employees(first_name,last_name, employee_id) VALUES ( 1000, ‘John’,‘Smith’);

INSERT INTO employees (employee_id) VALUES (1000);

INSERT INTO employees VALUES ( NULL, ‘John’,‘Smith’);

Exiting from iSQL*Plus without first committing the chang

System crash

Subsequent DML statement

GRANT statement

An error is returned.

You are prompted to enter a new value.

A report is produced that matches the first report produced.

You are asked whether you want a new value or if you want to run the report based on the previous value.

A schema object

A subquery that can contain an ORDER BY clause

Another name for a view that contains group functions

A subquery that is part of the FROM clause of another query

GRANT select ON dept TO ALL_USERS;

 GRANT select ON dept TO ALL;

GRANT QUERY ON dept TO ALL_USERS

GRANT select ON dept TO PUBLIC;