최신 1z1-071 무료덤프 - Oracle Database SQL

문제1

Which two are true about the precedence of opertors and condtions

A. AND and OR have the same order of precedence in a condition

B. || has a higher order of precedence than +(addition)

C. NOT has a higher order of precedence than AND and OR in a condition.

D. Operators are evaluated before conditions.

E. + (addition) has a higher order of precedence than * (mliplpition)

정답: B,C

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

문제2

Which two are true about external tables that use the ORACLE _DATAPUMP access driver?

A. Creating an external table creates a dump file that can be used only by an external table in the same database.

B. When creating an external table, data can be selected only from a table whose rows are stored in database blocks.

C. Creating an external table creates a directory object.

D. Creating an external table creates a dump file that can be used by an external table in the same or a different database.

E. When creating an external table, data can be selected from another external table or from a table whose rows are stored in database blocks.

정답: E

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

문제3

Examine this SQL statement:
SELECT cust_id, cus_last_name "Last Name"
FROM customers
WHERE country_id = 10
UNION
SELECT cust_id CUST_NO, cust_last_name
FROM customers
WHERE country_id = 30
Identify three ORDER BY clauses, any one of which can complete the query successfully.

A. ORDER BY 2,cust_id

B. ORDER BY CUST_NO

C. ORDERBY 2, 1

D. ORDER BY "CUST_NO"

E. ORDER BY "Last Name"

정답: C,E

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

문제4

Examine the description of EMPLOYEES table:
Which three queries return all rows for which SALARY+COMMISSION is greate than 20000?

A. SELECT * FROM employees WHERE NVL2(salary)+commission,salary+commission,

B. SELECT * FROM employees WHERE NVL(salary+commission,0)>==20000;

C. SELECT * FROM employees WHERE salary+NULLF(commission,0)>=20000;

D. SELECT * FROM employees WHERE salary+NVL2(commission,commission,0)>=20000;

E. SELECT * FROM employees WHERE salary+NVL(commission,0)>=20000;

F. SELECT * FROM employees WHERE NVL(salary+commission,0)>=20000;

정답: C,D,E

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

문제5

Examine the description of the CUSTOMERS table:
Which three statements will do an implicit conversion?

A. SELECT * FROM customers WHERE TO_DATE(insert_date)=DATE'2019-01-01';

B. SELECT * FROM customers WHERE TO_CHAR(customer_id)='0001';

C. SELECT * FROM customers WHERE insert_date=DATE'2019-01-01';

D. SELECT * FROM customers WHERE customer_id=0001;

E. SELECT * FROM customers WHERE insert_date'01-JAN-19';

F. SELECT * FROM customers WHERE customer_id='0001';

정답: B,E,F

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

문제6

In the PROMOTIONS table, the PROMO_ BEGIN_DATE column is of data type and the default date format is DD-MON-RR Which two statements are true about expressions using PROMO_ BEGIN_DATE in a query?

A. PROMO_ BEGIN_DATE - SYSDATE will return an error

B. PROMO_ BEGIN_DATE - 5 will return a date

C. PROMO_ BEGIN_DATE - SYSDATE will return a number

D. TONUMBER (PROMO BEGIN_DATE) - 5 will return a number

E. TODATE(PROMO BEGIN_DATE *5) will return a date

정답: B,C

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

문제7

Which three statements are true about views in an Oracle database?

A. Views have no object number.

B. A view can be created that refers to a non-existent table in its defining query.

C. Views have no segment.

D. Views can join tables only if they belong to the same schema.

E. Rows inserted into a table using a view are retained in the table if the view is dropped

F. A SELECT statement cannot contain a where clause when querying a view containing a WHERE clause in its defining query

정답: B,C,E

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

문제8

Examine these statements which execute successfully:
ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYYY HH24 MI: SS'
ALTER SESSION SET TIME_ ZONE = '-5:00';
SELECT DBTIMEZONE, SYSDATE FROM DUAL
Examine the result:

If LOCALTIMESTAMP was selected at the same time what would it return?

A. 11-JUL-2019 11,00,00,000000AM -05:00

B. 11-JUL-2019 6,00,00,000000 AM

C. 11-JUL-2019 11,00,00,00000000 AM

D. 11-JUL-2019 6,00,00,00000000 AM - 05:00

정답: D

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

문제9

You execute these commands successfully:
CREATE GLOBAL TEMPORARY TABLE invoices _ gtt
( customer id INTEGER,
invoice_ total NUMBER (10, 2)
) ON COMMIT PRESERVE ROWS;
INSERT INTO invoices_ gtt VALUES (1, 100);
COMMIT;
Which two are true?

A. To drop the table in this session, you must first truncate it.

B. Other sessions can view the committed row.

C. You can add a column to the table in this session.

D. You can add a foreign key to the table.

E. When you terminate your session, the row will be deleted.

정답: B,E

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

문제10

Examine this partial command:
CREATE TABLE cust(
cust_id NUMBER(2),
credit_limit NUMBER(10)
ORGANIZATION EXTERNAL
Which two clauses are required for this command to execute successfully?

A. the REJECT LIMIT clause

B. the ACCESS PARAMETERS clause

C. the DEFAULT DIRECTORY clause

D. the access driver TYPE clause

E. the LOCATION clause

정답: B,E

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

문제11

Table ORDER_ITEMS contains columns ORDER_ID, UNIT_PRICE and QUANTITY, of data type NUMBER Statement 1:
SELECT MAX (unit price*quantity) "Maximum Order FROM order items;
Statement 2:
SELECT MAX (unit price*quantity "Maximum order" FROM order items GROUP BY order id; Which two statements are true?

A. Statement 2 may return multiple rows of output.

B. Both the statement given the same output.

C. Statement 2 returns only one row of output.

D. Statement 1 returns only one row of output.

E. Both statements will return NULL if either UNIT PRICE or QUANTITY contains NULL,

정답: A,D

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

문제12

Examine this query:
SELECT 2 FROM dual d1 CROSS JOIN dual d2 CROSS JOIN dual d3;
What is returned upon execution?

A. 1 row

B. 6 rows

C. 8 rows

D. 3 rows

E. 0 rows

F. an error

정답: A

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

최신 1z1-071 무료덤프 - Oracle Database SQL

우리와 연락하기

유용한 링크

최신 업데이트