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

문제1

Which two are SQL features?

A. providing variable definition capabilities.

B. providing graphical capabilities

C. processing sets of data

D. providing database transaction control

E. providing update capabilities for data in external files

정답: C,D

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

문제2

Which three statements about roles are true?

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

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

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

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

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

F. A single user can be assigned multiple roles.

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

정답: A,B,F

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

문제3

Examine these statements:
CREATE TABLE dept (
deptno NUMBER PRIMARY KEY,
diname VARCHAR2(10) ,
mgr NUMBER ,
CONSTRAINT dept_fkey FOREIGN KEY(mgr) REFERENCES emp (empno));
CREATE TABLE emp (
Empno NUMBER PRIMARY KEY,
Ename VARCHAR2 (10) ,
deptno NUMBER,
CONSTRAINT emp_fkey FOREIGN KEY (deptno) REFERENCES dept (deptno) DISABLE); ALTER TABLE emp MODIFY CONSTRAINT emp_fkey ENABLE; Which two are true?

A. The Deptno column in the emp table will be able to contain nulls values.

B. The CREATE TABLE EMP statement must precede the CREATE TABLE DEPT statement for all threestatements to execute successfully.

C. The DEFT FKEY constraint definition must be removed from the CREATE TABLE DEF statement.and be added with an AITER TABLE statement once both tables are created, for the two CREATE TABLE statements to execute successfully in the order shown.

D. The MGR column in the DEPT table will not be able to contain NULL values.

E. All three statements execute successfully in the order shown

F. Both foreign key constraint definitions must be removed from the CREATE TABLE statements, andbe added with ALTER TABLE statements once both tables are created, for the two CREATE TABLEstatements to execute successfully in the order shown.

정답: A,E

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

문제4

Which three statements are true about indexes and their administration in an Oracle database?

A. A descending index is a type of function-based index

B. If a query filters on an indexed column then it will always be used during execution of the query

C. An index can be created as part of a CREATE TABLE statement.

D. A UNIQUE and non-unique index can be created on the same table column

E. A DROP INDEX statement always prevents updates to the table during the drop operation

F. An INVISIBLE index is not maintained when Data Manipulation Language (DML) is performed on its underlying table.

정답: A,C,D

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

문제5

Examine the description of the countries table:

Examine the description of the departments table:

Examine the description of the locations table:

Which two queries will return a list of countries with no departments?

A.

B.

C.

D.

정답: A,B

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

문제6

Which two statements are true about selecting related rows from two tables based on entity relationship diagram (ERD)?

A. Every relationship between the two tables must be implemented in a Join condition.

B. Rows from unrelated tables cannot be joined.

C. An inner join relates rows within the same table.

D. Relating data from a table with data from the same table is implemented with a self join.

E. Implementing a relationship between two tables might require joining additional tables.

정답: D,E

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

문제7

Which three statements are true about Oracle synonyms?

A. A synonym can be available to all users .

B. A synonym cannot be created for a PL /SQL package.

C. A SEQUENCE can have a synonym.

D. A synonym created by one user can refer to an object belonging to another user.

E. Any user can drop a PUBLIC synonym.

정답: A,C,D

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

문제8

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 (0.551) inserts the value as .55.

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

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

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

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

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

정답: A,D

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

문제9

Examine the description of the CUSTONERS table:

CUSTNO is the PRIMARY KEY.
You must determine if any customers' details have been entered more than once using a different CUSTNO, by listing all duplicate names.
Which two methods can you use to get the required result?

A. RIGHT OUTER JOIN with self join

B. LEFT OUTER JOIN with self join

C. self Join

D. subquery

E. PULL OUTER JOIN with self join

정답: C,D

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

문제10

Examine the description of the ENPLOYES table:

Which query requires explicit data type conversion?

A. SELECT join_ date + '20' EROM employees;

B. SELECT salary + '120.50' FROM employees;

C. SELECT SUBSTR(join date, 1, 2) - 10 FROM employees;

D. SELECT join _ date FROM employees WHERE join date > *10-02-2018';

E. SELECT join_ date||''|| salary FROM employees;

정답: D

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

문제11

Which statement is true regarding the SESSION_PRIVS dictionary view?

A. It contains the object privileges granted to other users by the current user session.

B. It contains the current object privileges available in the user session.

C. It contains the system privileges granted to other users by the current User session.

D. It contains the current system privileges available in the user session.

정답: D

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

문제12

Examine the description or the BOOKS_TRANSACTIONS table:

FOR customers whose income level has a value, you want to display the first name and due amount as 5% of their credit limit. Customers whose due amount is null should not be displayed.
Which query should be used?

A. SELECT cust_first_name, cust_credit_limit * . 05 AS DUE AMOUNT
FROM customers
WHERE cust income_level !=NULL
AND cust credit_level !=NULL;

B. SELECT cust_first_name, cust_credit_limit * . 05 AS DUE AMOUNT
FROM customers
WHERE cust income_level !=NULL
AND due_amount !=NULL;

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

D. SELECT cust_first_name, cust_credit_limit * . 05 AS DUE AMOUNT
FROM customers
WHERE cust income_level <> NULL
AND due_amount <> NULL;

E. SELECT cust_first_name, cust_credit_limit * . 05 AS DUE AMOUNT
FROM customers
WHERE cust income_level IS NOT NULL
AND due_amount IS NOT NULL;

정답: C

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

문제13

Examine the description of the EMPLOYEES table:

Which statement will execute successfully, returning distinct employees with non-null first names?

A. SELECT first_ name, DISTINCT last_ name FROM employees WHERE first_ name < > NULL;

B. SELECT first_ name, DISTNCT last_ name FROM employees WHERE first_ name IS NOT NULL;

C. SELECT DISTINCT * FROM employees WHERE first_ name IS NOT NULL;

D. SELECT Distinct * FROM employees WHERE first_ name < > NULL;

정답: C

문제14

Which two are true about scalar subquery expressions?

A. They can return two columns.

B. They can return at most one row.

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

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

E. .You must enclose them in parentheses.

정답: B,E

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

문제15

Which three statements are true about single-row functions?

A. They can be used only in the WHERE clause of a SELECT statement.

B. The data type returned can be different from the data type of the argument.

C. The argument can be a column name, variable, literal or an expression.

D. They return a single result row per table.

E. They can accept only one argument.

F. They can be nested to any level.

정답: B,C,F

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

문제16

Examine the description of the EMPLOYEES table:

Which statement will fail?

A. SELECT department_id, COUNT(*)
FROM employees
WHERE department_id <> 90 HAVING COUNT(*) >= 3
GROUP BY department_id;

B. SELECT department_id, COUNT (*)
FROM employees
HAVING department_ id <> 90 AND COUNT(*) >= 3
GROUP BY department_id;

C. SELECT department_id, COUNT(*)
FROM employees
WHERE department_id <> 90 GROUP BY department_id
HAVING COUNT(*) >= 3;

D. SELECT department_id, COUNT (*)
FROM employees
WHERE department_ id <> 90 AND COUNT(*) >= 3
GROUP BY department_id;

정답: D

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

문제17

Which two statements cause changes to the data dictionary?

A. DELETE FROM scott. emp;

B. TRUNCATE TABLE emp:

C. SELECT * FROM user_ tab._ privs;

D. AITER SESSION set NLs. _DATE FORMAT = 'DD/MM/YYYY';

E. GRANT UPDATE ON scott. emp TO fin manager;

정답: B,E

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

문제18

Which three statements are true about GLOBAL TEMPORARY TABLES?

A. A trigger can be created on a GLOBAL TEMPORARY TABLE

B. Data Manipulation Language (DML) on GLOBAL TEMPORARY TABLES generates no REDO.

C. A GLOBAL TEMPORARY TABLE can have only one index.

D. A GLOBAL TEMPORARY TABLE can be referenced in the defining query of a view.

E. A GLOBAL TEMPORARY TABLE cannot have PUBLIC SYNONYM.

F. A GLOBAL TEMPORARY TABLE can have multiple indexes

정답: B,D,F

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

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

우리와 연락하기

유용한 링크

최신 업데이트