Subject: Oracle DBA 1. Your database has a single undo tablespace, and you decid
ID: 3850229 • Letter: S
Question
Subject: Oracle DBA
1.
Your database has a single undo tablespace, and you decide to add another. How
can you ensure that the new one will be used?
A. Change the UNDO_TABLESPACE parameter to point to the new tablespace; there is no need to restart the database.
B. Change the UNDO_TABLESPACE parameter to point to the new tablespace, and restart the database.
C. Assign the new undo tablespace to one or more users; the UNDO_TABLESPACE parameter will be automatically adjusted.
D. Bring the new tablespace online; the UNDO_TABLESPACE parameter will be automatically adjusted.
2.
When one is using shared servers, what may happen if more concurrent requests are received than there are shared server processes?
A. Sessions may receive errors.
B. Statements may be queued.
C. No more shared servers may be started automatically.
D. The shared servers may execute several requests in parallel.
3.
Which of these is type of segment?
A. View
B. Table
C. Sequence
D. Rownum
E. All of the above
4.
What attributes of a user account can you specify with the CREATE USER command?
A. Default role(s)
B. Tablespace for storing all the user’s temporary data
C. Privilege
D. All of the above
5.
If a tablespace is made read-only, what can still be done to objects within it?
A. Insertions into a table will work, as long as there is free space within the segment and so no new extents need to be allocated.
B. Operations that are transparent to applications and users (such as creating indexes) can be done in the tablespace, but no DML commands can be executed against tables within it.
C. Objects in the tablespace can be dropped but not created.
D. No SQL commands can be executed against any objects in a read-only tablespace except SELECT statements.
Explanation / Answer
1.Change the UNDO_TABLESPACE parameter to point to the new tablespace; there is no need to restart the database.
The reason is that you can have multiple UNDO_TABLESPACE and you can specify each one with different names and use them with the following command:
UNDO_TABLESPACE = aakitbl_01;
2.The shared servers may execute several requests in parallel.
The reason behind this is that when the server requests goes far the processes it starts parallel processing of the requests.
3. Table
Because a segment is an database object which consists of space allocated to itself and table has space allocated.Hence, it is a segement.
4. ALL OF THE ABOVE.
It is because all the given features can be identified when a user is created like for eg:tablespaces for all the users temporary data can be noted, users priviliges can be noted,etc.
5.Operations that are transparent to applications and users (such as creating indexes) can be done in the tablespace, but no DML commands can be executed against tables within it.
The reason behind this is that after making the tablespace readonly use of DML commands or statements is prohibited and use of them may lead to the termination of the program.
Please rate the answer if it helped.....Thankyou
Hope it helps...