1z0-040 Oracle - Braindumps.com.ua: question list for "Oracle Database 10g: New Features for Administrators", page: 6

Add to favorites

Profile

Registration

Braindumps

Master braindump list

Forums

Vendor

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2461)

Network Appliance (2)

Authorization

Login:
Password:
remember me:

Contacts
Certification links
Links

Authorized user can see question and answers.
Please log in or sign up.

Exam question list:
Show all comments

Oracle 1z0-040: Oracle Database 10g: New Features for Administrators

#51. You define the Warning threshold for the tablespace usage metric for the USERS tablespace to be 60% and the Critical threshold to be 80%. When space usage of the USERS tablespace exceeds 60%, an alert is raised. Which two are sources for detailed alert information? (Choose two.)

#52. Which parameter avoids the overwriting of archived redo log files when you recover the database with the RESETLOGS option?

#53. View the Exhibit and examine the highlighted alert. Exhibit #1

Exhibit #2

You have received an alert with the Category specified as Snapshot Too Old. Which page would you open from the Advisor Central page to determine the system recommendations to avoid such alerts in future?

#54. You have 100 segments in the USERS tablespace. You realize that the USERS tablespace is running low on space. You can use Segment Advisor to _______.

#55. You executed the following command on a partitioned table sales_test:

 ALTER TABLE sales_test 
 MOVE PARTITION s_q3 TABLESPACE users2 
 UPDATE INDEXES 
 (sales_test_ix 
 (PARTITION s_q3 TABLESPACE example) );

Which two statements regarding the above command care correct? (Choose two.)

#56. Which file gets created automatically while migrating from non-ASM files to ASM disk group by using RMAN?

#57. While creating an Oracle 10g Release 1 (10.1) database, you set the COMPATIBLE parameter to 10.0.0 Questionialization parameter file. Which two statements are true in this situation? (Choose two)

#58. Which three statements regarding collection of database usage metrics are correct? (Choose three.)

#59. Exhibit

As shown in the diagram, in-memory statistics are transferred to the disk at regular intervals. Which background process performs this activity?

#60. If the database is shown degraded performance, which three charts on the Database Control Console Performance page will help you resolve the problem? (Choose three.)

[1] [2] [3] [4] [5] [6] [7] [8] [9] [10] [11] ... [20]

gen. 0.082

Server date 06:02 02-12-2008

Oracle 1z0-040

Forum

Start online exam simulation

Master braindump

User braindumps