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

A. PULL OUTER JOIN with self join

B. LEFT OUTER JOIN with self join

C. subquery

D. self Join

E. RIGHT OUTER JOIN with self join

A. INSERT INTO rate_list VALUES (-10) produces an error.

B. INSERT INTO rate_list VALUES (0.551) inserts the value as .55.

C. INSERT INTO rate_list VALUES (0.999) produces an error.

D. INSERT INTO rate_list VALUES (-99.99) inserts the value as 99.99.

E. INSERT INTO rate_list VALUES (-.9) inserts the value as -.9.

F. INSERT INTO rate_list VALUES (87654. 556) inserts the value as 87654.6.

A. 2 rows

B. 0 rows

C. 1 ROW

D. An error

A. In a query containing multiple set operators INTERSECT always takes precedence over UNION and UNION ALL

B. CHAR columns of different lengths used with a set operator retum a vAacsua mhtoe e equals the longest CHAR value.

C. An expression in the first SELECT list must have a column alias for the expression

D. All set operators are valid on columns all data types.

E. Queries using set operators do not perform implicit conversion across data type groups (e.g. character, numeric)

A. Create FOREIGN KEY constraints that reference tables in other schemas.

B. Delete rows from tables in any schema except sys.

C. Execute a procedure or function in another schema.

D. Create roles.

E. Set default and temporary tablespaces for a user.

A. A FLASHBACK TABLE statement can be used to retrieve the deleted data.

B. It always retains the space used by the removed rows.

C. A ROLLBACK statement can be used to retrieve the deleted data.

D. It retains the indexes defined on the table.

E. It drops any triggers defined on the table.

F. It retains the integrity constraints defined on the table.

A. It can be used to pass on privileges to other users by the grantee.

B. The grantee must have the GRANT ANY OBJECT PRIVILEGE system prvilege to use this option.

C. It can be used when granting privileges to roles.

D. It cannot be used to pass on privileges to PUBLIC by the grantee.

E. The grantee can grant the object privilege to any user in the database, with of without including this option.

F. It can be used for system and object privileges.

A. the REJECT LIMIT clause

B. the access driver TYPE clause

C. the LOCATION clause

D. the DEFAULT DIRECTORY clause

E. the ACCESS PARAMETERS clause

A. SALES1 is created with 1 row.

B. SALES1 has PRIMARY KEY and UNIQUE constraints on any selected columns which had those constraints in the SALES table.

C. SALES1 has NOT NULL constraints on any selected columns which had those constraints in the SALES table.

D. SALES1 Is created with 5,000 rows.

A. The argument can be a column name, variable, literal or an expression.

B. They can be used only in the where clause of a select statement.

C. They return a single result row per table.

D. They can be nested to any level.

E. They can accept only one argument.

F. The date type returned can be different from the data type of the argument.

A. All users have permissions to access all information in the data dictionary by default

B. All user actions are recorded in the data dictionary.

C. The SYS user owns all base tables and user-accessible views in the data dictionary.

D. Base tables in the data dictionary have the prefix DBA_.

E. The data dictionary is constantly updated to reflect changes to database objects, permissions, and data.

A. Implementing a relationship between two tables might require joining additional tables.

B. An inner join relates rows within the same table.

C. Every relationship between the two tables must be implemented in a Join condition.

D. Relating data from a table with data from the same table is implemented with a self join.

E. Rows from unrelated tables cannot be joined.

A. A constraint can be disabled even if the constrained column contains data.

B. A column with a foreign key constraint can never contain a null value.

C. A column with a UNIQUE constraint can contain a NULL value.

D. Constraints are enforced only during INSERT operations.

E. All constraints can be defined at the table or column level.

A. You can add a column to the table in this session.

B. You can add a foreign key to the table.

C. To drop the table in this session, you must first truncate it.

D. Other sessions can view the committed row.

E. When you terminate your session, the row will be deleted.

A. The HAVING clause can be used with aggregating functions in subqueries.

B. The WHERE clause can be used to exclude rows after dividing them into groups

C. Aggregating functions and columns used in HAVING clauses must be specified in these SELECT list of a query.

D. The WHERE clause can be used to exclude rows before dividing them into groups.

E. WHERE and HAVING clauses can be used in the same statement only if applied to different table columns.