QUESTION 111:
You need to create a database that must be able to store data in any language. Which character set would you use?
A.ASCII character set
B.Unicode character set
C.fixed-width multibyte character set
D.varying-width multibyte character set
Answers: B
QUESTION 112:
Identify two features of an offline tablespace. (Choose two.)
A.It automatically becomes online when the database is started.
B.The tablespace becomes online when the database is closed.
C.Users trying to access objects in the tablespace receive an error.
D.The event of bringing back offline tablespace to online is recorded in the control file.
E.The status of an offline tablespace is checked only when the database is mounted or opened.
Answers: C D
QUESTION 113:
You executed the following command to create an index on CUSTOMER_ID and ITEMS_ID columns in the ORDERS table:
SQL> CREATE INDEX orders_prim_indx
ON orders (customer_id, items_id);
In which two conditions would a query use this index? (Choose two.)
A.when both the columns are used in the WHERE clause of the query
B.when both the columns are used in the SELECT clause of the query
C.when the CUSTOMER_ID column is used in the WHERE clause of the query
D.when the ITEMS_ID column is used with a single row function in the WHERE clause of the query
Answers: A C
QUESTION 114:
Which two actions are performed when a database moves from the NOMOUNT to the MOUNT state? (Choose two.)
A.locate and open the control file
B.locate and open archived log files
C.obtain the names and the statuses of data files and online redo log files
D.initiate SMON to perform instance recovery if the database is not consistent
Answers: A C
QUESTION 115:
You are using rollback segments in your database. To ease transaction management, you want to implement automatic undo management by using the following steps:
1. creating an undo tablespace
2. setting the UNDO_MANAGEMENT parameter to AUTO in the parameter file
3. changing the tablespace that has the rollback segments to an undo tablespace by using the ALTER TABLESPACE command
4. setting the UNDO_TABLESPACE parameter to the tablespace that has the rollback segments
5. dropping the rollback segments and create undo segments in the same tablespace that has the rollback segments
Which option would you use?
A.3 only
B.1 and 2 only
C.2 and 3 only
D.3 and 5 only
E.2 and 5 only
Answers: B
QUESTION 116:
View the Exhibit and examine the contents of the v$log view in your database.
Which two statements regarding redo log files are true? (Choose two.)
A.Redo log files are not multiplexed.
B.Each redo log file is used by a different instance.
C.Redo log group 2 will be used after log group 3 is full.
D.Redo log group 1 will be used after log group 3 is full.
E.Redo log groups 1 and 2 have become corrupted because they are INACTIVE.
Answers: A D
QUESTION 117:
View the Exhibit and identify the component labeled as a question mark.
A.archiver (ARCn)
B.checkpoint (CKPT)
C.system monitor (SMON)
D.process monitor (PMON)
Answers: B
QUESTION 118:
Which three statements define the properties of a column that has the UNIQUE constraint that is enforced using ENABLE and VALIDATE clause? (Choose three.)
A.The column is indexed.
B.The column cannot have null values.
C.The column cannot have duplicate values.
D.A column in another table can reference this column.
E.The column cannot have any other constraints defined.
Answers: A C D
QUESTION 119:
Which three statements regarding the log sequence number are true? (Choose three.)
A.Each member in a group has a unique log sequence number.
B.The current log sequence number is stored in the control file.
C.The Checkpoint (CKPT) process assigns the log sequence number.
D.The current log sequence number is stored in the headers of all data files.
E.The log sequence number is assigned to a log group each time the Oracle server switches to that group to write to it.
Answers: B D E
QUESTION 120:
You executed the following command before starting a transaction:
SQL> SET CONSTRAINTS ALL DEFERRED;
What is the effect of this command?
A.The deferrable constraints are enforced at the end of the session.
B.The deferrable constraints are enforced at the end of each transaction.
C.The deferrable constraints are not enforced until they are changed to immediate.
D.The constraints are enforced at the end of each insert, delete, or update operation.
Answers: B
Passleader Latest Sample Questions for Oracle 1Z0-031 Test
