Oracle Certification Exam Question:

Download Job Interview Questions and Answers PDF

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.

Download Oracle Certification Interview Questions And Answers PDF

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