q. 7 : what can you do to reduce the burden on a rollback segment during the import of a large table
1. assign a large rollback segment
2. set transaction use rollback segment rbslarge
3. commit=y
4. none of the above
3
q. 8 : what is an incremental export
1. export of the objects that have changed since last export
2. export of rows that have changed since last export
3. incremental exports cannot be performed in oracle
4. none of the above
1
q. 9 : an incremental export is a good strategy for
1. applications with few large tables and less data changes
2. applications where changes are scattered across small tables
3. all of the above
4. none of the above
2
q. 10 : what is a cumulative export
1. export of the objects that have changed since last export
2. export of objects that have changed since last cumulative or complete export
3. export or rows that have changed since last cumulative or complete export
4. none of the above
2
q. 11 : what option of export utility allows for faster extraction of data
1. full=y
2. direct=y
3. sql=n
4. all of the above
2
q. 12 : why is direct path export faster
1. this option by passes the sql layer
2. all sga is used for export
3. all of the above
4. none of the above |
