Oracle 1Z0-071 Quiz 9 Topic 13 Questions 41-45

Question: 1

Which two statements are true about selecting related rows from two tables based on an Entity Relationship Diagram (ERD)? (Choose two.)

AImplementing a relationship between two tables might require joining additional tables

BRelating data from a table with data from the same table is implemented with a self join

CRows from unrelated tables cannot be joined

DEvery relationship between the two tables must be implemented in a join condition

EAn inner join relates rows within the same table

Show Answer

Question: 2

Which two statements are true about substitution variables? (Choose two.)

AA substitution variable can be used with any clause in a SELECT statement

BA substitution variable used to prompt for a column name must be enclosed in a single quotation marks

CA substitution variable prefixed with & always prompts only once for a value in a session

DA substitution variable can be used only in a SELECT statement

EA substitution variable used to prompt for a column name must be enclosed in double quotation marks

FA substitution variable prefixed with && prompts only once for a value in a session unless it is set to undefined in the session

Show Answer

Question: 3

Examine the description of the PRODUCTS table:

q3_1Z0-071

Which three queries use valid expressions? (Choose three.)

ASELECT product_id, (expiry_date -- delivery_date) * 2 FROM products;

BSELECT product_id, unit_price | | 5 ''Discount'', unit_price + surcharge -- discount FROM products;

CSELECT product_id, unit_price, 5 ''Discount'', unit_price + surcharge -- discount FROM products;

DSELECT product_id, unit_price, unit_price + surcharge FROM products;

ESELECT product_id, (unit_price * 0.15 / (4.75 + 552.25)) FROM products;

FSELECT product_id, expiry_date * 2 FROM products;

Show Answer

Question: 4

Which three statements are true about performing Data Manipulation Language (DML) operations on a view with no INSTEAD OF triggers defined? (Choose three.)

AInsert statements can always be done on a table through a view.

BViews cannot be used to add rows to an underlying table if the table has columns with NOT NULL constraints lacking default values which are not referenced in the defining query of the view.

CViews cannot be used to query rows from an underlying table if the table has a PRIMARY KEY and the PRIMARY KEY columns are not referenced in the defining query of the view.

DDelete statements can always be done on a table through a view.

EThe WITH CHECK clause has no effect when deleting rows from the underlying table through the view.

FViews cannot be used to add or modify rows in an underlying table if the defining query of the view contains the DISTINCT keyword.

Show Answer

Question: 5

An Oracle database server session has an uncommitted transaction in progress which updated 5000 rows in a table.

In which three situations does the transactions complete thereby committing the updates? (Choose three.)

Awhen a DBA issues a successful SHUTDOWN TRANSACTIONAL statement and the user then issues a COMMIT

Bwhen a CREATE INDEX statement is executed successfully in the same session

Cwhen a COMMIT statement is issued by the same user from another session in the same database instance

Dwhen the session logs out successfully

Ewhen a DBA issues a successful SHUTDOWN IMMEDIATE statement and the user then issues a COMMIT

Fwhen a CREATE TABLE AS SELECT statement is executed unsuccessfully in the same session

Show Answer

Oracle 1Z0-071 Quiz:9 Topic:13 Questions:41-45