QUESTION 21:
You specified extent management as local for a tablespace. How will this affect space management in the tablespace?
A.Bitmap will be used to record free and allocated extents.
B.Free extents will be managed by the data dictionary tables.
C.The tablespace can have extents containing blocks of different sizes.
D.The tablespace will be system managed and the users cannot specify the extent size.
Answers: A
QUESTION 22:
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 23:
You created a user, USER01, and granted it two roles, APPL_ROLE and HR_ROLE.
Next you execute the following command to set the default role for the user:
SQL> ALTER USER user01 DEFAULT ROLE NONE;
Which three statements are true in this scenario? (Choose three.)
A.The user can use the privileges that are granted to it directly.
B.The user will be prompted to set the default role while logging in.
C.The user can use the roles but cannot grant them to another user.
D.The user can set its default role explicitly after connecting to the database.
E.The user will not be able to use the privileges that exist in the APPL_ROLE and HR_ROLE roles until the user enables the roles.
Answers: A D E
QUESTION 24:
You executed the following query that displays the result as shown in the Exhibit:
SQL> SELECT constraint_name, constraint_type,
deferrable, deferred, validated
FROM dba_constraints
WHERE owner = ‘HR’
AND table_name=’EMPLOYEES’;
View the Exhibit.
Which three statements are true regarding the EMP_EMAIL_UK constraint? (Choose three.)
A.This is a UNIQUE constraint.
B.The constraint is enforced at the end of each transaction.
C.This constraint is enforced only for the new data that is being inserted.
D.The constraint is enforced at the end of each insert, update, and delete operation.
E.The column(s) the constraint is defined on can be used as the reference column for a child table.
Answers: A D E
QUESTION 25:
What are the two effects of the following command to drop a table? (Choose two.)
SQL> DROP TABLE oe.orders_history
CASCADE CONSTRAINTS;
A.The dependent tables are truncated.
B.The dependent tables are dropped along with the ORDERS_HISTORY table.
C.The extents are released and can be used by other segments in the tablespace.
D.The contents are moved to the undo segments, thus enabling the user to recover the table.
E.The referential integrity constraints that refer to primary and unique keys in the ORDERS_HISTORY table are dropped.
Answers: C E
QUESTION 26:
You executed the following command:
ALTER TABLESPACE tbs_03 MINIMUM EXTENT 128K;
Which two statements are true regarding the command? (Choose two.)
A.It is an invalid command for a locally managed tablespace.
B.It is an invalid command for a dictionary-managed tablespace.
C.All the extents of the existing objects in tbs_03 are resized to 128K.
D.It allocates extents of multiples of 128K to newly created objects in the tablespace for which a storage clause is not specified.
Answers: A D
QUESTION 27:
The SALES_ORDERS table has millions of rows. You want to avoid free list contention while users are querying and manipulating the rows concurrently. Which type of storage structure would you use to store the data?
A.clustered table with the tables stored in multiple tablespaces
B.regular table with the indexes stored in a different tablespace
C.partitioned table with partitions spread across multiple tablespaces
D.index-organized table with the indexes stored in a different tablespace
Answers: C
QUESTION 28:
You examine the alert log file and notice that errors are generated by the log writer (LGWR) process. Which is the best source for providing you with more information about the nature of the problem?
A.the control file
B.user trace files
C.the database audit trail
D.background trace files
E.the initialization parameter file
Answers: D
QUESTION 29:
Which prerequisite should be met to create an Oracle database?
A.You must have a minimum disk space of 100 MB.
B.You must have an Oracle database user account with the SYSDBA privilege.
C.You must have an Oracle database user account with the SYSOPER privilege.
D.You must have an Oracle database user account that belongs to the OS administrator group.
Answers: B
QUESTION 30:
You have only one control file, control01.ctl, in your database. You decide to multiplex the control file and perform the following steps:
1.Shut down the instance.
2.Create a copy of control01.ctl by using an operating system command.
3.Start the database.
After startup, you queried V$CONTROLFILE and find that the multiplexing was not successful. What could be the reason for this?
A.You copied the control file after the instance was shut down.
B.You used an operating system command to copy the control file.
C.You did not issue the manual checkpoint before the instance was shut down.
D.You did not update the parameter file to add information about the new control file.
Answers: D
Passleader Latest Sample Questions for Oracle 1Z0-031 Test
