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

出題：1

Examine the description of the BRICKS table;

Examine the description of the BRICKS_STAGE table;

Which two queries execute successfully?

A. SELECT brick_id,shape FROM bricks
MINUS
SELECT WEIGHT,COLOR from bricks_stage;

B. SELECT shape,color,weight from bricks
MINUS
SELECT * FROM bricks_stage;

C. select * from bricks
MINUS
select * from bricks_stage;

D. SELECT shape,color FROM bricks
MINUS
SELECT color,shape FROM bricks_stage;

E. SELECT shape,color FROM bricks
MINUS
SELECT WEIGHT,color FROM bricks_stage;

正解：C 解答を投票する

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

出題：2

Which two statements are true about single row functions?

A. FLOOR: returns the smallest integer greater than or equal to a specified number

B. CONCAT: can be used to combine any number of values

C. MOD: returns the quotient of a division operation

D. CEIL: can be used for positive and negative numbers

E. TRUNC: can be used with NUMBER and DATE values

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

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

出題：3

Examine the description of the PRODUCT_ DETAILS table:

Which two statements are true?

A. EXPIRY_ DATE cannot be used in arithmetic expressions.

B. PRODUCT_ PRICE contains the value zero by default if no value is assigned to it.

C. PRODUCT_ PRICE can be used in an arithmetic expression even if it has no value stored in it.

D. PRODUCT_ NAME cannot contain duplicate values.

E. PRODUCT_ ID can be assigned the PRIMARY KEY constraint.

F. EXPIRY_ DATE contains the SYSDATE by default if no date is assigned to it.

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

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

出題：4

Evaluate the following SQL statement
SQL>SELECT promo_id, prom _category FROM promotions
WHERE promo_category='Internet' ORDER BY promo_id
UNION
SELECT promo_id, promo_category FROM Pomotions
WHERE promo_category = 'TV'
UNION
SELECT promoid, promocategory FROM promotions WHERE promo category='Radio' Which statement is true regarding the outcome of the above query?

A. It produces an error because positional, notation cannot be used in the ORDER BY clause with SBT operators.

B. It produces an error because the ORDER BY clause should appear only at the end of a compound query-that is, with the last SELECT statement.

C. It executes successfully but ignores the ORDER BY clause because it is not located at the end of the compound statement.

D. It executes successfully and displays rows in the descend ignore of PROMO CATEGORY.

正解：C 解答を投票する

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

出題：5

Which three are true about privileges and roles?

A. All roles are owned by the SYS schema.

B. PUBLIC can be revoked from a user.

C. A role can contain a combination of several privileges and roles.

D. System privileges always set privileges for an entire database.

E. A user has all object privileges for every object in their schema by default.

F. PUBLIC acts as a default role granted to every user in a database

G. A role is owned by the user who created it.

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

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

出題：6

Which two are true about self joins?

A. They have no join condition.

B. They require the NOT EXISTS operator in the join condition.

C. They require table aliases.

D. They require the EXISTS opnrator in the join condition.

E. They can use INNER JOIN and LEFT JOIN.

F. They are always equijoins.

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

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

出題：7

Which three actions can you perform only with system privileges?

A. Use the WITH GRANT OPTION clause.

B. Access flat files via a database, which are stored in an operating system directory.

C. Truncate a table in another schema.

D. Query any table in a database.

E. Log in to a database.

F. Execute a procedure in another schema.

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

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

出題：8

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

出題：9

You issued this command: DROP TABLE hr. employees;
Which three statements are true?

A. All indexes defined on HR, EMPLOYEES are dropped.

B. Sequences used to populate columns in the HR. EMPLOYEES table are dropped.

C. Synonyms for HR EMPLOYEES are dropped.

D. The HR. EMPLOYEES table may be moved to the recycle bin.

E. Views referencing HR, EMPLOYEES are dropped.

F. ALL constraints defined on HR, EMPLOYEES are dropped.

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

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

出題：10

Which statement is true regarding the SESSION_PRIVS dictionary view?

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

B. It contains the object privileges granted to other users by the current 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 解答を投票する

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

出題：11

Which three statements are true about the Oracle join and ANSI Join syntax?

A. The SQL:1999 compliant ANSI join syntax supports creation of a Cartesian product of two tables.

B. The SQL:1999 compliant ANSI join syntax supports natural joins.

C. The Oracle join syntax supports creation of a Cartesian product of two tables.

D. The Oracle join syntax only supports right outer joins,

E. The Oracle join syntax performs less well than the SQL:1999 compliant ANSI Join Answer.

F. The Oracle join syntax supports natural joins.

G. The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax.

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

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

出題：12

The CUSTOMERS table has a CUST_LAST_NAME column of data type VARCHAR2.
The table has two rows whose COST_LAST_MANE values are Anderson and Ausson.
Which query produces output for CUST_LAST_SAME containing Oder for the first row and Aus for the second?

A. SELECT REPLACE (REPLACE(cust_last_name,'son',''),'An','O') FROM customers;

B. SELECT INITCAP (REPLACE(TRIM('son' FROM cust_last_name),'An','O')) FROM customers;

C. SELECT REPLACE (TRIM(TRALING'son' FROM cust_last_name),'An','O') FROM customers;

D. SELECT REPLACE (SUBSTR(cust_last_name,-3),'An','O') FROM customers;

正解：A 解答を投票する

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

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