VARCHAR2

VARCHAR1

CHAR

CHAR2

INTEGER

NUMBER

-123.40

-100

-120

-123.30

0

100

123

-123

KNOWMIND

WORKSM

WORKSMAX

MAXWORKS

KNOWMAX

MINDWORKS

WORKS

MINDWORK

1

2

3

0

4

Primary key access

Access via unique index

Table access by ROWID

Full table scan

ALTER TABLE students ADD PRIMARY KEY student_id;

ALTER TABLE students ADD CONSTRAINT PRIMARY KEY (student_id);

ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY student_id;

ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY (student_id);

ALTER TABLE students MODIFY CONSTRAINT stud_id_pk PRIMARY KEY (student_id);

TIMESTAMP

INTERVAL MONTH TO DAY

INTERVAL DAY TO SECOND

INTERVAL YEAR TO MONTH

TIMESTAMP WITH DATABASE TIMEZONE

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.

USER_TAB_PRIVS_MADE

USER_TAB_PRIVS

USER_COL_PRIVS_MADE

USER_COL_PRIVS

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

NOT NULL

PRIMARY KEY

FOREIGN KEY

CHECK

UNIQUE KEY

You can use aggregate functions in any clause of a SELECT statement.

You can use aggregate functions only in the column list of the SELECT clause and in the WHERE clause of a SELECT statement.

You can mix single row columns with aggregate functions in the column list of a SELECT statement by grouping on the single row columns.

You can pass column names, expressions, constants, or functions as parameters to an aggregate function.

You can use aggregate functions on a table, only by grouping the whole table as one single group.

You cannot group the rows of a table by more than one column while using aggregate functions.

A single row subquery can retrieve data from only one table.

A SQL query statement cannot display data from table B that is referred to in its subquery, unless table B is included in the main query's FROM clause.

A SQL query statement can display data from table B that is referred to in its subquery, without including table B in its own FROM clause.

A single row subquery can retrieve data from more than one table.

A single row subquery cannot be used in a condition where the LIKE operator is used for comparison.

A multiple-row subquery cannot be used in a condition where the LIKE operator is used for comparison.

MERGE

INSERT

UPDATE

ADD

ENTER

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

Both tables have NULL values.

You want all unmatched data from one table.

You want all matched data from both tables.

You want all unmatched data from both tables.

One of the tables has more data than the other.

You want all matched and unmatched data from only one table.

A role can be given to a maximum of 1000 users.

A user can have access to a maximum of 10 roles.

A role can have a maximum of 100 privileges contained in it.

Privileges are given to a role by using the CREATE ROLE statement.

A role is a named group of related privileges that can be granted to the user.

A user can have access to several roles, and several users can be assigned the same role.

The underlying tables must have data.

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.