최신Oracle Database SQL - 1z1-071무료샘플문제

문제1
View the Exhibit and examine the structure in the DEPARTMENTS tables. (Choose two.)

Examine this SQL statement:
SELECT department_id "DEPT_ID", department_name, 'b' FROM
departments
WHERE departments_id=90
UNION
SELECT department_id, department_name DEPT_NAME, 'a' FROM
departments
WHERE department_id=10
Which two ORDER BY clauses can be used to sort the output?

A. ORDER BY 3;

B. ORDER BY DEPT_ID;

C. ORDER BY DEPT_NAME;

D. ORDER BY 'b';

정답: A,B

문제2
Examine the data in the CUST_NAME column of the CUSTOMERS table.
CUST_NAME
----------------
Lex De Haan
Renske Ladwig
Jose Manuel Urman
Jason Mallin
You want to extract only those customer names that have three names and display the * symbol in place of the first name as follows:
CUST NAME
------------------
*** De Haan
**** Manuel Urman
Which two queries give the required output? (Choose two.)

A. SELECT LPAD(SUBSTR(cust_name,INSTR(cust_name,' ')),LENGTH(cust_name),'*') "CUST NAME" FROM customers WHERE INSTR(cust_name, ' ',-1,2)<>0;

B. SELECT LPAD(SUBSTR(cust_name,INSTR(cust_name,' ')),LENGTH(cust_name)- INSTR(cust_name,' '),'*') "CUST NAME" FROM customers WHERE INSTR(cust_name, ' ',1,2)<>0 ;

C. SELECT LPAD(SUBSTR(cust_name,INSTR(cust_name,' ')),LENGTH(cust_name),'*') "CUST NAME" FROM customers WHERE INSTR(cust_name, ' ',1,2)<>0;

D. SELECT LPAD(SUBSTR(cust_name,INSTR(cust_name,' ')),LENGTH(cust_name)- cust_name,''),'*')
"CUST NAME"
INSTR(
FROM customers
WHERE INSTR(cust_name, ' ',-1,-2)<>0;

정답: A,C

문제3
Examine the types and examples of relationship that follow:
1 One-to-one a) teacher to Student
2 One-to-many b) Employees to Manager
3 Many-to-one c) Person to SSN
4 Many-to-many d) Customers to Products
Which option indicates correctly matched relationships?

A. 1-c, 2-d, 3-a, and 4-b

B. 1-a, 2-b, 3-c, and 4-d

C. 1-c, 2-a, 3-b, and 4-d

D. 1-d, 2-b, 3-a, and 4-c

정답: C

문제4
View the Exhibit and examine the structure of the ORDERS table.

You must select ORDER_ID and ORDER_DATE for all orders that were placed after the last order placed by CUSTOMER_ID 101.
Which query would give you the desired result?

A. SELECT order_id, order_date FROM orders
WHERE order_date > ALL
(SELECT order_date FROM orders WHERE customer_id = 101);

B. SELECT order_id, order_date FROM orders
WHERE order_date >
ANY
(SELECT order_date FROM orders WHERE customer_id = 101);

C. SELECT order_id, order_date FROM orders
WHERE order_date > IN
(SELECT order_date FROM orders WHERE customer_id = 101);

D. SELECT order_id, order_date FROM orders
WHERE order_date > ALL
(SELECT MAX(order_date) FROM orders ) AND customer_id = 101;

정답: A

문제5
You must create a SALES table with these column specifications and data types: (Choose the best answer.) SALESID: Number STOREID: Number ITEMID: Number QTY: Number, should be set to 1 when no value is specified SLSDATE: Date, should be set to current date when no value is specified PAYMENT: Characters up to 30 characters, should be set to CASH when no value is specified Which statement would create the table?

A. CREATE TABLE sales(
salesid NUMBER(4),
storeid NUMBER(4),
itemid NUMBER(4),
qty NUMBER DEFAULT 1,
slsdate DATE DEFAULT 'SYSDATE',
payment VARCHAR2(30) DEFAULT CASH);

B. CREATE TABLE sales(
salesid NUMBER(4),
storeid NUMBER(4),
itemid NUMBER(4),
qty NUMBER DEFAULT 1,
slsdate DATE DEFAULT SYSDATE,
payment VARCHAR2(30) DEFAULT 'CASH');

C. CREATE TABLE sales(
salesid NUMBER(4),
storeid NUMBER(4),
itemid NUMBER(4),
qty NUMBER DEFAULT = 1,
slsdate DATE DEFAULT SYSDATE,
payment VARCHAR2(30) DEFAULT = "CASH");

D. CREATE TABLE sales(
salesid NUMBER(4),
storeid NUMBER(4),
itemid NUMBER(4),
qty NUMBER DEFAULT = 1,
slsdate DATE DEFAULT SYSDATE,
payment VARCHAR2(30) DEFAULT = "CASH");

정답: B

문제6
View and Exhibit and examine the structure and data in the INVOICE table.

Which two statements are true regarding data type conversion in query expressions? (Choose two.)

A. inv_date = '15-february-2008' :uses implicit conversion

B. CONCAT(inv_amt, inv_date) : requires explicit conversion

C. inv_amt = '0255982' : requires explicit conversion

D. inv_date > '01-02-2008' : uses implicit conversion

E. inv_no BETWEEN '101' AND '110' : uses implicit conversion

정답: A,E

문제7
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 TRANS_VALIDITY column would allow storage of a time interval in days, hours, minutes, and seconds.

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

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

정답: A,B

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

문제8
Which statement is true about TRUNCATE and DELETE?

A. For large tables, DELETE is faster than TRUNCATE.

B. You can never TRUNCATE a table if foreign key constraints will be violated.

C. For tables with multiple indexes and triggers, DELETE is faster than TRUNCATE.

D. You can DELETE rows from a table with referential integrity constraints.

정답: B

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

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

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

B. A subquery can retrieve zero or more rows.

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

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

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

정답: B,D

문제10
Which three statements are true about GLOBAL TEMPORARY TABLES? (Choose three.)

A. GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table.

B. Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted.

C. A TRUNCATE command issued in a session causes all rows in a GLOBAL TEMPORARY TABLE for the issuing session to be deleted.

D. A GLOBAL TEMPORARY TABLE's definition is available to multiple sessions.

E. A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.

F. GLOBAL TEMPORARY TABLE space allocation occurs at session start.

정답: B,C,D

문제11
Which three statements about roles are true? (Choose three.)

A. Privileges are assigned to a role using the GRANT statement.

B. Roles are assigned to roles using the ALTER ROLE statement.

C. Privileges are assigned to a role using the ALTER ROLE statement.

D. A single user can be assigned multiple roles.

E. Roles are assigned to users using the ALTER USER statement.

F. A role is named group of related privileges that can only be assigned to a user.

G. A single role can be assigned to multiple users.

정답: A,D,G

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

문제12
View the Exhibit and examine the structure of the CUSTOMERS table.
In the CUSTOMERS table, the CUST_LAST_NAME column contains the values 'Anderson' and
'Ausson'.
You issue the following query:
SQL> SELECT LOWER(REPLACE(TRIM('son' FROM cust_last_name),'An','O'))
FROM CUSTOMERS
WHERE LOWER(cust_last_name) LIKE 'a%n';
What would be the outcome?

A. an error because the TRIM function specified is not valid

B. an error because the LOWER function specified is not valid

C. an error because the REPLACE function specified is not valid

D. 'Oder' and 'Aus'

정답: A

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

A. A subquery in the WHERE clause of a SELECT statement can be nested up to three levels only.

B. If the subquery returns 0 rows, then the value returned by the subquery expression is NULL.

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

D. A subquery can be used to access data from one or more tables or views.

E. The columns in a subquery must always be qualified with the name or alias of the table used.

정답: B,D

문제14
The CUSTOMERS table has the following structure:
You need to write a query that does the following tasks:
1. Display the first name and tax amount of the customers. Tax is 5% of their credit limit.
2. Only those customers whose income level has a value should be
considered.
3. Customers whose tax amount is null should not be considered.
Which statement accomplishes all the required tasks?

A. Which statement accomplishes all the required tasks? 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;

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,tax_amount) IS NOT NULL;

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

정답: B

문제15
View the exhibit and examine the description of SALES and PROMOTIONS tables. You want to delete rows from the SALES table, where the PROMO_NAME column in the PROMOTIONS table has either blowout sale or everyday low price as values.

Which three DELETE statements are valid? (Choose three.)

A. DELETE
FROM sales
WHERE promo_id = (SELECT promo_id
FROM promotions
WHERE promo_name = `blowout sale')
OR promo_name = `everyday low price');

B. DELETE
FROM sales
WHERE promo_id = (SELECT promo_id
FROM promo_name = `blowout sale')
AND promo_id = (SELECT promo_id
FROM promotions
WHERE promo_name = `everyday low price')
FROM promotions
WHERE promo_name = `everyday low price');

C. DELETE
FROM sales
WHERE promo_id IN (SELECT promo_id
FROM promotions
WHERE promo_name IN = `blowout sale',`everyday low price'));

D. DELETE
FROM sales
WHERE promo_id = (SELECT promo_id
FROM promotions
WHERE promo_name = `blowout sale')
OR promo_id = (SELECT promo_id
FROM promotions
WHERE promo_name = `everyday low price')

정답: A,C,D

자격증의 중요성:

ITDumpsKR 경쟁율이 심한 IT시대에 인증시험을 패스함으로 IT업계 관련 직종에 종사하고자 하는 분들에게는 아주 큰 가산점이 될수 있고 자신만의 위치를 보장할수 있으며 더욱이는 한층 업된 삶을 누릴수 있을수도 있습니다.

ITDumpsKR 제품의 가치:

ITDumpsKR에는 IT인증시험의 최신 학습가이드가 있습니다. ITDumpsKR의 IT전문가들이 자신만의 경험과 끊임없는 노력으로 최고의 학습자료를 작성해 여러분들이 시험에서 패스하도록 도와드립니다.

무료샘플 받아보기:

관심있는 인증시험과목 덤프의 무료샘플을 원하신다면 덤프구매사이트의 PDF Version Demo 버튼을 클릭하고 메일주소를 입력하시면 바로 다운받아 덤프의 일부분 문제를 체험해 보실수 있습니다.

완벽한 서비스 제공:

ITDumpsKR는 한국어로 온라인상담과 메일상담을 받습니다. 덤프구매후 일년동안 무료 업데이트 서비스를 제공해드리며 구매일로 부터 60일내에 시험에서 떨어지는 경우 덤프비용 전액을 환불해드려 고객님의 부담을 덜어드립니다.

인터넷에는IT인증시험대비자료가 헤아릴수 없을 정도로 많습니다.이렇게 많은 덤프자료중 대부분 분들께서 저희ITDumpsKR를 선택하는 이유는 덤프 업데이트가 다른 사이트보다 빠르다는 것이 제일 큰 이유가 아닐가 싶습니다.

유용한 링크

우리와 연락하기

근무시간: ( UTC+9 ) 9:00-24:00

월요일~토요일

서포트: 바로 연락하기

최신Oracle Database SQL - 1z1-071무료샘플문제

자격증의 중요성:

ITDumpsKR 제품의 가치:

무료샘플 받아보기:

완벽한 서비스 제공:

유용한 링크

인기 시험

우리와 연락하기