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

문제1
Which three statements about roles are true?

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

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

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

D. A single user can be assigned multiple roles

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

F. Roles are assigned to roles using the ALTER ROLE Statement

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

정답: B,D,G

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

문제2
Which three statements are true about performing Data Manipulation Language (DML) operations on a view In an Oracle Database?

A. Views cannot be used to add on modify rows in an underlying table if the defining query of the view contains aggregating functions.

B. The WITH CHECK clause has no effect when deleting rows from the underlying table through the view.

C. Views cannot be used to add or modify rows in an underlying table if the defining query of the view contains the DISTINCT keyword.

D. Views cannot be used to add rows to an underlying table if the table has columns with NOT NULL constraints lacking default values which are not referenced in the defining query of the view.

E. Views cannot be used to query rows from an underlying table if the table has a PRIPOARY KEY and the PRIMARY KEY columns are not referenced in the defining query of the view.

F. Insert statements can always be done on a table through a view.

정답: A,C,D

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

문제3
Which two statements will return the names of the three employees with the lowest salaries?

A. SELECT last_name,salary
FROM employees
WHERE ROWNUM<=3
ORDER BY (SELECT salary FROM employees);

B. SELECT last_name,salary
FROM employees
FETCH FIRST 3 ROWS ONLY
ORDER BY salary;

C. SELECT last_name,salary
FROM employees
ORDER BY salary
FETCH FIRST 3 ROWS ONLY;

D. SELECT last_name,salary
FROM (SELECT * FROM employees ORDER BY salary)

E. SELECT last_name, salary
FROM employees
WHERE ROWNUM<=3

정답: C

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

문제4
Table HR.EMPLOYEES contains a row where the EMPLOYEES _ID is 109.
User ALICE has no privileges to access HR.EMPLOYEES.
User ALICE starts a session.
User HR. starts a session and successfully executes these statements:
GRANT DELETE ON employees TO alice;
UPDATE employees SET salary = 24000 WHERE employee_id = 109;
In her existing session ALICE then executes:
DELETE FROM hr.employees WHERE employee_id = 109;
What is the result?

A. The DELETE command will wait for HR's transaction to end then delete the row.

B. The DELETE command will immediately delete the row.

C. The delete command will immediately return an error.

D. The delete command will wait for HR's transaction to end then return an error.

정답: D

문제5
You create a table by using this command:
CREATE TABLE rate_list (rate NUMBER(6,2));
Which two are true about executing statements?

A. INSERT INTO rate_list VALUES (-99.99) inserts the value as 99.99.

B. INSERT INTO rate_list VALUES (0.999) produces an error.

C. INSERT INTO rate_list VALUES (-.9) inserts the value as -.9.

D. INSERT INTO rate_list VALUES (0.551) inserts the value as .55.

E. INSERT INTO rate_list VALUES (-10) produces an error.

F. INSERT INTO rate_list VALUES (87654. 556) inserts the value as 87654.6.

정답: C,D

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

문제6
Examine these two queries and their output:
SELECT deptno, dname FROM dept;

SELECT ename, job, deptno FROM emp ORDER BY deptno;

Now examine this query:
SELECT ename, dname
FROM emp CROSS JOIN dept WHERE job = 'MANAGER'
AND dept.deptno IN (10, 20) ;

A. 64

B. 12

C. 3

D. 6

정답: D

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

문제7
Examine this incomplete query:
SELECT DATA'2019-01-01'+<INTERVAL CLAUSE>
FROM DUAL;
Which three clauses can replace<INTERVAL CLAUSE>ti add 22 hours to the date?

A. INTERVAL'12' HOUR

B. INTERVAL '12:00'

C. INTERVAL'11:60'HOUR TO MINUTE

D. INTERVAL'0 12'DAY TO HOUR

E. INTERVAL'0,5'DAY

F. INTERVAL'720'MINUTE

정답: A,C,F

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

문제8
Which two will execute successfully?

A. SELECT NVL('DATE',200) FROM (SELECT NULL AS "DATE" FROM DUAL);

B. SELECT NVL('DATE',SYSDATE) FROM DUAL;

C. SELECT COALESCE(O,SYSDATE) TRCH DUAL;

D. SELECT COALESCE('DATE',SYSDATE) FROM (SELECT NULL AS "DATE" FROM DUAL) ;

E. SELECT COALESCR('DATE', SYSDATE) FROM DUAL;

정답: A

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

문제9
Which three privileges can be restricted to a subset of columns in a table?

A. ALTER

B. INDEX

C. UPDATE

D. REFERENCES

E. INSERT

F. DELETE

G. SELECT

정답: C,D,E

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

문제10
Which two are true about rollbacks?

A. A transaction interrupted by a system failure is automatically rolled back.

B. The ROLLBACK statement does not release locks resulting from table updates.

C. Data Control L anguage (DCL) statements, such as GRANT and REVOKE, can be rolled back.

D. Data consistency is not guaranteed after a rollback.

E. If the ROLLBACK statement is used without TO SAVEPOINT, then all savepoints in the transaction are deleted .

정답: A,E

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

문제11
Examine these SQL statements which execute successfully:

Which two statements are true after execution?

A. The primary key constraint will be enabled and DEFERRED.

B. The foreign key constraint will be enabled and DEFERRED.

C. The foreign key constraint will be disabled.

D. The primary key constraint will be enabled and IMMEDIATE.

E. The foreign key constraint will be enabled and IMMEDIATE.

정답: D,E

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

문제12
Examine the ORDER _ITEms table:

Which two queries return rows where QUANTITY is a multiple of ten?

A. SELECT" FROM order_ items WHERE FLOOR (quantity / 10) = TRUNC (quantity / 10);

B. SELECT * FROM order_ items WHERE quantity = TRUNC (quantity, -1);

C. SELECT * FROM order_ items WHERE MOD (quantity, 10) = 0;

D. SELECT FROM order_ items WHERE quantity / 10 = TRUNC (quantity);

E. SELECT" FROM order_ _items WHERE quantity = ROUND (quantity, 1);

정답: A,C

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

문제13
Which two statements are true about external tables?

A. Their data can be retrieved by using only SQL or PL/SQL.

B. You can populate them from existing data in the database by using the CREATE TABLE AS SELECT command.

C. Their metadata and actual data are both stored outside the database.

D. Indexes can be created on them.

E. DML statements cannot be used on them.

정답: A,E

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

문제14
Which two are true about scalar subquery expressions?

A. You cannot correlate them with a table in the parent statement

B. They can return at most one row.

C. You can use them as a default value for a column.

D. .You must enclose them in parentheses.

E. They can return two columns.

정답: B,D

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

자격증의 중요성:

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 제품의 가치:

무료샘플 받아보기:

완벽한 서비스 제공:

유용한 링크

인기 시험

우리와 연락하기