Oracle SQL

Statement 1 will not execute; statement 2 will.

The results will be the same, but the display will be different.

Statement 1 will execute; statement 2 will not.

Statement 1 is self-join; statement 2 is not.

.Any pending transactions on the table are rolled back.

The table structure and its deleted data cannot be rolled back and restored once the DROP TABLE command is executed.

The DROP TABLE command can be executed on a table on which there are pending transactions.

Only a DBA can execute the DROP TABLE command.

Use the ALTER TABLE command with the MODIFY clause on the EMP table.

Use the ALTER TABLE command with the MODIFY clause on the DEPT table.

Use the ALTER TABLE command with the ADD clause on the EMP table.

This task cannot be accomplished.

1

2

0

3

SELECT lastname, firstname FROM emp WHERE lastname = UPPER('smith');

SELECT lastname, firstname FROM emp WHERE lastname = 'smith';

SELECT lastname, firstname FROM emp WHERE UPPER(lastname) = 'smith';

SELECT lastname, firstname FROM emp WHERE LOWER(lastname) = 'smith';

Date values are displayed in descending order by default. "

C.The results are sorted by the first column in the SELECT list if the ORDER BY clause is not provided.

Null values are displayed last in ascending sequences.

You cannot sort query results by a column that is not included the SELECT list.

The results will be lower.

The statement will achieve the same results.

The statement will not execute.

The results will be higher.

SELECT e.ename FROM emp e WHERE e.empno NOT IN (SELECT m.mgr FROM emp m WHERE m.mgr IS NOT NULL);

SELECT e.ename FROM emp e WHERE e.empno IN (SELECT m.mgr FROM emp m);

SELECT e.ename FROM emp e WHERE e.mgr IS NOT NULL;

SELECT e.ename FROM emp e WHERE e.empno NOT IN (SELECT m.mgr FROM emp m);

250

1250

500

750

NOT IN operator is not allowed in subqueries.

.All employees have a manager.

None of the employees has a manager.

.A NULL value is returned from the subquery.

INSERT INTO student (stud_id, address, graduation) VALUES (101,'100 Main Street','17-JUN-99');

INSERT INTO student table VALUES (101,'Smith','100 Main Street','17-JUN-99');

.INSERT INTO student (stud_id, address, name, graduation) VALUES (101,'100 Main Street','Smith','17-JUN-99');

INSERT INTO student VALUES (101,'100 Main Street','17-JUN-99','Smith');

LIKE operator

IN operator

BETWEEN x AND y operator

Equal operator

ALL_TABLES "

ALL_COL_PRIVS_RECD

ALL_SOURCE

TABLE_PRIVILEGES

UPDATE student SET name = 'Smith', graduation = '15-AUG-2000' WHERE stud_id = 101;

UPDATE studentD.UPDATE student SET stud_id = NULL, address = '100 Main Street' WHERE graduation = '20-JAN-1999';

UPDATE student SET name = 'Smith', graduation = '29-MAY-2001' WHERE stud_id = 101;

UPDATE student SET stud_id = 999, graduation = '29-MAY-2001' WHERE stud_id = 101;

There is more than one employee with the first name Scott.

The FIRST_NAME values in the database are in lowercase

Scott has a NULL commission value.

Scott has a zero commission value.

Move the function to the SELECT clause and add a GROUP BY clause and a HAVING clause.

Move the function to the SELECT clause and add a GROUP BY clause

Use a subquery in the WHERE clause to compare the average salary value.

.Change the function in the WHERE clause.

Exception handling

Executable

Declarative

Heading

ALL_OBJECTS

DBA_SEGMENTS

USER_OBJECTS

.DBA_TABLES

Use the ALTER USER to assign the user a default profile.

.Use the ALTER USER command to assign the user a default tablespace.

.No action is required to give the user database access.

Grant the user the CREATE SESSION privilege.

Name and first name of only the employees in department number 3 or 5

Last name and first name of all employees with the same salary as employees in department 3 or 5

.last name and first name of all employees except those working in department 3 or 5

Last name and first name of only the employees whose salary falls in the range of salaries from department 3 or 5

The need to qualify the object name with its schema has been eliminated for all users.

All users were given object privileges to the table.

The need to qualify the object name with its schema was eliminated for only you.

.The object can now be accessed by all users.

In a non-pairwise subquery, the values returned from the subquery are compared as a group to the values in the outer query.

In a pairwise subquery, the values returned from the subquery are compared individually to the values in the outer query.

.A pairwise comparison produces a cross product.

B.A non-pairwise comparison produces a cross product.

DELETE * FROM student;

DROP TABLE student;

TRUNCATE TABLE student;

DROP TABLE student;

You use the ALTER TABLE command with the RENAME COLUMN clause to rename the column.

.You cannot rename a column.

You use the ALTER TABLE command with the MODIFY clause to rename the column.

.You use the ALTER TABLE command with the MODIFY COLUMN clause to rename the column.

SELECT view_text FROM TABLE emp WHERE view_name = 'EMP_VIEW';

SELECT view_text FROM my_views WHERE view_name = 'EMP_VIEW';

DESCRIBE VIEW emp_view

SELECT text FROM user_views WHERE view_name = 'EMP_VIEW';

The datatypes in the SELECT list are inconsistent with the datatypes in the INTO clause.

The SELECT statement returns more than one row.

.The SELECT statement contains a GROUP BY clause.

The SELECT statement does not have a WHERE clause.

ALTER TABLE patient MODIFY (id_number CONSTRAINT pat_id_pk PRIMARY KEY);

ALTER TABLE patient ADD CONSTRAINT pat_id_pk PRIMARY KEY(id_number);

ALTER TABLE patient ADD (id_number CONSTRAINT pat_id_pk PRIMARY KEY);

.This task cannot be accomplished.

The employee table column corresponding to the region table column contains null values for rows that need to be displayed.

The employee table has two columns that correspond.

.The employee and region tables have corresponding columns.

The employee and region tables have no corresponding columns.

DESCRIBE

CHANGE

.LIST

UPDATE

The need to qualify an object name with its schema was eliminated for users with access.

The need to qualify an object name with its schema was eliminated for only you.

The need to qualify an object name with its schema was eliminated for user Ed.

The need to qualify an object name with its schema was eliminated for all users.