Oracle 1Z0-071 Quiz 26 Topic 4 Questions 126-130

Question: 1

View the Exhibit and examine the data in the PROMOTIONS table.

q1_1Z0-071

PROMO_BEGIN_DATE is stored in the default date format, dd-mon-rr.

You need to produce a report that provides the name, cost, and start date of all promos in the POST category that were launched before January 1, 2000.

Which SQL statement would you use?

ASELECT promo_name, promo_cost, promo_begin_dateFROM promotionsWHERE promo_category = 'post' AND promo_begin_date < '01-01-00';

BSELECT promo_name, promo_cost, promo_begin_dateFROM promotionsWHERE promo_category LIKE 'P%' AND promo_begin_date < '1-JANUARY-00';

CSELECT promo_name, promo_cost, promo_begin_dateFROM promotionsWHERE promo_cost LIKE 'post%' AND promo_begin_date < '01-01-2000';

DSELECT promo_name, promo_cost, promo_begin_dateFROM promotionsWHERE promo_category LIKE '%post%' AND promo_begin_date < '1-JAN-00';

Show Answer

Question: 2

Which two statements are true regarding views? (Choose two.)

AThe WITH CHECK OPTION constraint can be used in a view definition to restrict the columns displayed through the view.

BThe OR REPLACE option is used to change the definition of an existing view without dropping and re-creating it.

CRows cannot be deleted through a view if the view definition contains the DISTINCT keyword.

DRows added through a view are deleted from the table automatically when the view is dropped.

EA simple view in which column aliases have been used cannot be updated.

FA subquery used in a complex view definition cannot contain group functions or joins.

Show Answer

Question: 3

View the Exhibit and examine the structure of CUSTOMERS table.

q3_1Z0-071

Evaluate the following query:

q3_1Z0-071

Which statement is true regarding the above query?

AIt produces an error because the condition on the CUST_CITY column is not valid.

BIt produces an error because the condition on the CUST_FIRST_NAME column is not valid.

CIt produces an error because conditions on the CUST_CREDIT_LIMIT column are not valid.

DIt executes successfully.

Show Answer

Question: 4

Evaluate the following CREATE SEQUENCE statement:

CREATE SEQUENCE seq1

START WITH 100

INCREMENT BY 10

MAXVALUE 200

CYCLE

NOCACHE;

The sequence SEQ1 has generated numbers up to the maximum limit of 200. You issue the following SQL statement:

SELECT seq1.nextval FROM dual;

What is displayed by the SELECT statement?

A100

Ban error

C10

D1

Show Answer

Question: 5

Which three statements indicate the end of a transaction? (Choose three.)

Aafter a CREATE statement is issued

Bafter a SAVEPOINT is issued

Cafter a SELECT statement is issued

Dafter a ROLLBACK is issued

Eafter a COMMIT is issued

Show Answer

Oracle 1Z0-071 Quiz:26 Topic:4 Questions:126-130