1Z0-053.pdf

C:\Documents and Settings\ONE-UNE-UNO\Mis documentos\1Z0-053.txt

martes, 19 de agosto de 2014 6:55

QUESTION 319 Which of the following is the least powerful privilege to create a program under a schema? B - CREATE_JOB QUESTION 296 Which of the following RMAN commands is used to perform Tablespace Point-In-Time Recovery? D- RECOVER TABLESPACE QUESTION 294 In which of the following states does the redo log group exists after a log file is re-created? C- CLEARING

QUESTION 332 OR 193 You work as a Database Administrator for Dolliver Inc. You have queried a dynamic performance view that displays the following output. USERNAME SYSDBA SYSOPER SYSASM --------- ------ ------- -Maria TRUE TRUE TRUE Peter TRUE TRUE FALSE Samuelson TRUE FALSE FALSE Which of the following views have you queried? A- V$PWFILE_USERS

QUESTION 299 Which of the following new features in Oracle 11g is used to rollback a committed transaction? C - Flashback Transaction Backout

QUESTION 302 Which of the following views reflects the changes to the settings of AWR? A - DBA_HIST_WR_CONTROL QUESTION 237 Which of the following data structures of a database are schema objects that require storage outside the data dictionary? A - Segments QUESTION 197 The Automatic Database Diagnostic Monitor (ADDM) stores its snapshots in the Automatic Workload Repository (AWR). In which of the following tablespaces the Automatic Workload Repository resides? A - SYSAUX

QUESTION 353 Which of the following statements about National Language Support (NLS) parameters are true? Each correct answer represents a complete solution. Choose two. A - NLS parameters that are set using a SQL function override the NLS parameters set in any B - NLS parameters determine the locale-specific behavior only on the server side. -1-



C - NLS parameters determine the locale-specific behavior only on the client side. D - NLS parameters that are set by the ALTER SESSION statement override the NLS parameter set as enviroment variable. Correct: A,D QUESTION 380 OR 190 or 91 You work as a Database Administrator for your company. The company uses Oracle as its database. The manager of the company wants you to move the company's databases. to another server, as the performance of the old server is now degraded. Which of the following RMAN commands will you use to accomplish the task? A - DUPLICATE 374 You are managing an ASM instance. You previously issued the following statements: ALTER DISKGROUP dg1 DROP DISK disk2; ALTER DISKGROUP dg1 DROP DISK disk3; ALTER DISKGROUP dg1 DROP DISK disk5; You want to cancel the disk drops that are pending for DGI disk group. Which statement should you issue? C. ALTER DISKGROUP dg1 UNDROP DISKS; QUESTION 367 You are planning to transport the TBS1 tablespace from one database to another. The TBS1 tablespace is a read/write tablespace, and it is currently online. You issue the following query on both the source and target databases: SELECT d.platform_name, t.endian_format FROM v$database d, v$trasportable_platform t WHERE d.platform_id=t.platform_id; In reviewing the results, you determine that the target database has a different platform than the source database, but both platforms have the same endian format. Which step would NOT be necessary for you to succesfully transport the TBS1 tablespace to the target database?. D- converting the datafiles using the RMAN CONVERT command. QUESTION 44 Which of the following cannot be used as input to the SQL Tuning Advisor? (Choose all that apply.) A - A single SQL statement provided by a user B - An existing SQL Tuning Set (STS) C - A preprocessed Database Replay workload D - A schema name A. SQL statement identified in EM as using excessive resources Correct C,D QUESTION 114 Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement? A - The SGA Tuning Advisor B - The SQL Access Advisor C - The SQL Tuning Advisor D - The Memory Advisor Correct: B QUESTION 229 Which of the following keywords is used to shut down a database while migrating it to ASM? -2-



C - NLS parameters determine the locale-specific behavior only on the client side. D - NLS parameters that are set by the ALTER SESSION statement override the NLS parameter set as enviroment variable. Correct: A,D QUESTION 380 OR 190 or 91 You work as a Database Administrator for your company. The company uses Oracle as its database. The manager of the company wants you to move the company's databases. to another server, as the performance of the old server is now degraded. Which of the following RMAN commands will you use to accomplish the task? A - DUPLICATE 374 You are managing an ASM instance. You previously issued the following statements: ALTER DISKGROUP dg1 DROP DISK disk2; ALTER DISKGROUP dg1 DROP DISK disk3; ALTER DISKGROUP dg1 DROP DISK disk5; You want to cancel the disk drops that are pending for DGI disk group. Which statement should you issue? C. ALTER DISKGROUP dg1 UNDROP DISKS; QUESTION 367 You are planning to transport the TBS1 tablespace from one database to another. The TBS1 tablespace is a read/write tablespace, and it is currently online. You issue the following query on both the source and target databases: SELECT d.platform_name, t.endian_format FROM v$database d, v$trasportable_platform t WHERE d.platform_id=t.platform_id; In reviewing the results, you determine that the target database has a different platform than the source database, but both platforms have the same endian format. Which step would NOT be necessary for you to succesfully transport the TBS1 tablespace to the target database?. D- converting the datafiles using the RMAN CONVERT command. QUESTION 44 Which of the following cannot be used as input to the SQL Tuning Advisor? (Choose all that apply.) A - A single SQL statement provided by a user B - An existing SQL Tuning Set (STS) C - A preprocessed Database Replay workload D - A schema name A. SQL statement identified in EM as using excessive resources Correct C,D QUESTION 114 Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement? A - The SGA Tuning Advisor B - The SQL Access Advisor C - The SQL Tuning Advisor D - The Memory Advisor Correct: B QUESTION 229 Which of the following keywords is used to shut down a database while migrating it to ASM? -2-



D - TRANSACTIONAL

QUESTION 275 Which of the following dynamic performance views can be queried to know whether the database is in ARCHIVELOG mode or NOARCHIVELOG mode? A - V$CONTROLFILE B - V$INSTANCE C - V$DATABASE D - V$LOG C - V$THREAD F - V$COTROLFILE_RECORD_SECTION Correct: C QUESTION 51 You want to perform some maintenance on your ASM disk groups. As a result, you want to prevent RDBMS instances from connecting to the ASM instance, but you do not want to shut down the ASM intance What command will achive this objective? A - ALTER SYSTEM ENABLE RESTRICTED SESSION QUESTION 328 Which of the following statements about conventional tablespaces (non-logically nanaged tablespaces) are true? Each correct answer represents a part of the solution. Choose two. A - In case of conventional tablespaces, Oracle reflects the allocation of a new exent by updating th associated segment header and the data dictionary table. B - Conventional tablespace use data dictionary tables for storage space management. Correct: A, B QUESTION 300 Which of the following terms is used when a table is restored to a place other than its original place? D - Out-of-place restore QUESTION 355 The advisors in Oracle are used to manage database by providing proper recommendations for the issues that may arise. They also provide detailed analysis of the database and are, therefore, peferred to alerts. Which of the following data repositories can be shared by all Oracle advisors? B - The Automatic Workload Repository(AWR) Correct: B QUESTION 241 Which of the following types of file defines the maximun size limit of the structures in the System Global Area? D - Initialization parameter files

QUESTION 324 A database stores objects and data in logical storage units call __________. B. Tablespaces

-3-



QUESTION 375 You set the undo pool resource plan directive for the consumer group named DSS_USERS that is assigned to the DAY_SHIFT plan. The database users SCOTT and BLAKE belong to the DSS_USERS resource group. The user SCOTT initiates a database session and executes a batch operation that inserts millions of rows into the HISTORY table. Which two options are true if the total undo space allocated to the DSS_USERS group exceeds the value specified in the undo pool resouce plan directive?(Chooose two.) A - The batch operation started by SCOTT terminates with an error. D - BLAKE cannot start a transaction that uses any DML operations until you increase the value of the undo pool resource plan directive QUESTION 219 or 122 Which of the following are the options for the STARTUP command? Each correct answer represents a complete solution. Choose all that apply. A - NOMOUNT B - MOUNT D - FORCE QUESTION 309 What is the default value for an Automatic Workload Repository (AWR)? B - TYPICAL QUESTION 71 You work as a Database Administrator for Veedol Inc. You find that the performance of the production database is at its best on 19th Nov 2006. Which of the following actions will you take, so that you get an appropriate message (notification) whenever the performance of the production database falls by 25%? B. You will create baseline metrics using a snapshot for the performance on 19th Nov 2006. QUESTION 323 The _______ scheme defined to represet characters as a sequence of bits, is known as a character set. D - encoding QUESTION 23 You execute this command. CONFIGURE RETENTION POLICY CLEAR; What is the retention policy set to after running the command? A - Retention is set to the default of REDUNDANCY 1. QUESTION 72 OR 338 Which of the following PL/SQL packages will you use to configure resource plans, resource consumer groups, and resource plan directives in the PROD database? C - A - DBMS_RESOURCE_MANAGER QUESTION 106 RMAN conserves the specified number of backups of control files and data files when the redundancy retention policy of backups is followed. A - True

-4-



QUESTION 283 What does the central recovery catalog known as? D - Base recovery catalog QUESTION 127 Which of the following formats is valid for the NLS_TIMESTAMP_TZ_FORMAT parameter? D - NLS_TIMESTAMP_TZ_FORMAT='YYYY-MM-DD HH.MI.SS.FF. TZH.TZM' QUESTION 238 What is the maximum number of tablespaces with different block sizes does Oracle allow? B - Five QUESTION 202 OR 129 The PGA Advisor is part of which Performance Advisor? A - Memory Advisor QUESTION 264 What is the default value size of the flash recovery area? B - 2048MB QUESTION 242 Which of the following is the valid format of specifying fully qualified ASM? B - +DGRP/dtbs/datafile/tbsp.229.546189327 QUESTION 109 Which of the following clauses is used when RMAN performs an incomplete database recovery prior to the RECOVER command? B - SET UNTIL TIME QUESTION 61 You frequently have multiple RMAN sessions running, and you want to be able to easily identify each job via the CLIENTJNFO column of the dynamic performance view V$SESSION. What RMAN command can you run to set the value for this column? C - set channelid to 'RJB rman session'; QUESTION 320 What does each part of a program chain called? B - Step QUESTION 132 You work as a Database Administrator for Gadgets Inc. The company uses Oracle database. Automatic SQL Tuning is used to analyze SQL and tune database system performance. You find that statistics gathered by SQL analysis are missing or stale. Which of the following statements follows as its consequence in such a situation? Each correct answer represents a complete solution. Choose all that apply. B - The query optimizer will return a recommendation to gather relevant statistics. D - The query optimizer will not generate an accurate execution plan. E - The query optimizer will return additional information in the form of a SQL profile. Question 257 When the OMF(Oracle-Managed Files) feature is used, which of the following initialization parameters specifies the default location where Oracle creates the data files? C - DB_CREATE_FILE_DEST QUESTION 113 Which of the following database modes is valid while configuring a database to enable Flashback Database? -5-



B - ARCHIVELOG QUESTION 287 Which of the following types of failures occurs when an incorrect SQL command or statement is executed? A - Statement failure QUESTION 170 Which of the following options will you choose if you do not want to manage you Oracle files directly? C - Oracle Managed Files QUESTION 36 You are creating a duplicate (auxiliary) database for testing purposes. Which of the following initialization parameter files can you use on the auxiliary database to specify the filenames on the new database? B - LOG_FILE_NAME_CONVERT C - DB_FILE_NAME_CONVERT E - CONTROL_FILES QUESTION 85 You work as a Database Administrator for your company. The company uses an Oracle database. The database is set to run in ARCHIVELOG mode. You use Recovery Manager (RMAN) for backup and recovery operations. You have specified two archive destinations. Disk1 and Disk2, for achival of redo logs. You want to backup the archived redo logs corresponding to the log sequence numbers 43,44,45, and 46. After starting the backup operation, you find that the archived redo logs corresponding to the log sequence regarding the backup operation is true? C - RMAN will back up all the archived redo logs. QUESTION 223 or 161 Which of the following views should you query to perform a Flashback Transaction Query? B - FLASHBACK_TRANSACTION_QUERY QUESTION 274 The files in the Flash Recovery Area that are deleted after getting obsolete are called ___. B - Transient files QUESTION 175 You work as a Database Administrator for Dolliver Inc. The company uses Oracle as its database. You want to create a window that activates the DAY_PLAN resource plan and uses schedule named WORK_HOURS_SCHEDULE. Which of the following PL/SQL procedures will you run to accomplish the task? B - BEGIN DBMS_SCHEDULER.CREATE_WINDOW( window_name=> 'WORK_HOURS_WINDOW', resource_plan=>'DAY_PLAN', schedule_name=>'WORK_HOURS_SCHEDULE', duration=>INTERVAL '10' HOUR, window_priority =>'HIGH'); END; / ) QUESTION 1 You are not sure if Flashback Database is enabled. -6-



What database column and view can you query to see if the flashback logs are being created in the flash recovery area? D - Query the FLASHBACK_ON COLUM in V$DATABASE QUESTION 354 You work as a Database Administrator for Bell Ceramics Inc. You have created a job by using the PL/SQL block give below. BEGIN_DBMS_SCHEDULER.CREATE_JOB(job_name=>'update_sales'job_type=> "STORED_PROCEDURE", job_action=>'COMPANY.SALES_PKG.UPDATE_SALES_SUMMARY', job_class=>'batch_update_jobs', );END; / However, after creating the job, you notice that the job is not executing. You have associated the update_sales job with the batch_update_jobs job class using execute privilegesfor the class. Which of the following statermens explain the correct reason for the non-execution of the created job? B - The job has not been enabled. QUESTION 88 or 174 Which of the following helps the DBA to manage the tablespace as a single unit without taking into account the structure and size of the underlying datafiles? D - Bigfile tablespace QUESTION 164 You work as a Database Administrator for Dolliver Inc. The company uses Oracle database. You want to list all the roles and users who have been granted the ADMINISTER_RESOURCE_MANAGER privilege. Which of the following statements will you use to accomplish this? D - SELECT GRANTEE FROM DBA_RSRC_MANAGER_SYSTEM _PRIVS WHERE PRIVILEGE = 'ADMINISTER_RESOURCE_MANAGER'; QUESTION 307 What is the default duration for an Automatic Workload Repository (AWR)? A - 7 days QUESTION 35 Which of the following segment types can you shrink using Oracle's segment shrink functionality? (Choose all that apply.) B - Index segments D - Data segments QUESTION 273 The Flash Recovery Area contains multiplexed redo logs files and control files. What do these files collectively known as? A - Permanent files QUESTION 8 You want to leverage resource consumer groups when using the Scheduler. Which Scheduler object uses resource plans directly? B - A job class QUESTION 10 Which of the following methods can you use to enable duplexed RMAN backups? (Choose two answers.) -7-



B - Use the BACKUP COPIES option in the RMAN CONFIGURE command. D - Use the COPIES option in the RMAN BACKUP command. QUESTION 351 Which of the following statements about a segment is true? D - An index segment holds all the data of a non-partitioned index. QUESTION 188 or 83 Which package provides API's for the SQL Tuning Advisor? A - DBMS_SQLTUNE QUESTION 18 Which of the following two parameters must you specify to use a flash recovery area for all of your backups? (Choose two answers.) A - DB_RECOVERY_FILE_DEST_SIZE C - DB_RECOVERY_FILE_DEST QUESTION 32 Which two dynamic performance views can you use to identify files that need to be backep up, regardless of whether you are in ARCHIVELOG mode or NOARCHIVELOG mode? D - V$DATAFILE and V$CONTROLFILE QUESTION 194 or 136 You work as a Database Administrator for Dolliver Inc. The company uses Oracle as its database. The database has a table named Employee. One of the database users has made inappropriate updates. Which of the following facilities will you prefer to rectify the mistake (choose the best answer)? C - D - Flashback Query QUESTION 123 You create several AWR snampshots for Monday morning from 9 A.M. to 11 A.M. using the package DBMS_WORKLOAD_REPOSITORY so that you can compare the performance of the database before upgrading the server hardware. Which of the following terms is used for this type of snapshot? C - A baseline QUESTION 318 Which of the following is the dafault value of JOB_STYLE attribute of USER_SCHEDULER_JOBS table? B - Regular QUESTION 293 Which of the following will you use to improve the performance of incremental backups? B - Enable block change tracking. QUESTION 53 You have a very large table table that your users access frequently Which of the following advisors will recommend any indexes to improve the performance of queries against this table? D - The SQL Access Advisor QUESTION 236 The record log records are written to the redo log files either every three seconds or -8-



after the redo log buffer is ______ filled. B - one-third QUESTION 225 What is the maximum size of the comma-separated list of values that can be given in the ASM_DISKGROUP initialization parameter? D - 30 character QUESTION 58 Which of the following archived log file configurations is the most ideal configuration per Oracle's recommendation? D - Use a flash recovery area mirrored on an ASM disk group only. QUESTION 9 You need to recover the database after a disk is lost but you are missing two archived redo log files. You need to run the RMAN RECOVERY DATABASE UNTIL command. In what database state can you perform this recovery? B - MOUNT QUESTION 269 or 205 Which of the following data dictionary views contain information about the Database Resource Manager? Each correct answer represents a complete solution. Choose two. C - C - DBA_RSRC_CONSUMER_GROUPS D - A -DBA_RSRC_CONSUMER_GROUPS_PRIVS QUESTION 246 Which of the following is the range of the memory footprint of an ASM instance? C - 60 MB to 120 MB QUESTION 383 OR 119 OR 94 Brenda works as a Database Administrator for your company. The company uses an Oracle database. Brenda wants to specify a number of locations to which the redo logs should be archived before an error occurs. Which of the following initialization parameters will she use to accomplish this? D - LOG_ARCHIVE_MIN_SUCCEED_DEST QUESTION 290 Which of the following can be a reason for statement failures? C-Failure of a single database operation QUESTION 325 The PGA Advisor is part of which Performance Advisor? C-Memory Advisor QUESTION 265 Which of the following facilities designed for bulk operations can read data without inserting it into a database? C - External tables QUESTION 97 or 216 only A or 327 Which of the following statements about a recovery catalog are true? Each correct answer represents a complete solution. Choose two? A - A recovery catalog should not be created in the target database. B - The information in the recovery catalog is obtained from the target datbase's control file. -9-



QUESTION 41 You drop the table ORDERJTEM, and because you have the RECYCLEBIN initialization parameter set to ON, the table and its indexes are moved to the recycle bin. Which of the following are valid names for these two objects in the recycle bin? B - BIN$QR9ZZ=49X2Z$0BIN$QR8ZZ=W9X2Z$0 QUESTION 147 Which of the following is true about Resource Plan Directives? C - These are used by administrators to associate resource consumer groups with particular plans an allocate resources among resource consumer groups. QUESTION 37 Which of the following DML operations use a significant portion of the PGA?(Choose all that apply.) A - Hash joins B - Buffers for bulk load operations D - Bitmap merges E - Bitmap create QUESTION 66 Which of the following clauses are valid for the FLASHBACK TABLE command? (Choose all that apply.) C - TO TIMESTAMP D - TO BEFORE DROP QUESTION 29 Identify the advantage of recovery an image copy of a datafile during RMAN backup.(Choose all that apply.) A - During media recovery, fewer incremental updates need to be applied to the last image copy. C - You do not need to perform additional image copy backups. QUESTION 230 Mirrored copies of data are place in the _________. A - Failure group QUESTION 298 Which of the following commands is used to manually remove the objects from the recycle bin? D - PURGE QUESTION 365 Which of the following statements about space management of the flash recovery area are true? (Choose three.) A - A warning alert is automatically generated when the flash recovery area is 85% full B - A critical alert is automatically generated when the flash recovery area is 97% full. D - Oracle automatically deletes transient files from the flash recovery area when additional space is needed. QUESTION 321 Which of the following parameters governs the case-sensitive sorts? A - NLS_SORT_CI QUESTION 341 Which of the following views is used to retrieve information for all the scheduler windows -10-



in a database? A - DBA_SCHEDULER_WINDOWS QUESTION 2 What dynamic performance view can you query to list the supported platforms for transportable tablepaces? A - V$TRANSPORTABLE_PLATFORM QUESTION 25 Identify the correct relationships between resource consumer groups, resource plan directives, and resource plans. (Choose all that apply.) A - Only one resource plan can be active at a time. C - One resource plan can have multiple plan directives. QUESTION 224 or 330 or 180 Which of the following files by default are stored in the Flash Recovery Area? Each correct answer represents a complete solution. Choose two. A - RMAN image copies B - D - RMAN backups sets QUESTION 357 Which of the following statements are true about a server parameter file (SPFILE)? Each correct answers represents a complete solution. Choose all that apply. A - It is created from a text initialization parameter file by using the CREATE SPFILE statement. B - It is a binary file. C - It is maintained on the computer where the Oracle server is running. F - It can be backep up by RMAN. QUESTION 135 Which of the following tasks can you accomplish with the Support Workbench? Each correct answer represents a complete solution. Choose all that apply. A - Package diagnostic information send to Oracle support. B - View problem details C - Create a service request QUESTION 227 The SHARED_POOL_SIZE initialization parameter can be resized until the total size of SQA is less than _______. C - SGA_TARGET QUESTION 116 Which of the following is not a valid setting for LOGGING_LEVEL Job Class parameter? B - DBMS_SCHEDULAR_LOGGING_ON QUESTION 14 To enable remote connectios to the database using the password file, what values should REMOTE_LOGIN_PASSWORDFILE have? (Choose all that apply.) B - SHARED C - EXCLUSIVE QUESTION 255 The mirroring levels with which Oracle creates files in a disk group is determined by which of the following? A - Disk group type -11-



QUESTION 78 or 218 Which of the following represents the most elementary unit of storage in an Oracle table? D - Block QUESTION 52 You can use the EM Support Workbench for which of the following tasks? (Choose all the correct answers.) B - Manually run a health check C - Close problems and incidents D - Generate additional SQL test cases to help Oracle Support solve the problem. E - View problems and incidents. QUESTION 130 or 342 Which of the following statements about an incomplete recovery are true? Each correct answer represents a complete solution. Choose all that apply. A - D - An incomplete recovery is performed when the requirement is to recover a database up to a specified time. B - A - An incomplete recovery is required when ont of the archived redo log files required for the complete recovery is missing. C - C - An incomplete recovery is performed when the requierement is to recover a database up to a specified system change number(SCN). QUESTION 76 The Automatic Database Diagnostic Monitor(ADDM) stores its snapshots in the Automatic Workload Repository(AWR). In which of the following tablespaces the Automatic Workload Repository resides? C - SYSAUX QUESTION 369 After configuring the database in which you will store you recovery catalog, you create the catalog owner and grant the owner the RECOVERY_CATALOG_OWNER role. Which two actions should you take? (Choose two.) B - Connect to the recovery catalog database as the recovery catalog owner D - Issue the CREATE CATALOG, command QUESTION 181 Which of the following options can be limited using the Database Resource Manager (DRM) for a specific set of users? Each correct answer represents a complete solution. Choose three. A - Maximum active concurrent sessions within a group B - Maximum execution time allowed for an operation D - Maximum degree of parallelism for an operation QUESTION 121 Which of the following statements about a data segment are true? Each correct answer represents a complete solution. Choose two. C - A data segment can belong to only one tablespace. D - A data segment can hold all the data of a non-partitioned table. QUESTION 115 Which of the following parameters is used to enable resumable for an instance? B - RESUMABLE_TIMEOUT -12-



QUESTION 220 Which of the following is true about Resource Plan Directives? A - These are used by administrators to associate resource consumer groups with particular plans an allocate resources among resource consumer groups. QUESTION 268 Which of the following is responsible for storing backups of Archived logs in the flash recovery area? C - RMAN QUESTION 156 You want to use the custom packagig feature from the EM support Workbench. Which of the following tasks can you accomplish with this feature? Each correct answer represents a complete solution. Choose all that apply. B - Add external files such as log files or SQL scripts. C - Remove sensitive information from the package. QUESTION 141 Which of the following views is used to retrieve information for all the scheduler windows in the database? A - DBA_SCHEDULER_WINDOWS QUESTION 158 OR 211 Which of the following data dictionary views should you query to check if a database is running in ARCHIVELOG or NOARCHIVELOG mode? A - V$DATABASE QUESTION 343 Which of the following statements about a data segment are true? Each correct answer represents a complete solution. Choose two. A - A data segment can hold all the data of a non-partitioned table. C - A data segment can belong to only one tablespace. QUESTION 370 You want to use the Flashback Query feature to query data as of specified point in time using the AS OF clause SELECT statement? A - You must use automatic undo management in the database QUESTION 358 Which of the following is NOT a component of an Oracle database block? A - Block segment QUESTION 364 Which of the following NLS parameters affects linguistic searches directly? D - NLS_SORT QUESTION 292 Which of the following statements is used to create and enable block change tracking? D - ALTER DATABASE ENABLE BLOCK CHANGE TRACKING; QUESTION 56 or 3 -13-



You issue the following command to enable block change tracking. SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING; However, you receive an error message, and the tracking file is not created. What is a possible reason for the error message? D - The parameter DB_CREATE_FILE_DEST is not set. QUESTION 232 Automatic Storage Management is a ________. C - Database service QUESTION 261 Which of the following is the valid range for setting the size of ASM Allocation Units? B - 1MB to 64MB QUESTION 352 The ASM filenames can be specified in six different formats. One of the formats of specifying the ASM filenames is as follows. +diskgroup/directory_name/file_name Which of the following types of ASM filesnames is given in the above specified format? B- Alias ASM Filename QUESTION 77 Within a locally managed tablespace, you can have these two types of extent management. Each correct answer represents a complete solution. Choose two. B - Automatic D - Uniform QUESTION 372 Which task does the RBAL process perform? A - coordinates rebalancing activity for disk groups QUESTION 172 or 336 By default, database stores statistics from the ____ and stores them in the ____ as snapshots. The tables are stored in the ________ tablespace under the _______ schema. B - D - SGA, AWR, SYSAUX, SYSMAN QUESTION 34 You lose all of the datafiles in your TEMP tablespace after the database shuts down. When the database starts again, what happens? C - The tempfile is re-created at the original location, a message is written to the alert log, and the database starts normally. QUESTION 4 You are restoring and recovering a database to a new host. What data dictionary view will you use to identify the names of the datafiles on the new database? C - V$DATAFILE QUESTION 244 Which of the following ASM filename format includes the specification of the file type? D - Fully qualified names QUESTION 16 Setting which of the following initialization parameters enables Automatic Memory Management? A - MEMORYJARGET

-14-



QUESTION 67 To recover from the loss of the entire database, including all current control files, all online redo log files, and all parameter files, what backups are required, at a minimum, to restore the database succesfully? (Choose all that apply.) A - Archived redo logs generated after the last datafile backups B - One autobackup of the control file D - A backup of all datafiles i E The password file QUESTION 381 or 186 or 326 or 92 Martha is an employee in Tech-Mart Inc. The company uses an Oracle database. The database contains a table Employees for storing employee records. Martha is performing an insert operation on the Employees table. After some time, the insert operation fails. Which of the following types of failures has occurred? C - A - Statement failure QUESTION 128 You work as a Database Administrator for Dolliver Inc. The company uses Oracle 10g database. You have created two windows named REQUIRED_HOURS_WINDOW and DONE_HOURS_WINDOW While opening the DONE_HOURS_WINDOW manually, you find that the other window REQUIRED_HOURS_WINDOW) is overlapping. Which of the following parameters will you use to resolve the overlapping conflict? D - FORCE QUESTION 166 or 346 or 213 or 62 Whicho of the following statements regarding Automatic Storage Management (ASM) disk groups is true? B - A You can mix ASM disk groups with operation system-based datafiles within the same database. QUESTION 191 OR 81 Which of the following dynamic performance views will you query to view the valid values for NLS parameters NLS_LANGUAGE, NLS_SORT, NLS_TERRITORY and NLS_CHARACTERSET? D - V$NLS_VALID_VALUES QUESTION 377 You want to back up your 100-GB database on a remote tape device. You are required to ensure that minimum network bandwidth is consumed while transferring the backups to the tape device. The current consumption of your CPLU is approximately 40 percent. Which type of backup should you perform? C - compressed backup QUESTION 168 Which of the following statements about an extent are true? Each correct answer represents a complete solution. Choose two. A - New extents are allocated to a segment when all the extents allocated to the segment are full. C - An extent is a logical collection of contiguous data blocks.

QUESTION 110 What does the new instance called during the copy operation when a duplicate database is created? C - Auxiliary instance -15-



QUESTION 280 Which of the following statements is true about Data Pump? A - It uses background processes only. QUESTION 361 Oracle uses its own character set instead of that supplied by the host operating system. B - True QUESTION 112 Which of the following statements about Flashback technologies is true? B - They are designed for user error or logical corruption. QUESTION 57 You define you national character set as AL16UTF16. What datatypes will store Unicode data? A - NVARCHAR2 C - NCLOB F - NCHAR QUESTION 182 You work as a Database Administrator for uCertify Inc. The company uses Oracle database. You are required to perform a user-managed media recovery, as a media failure has damaged some data files. You find that one of the archived redo log files required for the complete recovery is corrupt. Therefore, you decide to perform an incomplete recovery. What will you do to accomplish this? A - Restore the whole database backup and perform a cancel-based recovery. QUESTION 48 You lose all control file copies and your datafiles are intact, but your online log files are unavailable. How do you recover the database in this situation? A - Re-create the control file and open the database with RESETLOGS. QUESTION 157 Catherine works as a Database Administrator for Dolliver Inc. The company uses an Oracle database. Catherine wants to create a locally managed tablespace named Sample. She executes the following statement to accomplish this. CREATE TABLESPACE Sample DATAFILE C./Oracle/Oradata/Datafiles/Sample01.dbf SIZE 20M AUTOEXTEND ON NEXT 10M MAXSIZE 200M DEFAULT STORAGE (INITIAL 40K NEXT 40K PCTINCREASE 0 MINEXTENTS 2 MAXEXTENTS 50) MINIMUM EXTENT 40K EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO; What will happen when the statement is executed? C - It will return an error because the DEFAULT STORAGE and the MINIMUM EXTENT clauses cannot be specified when creating a locally managed tablespace. QUESTION 86 Your RMAN configuration has the backup optimization set to ON. Which of the following commands will this setting affect? Each correct answer represents a complete solution. Choose all that apply. A - BACKUP ARCHIVELOG with ALL or LIKE options B - BACKUP BACKUPSET ALL D - BACKUP DATABASE

-16-



QUESTION 173 Consider the following configuration of an ASM disk group. /devices/da1 -member of dgrp1 /devices/da2 -member of dgrp1 /devices/da3 -member of dgrp1 /devices/da4 -member of dgrp1 /devices/db1 -member of dgrp2 /devices/db2 -member of dgrp2 /devices/db3 -member of dgrp2 You want to add a new disk /devices/db4 to the disk group dgrp2. Which of the following statements should you issue to accomplish the task? D - ALTER DISKGROUP dgrp2 ADD DISK '/devices/db4' NAME db4; QUESTION 11 Which of the following tablespces can be recovered while the database is online? (Choose all that apply.) A - USERS C - SYSAUX E - EXAMPLE QUESTION 239 Which of the following statements is used to create disk groups? C - CREATE DISKGROUP QUESTION 240 Which of the following background processes uses the Least Recently Used (LRU) algorithm? C - DBWn QUESTION 267 Which of the following commands is used to manually clear reclaimable space of the Flash Recovery Area? B - DELETE OBSOLETE QUESTION 84 or 165 Which of the following file types are by default stored in the flash recovery area, if the files have been defined? Each correct answer represents a complete solution. Choose all that apply. A - Archive redo log files B - Database flashback logs D - Recovery Manager backups QUESTION 192 You work as a Database Administrator for uCertify Inc. The company uses Oracle database. You want to perform a Flashback Transaction Query to help identify the changes at the transaction level. Which of the following privileges do you need in order to perform the task? B - The system privilege QUESTION 103 Which of the following statements about Automatic Storage Management are true? Each correct answer represents a complete solution. Choose all that apply. A - It is designed to reales the burden of disk and storage management. B - It is a simple storage management interface available to the Database Administrator. C - It provides a various tools that can save the time of the Database Administrator.

-17-



QUESTION 73 Many RMAN settings help in automation or simplification using RMAN. Where are these settings stored? Each correct answer represents a complete solution. Choose all that apply. C - Target database control file D - Recovery catalog QUESTION 89 You are creating an incident package to send to Oracle support as follows. What kind of packaging are you using? C - Quick packaging QUESTION 297 Which of the following actions can save time to get the information from the Flashback Transaction Query? A - Adding RETENTION GUARANTEE to the UNDO tablespace. QUESTION 74 Which of the following values of the STATISTICS_LEVEL initialization parameter should be set to include plan execution statistics in the AWR? D - ALL QUESTION 124 A user has mistakenly dropped two tables in the PROD database instead of DEV. You have Flashback enabled on PROD database. Which Flashback Recovery feature will you use to recovery from the above problem? B - Oracle Flashback Drop QUESTION 334 Which of the following is true about Resource Plan Directives? A - These are used by administrators to associate resource consumer groups with particular plans an allocate resources among resource consumer groups QUESTION 152 You work as a Database Administrator for uCertify Inc. The company uses an Oracle 10g database. There are tables named T1 and T2 that are dropped at a particular time. You have performed a Flashback Drop for both tables. Now, you want to crosscheck whether or not the Flashback Drop has been succesful. Which of the following actions will you perform to accomplish the task? Each correct answer represents a complete solution. Choose two. A - Fire a query against the RECYCLEBIN view. D - Run the SHOW RECYCLEBIN command. QUESTION 363 Identify whether the given statement is true or false. "NLS parameters that are set by using a SQL function override the NLS parameters that are set any other way." A - True QUESTION 28 You are using a recovery catalog and you lose all copies of your control file. Which of the following sets commands will you use to restorre the control file before you recover the database? D - RESTORE CONTROLFILE

-18-



QUESTION 207 Many RMAN settings help in automation or simplification using RMAN. Where are these settings stored? Each correct answer represents a comlete solution. Choose all that apply. B - Target database control file D - Recovery catalog QUESTION 345 or 70 You work as a Database Administrator for Veedol Inc. Your manager wants you to run a job that updates the transaction table every 30 minutes. To schedule the job, you have to set the value of the interval element. Which of the following settings for the repeat_interval argument will achive the desired objective. Each correct answer represents a complete solution. Choose two. D - A - 'freq = hourly;interval=1/2' E - D - 'freq = minutely;interval=30' QUESTION 301 Which of the following options will disable AWR? A - BASIC QUESTION 198 or 350 You work as Database Administrator for Garrison Inc. The company uses Oracle as its database. There are some SQL statements that are inefficiently written for databases of the production enviroment. The manager of the company wants you to use SQL Tuning Advisor to generate recommendations for the same. Which of the following sources can you identify that the advisor uses to analyze SQL statements? B - A - SQL Tuning Sets QUESTION 204 or 185 or 82 You work as a Database Administrator for uCertify Inc. The company uses an Oracle database named OraBase. You use Recovery Manager (RMAN) for backup and recovery operations. You want to create a recovery catalog to store metadata about the backup and recovery operations. You create a database named CatalogBase in which you will store the revovery catalog. You also create a database user account named CatOwner in the CatalogBase database, which will hold the tables and views constituting the recovery catalog. What else will you need to do in order to create the recovery catalog? Each correct answer represents a part of the solution. Choose all that apply. A - D Execute the CREATE CATALOG command. B - B Connect to the CatalogBase database by using the CatOwner user account. D - A Grant the RECOVERY_CATALOG_OWNER pre-defined role to the CatOwner user account. QUESTION 339 In the DBA_SCHEDULER_JOBS view you notice that a PROD job has the status BROKEN, what does this mean? D - The job has exceeded a certain number of failures. QUESTION 100 Which of the following types of failures is the cause of automatic Instance Recovery? B - Instance failure QUESTION 263 Which of the following database files is considered as a permanent file in the flash recovery area? A - Control files -19-



QUESTION 235 Oracle Managed Files (OMF) eases the administration to files. Which of the following is true about this feature in Oracle 10g? D - OMF specifies the operations in terms of tablespaces QUESTION 143 OR 344 Observe the structure of the table employees. DESC employees Name Null? Type __________ _________ _________ emp_no NOT NULL VARCHAR(5) PRIMARY KEY emp_fname NOT NULL VARCHAR(15) emp_lname NOT NULL VARCHAR(15) emp_dob NOT NULL DATE emp_dtofjoin NOT NULL DATE emp_salary NUMBER(5,2) The table contains 8475 records. One of the employees wants to know the names of all employees of the company. For this, hefires the following query. SELECT * FROM EMPLOYEES ORDER BY emp_fname; Since the operation performed on executing the query cannot fit into memory, it requieres disk space to complete the operation. Which of the following types of segments will Oracle allocate to complete the operation and to provide the required result? A - Temporary segment QUESTION 59 Which of the following database objects are not candidates for RMAN image copies? (Choose all that apply.) B - Online redo log files C - Flashback log files E - Password files QUESTION 120 or 200 You work as a Database Administrator for Gigabytes Inc. The company uses Oracle 11g as its database. You are asked by your manager to conduct a training session for new recruitments. You quetioned the batch about Automatic Work Repository (AWR). Which of the following statements will you consider as correct for AWR? Each correct answer represents a complete solution. Choose two. B - A - Data dictionary views can be used to access the snapshots collected by AWR. D - D - All AWR tables are stored in the SYSAUX tablespace. QUESTION 199 Following the principle of least privilege, which of the following roles should be granted to the accounts only that need it? Each correct answer represents a complete solution. Choose all that apply. C - SYSASM D - SYSDBA E - SYSOPER QUESTION 382 or 93 -20-



Which of the following advisors within the Oracle advisory framework will analyze a single SQL statement and make recommendations for performance improvement? D - SQL Tuning Advisor QUESTION 101 or 215 Which of the following advisors is run in every maintenance window by the auto-task system? D - A - The SQL Access Advisor QUESTION 340 or 151 Which data dictionary views will display information about the current user's recycle bin? Each correct answer represents a complete solution. Choose all that apply. A - RECYCLEBIN C - USER_RECYCLEBIN QUESTION 22 Fill in the blanks to make the following statement true. You use commmand so that the view contains the specified name associated with the session in the column. B - ALTER SESSION ENABLE RESUMABLE TIMEOUT ... NAME 'statement description', DBA_RESUMABLE, NAME QUESTION 43 Which of the following can be a performance bottleneck in RMAN? (Choose all that apply. A - Reading data B - Writing data D - Validating blocks QUESTION 359 What is the default value of the NLS_SORT parameter? B - Binary QUESTION 142 You work as a Database Administrator for uCertif Inc. The company uses Oracle database to retain its data. You need to determine the territories that are supported by the database. Which of the following queries will you execute to accomplish the task? B - SELECT * FROM V$NLS_VALID_VALUES WHERE PARAMETER='TERRITORY'; QUESTION 278 What is the default value of the LOG_ARCHIVE_MIN_SUCCEED_DEST parameter? D - 1 QUESTION 159 or 335 What are the file types that must be present in a database? A - Datafiles B - Online Redo Log Files C - Control File QUESTION 146 or 196 Which of the following statements about logical storage structures of an Oracle database are true? Each correct answer represents a complete solution. Choose all that apply. B - C - A segment consists of at least one extent D - B - Extents allocated to a segment can belogn to multiple data files. E - A - Data blocks of an extent cannot belong to multiple data files. QUESTION 131 Which of the following is built in repository in every Oracle Database that stores vital -21-



statistics taken at regular intervals? A - Automatic Workload Repository (AWR) QUESTION 234 The datafiles are divided into _______ by the Automatic Storage Management. A - Extents QUESTION 153 or 201 You work as a Database Administrator for Bell Ceramics Inc. The company uses Oracle as its database. You notice that the performance of a database named Salary has degraded over a period of time from the month of January to August. You investigate and find that there is a lack of indexes in the database. Which of the following advisory components will you use to analyze the issue? A - SQL Access Advisor QUESTION 19 Your database is not using an RMAN recovery catalog. Which of the following commands are not available to you in this scenario? (Choose all that apply.) B - BACKUP ... KEEP FOREVER D - REPORT SCHEMA ... AT QUESTION 337 OR 348 Which of the following are the characteristics of locally managed tablespaces? Each correct answer represents a complete solution. Choose all that apply. B - A bitmap is used to record free extents D - Oracle recommends locally managed tablespaces for all new tablespaces. F - Free extents are managed within the tablespace. QUESTION 176 OR 212 Which of the following statements is true regarding initialization parameter files? B - SPFILE is not editable in text form, the init.ora file is editable in text form, and SPFILE is the preferred type of the initialization parameter file. QUESTION 303 Which of the following tablespaces needs additional space if the AWR statistics collection interval is very short? D - SYSAUX QUESTION 105 OR 222 You work as Database Administrator for Blue-Well Inc. The company uses an Oracle database. The database contains a resource consumer group named QUERY_USERS. You want to specify the maximum number of active sessions allowed in the QUERY_USERS resource consumer group as twenty. Which of the following Database Resource Manager parameters will you use to accomplish this? C - ACTIVE_SESS_POOL_P1 QUESTION 329 or 145 You work as a Database Administrator for Bell Ceramics Inc. The company uses Oracle database. You create a window (a scheduler object) to change the active resource plan based on defined schedules. There are many parameters, such as WINDOW_NAME, RESOURCE_PLAN, etc., which can be used while creating a window. You set the REPEAT_INTERVAL parameter to NULL Which of the following statements is true in such a scenario? A - The window will open only once at the specified start date. QUESTION 295 -22-



What does TSPITR stand for? A - Tablespace Point-In-Time Recovery QUESTION 17 You configure AUTOBACKUP to ON in an RMAN session. When will RMAN back up the control file? (Choose all that apply.) A - When you run an RMAN BACKUP command QUESTION 90 or 134 You work as Database Administrator for your company. The company uses an Oracle database to retain its data. You have started RMAN job. The job uses more than two channels, each having a name. You are required to find out the names of all channels being used by that job The V$SESSION dynamic performance view contains the details of every current session. Which of the following columns of the V$SESSION dynamic performance view will you enquire to find out the names of the channels? B - D - CLIENT_INFO QUESTION 217 The ASM filenames can be specified in six different formats. One of the formats of specifying the ASM filenames is as follows. +diskgroup/directory_name/file_name Which of the following types of ASM filename is given in the above specified format? C - Incomplete ASM Filename QUESTION 228 Which of the following symbols is used as a prefix fo an ASM instance name? C - + QUESTION 148 Which of the following can be considered as a type of segment? Each correct answer represents a complete solution. Choose two A - Data dictionary C - Table QUESTION 49 You need to determine the proper target time for TSPITR. What methods can you use to determine the correct target time? (Choose all that apply.) B - Flashback Version Query C - Flashback Transaction Query D - Flashback Query QUESTION 40 As the DBA, you run this command on the recovery catalog database. SQL> GRANT RECOVERY_CATALOG_OWNER TO KMSHELT; what privileges do the user KMSHELT have? D - KMSHELT can potentially own a VPC but will not be able to unless the DBA grants other privileges first. QUESTION 291 Which of the following will be lauched for each data pump job that is running? D - DWnn QUESTION 111 Which of the following pairs of the dynamic performance views can be used to determine which user generated a particular user trace file? A - V$SESSION, V$PROCESS QUESTION 54 Which of the following are valid reasons for using a duplicate database? (Choose all that -23-



apply.) A - You want to test a new application's performance with no impact to the production database. C - You want to test an upgrade form Oracle Database 11 g R1 to Oracle Database 11 g R2. D - You want to test backup and recovery procedures. QUESTION 356 Which of the following are the valid modes in which an ASM instance can be shutdown? Each correct answer represents a complete solution. Choose all that apply. A - NORMAL B - ABORT C - TRANSACTIONAL D - IMMEDIATE QUESTION 371 The code that executes several transactions is shown in the exhibit. (Click the Exhibit(s) button.) You want to back out all three transactions. Which backout option should you specify when calling the TRANSACTION_BACKOUT procedure? A - CASCADE QUESTION 277 RMAN conserves the specified number of backups of control files and data files when the redundancy retention policy of backup is followed. If the number of copies exceeds the defined limit then they are market as A - OBSOLETE QUESTION 24 You lose an entire redo log group that is in the CURRENT state. What happens to the database instance and how can you recover from the lost redo log group? D - The instance will shut down or crash and you will have to perform cancel-based recovery. QUESTION 104 You work as a Database Administrator for Bell Ceramics Inc. The Manager of the company asks you to run a job at some specified point in time, say at 5.00 PM every day. Which of the following stored database objects will you use to accomplish the task? C - Schedule QUESTION 243 Identify whether the given statement is true or false. "There is no OPEN operation for an ASM instance." B - True QUESTION 80 or 140 You work as a Database Administrator for Federal Inc. The company uses an Oracle database. You create backups and copies by using the operating system commands. Now, you want to use Recovery Manager (RMAN) for backup and recovery operations. Moreover, you want to use a recovery catalog as the RMAN repository. Which of the following steps will you take to accomplish this? Each correct answer represents a part of the solution. Choose all that apply. A - B- Execute the CATALOG command. C - C - Register the database with the recovery catalog. D - D - Create a recovery catalog. QUESTION 108 Which of the following RMAN commands performs a recovery process by applying incremental -24-



backups and archived redo logs to a restored backup? D - RECOVER

QUESTION 349 You work as a Database Administrator for uCertify Inc. You want to schedule and manage the jobs in a database. Which of the following packages will you use to accomplish this task? D - The DBMS_SCHEDULER package QUESTION 313 To which of the following commands can a SQL profile not be applied? C - DROP QUESTION 209 Whicho of the following are NOT considered as segments in an Oracle database? Each correct answer represents a complete solution. Choose all that apply. A - Sequence C - Trigger QUESTION 331 or 75 You work as a Database Administrator for Gentech Inc. The company uses Oracle database. You are required to grant the ADMINISTER_ROSOURCE_MANAGER privilege to some users to allow them to manage the resource consumer groups. What will you do to accomplish this? B - A Use the DBMS_RESOURCE_MANAGER_PRIVS package. QUESTION 311 Which of the following is not a step of Database Replay? C - Workload play QUESTION 305 Which component of the Oracle architecture stores the statistical information gathered by Memory Monitor (MMON) from various sources? D - AWR QUESTION 276 Which of the following parameters specifies at the most ten archiving destinations? C - LOG_ARCHIVE_DEST_n QUESTION 87 and 96 Which of the following determines the location of the Automatic Diagnostic Repository (ADR)? D - DIAGNOSTIC_DEST instance parameter QUESTION 184 You work as a Database Administrator for Dolliver Inc. The database of the company uses the US7ASCII character set. The database is getting global and is, therefore, required to support multiple languages. The character set for the database is insufficient to support multiple languages. Now, you want to switch over to another character set for the database. Which of the following actions will achieve this objective? Each correct answer represents a complete solution. Choose two. B - Issuing the ALTER DATABASE NATIONAL CHARACTER SET command to change the character set for the database. D - Issuing the ALTER DATABASE CHARACTER SET command to change the character set for the database. QUESTION 284 -25-



Which of the following types of failures is a media failure? A - Crashed hard disk QUESTION 98 Which of the following Dynamic Performance views contain information relevant to SQL Tuning? Each correct answer represents a part of the solution. Choose all that apply. A - V$SQLSTATS B - V$SQLAREA C - V$SQL_BIND_DATA D - V$SQL All the above are correct QUESTION 306 Which of the following tablespaces does the Automatic Workload Repository (AWR) use to store the collected statistics? C - SYSAUX QUESTION 126 Which of the following clauses will set the default sort method for the NLS_SORT parameter? A - WHERE QUESTION 99 You work as a Database Administrator for Gentech Inc. The company uses an Oracle database. You use Recovery Manager (RMAN) for backup and recovery operations. You do not perform a regular backup of the database. You want to implement a backup retention policy for the backups and copies that you create with RMAN. Through the retention policy. you want to ensure that one backup of each data file is retained for at least five days. Which of the following RMAN commands will you use to accomplish this? B - CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 5 DAYS; QUESTION 250 Which of the following files can be managed by an Automatic Storage Management (ASM) instance? C -Data file QUESTION 150 or 214 Which of the following statements about an undo segment are true? Each correct answer represents a complete solution. Choose all that apply. A - It is used to rollback uncommitted transactions during instance recovery. B - It is used to roll back transactions when a ROLLBACK statement is issued. C - It holds all undo data of a database. D - It provides read consistency. QUESTION 233 While specifying the value of the LARGE_POOL_SIZE initialization parameter, you gave the integer value but did not specify the scale as K or M for kilobytes or megabytes. In this scenario, the number will be taken as _______. A - Bytes QUESTION 366 You issued the following statement: ALTER DATABASE BACKUP CONTROFILE TO TRACE; What will be the result of issuing the statement? C - A script containing the CREATE CONTROL FILE statement will be created. QUESTION 376 -26-



Your database is open, and a tempfile in the default temporary tablespace is accidently deleted. Which statement about recovering from the tempfile loss is true? C - You can recover without shutting down the database instance or altering the availability of the temporary tablespace. QUESTION 360 Which of the following NLS parameters is used to govern the language in which the day and months name are displayed using the TO_CHAR and TO_DATE functions? A - NLS_DATE_LANGUAGE QUESTION 281 Which of the following views provides an information about the status of the flash recovery area? B - DBA_OUTSTANDING_ALERTS QUESTION 221 What are the procedure of Each correct A - LOW B - HIGH

or 167 possible values for the window_priority attribute in the CREATE_WINDOW the DBMS_SCHEDULER package? answer represents a part of the solution. Choose two.

QUESTION 30 After you unregister a database from a recovery catalog, what happens to the backup metadata in the recovery catalog? B - The backup metadata is maintained in the control file for a number of days specified by the initialization parameter CONTROL_FILE_RECORD_KEEP_TIME and immediately removed from the recovery catalog QUESTION 27 You are using TISPITR to recover one or more tablespaces to a previous time in point or back to a specific SCN. What included in the recovery set? E - The datafiles from the tablespace to be recovered QUESTION 248 The extra I/O data dictionary requests due to small size of data dictionary cache are known as ________. C - Recursive calls QUESTION 249 The number of disk failures that are tolerated without dismounting the disk group or losing data is controlled by which of the following? B - Redundancy level QUESTION 160 You work as Database Administrator for Dolliver Inc. The company uses Oracle as its database. You want to undo all the modifications done by a particular transaction without affecting the changes made by the rest of the transactions. Which of the following views will you use to accomplish the task? A - FLASHBACK_TRANSACTION_QUERY

-27-



QUESTION 107 "If a channel is not allocated manually, RMAN automatically allocates channels according to the options specified in the CONFIGURE command." A - True QUESTION 333 You work as a Database Administrator for Dolliver Inc. The company uses Oracle as its database. You have two databases on the same computer. You want to transfer/insert bulk data from one database to another, say from DB1 to DB2. Which of the following methods will you use to accomplish your task? D - Data Pump QUESTION 7 For which of the following scenarios would you use user-managed incomplete recovery? (Choose all that apply.) A - You have lost a datafile and one or more of the archived redo log files are missing. B - Several widespread logical errors have occurred in the database in the last day. C - You want to create a test database as of a point in time in the past. QUESTION 125 You work as a Database Administrator for uCertify Inc. You notice that the AWR collection interval in DBMS_WORKLOAD_REPOSITORY package is set to 1 hour and the retention period is set to 30 days. You now want to change the settings to 2 hours and the retention period to 60 days. Which of the following SQL commands will result in the desired settings? C - SQL > execute dbms_workload_repository.modify_snapshot_settings (interval => 120, retentio =>86400); QUESTION 162 You work as a Database Administrator for uCertify Inc. The company uses an Oracle database to store the data regarding the details of the company. Some of the rebalancing operations are requiered to be performed on the database. The rate of user I/O is high in the daytime hours being the peak working time. You do not want the rebalancing operations to bring about any type of interference in the user I/O. You have decided to decrease the pace of rebalancing operations in the day time and increase the same in the night hours when the user I/O is less or null. For which of the following initialization parameters will you set the value to accomplish the required task? B - ASM_POWER_LIMIT QUESTION 285 Identify whether the given statement is true or false. "Oracle automatically performs an instance recovery when a database is restarted after an instance failure." B - True QUESTION 262 Which of the following types of tablespaces stores information about the used and free extents of a database? D - Dictionary managed tablespace QUESTION 117 Which of the following parameters is used to display an entire range of supported languages, -28-



as well as all other globalization options? D - V$NLS_VALID_VALUES QUESTION 138 OR 210 Which of the following parameters specifies what disks ASM instance should discover and use for storing files? A - ASM_DISKSTRING QUESTION 118 Which of the following procedures is used to prioritize the jobs in a schedule? B - SET_ATTRIBUTE QUESTION 171 Which of the following database components records snapshots of critical database statistics and workload metrics and stores them in the database? A - AWR QUESTION 177 Which of the following views will you query if you want to perform a Flashback Transaction Query? B - FLASHBACK_TRANSACTION_QUERY QUESTION 178 You work as Database Administrator for uCertify Inc. The company uses Oracle as its database. You want to create a snapshot. Therefore, you use the DBMS_WORKLOAD_REPOSITORY package. Which of the following statements about CREATE_SNAPSHOT are true? Each correct answer represents a complete solution. Choose two. C. It is a function. E. It is a procedure. QUESTION 183 You work as Database Administrator for uCertify Inc. You have set the retention period for Automatic Repository (AWR) statistics to six days an the collection interval to 20 minutes. Now you want to view the statistics collected and stored in an AWR snapshot. Which of the following will you use to accoplish the task? Each correct answer represents a complete solution. Choose two. A - The DBMS_WORKLOAD_REPOSITORY package. C - The Enterprise Manager QUESTION 187 or 203 Identify the true statements about Automatic Memory Management (AMM). Each correct answer represents a complete solution. Choose all that apply. B - D The initialization parameter MEMORY_TARGET must be less than MEMORY_MAX_TARGET, and MEMORY_MAX_TARGET is a static parameter. C - A The initialization parameter MEMORY_TARGET enables AMM and it is a dynamic parameter. QUESTION 189 If you want to use the SQL Tuning Advisor to tune multiple SQL Statemens, what object will this require to be created? C - SQL Tuning Sets(STS) QUESTION 195 OR 286 -29-



Which of the following procedures of the DBMS_RESOURCE_MANAGER package will create a work area for changes to resource manager objects? A - CREATE_PENDING_AREA procedure QUESTION 206 Which data dictionary views will display information about the current user's recycle bin? Each correct answer represents a complete solution. Choose all that apply. A - RECYCLEBIN D - USER_RECYCLEBIN QUESTION 208 or 179 You are an employee in Z-Tech Inc. The company uses an Oracle database. You have created a table named Personal_Records that is stored in a dictionary-managed tablespace. You want to determine the size of the third extent allocated to the table. Which of the following statements will you use to accomplish this? D - SELECT NEXT_EXTENT,PCT_INCREASE FROM USER_TABLES WHERE TABLE_NAME='PERSONAL_RECORDS'; QUESTION 21 You want to designate one of the Linux system administrators as the recovery catalog owner. Which role must you grant to her Oracle user account? C - RECOVERY_CATALOG_OWNER QUESTION 226 Which of the following types of database file stores all the changes made to the database? D - Archive redo log file QUESTION 231 Which of the following initialization parameters provides the default values of the SESSIONS and TRANSACTIONS parameters? D - PROCESSES QUESTION 245 Which of the following options is the default value for the STARTUP command to start an ASM instance? C - MOUNT QUESTION 247 Which of the following types of files defines the maximum number of users that can connect to the database concurrently? C - Initialization parameter file QUESTION 251 What is the default value of the PROCESSES initialization parameter? C - 100 QUESTION 252 Which of the following is true regarding the tablespace if a tablespace is said to be temporary? A - The tablespace is permanen but the segments stored in the tablespace are temporary. QUESTION 253 When the OMF(Oracle-Managed Files) feature is used, which of the following initialization parameters specifies the default location where Oracle creates the onlin redo log files and -30-



control files? C - DB_CREATE_ONLINE_LOG_DEST_n QUESTION 254 What does OMF stands for? C - Oracle Managed Files QUESTION 256 Which of the following dynamic performance views displays the names and status of all the control files in a database? B - V$CONTROLFILE QUESTION 258 Identify whether the given statement is true or false. "A temporary tablespace is used to hold the temporary records generated by sort operations that are performed by database users." A. True QUESTION 259 The value of the LARGE_POOL_SIZE initialization parameter should be set to at least _____ for a single ASM instance. B - 12 MB QUESTION 271 Which of the following statements for setting up the flash recovery area is true? A - The DB_RECOVERY_FILE_DEST_SIZE initialization parameter is defined before the DB_RECOVERY_FILE_DEST initialization parameter is enabled. QUESTION 279 Where do the server-managed backups go by default? A - Flash Recovery Area QUESTION 282 From which of the following files of the target database does a recovery catalog obtain its information? B - Control file QUESTION 288 Which of the following types of failures occurs when a user mistakenly drops a table from a database? D - User error QUESTION 289 What does SCN stands for? D - System change number QUESTION 304 Which of the following commands will you execute to see the current status of an incident? C - SHOW INCIDENT QUESTION 308 Which of the following is another name of DIAGNOSTIC_DEST initialization parameter? B - ADR base QUESTION 310 What does ADRCI stand for? -31-



A - Automatic Diagnostic Repository Command Interpreter QUESTION 312 Which of the following clauses forces Oracle to perform sort operation to de-duplicate the result set of a query? C - DISTINCT QUESTION 314 Which of the following characteristics is used by the EM Database Control Segment Resource Estimation feature? B - Estimated number of colums QUESTION 315 Which of the following is not the main element of Database Resource Manager? D - Resource consumer plan directives QUESTION 316 Which of the following precedures will stop a running job? C - DBMS_SCHEDULERSTOP_JOB QUESTION 317 Which of the following is optionally NOT define by Schedules? B - Job type QUESTION 322 Which of the following NLS views is used to see the current NLS settings? A - NLS_SESSION_PARAMETERS QUESTION 33 You want to create an archival backup for historical purposes. Where can you store the archival backup? A - To disk location outside of the recovery area or a tape group QUESTION 89 You are creating an incident package to sent to Oracle support as follows. What kind of packaging are you using? C - Quick packaging QUESTION 15 You want to use Flashback Transaction Query to identify the SQL needed to reverse a transaction in the HR. EMPLOYEES table. Where can you find out the value of the transaction ID column XID to use when you query FLASHBACK_TRANSACTION_QUERY? (Choose the best answer.) A. From the VERSIONS_XID column of HR. EMPLOYEES QUESTION 137 Which of the following procedures of the DBMS_RESOURCE_MANAGER package creates a single-level resource plan containing up to eight consumer groups in one step? B - CREATE_SIMPLE_PLAN Procedure QUESTION 95 Which of the following statements about conventional tablespaces (non-locally managed tablespaces) are true? Each correct answer represents a part of the solution. (Choose two) A. Conventional tablespaces use data dictionary tables for storage space management. -32-



C. In case of conventional tablespaces, Oracle reflects the allocation of a new extent by updating th associated segment header and the data dictionary table. QUESTION 79 You work as a Database Administrator for Gentech Inc. The company uses an Oracle database. The database contains several resource consumer groups. Andrew joins the company as an Assistant Database Administrator. You are required to grant him the ADMINISTER_RESOURCE_MANAGER privilege so that he is able to manage resource consumer groups in the database. You also want to ensure that Andrew is able to grant this privilege to other users in the database. Which of the following statements will you use to accomplish this? C. DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SYSTEM_PRIVILEGE ( GRANTEE_NAME=>'ANDREW', PRIVILEGE_NAME => 'ADMINISTER_RESOURCE_MANAGER', ADMIN_OPTION=> TRUE); QUESTION 60 You inadvertently delete some RMAN backups with operating system commands. You perform additional backups from RMAN again but you need to remove the deleted backups from the recovery catalog. What commands can you use to clean up the catalog? (Choose all that apply.) B. CROSSCHECK D. UNCATALOG QUESTION 379 You have two database instances, PROD and TEST. You want to maintain separate ADR homes for these two instances. Which statement is true? B - You should create multiple ADR home locations within a singles ADR base QUESTION 102 Which of the following are segment types in a database? Each correct answer represents a complete solution. Choose all that apply. A - Data B - Index D - Undo QUESTION 373 QUESTION 368 You are working n a 24X7 database. You want to design a backup strategy for your database that uses user-managed backups. You want to be able to perform all backups while the database remains on line. Which statement about performing user-managed backups in a 24X7 enviroments is true? C - To backup a tablespace, it must be in backup mode.

You inadvertently delete some RMAN backups with operating system commands. You perform additional backups from RMAN again but you need to remove the deleted backups from the recovery catalog. What -33-



commands can you use to clean up the catalog? (Choose all that apply.) B. CROSSCHECK D. UNCATALOG QUESTION 154 Which of the following dynamic performance views can be used for collecting information about the Database Resource Manager? QUESTION 362 Which of the following options is a linguistic sort parameter? D - NLS_SORT VERIFICAR SI QUESTION 139 Which of the following parameters will you set if you want to specify the type of sorting character data? B - NLS_SORT QUESTION 12 Which of the following methods can you use to run a job chain?(Choose all that apply.) A. Create and schedule a job with CREATE JOB of type CHAIN. E. Use the RUN_CHAIN procedure. QUESTION 169 You work as Database Administrator for Dolliver Inc. The company uses an Oracle database. David is an employee in the company. He is currently logged on to resource consumer group named DB_DEVELOPERS. You want to dinamically change the resource consumer group of David to DB_USERS. Which of the following procedures of the DBMS_RESOURCE_MANAGER package will you use to accomplish the task without requiring David to log out. D - SWITCH_CONSUMER_GROUP_FOR_USER QUESTION 26 You are using the RMAN Data Recovery Advisor functionality. When an error occurs, which of the following commands can you use to monitor and maintain failures? (Choose all that apply.) B. REPAIR FAILURE C. CHANGE FAILURE D. ADVISE FAILURE QUESTION 348 Which of the following are the characteristics of locally managed tablespaces?

QUESTION 42 You create and execute a stored local script using the following commands create script user backup { backup as copy tablespace users; delete noprompt obsolet; } execute script user_backup; What happens when you run these commands. -34-



A - The script does not run because it must be executed within a RUN block. QUESTION 65 Which of the following initialization parameters are specific to an ASM instance? C. ASM_POWER_LIMIT QUESTION 236 The redo log records are written to the redo log files either every three or after the redo log buffer is _______filled. B. One-third Question 284 Which of the following types of failures is a media failure? A. Crashed hard disk QUESTION 135 Which of the following tasks can you accomplish with the Support Workbench? A. Package diagnostic information and send to Oracle support. B. View problem details. D. Automatically install patches releated to the incident. 60 - You inadvertenly delete some RMAN backups with operating system commands. B - CROSSCHECK D - UNCATALOG QUESTION 272 Which of the following parameters points to the flash recovery area? C - DB_RECOVERY_FILE_DEST

QUESTION 163 Whhich of the following are true regarding the ASM coarse striping and ASM fine grained striping? Each correct answer represents a complete solution. Choose all that apply. C - Coarse striping is used for all voluminous input/output, whereas fine grained striping is used for a small input/output. D - Coarse striping manages the load balance across the disk groups, whereas fine-grained striping spreads the load on disk groups reducing latency for certain file types. QUESTION 47 How many copies of the alert log are stored in the directory specified by the initialization parameter DIAGNOSTIC_DEST? D - Two per instance. QUESTION 155 You are an employee in Gentech Inc. The company uses an Oracle database. You want to set a default date format for the current session. Which of the following National Language Support (NLS) parameters will you set to accomplish this? A - NLS_DATE_FORMAT QUESTION 39 Which of the following statements is true regarding lightweight jobs? -35-

1Z0-053.pdf

Recommend Documents