Oracle Certification Exam Question:

Explain What are the benefits of system-managed locally managed tablespace?

Answer:

Locally Managed Tablespaces Include the following Benefits:

1.Free extents are managed in the Tablespace.
2.Bitmap is used to record free extents.
3.Each bit corresponds to a block or a group of block.
4.Bit value indicates free or used.

Previous Question

Next Question

Explain Which two statements are true about sequences created in a single instance database? (Choose
two.)
A. The numbers generated by a sequence can be used only for one table
B. DELETE <sequencename> would remove a sequence from the database
C. CURRVAL is used to refer to the last sequence number that has been generated
D. When the MAXVALUE limit for a sequence for reached, you can increase the MAXVALUE limit
by using the ALTER SEQUENCE statement
E. When a database instance shuts down abnormally, the sequence numbers that have been
cached but not used would be available once again when the database instance is restarted

Explain Which three statements/commands would cause a transaction to end? (Choose three.)
A. COMMIT
B. SELECT
C. CREATE
D. ROLLBACK
E. SAVEPOINT