1Z0042WORD标红版Word格式.docx

1、C） undo blocks generated per second D） the size of the database buffer cache E） the value of the UNDO_RETENTION parameter2. 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） renaming the control files

2、B） dropping a user in your database C） enabling or disabling redo log archiving D） dropping a tablespace in your database E） re-creating the control files, after you lost all the control files in your database3. You want to create a new optimized database for your transactional production environmen

3、t to be used by a financial application. While creating the database, you want the Oracle software to take care of all basic settings to optimize the database performance. Which method would you use to achieve this objective?A） Use the CREATE DATABASE. command to create the database with Oracle-mana

4、ged files. B） Use the Database Configuration Assistant （DBCA） to create the database with Oracle-managed files. C） Use Enterprise Manager to create a new database with the Online Transaction Processing （OLTP） option. D） Use Database Configuration Assistant （DBCA） to create the database with Transact

5、ion Processing template. E） Use the CREATE DATABASE. command to create the database with Automatic Storage Management （ASM） file system.4. Which three statements are true about the stages of database startup?A） Data files and redo log files can be renamed at the MOUNT stage. B） Control files are rea

6、d at the OPEN stage for the location of data files. C） Control files are required to bring the database to the NOMOUNT stage. D） Data files and redo log files are made available to users at the OPEN stage. E） Data files and online redo log files are checked for consistency while opening the database

7、. 5. A constraint in a table is defined with the INITIALLY IMMEDIATE clause. You executed the ALTER TABLE command with the ENABLE VALIDATE option to enable the constraint that was disabled. What are the two effects of this command? （Choose two.） A） It fails if any existing row violates the constrain

8、t. B） It does not validate the existing data in the table. C） It enables the constraint to be enforced at the end of each transaction. D） It prevents insert, update, and delete operations on the table while the constraint is in the process of being enabled.6. You received complaints about the degrad

9、ation of SQL query performance. You identified top SQL queries that consume time. What would be your next step to find out recommendations about statistics collection and restructuring of the SQL statement to improve query performance?A） run Segment Advisor B） run SQL Tuning Advisor on top SQL state

10、ments C） run the Automatic Workload Repository （AWR） report D） run the Automatic Database Diagnostic Monitor （ADDM） on top SQL statements7. The UNDO_RETENTION parameter in your database is set to 1000 and undo retention is not guaranteed. Which statement regarding retention of undo data is correct?A

11、） Undo data becomes obsolete after 1,000 seconds. B） Undo data gets refreshed after every 1,000 seconds. C） Undo data will be stored permanently after 1,000 seconds. D） Committed undo data would be retained for 1,000 seconds if free undo space is available. E） Undo data will be retained in the UNDO

12、tablespace for 1,000 seconds, then it gets moved to the TEMPORARY tablespace to provide read consistency.8. View the Exhibit. Which statement regarding the dept and emp tables is true?A） When you delete a row from the emp table, you would receive a constraint violation error. B） When you delete a ro

13、w from the dept table, you would receive a constraint violation error. C） When you delete a row from the emp table, automatically the corresponding rows are deleted from the dept table. D） When you delete a row from the dept table, automatically the corresponding rows are deleted from the emp table.

14、 E） When you delete a row from the dept table, automatically the corresponding rows are updated with null values in the emp table. F） When you delete a row from the emp table, automatically the corresponding rows are updated with null values in the dept table.9. Which three statements are correct ab

15、out temporary tables?A） Indexes and views can be created on temporary tables. B） Both the data and the structure of temporary tables can be exported. C） Temporary tables are always created in a users temporary tablespace. D） The data inserted into a temporary table in a session is available to other sessions. E） Data manipulation language （DML） locks are never acquired on the data of temporary tables.10. Which statement regarding the