Oracle 1Z0-050 Online Practice Questions and Exam Preparation

Oracle 1Z0-050 Online Questions & Answers

• Question 71:

  You have a range-partitioned table in your database. Each partition in the table contains the sales data for a quarter. The partition related to the current quarter is modified frequently and other partitions undergo fewer data manipulations. The

  preferences for the table are set to their default values. You collect statistics for the table using the following command in regular intervals:

  SQL> EXECUTE DBMS_STATS .GATHER_TABLE_STATS('SHI ,'SALES1 ,GRANUU\RITY=>'GLOBALl);

  You need statistics to be collected more quickly. What can you do to achieve this?

  A. Set DYNAMIC_SAMPLING to level 4.
  B. Set the STATISTICS_LEVEL parameter to BASIC.
  C. Set the INCREMENTAL value to TRUE for the partition table.
  D. Increase the value of STALE_PERCENT for the partition table.
  C. Set the INCREMENTAL value to TRUE for the partition table.

• Question 72:

  Which statement is true regarding the VALIDATE DATABASE command?

  A. It checks the database for intrablock corruptions only
  B. It checks for block corruption in the valid backups of the database.
  C. It checks the database for both intrablock and interblock corruptions.
  D. It checks for only those corrupted blocks that are associated with data files.
  A. It checks the database for intrablock corruptions only

• Question 73:

  View the Exhibit to examine the error while executing the REPAIR FAILURE command in an RMAN session.

  

  What is the reason for this error?

  A. Another repair session is running concurrently.
  B. The failure ID has not been mentioned in the command for data file 5.
  C. There are new failures recorded in the Automatic Diagnostic Repository (ADR).
  D. The ADVISE FAILURE command has not been issued before the REPAIR FAILURE command.
  A. Another repair session is running concurrently.

• Question 74:

  View the Exhibit for some of the current parameter settings.

  

  A user logs in to the HR schema and issues the following commands:

  SQL> CREATE TABLE emp

  (empno NUMBER(3),

  enameVARCHAR2(20),

  sal NUMBER(8,2));

  SQL> INSERT INTO emp(empno,ename) VALUES(1 /JAMES'); At this moment, a second user also logs in to the HR schema and issues the following command:

  SQL> ALTER TABLE emp MODIFY sal NUMBER(10,2);

  What happens in the above scenario?

  A. A deadlock is created.
  B. The second user's command executes successfully.
  C. The second user's session immediately produces the resource busy error.
  D. The second user's session waits for a time period before producing the resource busy error.
  D. The second user's session waits for a time period before producing the resource busy error.

• Question 75:

  You are managing an Oracle Database 11 g database with ASM storage. The ASM disk group has the COMPATIBLE .ASM attribute set to 11.1. Which statements are true regarding extent management and allocation units in the ASM disk group? (Choose all that apply.)

  A. Extent management is completely automated.
  B. The allocation unit size may vary but the extent size is fixed.
  C. The au_size disk group attribute determines the size of allocation units in the disk group.
  D. The allocation unit size and extent size are fixed for all the disks in a disk group and cannot be changed.
  A. Extent management is completely automated.
  C. The au_size disk group attribute determines the size of allocation units in the disk group.

• Question 76:

  View the Exhibit to observe the error.

  

  You receive this error regularly and have to shut down the database instance to overcome the error. What can the solution be to reduce the chance of this error in future, when implemented?

  A. locking the SGA in memory
  B. automatic memory management
  C. increasing the value of SGA_MAX_SIZE
  D. setting the PRE_PAGE_SGA parameter to TRUE
  B. automatic memory management

• Question 77:

  Examine the following RMAN command:

  BACKUP DATABASE TAG TESTDB KEEP UNTIL 'SYSDATE+11 RESTORE POINT TESTDB06;

  Which two statements are true regarding the backup taken by using the above RMAN command? (Choose two.)

  A. Only data files and the control file are backed up.
  B. Archived redo logs are backed up only if the database is open during the backup
  C. The backup is deleted after one day, regardless of the default retention policy settings.
  D. The backup becomes obsolete after one day, regardless of the default retention policy settings.
  B. Archived redo logs are backed up only if the database is open during the backup
  D. The backup becomes obsolete after one day, regardless of the default retention policy settings.

• Question 78:

  You want to take the backup of the USERS tablespace. It has a single data file of 900 MB.. You have tape drives of 300 MB each. The SBT channel is configured for the RMAN. To accomplish the backup, you issued the following RMAN

  command:

  RMAN> BACKUP SECTION SIZE 300M TABLESPACE users; Which two statements are true regarding the execution of the above command? (Choose two.)

  A. The backup piece size will be limited to 300 MB.
  B. The operation is accomplished using the default channel available.
  C. The RMAN parallelizes the backup although the parallelism is not set for a channel,
  D. Three channels for the tape drive must be configured by setting the parallelism to three.
  A. The backup piece size will be limited to 300 MB.
  B. The operation is accomplished using the default channel available.

• Question 79:

  In which two aspects does hot patching differ from conventional patching? (Choose two.)

  A. It consumes more memory compared with conventional patching.
  B. It can be installed and uninstalled via OPatch unlike conventional patching.
  C. It takes more time to install or uninstall compared with conventional patching.
  D. It does not require down time to apply or remove unlike conventional patching.
  E. It is not persistent across instance startup and shutdown unlike conventional patching.
  A. It consumes more memory compared with conventional patching.
  D. It does not require down time to apply or remove unlike conventional patching.

• Question 80:

  View the Exhibit to examine the output for the V$DIAG_INFO view.

  

  Which statements are true regarding the location of diagnostic traces? (Choose all that apply.)

  A. The path to the location of the background as well as the foreground process trace files is /u01/oracle/diag/rdbms/orclbi/orclbi/trace.
  B. The location of the text alert log file is /u01/oracle/diag/rdbms/orclbi/orclbi/alert.
  C. The location of the trace file for the current session is/u01/oracle/diag/rdbms/orclbi/orclbi/trace.
  D. The location of the XML-formatted version of the alert log is /u01/oracle/diag/rdbms/orclbi/orclbi/alert.
  A. The path to the location of the background as well as the foreground process trace files is /u01/oracle/diag/rdbms/orclbi/orclbi/trace.
  C. The location of the trace file for the current session is/u01/oracle/diag/rdbms/orclbi/orclbi/trace.
  D. The location of the XML-formatted version of the alert log is /u01/oracle/diag/rdbms/orclbi/orclbi/alert.