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

出題：1

Which two statements are true about an Oracle database?

A. A table can have multiple foreign keys.

B. A NUMBER column without data has a zero value.

C. A table can have multiple primary keys.

D. A VARCHAR2 column without data has a NULL value.

E. A column definition can specify multiple data types.

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

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

出題：2

Which two are true about the USING clause when joining tables?

A. It is used to specify an explicit join condition involving operators.

B. All column names in a USING clause must be qualified with a table name or table alias.

C. It can never be used with onatural join.

D. It can never be used with a full outer join.

E. It is used to specify an equijoin of columns that have the same name in both tables.

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

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

出題：3

Examine the data in the COLORS table:

Examine the data in the BRICKS table:

Which two queries return all the rows from COLORS?

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

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

出題：4

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 メンバーにのみ表示されます)

出題：5

Which two tasks require subqueries?

A. Display the minimum PROD_LIST_PRICE for each product status.

B. Display the total number of products supplied by supplier 102 which have a product status of obsolete.

C. Display products whose PROD_MIN_PRICE is more than the average PROD_LIST_PRICE of all products, and whose status is orderable.

D. Display the number of products whose PROD_LIST_PRICE is more than the average PROD_LIST_PRICE.

E. Display suppliers whose PROD_LIST_PRICE is less than 1000.

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

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

出題：6

Examine the description or the CUSTOMERS 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_AMONT FROM customers WHERE cust_income_level != NULL AND due_amount != NULL;

B. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMONT 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 DUE_AMOUNT FROM customers WHERE cust_income_level != NULL AND cust_credit_level != NULL;

D. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMONT FROM customers WHERE cust_income_level IS NOT NULL AND due_amount IS NOT NULL;

E. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMONT FROM customers WHERE cust_income_level <> NULL AND due_amount <> NULL;

正解：B 解答を投票する

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

出題：7

Examine the description products table:

Examine the description of the new_projects table;

Which two queries execute successfully?

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

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

出題：8

Which statement will return a comma-separated list of employee names in alphabetical order for each department in the EMP table?

A. SELECT deptno,LISTAGG(ename, ', ') WITHIN GROUP (GROUP BY deptno) AS employee_list FROM emp ORDER BY ename;

B. SELECT deptno,LISTAGG(ename, ', ') WITHIN GROUP AS employee_list FROM emp GROUP BY deptno ORDER BY ename;

C. SELECT deptno,LISTAGG(ename, ' , ') WITHIN GROUP AS employee_list FROM emp GROUP BY deptno;

D. SELECT deptno,LISTAGG(ename, ', ') WITHIN GROUP (ORDER BY ename) AS employee_list FROM emp GROUP BY deptno;

正解：D 解答を投票する

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

出題：9

Examine these statements executed in a single Oracle session:
CREATE TABLE product (pcode NUMBER(2),pname VARCHAR2(20));
INSERT INTO product VALUES(1,'pen');
INSERT INTO product VALUES (2,'pencil');
INSERT INTO product VALUES(3,'fountain pen');
SAVEPOINT a;
UPDATE product SET pcode=10 WHERE pcode =1;
COMMIT;
DELETE FROM product WHERE pcode =2;
SAVEPOINT b;
UPDATE product SET pcode=30 WHERE pcode =3;
SAVEPOINT c;
DELETE FROM product WHERE pcode =10;
ROLLBACK TO SAVEPOINT b;
COMMIT;
Which three statements are true?

A. There is no row containing pen

B. There is no row containing fountain pen.

C. The code for fountain pen is 3

D. The code for pen is 10.

E. There is no row containing pencil.

F. The code for pen is 1.

正解：A,D,E 解答を投票する

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

出題：10

Which three statements are true about inner and outer joins?

A. Outer joins can only be used between two tables per query.

B. A left or right outer join returns only unmatched rows.

C. Outer joins can be used when there are multiple join conditions on two tables.

D. An inner join returns matched rows.

E. A full outer join returns matched and unmatched rows.

F. A full outer join must use Oracle syntax.

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

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

出題：11

Choose two
Examine the description of the PRODUCT DETALS table:

A. EXPIRY_DATE contains the SYSDATE by default if no date is assigned to it

B. PRODUCT_NAME cannot contain duplicate values.

C. PRODUCT_ID can be assigned the PEIMARY KEY constraint.

D. EXPIRY_DATE cannot be used in arithmetic expressions.

E. PRODUCT_PRICE can be used in an arithmetic expression even if it has no value stored in it

F. PRODUCT_PRICE contains the value zero by default if no value is assigned to it.

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

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

出題：12

Examine this SQL statement:
SELECT cust_id, cust_last_name "Last Name
FROM customers
WHERE countryid=10
UNION
SELECT custid CUSTNO, cust_last_name
FROM customers
WHERE countryid=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. ORDER BY CUSTNO

D. ORDERBY2, 1

E. ORDER BY "Last Name"

正解：A,D,E 解答を投票する

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

出題：13

Which two are true about global temporary tables?

A. Their data is always stored in the default temporary tablespace of the user who created them.

B. Indexes can be created on them.

C. If the ON COMMIT clause Is transaction-specific, all rows in the table are deleted alter each COMMIT or ROLLBACK.

D. They can be created only by a user with the DBA role,but can be accessed by all users who can create a session.

E. Backup and recovery operations are available for these tables.

F. If the ON COMMIT clause is session-specific,the table is dropped when the session is terminated.

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

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

出題：14

Which two are true about the MERGE statement?

A. The WHEN MATCHED clause can be used to specify the updates to be performed.

B. The WHEN MATCHED clause can be used to specify the inserts to be performed.

C. The WHEN NOT MATCHED clause can be used to specify the deletions to be performed.

D. The WHEN NOT MATCHED clause can be used to specify the updates to be performed.

E. The WHEN NOT MATCHED clause can be used to specify the inserts to be performed.

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

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

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