최신Oracle Database SQL - 1z0-071무료샘플문제

A. They can be temporary tables.

B. Their metadata is stored in the database.

C. They can be indexed.

D. They can be used in queries containing sorts.

E. They can be used in queries containing joins.

F. DML statements can modify them.

A. Only the primary key can be defined at the column and table levels.

B. A table can have only one primary key but multiple foreign keys.

C. A table can have only one primary key and one foreign key.

D. Both primary key and foreign key constraints can be defined at both column and table levels.

E. The foreign key and parent table primary key must have the same name.

A. an entity

B. an activity

C. a table

D. a unique identifier

E. an attribute

F. a relationship

A. Only 'mgr_id'

B. None, because no input required

C. Only 'hiredate'

D. Both the substitution variables 'hiredate' and 'mgr_id\

A. A synonym has an object number.

B. A synonym can have a synonym.

C. Any user can create a PUBLIC synonym.

D. All private synonym names must be unique in the database.

E. A synonym can be created on an object in a package.

A. It is created with no rows.

B. It will have NOT NULL constraints on the selected columns which had those constraints in the SALES table.

C. It will not be created because of the invalid WHERE clause.

D. It has PRIMARY KEY and UNIQUE constraints on the selected columns which had those constraints in the SALES table.

E. It will not be created because the column-specified names in the SELECT and CREATE TABLE clauses do not match.

A. It generates an error because = is not valid and should be replaced by the IN operator.

B. It executes successfully but does not give the correct output.

C. It executes successfully and gives the correct output.

D. It generate an error because the subquery does not have a GROUP BY clause.

A. They can contain GROUP BY clauses.

B. They cannot contain a subquery.

C. Two or more values are always returned from the subquery.

D. They can contain HAVING clauses.

E. They can return multiple columns.

A. SELECT prod_id, cust_id, amount_sold
FROM sales
ORDER BY amount_sold
FETCH FIRST 5 PERCENT ROWS WITH TIES;

B. SELECT prod_id, cust_id, amount_sold
FROM sales
ORDER BY amount__sold
FETCH FIRST 5 PERCENT ROWS ONLY;

C. SELECT prod_id, cust_id, amount_sold
FROM sales
ORDER BY amount_sold
FETCH FIRST 5 PERCENT ROWS ONLY WITH TIES;

D. SELECT prod_ id, cust_id, amount_sold
FROM sales
ORDER BY araount_sold
FETCH FIRST 5 PERCENT ROWS WITH TIES ONLY;