Oracle 1Z0-082 問題集

質問 1：
You execute this command:
CREATE SMALLFILE TABLESPACE sales
DATAFILE '/u01/app/oracle/sales01.dbf
SIZE 5G
SEGMENT SPACE MANAGEMENT AUTO;
Which two statements are true about the SALES tablespace? (Choose two.)
A. Free space is managed using freelists
B. It uses the database default blocksize
C. Any data files added to the tablespace must have a size of 5 gigabytes
D. It is a locally managed tablespace
E. It must be smaller than the smallest BIGFILE tablespace
正解：B,D

質問 2：
Which three are types of segments in an Oracle Database? (Choose three.)
A. clusters
B. tables
C. stored procedures
D. undo
E. index
F. sequences
正解：A,B,D

質問 3：
Which two statements are true about the DUAL table? (Choose two.)
A. It can be used to display only constants or pseudo columns
B. It can display multiple rows and columns
C. It can be accessed by any user who has the SELECT privilege in any schema
D. It consists of a single row and single column of VARCHAR2 data type
E. It can be accessed only by the SYS user
F. It can display multiple rows but only a single column
正解：B,D

質問 4：
The stores table has a column START_DATE of data type DATE, containing the date the row was inserted. You only want to display details of rows where START_DATE is within the last 25 months. Which where clause can be used?
A. WHERE MON'THS_BETWEEN (SYSDATE, start_date) <= 25
B. WHERE MON'THS_BETWEEN (start_date, SYSDATE) <= 25
C. WHERE TO_XUMBER(start_date - SYSDATE) <= 25
D. WHERE ADD_MONTHS<start_date, 25) <= SYSDATE
正解：B

質問 5：
The SCOTT/TIGER user exists in two databases, BOSTON_DB and DALLAS_DB, in two different locations.
Each database has a tnsnames.ora file defining DALLAS_DB as a service name.
Examine this command:
CREATE DATABASE LINK dblink1 CONNECT TO scott IDENTIFIED BY tiger USING 'dallas_db'; How do you execute the command so that only SCOTT in BOSTON_DB can access the SCOTT schema in DALLAS_DB?
A. as SCOTT in BOSTON_DB
B. as SCOTT in DALLAS_DB
C. as SCOTT in both the databases
D. as SYS in both the databases
E. as SCOTT in BOSTON_DB and SYS in DALLAS_DB
正解：A
解説: (Topexam メンバーにのみ表示されます)

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

質問 7：
Which three statements are true about Deferred Segment Creation in Oracle databases?
A. It Is the default behavior for tables and indexes.
B. It Is supported for Index Organized Tables (IOTs) contained in locally managed tablespaces.
C. Sessions may dynamically switch back and forth from deferred to immediate segment creation.
D. Indexes inherit the deferred or immediate segment creation attribute from their parent table
E. It is supported for SYS-owned tables contained in locally managed tablespaces.
正解：A,C,D