数据库专家考试051

1

/

99

Exam : 1Z0-051

Title :

Oracle Database: SQL

Fundamentals I

2

/

99

1. View the Exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTS, and TIMES

tables.

The PROD_ID column is the foreign key in the SALES table, which references the PRODUCTS table.

he

B. The NEW_SALES table would get created and all the NOT NULL constraints defined on the specified

3

/

99

C. The NEW_SALES table would not get created because the column names in the CREATE TABLE

com

mand and the SELECT clause do not match.

D. The NEW_SALES table would get created and all the FOREIGN KEY constraints defined on the

A. CREATE VIEW v3

C. CREATE VIEW v2

-

2*365

D. CREATE VIEW v4

-

2*365

4

/

99

D. WHERE prod_id LIKE '%\

B

FROM DUAL;

B. SELECT TO_CHAR(1890.55,'$9,999V99')

FROM D

UAL;

C. SELECT TO_CHAR(1890.55,'$99,999D99')

FROM DUAL;

D. SELECT TO_CHAR(1890.55,'$99G999D00')

FROM DUAL;

E. SELECT TO_CHAR(1890.55,'$99G999D99')

FROM DUAL;

SHIPMENT_MODE VARCHAR2(30)

SHIPMENT_COST NUMBER(8,2)

You want to generate a report that displays the PO_ID and the penalty amount to be paid if the

SHIPMENT_DATE is later than one month from the PO_DATE. The penalty is $20 per day.

SQL> SELECT po_id, CASE

WHEN MONTHS_BETWEEN (shipment_date,po_date)>1 THEN

5

/

99

TO_CHAR((shipment_date

-

SQL>SELECT po_id, DECODE

C. Only the first query executes successfully and gives the correct result.

D. Only the second query executes successfully but gives a wrong result.

E. Only

C

7. Which two statements are true regarding the USING and ON clauses in table joins? (Choose two.)

C. The ON clause can be used to join tables on columns that have different names but compatible data

D. The WHERE clause can be used to apply additional condition

ON or the USING clause.

CD

A. listi

B. finding the number of customers, in each city, whose marital status is 'married'

C. finding the average credit limit of male customers residing in 'Tokyo' or 'Sydney'