Oracle 1z0-071 問題集

質問 1：
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 only NULL PUBLISHER_ID column name is added to the columns list in the INSERT statement.
B. It executes successfully onlyif NULL PUBLISHER ID column name is added to the columns list and NULL is explicitly specified In the INSERT statement.
C. It executes successfully and the row is inserted with a null PLBLISHER_ID.
D. It executes successfully only if NULL is explicitly specified in the INSERT statement.
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 2：
Which three statements are true about views in an Oracle database?
A. Views have no segment.
B. A SELECT statement cannot contain a where clause when querying a view containing a WHERE clause in its defining query
C. Views have no object number.
D. Views can join tables only if they belong to the same schema.
E. Rows inserted into a table using a view are retained in the table if the view is dropped
F. A view can be created that refers to a non-existent table in its defining query.
正解：A,E,F
解説: (Topexam メンバーにのみ表示されます)

質問 3：
Examine the description of the CUSTONERS table:

CUSTNO is the PRIMARY KEY.
You must determine if any customers' details have been entered more than once using a different CUSTNO, by listing all duplicate names.
Which two methods can you use to get the required result?
A. self Join
B. LEFT OUTER JOIN with self join
C. PULL OUTER JOIN with self join
D. subquery
E. RIGHT OUTER JOIN with self join
正解：A,D
解説: (Topexam メンバーにのみ表示されます)

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

質問 5：
Which three statements are true about GLOBAL TEMPORARY TABLES?
A. A TRUNCATE command issued in a session causes all rows In a GLOBAL TEMPORARY TABLE for the issuing session to be deleted.
B. GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table.
C. A GLOBAL TEMPORARY TABLE's definition is available to multiple sessions.
D. A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.
E. GLOBAL TEMPORARY TABLE space allocation occurs at session start.
F. Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted.
正解：A,C,F
解説: (Topexam メンバーにのみ表示されます)

質問 6：
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 "Last Name"
B. ORDER BY"CUST NO"
C. ORDER BY 2, cust_id
D. ORDER BY CUSTNO
E. ORDERBY2, 1
正解：A,C,E
解説: (Topexam メンバーにのみ表示されます)

質問 7：
Which two are true about rollbacks?
A. A transaction interrupted by a system failure is automatically rolled back.
B. Data consistency is not guaranteed after a rollback.
C. Data Control L anguage (DCL) statements, such as GRANT and REVOKE, can be rolled back.
D. The ROLLBACK statement does not release locks resulting from table updates.
E. If the ROLLBACK statement is used without TO SAVEPOINT, then all savepoints in the transaction are deleted .
正解：A,E
解説: (Topexam メンバーにのみ表示されます)

質問 8：
Which two are true about self joins?
A. They have no join condition.
B. They are always equijoins.
C. They require table aliases.
D. They can use INNER JOIN and LEFT JOIN.
E. They require the NOT EXISTS operator in the join condition.
F. They require the EXISTS opnrator in the join condition.
正解：C,D
解説: (Topexam メンバーにのみ表示されます)

質問 9：
Which three are true?
A. LAST_DAY returns the date of the last day of the month for the date argument passed to the function.
B. ADD_MONTHS works with a character string that can be implicitlyt converted to a DATE data type.
C. CEIL requires an argument which is a numeric data type.
D. LAST_DAY return the date of the last day the previous month only.
E. CEIL returns the largest integer less than or equal to a specified number.
F. LAST_DAY returns the date of the last day of the current ,month onlyu.
G. ADD_MONTHS adds a number of calendar months to a date.
正解：A,B,G
解説: (Topexam メンバーにのみ表示されます)