Question 1.
When granting the system privilege, which clause enables the grantee to further grant the privilege to other users or roles?

A.	PUBLIC
B.	WITH PRIVILEGE
C.	WITH ADMIN OPTION
D.	WITH GRANT OPTION

Answer:   C

Explanation:
When granting the system privileges to a user WITH ADMIN OPTION will enable the grantee to further grant system privileges to other user or roles. 

Question 2.
Which statement about organizing tablespaces and segments is true?

A.	You should mix segments with short and long life spans in the same tablespace.
B.	You should keep good control over space allocation and define storage limits for users.
C.	You should use the autoextend feature on tablespaces that have a high update, delete, and insert activity.
D.	Data that is accesses by multiple users should be stored in tablespaces that reside on the same disk for easier management.

Answer:  B

Explanation:
Storage parameters affect both how long it takes to access the data stored in the database and how efficiently space in the database is used. During organizing tablespaces and segments, space allocation and storage limits defined by the storage parameter should be given a good value to get control over space allocation. 

Question 3.
From the data dictionary you know that user A has profile TEST_PROF assigned, and the IDLE_TIME resource shows default as its value. What does this mean?

A.	The actual limit depends on the setting in the profile called DEFAULT.
B.	User A can stay connected to the database without ever being automatically disconnected.
C.	The limit can be influenced only at the instance level by setting an initialization parameter.
D.	A database administrator using the ALTER SYSTEM command can set the limit.

Answer:  A

Explanation:
The DEFAULT values specify that this profile is subject to the limit for this resource as specified in the default profile. As in the situation the IDLE_TIME will be limited or have a value equal to value defined in the default profile.

Question 4.
Which statement about using PCTFREE and PCTUSED is true?

A.	Block space utilization can be specified only at the segment level.
B.	Block space utilization cab be specified only in the data dictionary.
C.	Block space utilization parameters can only be specified at the tablespace level.
D.	Block space utilization can be specified both at the tablespace level and at the segment level.

Answer:   A

Explanation:
PCTFREE is the amount of space reserved in the block for a possible update in the rows that already are contained in that block. After a PCTFREE is met the block is considered full and is not available for further growth of rows or insertion of new rows.PCTUSED: when a block has dropped below its PCTUSED quota oracle add the block to the free list for further insertion.  
Block space utilization can be specify for a segment by specifying a value for the PCTFREE and PCTUSED

Question 5.
Which two dynamic performance views could you query to display the number of online redo log groups and the current log groups?

A. V$LOG
B. V$THREAD
C. V$SESSION
D. V$ARCHIVE
E. V$INSTANCE

Answer: A & B

Explanation:
V$LOG and V$THREAD are the two dynamic performance views that can be queried to display the number of online redo log groups and current redo log group.

Question 6.
MINEXTENTS must be at least _____when a rollback segment is created.

A.	1
B.	2
C.	3
D.	5

Answer:  B

Explanation:
MINEXTENTS must be at least 2 for a rollback segment when rollback segment is created.

Question 7.
All members of the current online redo log groups are not available. Which action does Oracle take?

A. The instance crashes.
B. The instance writes to the next online redo log group.
C. The instance hangs until the DBA switches the redo log file.
D. The instance hangs until the DBA restart the archive process.

Answer: A

Explanation:
If all member of current online group become in accessible to the LGWR as they are being written, the database instance immediately shutdown. In this case you may need to perform media recovery from the loss of an online redo log file.

Question 8.
Which view displays the NLS initialization parameters that have been explicitly set?

A. NLS_SESSION_PARAMETERS
B. NLS_INSTANCE_PARAMETERS
C. NLS_DATABASE_PARAMETERS
D. V$NLS_INSTANCE_PARAMETERS

Answer: B

Explanation:
NLS_INSTANCE_PARAMETERS view will display NLS values set in the initialization parameter file init.ora.

Question 9.
Before a DBA creates a transportable tablespace, which two conditions must be completed?

A. All indexes are disabled or dropped.
B. The target system has precreated the tablespace.
C. The target system is in the same operating system.
D. The target system is in the same block size system.
E. The tables containing nested tables are contained in the same tablespace.

Answer: C & D

Explanation:
Tablespace can be transported from one database to another but Both the databases should be in the same operating system and the source and target database should have the same database block size. You can use transportable tablespace feature to move subset of an oracle database and plug it into another oracle database, essentially moving tablespace between the databases. Its is fastest way to move data between database than the export/import and unload/load. 

Question 10.
When you created a tablespace, you overestimated the size of one of the datafiles. Several objects were stored in the datafile. Some, but not all of the objects were dropped subsequently. To which point will you be able to decrease the size of the datafile?

A. To zero.
B. To the size of the datafile header.
C. To the last block of the last object.
D. It is not possible to decrease the size of the datafile.

Answer: C

Explanation:
A DBA can correct errors in estimates of space requirements and reclaim unused space in the database. Use the following command to manually decrease the size of datafile.

ALTER DATABASE 
DATAFILE file_name 
RESIZE integer[k/m];

It will decrease the size of the data file but the size cannot be decrease below the last block of last object.

	Web www.certsbraindumps.com