Oracle 1z0-042: Oracle Database 10g: Administration I
#111. 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 of the data blocks to satisfy the users' queries. Which component of the Oracle Instance would you change to improve performance?
#112. User SCOTT wants to export his objects using Oracle Data Pump and executes the following command: $ expdp scott/tiger directory = EXPORT_DIR dumpfile = scott.dmp include = table include = view:"like '%DEPARTMENTS%'" content = DATA_ONLY Which task would the command accomplish?
#113. When you try to open your database, you receive the following error: ORA-00205: error in identifying controlfile Where would you find the details required to resolve this error?
#114. 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?
#116. You started a long transaction. Before committing, you executed a query on one of the tables currently being modified. You received the following error: ORA-01555: snapshot too old How would you prevent such an error in the future? (Choose three.)
#117. Your database is running in NOARCHIVELOG mode. You want to put the database in ARCHIVELOG mode. Which two statements regarding archive log destinations are true? (Choose two.)
#118. 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 tablespace name. In which tablespace would the table be stored?
#119. Your database is in NOARCHIVELOG mode and a logswitch happens every 20 minutes. On Thursday morning, media failure resulted in corruption of a data file belonging to the TOOLS tablespace. Backups are taken on every Sunday. What would you do in this situation?
gen. 0.073
Forum
Master braindump