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

문제1

Which two statements about sub queries are true? (Choose two.)

A. Sub queries CANNOT be nested by more than two levels.

B. A sub query CANNOT be used in an SQL query statement that uses group functions.

C. A sub query can retrieve zero or more rows.

D. A sub query should retrieve only one row.

E. A sub query can be used only in SQL query statements.

F. When a sub query is used with an inequality comparison operator in the outer SQL statement, the column list in the SELECT clause of the sub query should contain only one column.

정답: C,F

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

문제2

The following data exists in the PRODUCTS table:
PROD_ID PROD_LIST_PRICE
123456 152525.99
You issue the following query:
SQL> SELECT RPAD(( ROUND(prod_list_price)), 10,'*')
FROM products
WHERE prod_id = 123456; What would be the outcome?

A. **152525.99

B. 152526****

C. 152525**

D. an error message

정답: B

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

문제3

Examine the structure of the PROMOTIONS table: The management wants to see a report of unique promotion costs in each promotion category.

Which query would achieve the required result?

A. SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1;

B. SELECT DISTINCT promo_cost, promo_category FROM promotions;

C. SELECT promo_category, DISTINCT promo_cost FROM promotions;

D. SELECT DISTINCT promo_cost, DISTINCT promo_category FROM promotions;

정답: A

문제4

Evaluate the SQL statement:
SELECT ROUND(45.953, -1), TRUNC(45.936, 2)
FROM dual;
Which values are displayed?

A. 50 and 45.9

B. 50 and 45.93

C. 46 and 45.93

D. 45.95 and 45.93

E. 45 and 45.93

F. 46 and 45

정답: B

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

문제5

You are currently located in Singapore and have connected to a remote database in Chicago. You issue the following command:
Exhibit:

PROMOTIONS is the public synonym for the public database link for the PROMOTIONS table.
What is the outcome?

A. Number of days since the promo started based on the current Singapore data and time.

B. Number of days since the promo started based on the current Chicago data and time

C. An error because the ROUND function specified is invalid

D. An error because the WHERE condition specified is invalid

정답: B

문제6

What is true about updates through a view?

A. When you update a view group functions are automatically computed.

B. When you update a view only the constraints on the underlying table will be in effect.

C. When you update a view the constraints on the views always override the constraints on theunderlying tables.

D. You cannot update a view with group functions.

정답: D

문제7

What is true about sequences?

A. The minimum value of an ascending sequence defaults to 1.

B. The maximum value of descending sequence defaults to 1.

C. A sequence always increments by 1.

D. The start value of the sequence is always 1.

정답: A

문제8

The SQL statements executed in a user session as follows:
Exhibit:

Which two statements describe the consequence of issuing the ROLLBACK TO SAVE POINT a command in the session? (Choose two.)

A. Only the DELETE statements are rolled back

B. The rollback generates an error

C. Both the DELETE statements and the UPDATE statement are rolled back

D. No SQL statements are rolled back

E. Only the seconds DELETE statement is rolled back

정답: B,D

문제9

Which statement adds a constraint that ensures the CUSTOMER_NAME column of the CUSTOMERS table holds a value?

A. ALTER TABLE customers MODIFY customer_name CONSTRAINT cust_name_nn NOT NULL;

B. ALTER TABLE customers ADD CONSTRAINT cust_name_nn CHECK customer_name NOT NULL;

C. ALTER TABLE customers ADD CONSTRAINT cust_name_nn CHECK customer_name IS NOT NULL;

D. ALTER TABLE customers MODIFY CONSTRAINT cust_name_nn CHECK customer_name IS NOT NULL;

E. ALTER TABLE customers MODIFY name CONSTRAINT cust_name_nn NOT NULL;

F. ALTER TABLE customers MODIFY customer_name CONSTRAINT cust_name_nn IS NOT NULL;

정답: A

문제10

View the Exhibit and examine the structure of ORDERS and CUSTOMERS tables.

There is only one customer with the CUST_LAST_NAME column having value Roberts. Which INSERT statement should be used to add a row into the ORDERS table for the customer whose CUST_LAST_NAME is Roberts and CREDIT_LIMIT is 600?

A. INSERT INTO(SELECT o.order_id, o.order_date,o.order_mode,c.customer_id, o.order_total FROM orders o, customers c WHERE o.customer_id = c.customer_id AND c.cust_last_name='Roberts' ANDc.credit_limit=600 ) VALUES (1,'10-mar-2007', 'direct',(SELECT customer_id FROM customers WHERE cust_last_name='Roberts' AND credit_limit=600), 1000);

B. INSERT INTO orders (order_id,order_date,order_mode,
(SELECT customer_id
FROM customers
WHERE cust_last_name='Roberts' AND
credit_limit=600),order_total)
VALUES(1,'10-mar-2007', 'direct', &customer_id, 1000);

C. INSERT INTO orders (order_id,order_date,order_mode,
(SELECT customer_id
FROM customers
WHERE cust_last_name='Roberts' AND
credit_limit=600),order_total)
VALUES(1,'10-mar-2007', 'direct', &&customer_id, 1000);

D. INSERT INTO orders
VALUES (1,'10-mar-2007', 'direct', (SELECT customer_id FROM customers WHERE cust_last_name='Roberts' AND credit_limit=600), 1000);

정답: D

문제11

Evaluate the following query:

What would be the outcome of the above query?

A. It produces an error because flower braces have been used.

B. It executes successfully and displays the literal" {'s start date was} " for each row in theoutput.

C. It executes successfully and introduces an 's at the end of each promo_name in the output.

D. It produces an error because the data types are not matching.

정답: C

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

문제12

Examine the structure of the SHIPMENTS table:

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. Evaluate the following two queries: Which statement is true regarding the above commands?

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

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

C. Only the first query executes successfully but gives a wrong result.

D. Only the second query executes successfully and gives the correct result.

E. Both execute successfully and give correct results.

정답: B

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

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

우리와 연락하기

유용한 링크

최신 업데이트