1.Creating Tablespace
CREATE TABLESPACE tablespace
[DATAFILE clause]
[MINIUM EXTENT integer[K|M]]
[BLOCKSIZE integger [K]]
[LOGGING|NOLOGGING]
[DEFAULT storage_clause]
[ONLINE|OFFLINE]
[PERMANENT|TEMPORARY]
Continue reading 表空间和数据文件管理(SG 9iR2)-3
1.Your database is running under automatic undo management and the UNDO_RETENTION parameter is set to 900 sec.
You executed the following command to enable retention guarantee:
ALTER TABLESPACE undotbs1 RETENTION GUARANTEE
What efeect would this statement have on the database?
A – The extents in undo tablespace retain data until the next full database backup.
B – The extents containing committed data in the undo tablespace are never overwritten.
C – The extents which no longer contain uncommitted data in the undo tablespace
are not overwritten for at least 15 minutes.
D – The extents containing committed data in the undo tablespace are not overwritten
until the instance is shut down.
Continue reading OCP 10g(1z0-042) daily 10 practices-3
1.Which three statements are true regarding the logical structure of the Oracle database?(choose three)
A – Each segment contains one or more extents
B – Mutiple tablespaces can share single datafile
C – A data block is a smallest unit of I/O for data files.
D – it is possible to have tablespaces of different blocks size in a database
E – Each data block in the database always corresponds to one OS block.
(Answer:A,C,D)
Continue reading OCP 10g(1z0-042) daily 10 practices-2
1.What are the consequences of executing the SHUTDOWN ABORT command(Choose tow)
A – The database files are synchronized.
B – Uncommitted changes are no rolled back.
C – The database is closed,but the instance is still started.
D – Database buffers and redo buffers are not written to the disk.
E – The data base undergose automatic media recovery during the next startup.
Continue reading OCP 10g(1z0-042) daily 10 practices-1
I found this web site scribd by accident.There are lots of books on this site.Here’s another similar site slideshare. Have fun!
Recent Comments