oracle 11g 051,Oracle 11g 1Z0-051题库

Oracle 11g 1Z0-051

考题名称：Oracle Database: SQL Fundamentals I

版本号：V9.02

更新时间：2011-10-13

考题数量：175 道题

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.

Similarly, the CUST_ID and TIME_ID columns are also foreign keys in the SALES table referencing the

CUSTOMERS and TIMES tables, respectively.

Evaluate the following CREATE TABLE command:

CREATE TABLE new_sales(prod_id, cust_id, order_date DEFAULT SYSDATE)

AS

SELECT prod_id, cust_id, time_id

FROM sales;

Which statement is true regarding the above command?

A. The NEW_SALES table would not get created because the DEFAULT value cannot be specified in the

column definition.

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

columns would be passed to the new table.

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

command and the SELECT clause do not match.

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

specified columns would be passed to the new table.

Answer: B

2. View the Exhibit to examine the description for the SALES table.

Which views can have all DML operations performed on it? (Choose all that apply.)

A. CREATE VIEW v3

AS SELECT * FROM SALES

WHERE cust_id = 2034

WITH CHECK OPTION;

B. CREATE VIEW v1

AS SELECT * FROM SALES

WHERE time_id <= SYSDATE - 2*365

WITH CHECK OPTION;

C. CREATE VIEW v2

AS SELECT prod_id, cust_id, time_id FROM SALES

WHERE time_id <= SYSDATE - 2*365

WITH CHECK OPTION;

D. CREATE VIEW v4

AS SELECT prod_id, cust_id, SUM(quantity_sold) FROM SALES

WHERE time_id <= SYSDATE - 2*365

GROUP BY prod_id, cust_id

WITH CHECK OPTION;

Answer: AB

3. You need to extract details of those products in the SALES table where the PROD_ID column

contains the string '_D123'.

Which WHERE clause could be used in the SELECT statement to get the required output?

A. WHERE prod_id LIKE '%_D123%' ESCAPE '_'

B. WHERE prod_id LIKE '%\_D123%' ESCAPE '\'

C. WHERE prod_id LIKE '%_D123%' ESCAPE '%_'

D. WHERE prod_id LIKE '%\_D123%' ESCAPE '\_'

Answer: B

4. Which two statements are true regarding single row functions? (Choose two.)

A. They a ccept only a single argument.

B. They c an be nested only to two levels.

C. Arguments can only be column values or constants.

D. They a lways return a single result row for every row of a queried table.

E. They c an return a data type value different from the one that is referenced.

Answer: DE

5. Which SQL statements would display the value 1890.55 as $1,890.55? (Choose three .)

A. SELECT TO_CHAR(1890.55,'$0G000D00')

FROM DUAL;

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

FROM DUAL;

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;

Answer: ADE