Oracle 1z0-071 問題集

質問 1：
Which two are true about granting privilege on objects?
A. A table owner must grant the references privilege to allow other users to create FOREIGN KEY constraints using that table.
B. The owner of an object acquires all object privilege on that object by default.
C. An object privilege can be granted to other users only by the owner of object.
D. The WITH GRANT OPTION clause can be used only by DBA users.
E. An object privilege can be granted to a role only by the owner of that object.
正解：A,B
解説: (Topexam メンバーにのみ表示されます)

質問 2：
Which three statements are true about performing DML operations on a view with no Instead of triggers defined?
A. Views cannot be used to add rows to an underlying table if the table has columns with NOT NULL constraints lacking default values which are not referenced in the defining query of the view.
B. Insert statements can always be done on a table through a view.
C. Views cannot be used to query rows from an underlying table if the table has a PRIMARY KEY and the PRIMARY KEY columns are not referenced in the defining query of the view.
D. Views cannot be used to add or modify rows in an underlying table if the defining query of the view contains the DISTINCT keyword.
E. WITH CHECK clause has no effect when deleting rows from the underlying table through the view.
F. Delete statements can always be done on a table tough a view.
正解：A,D,F
解説: (Topexam メンバーにのみ表示されます)

質問 3：
You want to return the current date and time from the user session, with a data type of TIMESTAMP WITH TIME ZONE.
Which function will do this?
A. CURRENT DATE
B. LOCALTIMESTAMP
C. CURRENT_ TIMESTAMP
D. SYSDATE
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 4：
Which statement falls to execute successfully?
A. SELECT *
FROM employees e
JOIN department d
WHERE e.department_id=d.department_id
AND d.department_id=90;
B. SELECT *
FROM employees e
JOIN departments d
ON e.department_id=d.department_id
WHERE d.department_id=90;
C. SELECT *
FROM employees e
JOIN departments d
ON d.departments_id=90
WHERE e.department_id=d.department_id;
D. SELECT *
FROM employees e
JOIN departments d
ON e.department_id=d.department_id
AND d.department_id=90;
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Which three statements are true about Structured Query Language (SQL)?
A. It requires that data be contained in hierarchical data storage
B. It is the only language that can be used for both relational and object-oriented databases
C. It provides independence for logical data structures being manipulated from the underlying physical data storage
D. It best supports relational databases
E. It guarantees atomicity, consistency, isolation, and durability (ACID) features
F. It is used to define encapsulation and polymorphism for a relational table
正解：C,D
解説: (Topexam メンバーにのみ表示されます)

質問 6：
Which two are true about virtual columns?
A. They cannot have a data type explicitly specified.
B. They can be referenced in the column expression of another virtxial column.
C. They can be referenced In the where clause of an update or debete statement.
D. They can be referenced in the set clause of an update statement as the name of the column To be updated.
E. They can be indexed.
正解：A,E
解説: (Topexam メンバーにのみ表示されます)

質問 7：
BOOK_SEQ is an existing sequence in your schema.
Which two CREATE TABLE commands are valid?
A. CREATE TABLE bookings (
bk_id NUMBER(4) DEFAULT book_seq.NEXTVAL PRIMARY KEY,
start_date DATE DEFAULT SYSDATE,
end_date DATE DEFAULT SYSDATE NOT NULL);
B. CREATE TABLE bookings ( bk_id NUMBER(4),
start_date DATE DEFAULT SYSDATE,
end_date DATE DEFAULT (end_date >= start_date));
C. CREATE TABLE bookings (
bk_id NUMBER(4) DEFAULT book_seq.CURRVAL,
start_date DATE DEFAULT SYSDATE,
end_date DATE DEFAULT start date);
D. CREATE TABLE bookings (
bk_id NUMBER(4) NOT NULL DEFAULT book_seq.CURRVAL,
start_date DATE NOT NULL,
end_date DATE DEFAULT SYSDATE);
E. CREATE TABLE bookings (
bk_id NUMBER(4) NOT NULL PRIMARY KEY,
start_date DATE NOT NULL,
end_date DATE DEFAULT SYSDATE);
正解：A,E
解説: (Topexam メンバーにのみ表示されます)

質問 8：
Which two are true about scalar subquery expressions?
A. You cannot correlate them with a table in the parent statement
B. .You must enclose them in parentheses.
C. They can return two columns.
D. You can use them as a default value for a column.
E. They can return at most one row.
正解：B,E
解説: (Topexam メンバーにのみ表示されます)

質問 9：
Which three statements are true about Oracle synonyms?
A. A SEQUENCE can have a synonym.
B. A synonym can be available to all users .
C. A synonym created by one user can refer to an object belonging to another user.
D. A synonym cannot be created for a PL /SQL package.
E. Any user can drop a PUBLIC synonym.
正解：A,B,C
解説: (Topexam メンバーにのみ表示されます)