Oracle 1Z0-071 Quiz 47 Topic 15 Questions 231-235

Question: 1

Which three statements are true? (Choose three.)

AThe data dictionary is created and maintained by the database administrator.

BData dictionary views consist of joins of dictionary base tables and user-defined tables.

CThe usernames of all users including database administrators are stored in the data dictionary.

DThe USER_CONS_COLUMNS view should be queried to find the names of columns to which constraints apply.

EBoth USER_OBJECTS and CAT views provide the same information about all objects that are owned by the user.

FViews with the same name but different prefixes, such as DBA, ALL and USER, reference the same base tables from the data dictionary.

Show Answer

Question: 2

View the exhibits and examine the structures of the COSTS and PROMOTIONS tables.

q2_1Z0-071

Evaluate the following SQL statement:

q2_1Z0-071

What would be the outcome of the above SQL statement?

AIt displays prod IDs in the promo with the lowest cost.

BIt displays prod IDs in the promos with the lowest cost in the same time interval.

CIt displays prod IDs in the promos with the highest cost in the same time interval.

DIt displays prod IDs in the promos which cost less than the highest cost in the same time interval.

Show Answer

Question: 3

View the exhibit and examine the descriptions of the DEPT and LOCATIONS tables.

q3_1Z0-071

You want to update the CITY column of the DEPT table for all the rows with the corresponding value in the CITY column of the LOCATIONS table for each department.

Which SQL statement would you execute to accomplish the task?

AUPDATE dept dSET city = ALL (SELECT cityFROM locations lWHERE d.location_id = l.location_id);

BUPDATE dept dSET city = (SELECT cityFROM locations l)WHERE d.location_id = l.location_id;

CUPDATE dept dSET city = ANY (SELECT cityFROM locations l)

DUPDATE dept dSET city = (SELECT cityFROM locations lWHERE d.location_id = l.location_id);

Show Answer

Question: 4

The BOOKS_TRANSACTIONS table exists in your schema in this database.

You execute this SQL statement when connected to your schema in your database instance.

SQL> SELECT * FROM books_transactions ORDER BY 3;

What is the result?

AThe execution fails unless the numeral 3 in the ORDER BY clause is replaced by a column name.

BAll table rows are displayed sorted in ascending order of the values in the third column.

CThe first three rows in the table are displayed in the order that they are stored.

DOnly the three rows with the lowest values in the key column are displayed in the order that they are stored.

Show Answer

Question: 5

Which statement is true about Data Manipulation Language (DML)?

ADML automatically disables foreign ley constraints when modifying primary key values in the parent table.

BEach DML statement forms a transaction by default.

CA transaction can consist of one or more DML statements.

DDML disables foreign key constraints when deleting primary key values in the parent table, only when the ON DELETE CASCADE option is set for the foreign key constraint.

Show Answer

Oracle 1Z0-071 Quiz:47 Topic:15 Questions:231-235