No more data files can be added to the tablespace.
Segment space is managed by free lists in the tablespace.
A user created without being assigned a default tablespace uses this tablespace.
The tablespace can be dropped with the current setting with segments present in it.
第1题:
Which two statements correctly describe the relation between a data file and the logical databasestructures()
第2题:
Which two statements are true regarding undo tablespaces()
第3题:
A. It stores only the temporary table but not its indexes.
B. It stores both the temporary table as well as its indexes.
C. It must be a nondefault temporary tablespace for the database.
D. It can be a default or nondefault temporary tablespace for the database.
E. It must be the default temporary tablespace of the user who issues the command.
第4题:
Which two statements are true regarding transactions in an Oracle database()
第5题:
Which two statements regarding the LOGGING clause of the CREATE TABLESPACE... statement are correct?()
第6题:
The user HR receives the following error while inserting data into the TTK table: ERROR at line 1: ORA-01653: unable to extend table HR.TTK by 128 in tablespace SMDUpon investigation, you find that SMD is a small file tablespace. Which three action would allow the user to insert data()
第7题:
Which two statements about bigfile tablespaces are true? ()
第8题:
A. The MRKT tablespace is created as a small file tablespace, because the file size is less than the minimum required for big file files.
B. The MRKT tablespace may be dropped if it has no contents.
C. Users who were using the old default tablespace will have their default tablespaces changed to the MRKT tablespace.
D. No more data files can be added to the tablespace.
E. The relative file number of the tablespace is not stored in rowids for the table rows that are stored in the MRKT tablespace.
第9题:
Users in your production database complain that they are getting the following error message while trying to insert rows into the ORDERS table: ERROR at line 1: ORA-01654: unable to extend index USERS.ORDERS_IND by 8 in tablespace INDEXES.While investigating, you find that the INDEXES tablespace has run out of space and there is no more free space on the disk where the data files are available. Which two actions could you perform to overcome this error without affecting the queries that are currently being executed?()
第10题:
Which two statements regarding the LOGGING clause of the CREATE TABLESPACE. .. statement are correct?()