You executed the following command to create a tablespace called SALES_DATA: SQL> CREATE TABLESPACE sales_data DATAFILE SIZE 100M SEGMENT SPACE MANAGEMENT AUTO; Which two statements are true about the SALES_DATA tablespace()
Identify three situations in which you would NOT be able to drop a tablespace. ()
You lost the index tablespace in your database. You decided to re-create the index tablespace and the indexes in the tablespace. What methods can you use to re-create the indexes?()
You moved the index EMP_NO_INDX from one tablespace to another and then issued the following command to rebuild the index EMP_NO_INDX: SQL> ALTER INDEX EMP_NO_INDX REBUILD ONLINE; Which table allows the users to access the EMP_NO_INDX index while performing the rebuild operation?()
You noticed that the index tablespace in your database requires a recovery. However, instead of performing a media recovery, you decided to re/x7fcreate the indexes in a new tablespace. Which two options would you use to reduce the time it takes to re/x7fcreate the indexes?()
You experience a loss of the disk on which the USER_DATA tablespace data files are stored. You attempt to recover the data files but discover that the archived redo log file with sequence number 45, which is needed to perform complete recovery, is invalid. You then begin incomplete recovery-You receive this prompt: ORA-00279:change 309012...03/09/01 11:33:56 needed for thread ORA-00289: suggestion : /disk1/archive/arch_45.rdo ORA-00280: change 309012 for thread 1 is in sequence #45 Specify log: {=suggested | filename | AUTO | CANCEL} What is the correct response?()
You explicitly specified the tablespace usage threshold values while creating a tablespace. You need to revert to the database-wide default tablespace usage threshold values for the tablespace. Which PL/SQL package would you use?()
You lost the PRODSTD tablespace, which was read/write. The tablespace was read/x7fonly when the last backup was performed. How would you recover the tablespace?()
Youre performing tablespace point-in-time recovery on a tablespace called USERS. If an object in that tablespace has a foreign key constraint owned by another object in the INDEX_TBS which statement is true?()
The warning level threshold value for a tablespace, DATA1, is set to 60% and the critical level threshold value is set to 80%. The tablespace, DATA1, is infrequently used and is not a part of the production environment. You issued the following command: SQL> EXECUTE DBMS_SERVER_ALERT.SET_THRESHOLD (dbms_server_alert.tablespace_pct_full, dbms_server_alert.operator_ge,80, dbms_server_alert.operator_ge,90, 1,1,NULL, dbms_server_alert.object_type_tablespace,’DATA’); What will be the result of the command?()