1Z0-042(168题库).pdf
50墨值下载
1. Which three pieces of information are considered while deciding the size of the undo tablespace in your
database? (Choose thr ee.)
A) the size of an undo block
B) the size of the redo log files
C) undo blocks generated per second
D) the size of the database buffer cache
E) the value of the UNDO_RETENTION parameter
2. You executed the STARTUP MO UNT command to s tart your database. For which database operation do y ou
need to start the database in the MOUNT state?
A) renaming the control file s
B) dropping a user in your database
C) enabling or disabling redo log archiving
D) dropping a tablespace in your databa se
E) re-creating the control files, after you lost all the control files in your database
3. You want to create a new optimized database for y our transactional prod uction environment to be used by a
financial application. While creating the databas e, 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-managed files.
B) Use the Database Configuration Assistant (DBCA) to create th e dat abase 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 Transaction 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? (Choo se three.)
A) Data files and redo log files can be renamed at the MOUNT stage.
B) Control files are read at the OPEN stage for the location of data files.
C) Control files are required to bring the database to the NOMO UNT stage.
D) Data files and redo log files are mad e available to users at the OPEN stage.
E) Data files and online redo log files a r e checked for consistency while o pening the database.
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 e nable the constraint that was disabled. What are the two
effects of this command? (Choose two.)
A) It fails if any existing row violates the constraint.
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 operation s on the table whil e the constrai nt is in the proces s of being enable d.
6. You received complaints about the degradation of SQL query performance. You identified top SQL queries
that consume time. What would be your next step to find out recommendations about st atistics collection and
restructuring of the SQL statement to improve query performance?
A) run Segment Advisor
B) run SQL Tuning Advisor on top SQL statements
C) run the Automatic Workload Repository (AWR) re port
D) run the Automatic Database Diagnostic Monitor (ADDM ) on top SQL statements
7. The UNDO_RETENTION parameter in your database is set to 1000 and undo retention is not guaranteed.
Which statement regardi ng retention of undo data is correct?
A) Undo data becomes o bsolete 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 reta ined for 1,000 seconds if free undo space is available.
E) Undo data will be retained in the UNDO tablespace for 1,000 seconds, then it gets moved to the TEMPORARY
tablespace to provide read consisten cy.
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 re ceive a constraint violation error.
B) When you delete a row 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 delete d from the dept table.
D) When you delete a row from the dept table, automatically the corresponding rows are del eted from the emp table.
E) When you delete a row f rom the dept table, automatically the corresp onding rows are updated with null value s in the
emp table.
F) When you delete a row from the emp table, automatically the corresp onding rows a re updated with null values in the
dept table.
of 43
50墨值下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论