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.
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.
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
Subsequent DML statement
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;
/SQL*Plus is the Oracle proprietary interface for executing SQL statements.
/SQL*Plus commands are accesses from a browser.
/SQL*Plus commands are used to manipulate data in tables.
/SQL*Plus commands manipulate table definitions in the database.
Create groups of data.
Sort data in a specific order
Convert data to a different format
Retrieve data based on an unknown condition
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.