Exam information

Exam 1Z0-050: Oracle Database 11g, New Features for Administrators

Other exams

Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.)

Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.)

Which two will be the implications of these values in your database?

Examine the values for the following initialization parameters: FAST_START_MTTR_TARGET=0 LOG_CHECKPOINT_INTERVAL=0Which two will be the implications of these values in your database? (Choose two.)

What is the effect of this command?

SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL;What is the effect of this command?

What action would you take to ensure that a user cannot connect to the database instance by merely logging in to a remote machine?

A user, who is authenticated externally, logs in to a remote machine and connects to the database instance. What action would you take to ensure that a user cannot connect to the database instance by merely logging in to a remote machine?

Which two statements are true about Shared SQL Area and Private SQL Area?

Which two statements are true about Shared SQL Area and Private SQL Area? (Choose two.)

Which option would you use to reduce fragmentation without affecting the users who are currently using the index?

While observing the index statistics, you find that an index is highly fragmented, thereby resulting in poor database performance. Which option would you use to reduce fragmentation without affecting the users who are currently using the index?

Which statement describes the purpose of the above password file?

You executed the following command to create a password file in the database server: $ orapwd file = orapworcl entries = 5 ignorecase=NWhich statement describes the purpose of the above password file?

Which two statements correctly describe the relation between a data file and the logical database structures?

Which two statements correctly describe the relation between a data file and the logical database structures? (Choose two.)

Which data types would you use for the new column?

You want to access employee details contained in flat files as part of the EMPLOYEE table. You plan to add a new column to the EMPLOYEE table to achieve this.Which data types would you use for the new column?

What will be the implications on the archiving and the location of archive redo log files?

You configured the Flash Recovery Area for your database. The database instance has been started in ARCHIVELOG mode and the LOG_ARCHIVE_DEST_1 parameter is not set. What will be the implications on the archiving and the location of archive redo log files?

Page 1 of 2612345...1020...Last »