Oracle 1z0-071 問題集

質問 1：
Examine the description of the CUSTOMERS table:

You want to display details of all customers who reside in cities starting with the letter D followed by at least two character.
Which query can be used?
A. SELECT * FROM customers WHERE city LIKE'D %';
B. SELECT * FROM customers WHERE city ='%D_';
C. SELECT * FROM customers WHERE city LIKE'D_';
D. SELECT * FROM customers WHERE city ='D_%';
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 2：
Which two statements are true about views?
A. Theethi CHEcK clause prevents certalin rows from being updated or inserted in the underying table through the view.
B. Views can be updated without the need to re-grant privileges on the view.
C. Tables in the defining query of a view must always exist in order to create the view.
D. The wITH CHECK clause prevents certain rows from being displayed when querying the view.
E. Views can be indexed.
正解：B,C
解説: (Topexam メンバーにのみ表示されます)

質問 3：
Examine this statement:

Which two things must be changed for it to execute successfully?
A. One of the LONG columns must be changed to a VARCHAR2 or CLOB.
B. The foreign key constraint on DEPT_ID must be defined at the table level instead of the column level.
C. The word CONSTRAINT in the foreign key constraint on DEPT_ID must be changed to FOREIGN KEY.
D. The primary key constraint on BMP_ID must have a name.
E. The NOT NULL constraint on ENAME must be defined at the column level instead of the table level.
正解：A,E
解説: (Topexam メンバーにのみ表示されます)

質問 4：
In which three situations does a new transaction always start?
A. When issuing a CREATE INDEX statement after a CREATE TABLE statement completed unsuccessfully in the same session
B. When issuing a TRUNCATE statement after a SELECT statement was issued in the same session
C. When issuing a SELECT FOR UPDATE statement after a CREATE TABLE AS SELECT statement was issued in the same session
D. When issuing a DML statement after a DML statement filed in the same session.
E. When issuing a CREATE TABLE statement after a SELECT statement was issued in the same session
F. When issuing the first Data Manipulation Language (OML) statement after a COMMIT or ROLLBACK statement was issued in the same session
正解：B,C,F
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Which three are key components of an Entity Relationship Model?
A. an activity
B. an entity
C. a table
D. a relationship
E. an attribute
F. a unique identifier
正解：B,D,E
解説: (Topexam メンバーにのみ表示されます)

質問 6：
MANAGER is an existing role with no privileges or roles.
EMP is an existing role containing the CREATE TABLE privilege.
EMPLOYEES is an existing table in the HR schema.
Which two commands execute successfully?
A. GRANT CREATE TABLE, emp TO manager;
B. GRANT CREATE ANY SESSION, CREATE ANY TABLE TO manager;
C. GRANT CREATE SEQUENCE TO manager, emp;
D. GRANT SELECT, INSERT ON hr.employees TO manager WITH GRANT OPTION:
E. GRANT CREATE TABLE, SELECT ON hr. employees TO manager;
正解：B,C
解説: (Topexam メンバーにのみ表示されます)

質問 7：
Which statement fails to execute successfully?
A.

B.

C.

D.

正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 8：
Examine the BRICKS table:

You write this query:
SELECT
FROM bricks b1 CROSS JOIN bricks b2
WHERE b1. Weight < b2. Weight:
How many rows will the query return?
A. 0
B. 10
C. 16
D. 4
E. 6
F. 1
正解：E
解説: (Topexam メンバーにのみ表示されます)

質問 9：
.No user-defined locks are used in your database.
Which three are true about Transaction Control Language (TCL)?
A. ROLLBACK to SAVEPOTNT undoes the transaction's changes made since the named savepoint and then ends the transaction.
B. COMMIT erases all the transaction's savepoints and releases its locks.
C. ROLLBACK without the TO SAVEPOINT clause undoes alt the transaction's changes, releases its locks, and erases all its savepoints.
D. ROLLBACK without the TO SAVEPOINT clause undoes all the transaction's changes but does not release its locks.
E. ROLLBACK without the TO SAVEPOINT clause undoes all the transaction's changes but does not erase its savepoints.
F. COMMIT ends the transaction and makes all its changes permanent.
正解：B,C,F
解説: (Topexam メンバーにのみ表示されます)