최신 1Z1-051 무료덤프 - Oracle Database: SQL Fundamentals I

문제1

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

A. Only two subqueries can be placed at one level.

B. There is no limit on the number of subquery levels in the WHERE clause of a SELECT statement.

C. A subquery can be used only in SQL query statements.

D. A subquery can retrieve zero or more rows.

E. A subquery can appear on either side of a comparison operator.

정답: D,E

설명: (DumpTOP 회원만 볼 수 있음)

문제2

Evaluate the following SQL statements:
Exhibit:

Exhibit:

The above command fails when executed. What could be the reason?

A. ORD_NO and ITEM_NO cannot be used as a composite primary key because ORD_NO is also the FOREIGN KEY

B. The BETWEEN clause cannot be used for the CHECK constraint

C. The CHECK constraint cannot be placed on columns having the DATE data type

D. SYSDATE cannot be used with the CHECK constraint

정답: D

설명: (DumpTOP 회원만 볼 수 있음)

문제3

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

A. A constraint can be disabled even if the constraint column contains data

B. A constraint is enforced only for the INSERT operation on a table

C. All constraints can be defined at the column level as well as the table level

D. A columns with the UNIQUE constraint can contain NULL values

E. A foreign key cannot contain NULL values

정답: A,D

문제4

Examine the structure proposed for the TRANSACTIONS table:

Which two statements are true regarding the storage of data in the above table structure? (Choose two.)

A. The CUST_CREDIT_VALUE column would allow storage of positive and negative integers.

B. The CUST_STATUS column would allow storage of data up to the maximum VARCHAR2 size of 4,000 characters.

C. The TRANS_DATE column would allow storage of dates only in the dd-mon-yyyy format.

D. The TRANS_VALIDITY column would allow storage of a time interval in days, hours, minutes, and seconds.

정답: A,D

문제5

Which object privileges can be granted on a view?

A. none

B. DELETE, INSERT,SELECT

C. DELETE, INSERT, SELECT, UPDATE

D. ALTER, DELETE, INSERT, SELECT

정답: C

설명: (DumpTOP 회원만 볼 수 있음)

문제6

You want to display the date for the first Monday of the next month and issue the following command:
SQL>SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE),'MON'), 'dd "is the first Monday for"fmmonth rrrr') FROM DUAL;
What is the outcome?

A. It generates an error because TO_CHAR should be replaced with TO_DATE.

B. It generates an error because fm and double quotation marks should not be used in the format string.

C. It executes successfully but does not return the correct result.

D. It executes successfully and returns the correct result.

E. It generates an error because rrrr should be replaced by rr in the format string.

정답: D

설명: (DumpTOP 회원만 볼 수 있음)

문제7

Which object privileges can be granted on a view?

A. none

B. DELETE, INSERT,SELECT

C. DELETE, INSERT, SELECT, UPDATE

D. ALTER, DELETE, INSERT, SELECT

정답: C

설명: (DumpTOP 회원만 볼 수 있음)

문제8

The CUSTOMERS table has the following structure: Exhibit:

You need to write a query that does the following task:
*Display the first name and tax amount of the customers. Tax is 5% of their credit limit
*Only those customers whose income level has a value should be considered
*Customers whose tax amount is null should not be considered
Which statement accomplishes all the required tasks?

A. SELECT cust_first_name, cust_credit_limit * .05 AS TAX_AMOUNT FROM customers WHERE cust_income_level <> NULL AND tax_amount <> NULL;

B. SELECT cust_first_name, cust_credit_limit * .05 AS TAX_AMOUNT FROM customers WHERE cust_income_level IS NOT NULL AND cust_credit_limit IS NOT NULL;

C. SELECT cust_first_name, cust_credit_limit * .05 AS TAX_AMOUNT FROM customers WHERE cust_income_level IS NOT NULL AND tax_amount IS NOT NULL;

D. SELECT cust_first_name, cust_credit_limit * .05 AS TAX_AMOUNT FROM customers WHERE (cust_income_level,tax_amount) IS NOT NULL;

정답: B

문제9

View the Exhibit and examine the structure of the CUSTOMERS table .Which statement would display the highest credit limit available in each income level in each city in the CUSTOMERS table?

A. SELECT cust_city, cust_income_level, MAX(cust_credit_limit) FROM customers GROUP BY cust_credit_limit, cust_income_level, cust_city ;

B. SELECT cust_city, cust_income_level, MAX(cust_credit_limit) FROM customers GROUP BY cust_city, cust_income_level;

C. SELECT cust_city, cust_income_level, MAX(cust_credit_limit ) FROM customers GROUP BY cust_city, cust_income_level, cust_credit_limit;

D. SELECT cust_city, cust_income_level, MAX(cust_credit_limit) FROM customers GROUP BY cust_city, cust_income_level, MAX(cust_credit_limit);

정답: B

문제10

View the Exhibit and examine the structure of the PROMOTIONS table.
Using the PROMOTIONS table, you need to find out the names and cost of all the promos done on 'TV' and 'internet' that ended in the time interval 15th March '00 to 15th October '00. Which two queries would give the required result? (Choose two.)

A. SELECT promo_name, promo_cost FROM promotions WHERE promo_category IN ('TV', 'internet') AND promo_end_date BETWEEN '15-MAR-00' AND '15-OCT-00';

B. SELECT promo_name, promo_cost FROM promotions WHERE (promo_category = 'TV' OR promo_category ='internet') AND (promo_end_date >='15MAR-00'AND promo_end_date <='15-OCT-00');

C. SELECT promo_name, promo_cost FROM promotions WHERE (promo_category BETWEEN 'TV' AND 'internet') AND (promo_end_date IN ('15-MAR-00','15-OCT-00'));

D. SELECT promo_name, promo_cost FROM promotions WHERE promo_category = 'TV' OR promo_category ='internet' AND promo_end_date >='15MAR-00' ORpromo_end_date <='15-OCT-00';

정답: A,B

문제11

View the Exhibit and examine the structure of the PRODUCTS, SALES, and SALE_SUMMARY tables.
SALE_VW is a view created using the following command:
SQL>CREATE VIEW sale_vw AS
SELECT prod_id, SUM(quantity_sold) QTY_SOLD
FROM sales GROUP BY prod_id;
You issue the following command to add a row to the SALE_SUMMARY table:
SQL>INSERT INTO sale_summary
SELECT prod_id, prod_name, qty_sold FROM sale_vw JOIN products
USING (prod_id) WHERE prod_id = 16;
What is the outcome?

A. It gives an error because the column names in the subquery and the SALE_SUMMARY table do not match.

B. It gives an error because a complex view cannot be used to add data into the SALE_SUMMARY table.

C. It gives an error because the number of columns to be inserted does not match with the number of columns in the SALE_SUMMARY table.

D. It executes successfully.

정답: C

최신 1Z1-051 무료덤프 - Oracle Database: SQL Fundamentals I

우리와 연락하기

유용한 링크

최신 업데이트