1z0-071試験無料問題集「Oracle Database SQL 認定」

A. The data type group of each column returned by the second query must match the data type group of the corresponding column returned by the first query

B. The data type of each column returned by the second query must be implicitly convertible to the data type of the corresponding column returned by the first query

C. The data type of each column retuned by the second query must exactly match the data type of the corresponding column returned by the first query

D. The names and number of columns must be identical for all SELECT statements in the query.

E. The number, but not names, of columns must be identical for all SELECT statements in the query

A. A single WHEN condition can be used for multiple INTO clauses.

B. The total number of rows inserted is always equal to the number of rows returned by the subquery

C. It cannot have an ELSE clause.

D. Each row returned by the subquery can be inserted into only a single target table.

E. Each WHEN condition is tested for each row returned by the subquery.

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

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

C. The foreign key columns and parent table primary key columns must have the same names.

D. Only the primary key can be defined at the column and table level.

E. Primary key and foreign key constraints can be defined at both the column and table level.

F. It is possible for child rows that have a foreign key to be deleted automatically from the child table at the time the parent row is deleted

G. It is possible for child rows that have a foreign key to remain in the child table at the time the parent row is deleted.

A. An ORDR BY clause will always precede a HAVI NG clause if both are used in the same top-level

B. By default an ORDERBY clause sorts rows in ascending order

C. An ORDER BY clause can perform a binary sort

D. An ORDER BY clause can perform a linguistic sort

E. An ORDER BY clause always sorts NULL values last.

A. Views with the prefix dba_ display only metadata for objects in the SYS schema.

B. The data dictionary does not store metadata in tables.

C. The data dictionary is accessible when the database is closed.

D. Views with the prefix all_, dba_ and useb_ are not all available for every type of metadata.

E. Views with the prefix all_ display metadata for objects to which the current user has access.

A. The primary key constraint on BMP_ID must have a name.

B. The NOT NULL constraint on ENAME must be defined at the column level instead of the table level.

C. The foreign key constraint on DEPT_ID must be defined at the table level instead of the column level.

D. One of the LONG columns must be changed to a VARCHAR2 or CLOB.

E. The word CONSTRAINT in the foreign key constraint on DEPT_ID must be changed to FOREIGN KEY.

A. the ACCESS PARAMETERS clause

B. the access driver TYPE clause

C. the REJECT LIMIT clause

D. the LOCATION clause

E. the DEFAULT DIRECTORY clause

A. The AVG function implicitly converts NULLS to zero

B. Aggregate functions can be nested to any number of levels

C. Aggregate functions can be used in any clause of a SELECT statement

D. The MAX and MIN functions can be used on columns with character data types

A. Creating an external table will automatically create a file using the specified directory and file name.

B. A system privilege is required.

C. A create table statement can specify the maximum number of rows the table will contain.

D. A primary key constraint is manadatory.

E. The same table name can be used for tables in different schemas.

A. A role can contain a combination of several privileges and roles.

B. All roles are owned by the sYs schema.

C. PUBIIC can be revoked from a user.

D. PUBLIC acts as a default role granted to every user in a database.

E. A user has all object privileges for every object in their schema by default.

F. A role is owned by the user who created it.

G. System prilgese always set prilge for an entire database.

A. update statements can have different subqueries to specify the values for each updated column.

B. delete statements can remove multiple rows based on multiple conditions.

C. insert into. . .select. . .from statements automatically commit.

D. insert statements can insert nulls explicitly into a column.

E. DML statements require a primary key be defined on a table.

A. SELECT prod_id || q'('s not available)' 'CURRENT AVAILABILITY' FROM product_status WHERE status = 'OUT OF STOCK';

B. SELECT prod_id || q'('s not available)' "CURRENT AVAILABILITY" FROM product_status WHERE status = 'OUT OF STOCK';

C. SELECT prod_id "CURRENT AVAILABILITY" || q'('s not available)' FROM product_status WHERE status = 'OUT OF STOCK';

D. SELECT prod_id || q's not available'' FROM product_status WHERE status='OUT OF STOCK';

E. SELECT prod_id || q'('s not available)' FROM product_status WHERE status = 'OUT OF STOCK';

F. SELECT prod_id || q"'s not available" FROM product_status WHERE status = 'OUT OF STOCK';

A. The output is sorted by the UNION ALL operator.

B. NULLS are not ignored during duplicate checking.

C. Duplicates are eliminated automatically by the UNION ALL operator

D. The number of columns selected in each SELECT statement must be identical

E. The names of columns selected in each SELECT statement must be identical.

A. NULLS are not included in the sort operation.

B. Column aliases can be used in the ORDER BY clause.

C. Numeric values are displayed in descending order if they have decimal positions.

D. In a character sort, the values are case-sensitive.

E. Only columns that are specified in the SELECT list can be used in the ORDER BY clause.