1z1-071試験無料問題集（325題）「Oracle Database SQL 認定」

出題：1

Examine the description of the EMPLOYEES table:

Which statement will fail?

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

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

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

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

正解：C 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：2

Examine this query which executes successfully;
Select job,deptno from emp
Union all
Select job,deptno from jobs_history;
What will be the result?

A. It will return rows that are not common to both select statements.

B. It will return rows from both select statements after eliminating duplicate rows.

C. It will return rows both select statements including duplicate rows.

D. It will return rows common to both select statements.

正解：C 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：3

Examine these statements and results:
SQL> SELECT COUNT(*) FROM emp
COUNT(*)
---------------------
14
sQL> CREATE GLOBAL TEMPORARY TABLE t emp As SELECT * FROM emp;
Table created
SQL> INSERT INTo temp SELECT * FROM emp;
14 rows created
SQL> COMMIT:
Commit complete*
SQL> INSERT INTo temp SELECT * EROM emp;
14. rows created
SQL> SELECT COUNT(*) FROM t emp
How many rows are retrieved by the last query?

A. 28

B. 14

C. 42

D. 0

正解：B 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：4

Examine this statement which executes successfully:
Which three are true?

A. Only if the salary is 20000 or less and the employee id is less than 125,insert EMPLOYEE_ID,MANAGER_ID,and SALARY into the MGR_HISTORY table.

B. If the salary is 20000 or less and the employee id is less than 125,insert EMPLOYEE_ID,HIRE_DATE,and SALARY into the SAL_HISTORY table.

C. Regardless of salary,only if the employee id is less than 125,insert EMPLOYEE_ID,NANAGER_ID,SALARY into the MGR_HISTORY table.

D. If the salary is more than 20000 and the employee is less than 125,insert EMPLOYEE_ID and SALARY into the SPECIAL_SAL table.

E. Only if the salary is 20000 or less and the employee id is 125 or higher,insert EMPLOYEE_ID,MANAGER_ID,and SALARY into the MDR_HISTORY table.

F. Regardless of salary and employee id,insert EMPLOYEE_ID,MANAGER_ID,and SALARY into the MGR_HISTORY table.

正解：A,B,C 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：5

Which two are true about creating tables in an Oracle database?

A. Creating an external table will automatically create a file using the specified directory and file name.

B. A system privilege is required.

C. A create table statement can specify the maximum number of rows the table will contain.

D. A primary key constraint is manadatory.

E. The same table name can be used for tables in different schemas.

正解：B,E 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：6

Examine the command to create the BOOKS table.
SQL> create table books(book id CHAR(6) PRIMARY KEY,
title VARCHAR2(100) NOT NULL,
publisher_id VARCHAR2(4),
author_id VARCHAR2 (50));
The BOOK ID value 101 does not exist in the table.
Examine the SQL statement.
insert into books (book id title, author_id values
('101','LEARNING SQL','Tim Jones')

A. It executes successfully and the row is inserted with a null PLBLISHER_ID.

B. It executes successfully only if NULL is explicitly specified in the INSERT statement.

C. It executes successfully onlyif NULL PUBLISHER ID column name is added to the columns list and NULL is explicitly specified In the INSERT statement.

D. It executes successfully only NULL PUBLISHER_ID column name is added to the columns list in the INSERT statement.

正解：A 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：7

Which two statements are true about the SET VERIFY ON command?

A. It can be used in SQL Developer and SQL*Plus.

B. It displays values for variables created by the DEFINE command.

C. It displays values for variables used only in the WHERE clause of a query.

D. It can be used only in SQL*plus.

E. It displays values for variables prefixed with &&.

正解：A,B 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：8

Which two are true about transactions in the Oracle Database?

A. A DDL statement issued by a session with an uncommitted transaction automatically Commits that transaction.

B. DML statements always start new transactions.

C. An uncommitted transaction is automatically committed when the user exits SQL*Plus.

D. A session can see uncommitted updates made by the same user in a different session.

E. DDL statements automatically commit only data dictionary updates caused by executing the DDL.

正解：A,C 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：9

Which two are true about creating tables in an Oracle database?

A. Creating an external table will automatically create a file using the specified directory and file name.

B. A system privilege is required.

C. A create table statement can specify the maximum number of rows the table will contain.

D. A primary key constraint is manadatory.

E. The same table name can be used for tables in different schemas.

正解：B,E 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：10

Examine the description of the EMPLOYEES table:

Examine this query:

Which line produces an error?

A. Line 5

B. Line 7

C. Line 8

D. Line 3

正解：D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：11

Examine this list of requirements for a sequence:
1. Name:EMP_SEQ
2. First value returned:1
3. Duplicates are never permitted.
4. Provide values to be inserted into the EMPLOYEES.EMPLOYEE_ID COLUMN.
5. Reduce the chances of gaps in the values.
Which two statements will satisfy these requirements?

A. CREATE SEQUENCE emp_seq START WITH 1 INCRENENT BY 1 NOCACHE;

B. CREATE SEQUENCE emp_seq;

C. CREATE SEQUENCE emp_seq START WITH 1 INCREMENT BY 1 CACHE;

D. CREATE SEQUENCE emp_seq NOCACHE;

E. CREATE SEQUENCE emp_seq START WITH 1 CACHE;

F. CREATE SEQUENCE emp_seq START WITH 1 INCREMENT BY 1 CYCLE;

正解：A,C 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

1z1-071試験無料問題集「Oracle Database SQL 認定」