摘要:
Your database is in NOARCHIVELOG mode and a logswitch happens every 20 minutes. On Thursday morning, media failure resulted in corruption of a data fi 阅读全文
摘要:
You created a new user in your database but missed assigning a default tablespace to that user. The user created a table without specifying the tables 阅读全文
摘要:
Your database is running in NOARCHIVELOG mode. You want to put the database in ARCHIVELOG mode. Which two statements regarding archive log destination 阅读全文
摘要:
You started a long transaction. Before committing, you executed a query on one of the tables currently being modified. You received the following erro 阅读全文
摘要:
You specified extent management as local for a tablespace. How will it affect space management in the tablespace? A. All the extents will be of the sa 阅读全文
摘要:
You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state? A. r 阅读全文
摘要:
When you try to open your database, you receive the following error: ORA-00205: error in identifying controlfile Where would you find the details requ 阅读全文
摘要:
User SCOTT wants to export his objects using Oracle Data Pump and executes the following command: $ expdp scott/tiger directory = EXPORT_DIR dumpfile 阅读全文
摘要:
Users complain about the slow response time of queries. While investigating the cause you find that the Oracle Instance is not configured to cache all 阅读全文
摘要:
A user complains that he gets the following error message repeatedly after executing some SQL statements. The error message forces the user to log off 阅读全文
摘要:
Your Oracle 11g database has 6 tablespaces (view Exhibit) in which:- TEMP is the default temporary tablespace- UNDOTBS1 is the default undo tablespace 阅读全文