1Z0-031测试题

QUESTION NO: 36
You have two undo tablespaces defined for your database. The instance is currently using
the undo tablespace named UNDOTBS_1. You issue this command to switch to UNDOTBS
2 while there are still transactions using UNDOTBS_1:
ALTER SYSTEM SET UNDO_TABLESPACE = undotbs_2
Which two results occur? (Choose two.)
A. New transactions are assigned to UNDOTBS_2.
B. Current transactions are switched to the UNDOTBS_2 tablespace.
C. The switch to UNDOTBS_2 fails and an error message is returned.
D. The UNDOTBS_1 undo tablespace enters into a PENDING OFFLINE mode (status).
E. The switch to UNDOTBS_2 does not take place until all transactions in UNDOTBS_1
are completed.

Answer: A, D

QUESTION NO: 38
For a tablespace created with automatic segment-space management, where is free space
managed?
A. In the extent
B. In the control file
C. In the data dictionary
D. In the undo tablespace

Answer: D

QUESTION NO: 61
The DBA can structure an Oracle database to maintain copies of online redo log files to
avoid losing database information.
Which three are true regarding the structure of online redo log files? (Choose three.)
A. Each online redo log file in a group is called a member.
B. Each member in a group has a unique log sequence number.
C. A set of identical copies of online redo log files is called an online redo log group.
D. The Oracle server needs a minimum of three online redo log file groups for the normal
operation of a database.
E. The current log sequence number of a redo log file is stored in the control file and in the
header of all data files.
F. The LGWR background process concurrently writes the same information to all online
and archived redo log files in a group.

Answer: A, C, E

 

QUESTION NO: 75
Which two statements about segments are true? (Choose two.)
A. Each table in a cluster has its own segment.
B. Each partition in a partitioned table is a segment.
C. All data in a table segment must be stored in one tablespace.
D. If a table has three indexes only one segment is used for all indexes.
E. A segment is created when an extent is created, extended, or altered.
F. A nested table of a column within a table uses the parent table segment.

Answer: B, C

 

QUESTION NO: 78
You need to know how many data files were specified as the maximum for the database
when it was created. You did not create the database and do not have the script used to
create the database.
How could you find this information?
A. Query the DBA_DATA_FILES data dictionary view.
B. Query the V$DATAFILE dynamic performance view.
C. Issue the SHOW PARAMETER CONTROL_FILES command.
D. Query the V$CONTROLFILE_RECORD_SECTION dynamic performance view.

 

Answer: D

 

QUESTION NO: 82
Examine this TRUNCATE TABLE command:

TRUNCATE TABLE departments;
Which four are true about the command? (Choose four.)
A. All extents are released.
B. All rows of the table are deleted.
C. Any associated indexes are truncated.
D. No undo data is generated for the table's rows.
E. It reduces the number of extents allocated to the DEPARTMENTS table to the original
setting for MINEXTENTS.

Answer: B, C, D, E

 

QUESTION NO: 94
The new Human Resources Application will be used to manage employee data in the
EMPLOYEES table. You are developing a strategy to manage user privileges. Your
strategy should allow for privileges to be granted or revoked from individual users or
groups of users with minimal administrative effort.
The users of the Human Resources application have these requirements:
? A Manager should be able to view the personal information of the employees in
his/her group and make changes to their Title and Salary.
What should you grant to the manager user?
A. Grant SELECT on the EMPLOYEES table
B. Grant INSERT on the EMPLOYEES table
C. Grant UPDATE on the EMPLOYEES table
D. Grant SELECT on the EMPLOYEES table and then grant UPDATE on the TITLE and
SALARY columns
E. Grant SELECT on the EMPLOYEES table and then grant INSERT on the TITLE and
SALARY columns
F. Grant UPDATE on the EMPLOYEES table and then grant SELECT on the TITLE and
SALARY columns
G. Grant INSERT on the EMPLOYEES table and then grant SELECT on the TITLE,
MANAGER, and SALARY columns

 

Answer: D