1Z0-053 Exam Dumps | The CONTROL_FILE_RECORD_KEEP_TIME initialization parameter should be set to what value? (Choose all that

<< Prev Question Next Question >>

Question 296/442

The CONTROL_FILE_RECORD_KEEP_TIME initialization parameter should be set to what value?
(Choose all that apply.)

A. The initialization parameter should be set to 0 when the RMAN repository is being used.

B. The initialization parameter should be set to greater than 0 with the RMAN repository utilizing the recovery catalog only.

C. The initialization parameter should be set to greater than 0 with the RMAN repository utilizing the control file or the recovery catalog.

D. The initialization parameter should be set to 0 with the RMAN repository utilizing the control file or the recovery catalog.

E. The initialization parameter should never be set to 0 if you are using RMAN.

Question List (442q): Question 1: The environmental variable ORACLE_BASE is set. You want to c...; Question 2: Which setting enables the baselines by default in Oracle Dat...; Question 3: What is an obsolete backup set?...; Question 4: Identify the two direct sources from where SQL plans can be ...; Question 5: How is block-change tracking enabled?...; Question 6: Which two statements are true regarding the starting of the ...; Question 7: How would you grant the RVPC user access to specific RMAN da...; Question 8: Which are the prerequisites for performing flashback transac...; Question 9: You want to track and store all transactional changes to a t...; Question 10: Multiple RMAN sessions are connected to the database instanc...; Question 11: You have lost datafile 4 from your database. Which is typica...; Question 12: Identify the three predefined server-generated alerts. (Choo...; Question 13: Which statement describes the significance of the CHANGE FAI...; Question 14: Which of the following statements is true regarding the VERS...; Question 15: The Oracle Database 11g database is running in the ARCHIVELO...; Question 16: You are using Recovery Manager (RMAN) to perform backups. In...; Question 17: Which of the following represents the correct sequence of ev...; Question 18: How many individual archive-log destination directories are ...; Question 19: What is the proper procedure to recover a lost tempfile?...; Question 20: Using Recovery Manager (RMAN), you take image copies of a pr...; Question 21: Which is the correct command to back up the database, back u...; Question 22: A database is running In ARCHIVELOG mode. It has two online ...; Question 23: What is the correct order of steps to perform an online data...; Question 24: Using Oracle Enterprise Manager to set SGA pool values manua...; Question 25: You want to configure the Flashback Database feature and ret...; Question 26: What RMAN command must you use before you can back up a data...; Question 27: You want to use the automatic management of backup and recov...; Question 28: View the Exhibit for some of the current parameter settings....; Question 29: Which type of backup backs up only data blocks modified sinc...; Question 30: Which of the following initialization parameters have been d...; Question 31: Which are the two prerequisites before setting up Flashback ...; Question 32: Which statement is true regarding the VALIDATE DATABASE comm...; Question 33: Evaluate the following block of code: (Exhibit) What is the ...; Question 34: You work in a data warehouse environment that involves the e...; Question 35: Which statements are true regarding the creation of an incid...; Question 36: You are working in an online transaction processing (OLTP) e...; Question 37: View the Exhibit to examine the output produced by the follo...; Question 38: To enable faster incremental backups, you enabled block chan...; Question 39: Which statements about the MEMORY_TARGET initialization para...; Question 40: You are managing an Oracle Database 11g database. You want t...; Question 41: Your database is running in ARCHIVELOG mode. You have been t...; Question 42: You notice that a job in a chain has not completed on a nonc...; Question 43: What type of backup is stored in a proprietary RMAN format?...; Question 44: You need to perform an online table redefinition of an exist...; Question 45: Which of the following are valid program types for a lightwe...; Question 46: Which two statements are true about the compressed backups i...; Question 47: Identify the channel settings that can be performed using th...; Question 48: View the Exhibit. You are creating a database by using Datab...; Question 49: Which statements describe the capabilities of the DBMS_NETWO...; Question 50: The Database Resource Manager is automatically enabled in th...; Question 51: What two statements are true regarding the recommendations r...; Question 52: Which method could be utilized to identify both DML operatio...; Question 53: Your database is up and running and one of your three contro...; Question 54: You realize that the control file is damaged in your product...; Question 55: Which statement most accurately describes the implementation...; Question 56: What recommendations does the SQL Access Advisor provide for...; Question 57: Examine the following scenario: - Database is running in ARC...; Question 58: You are working on a CATDB database that contains an Oracle ...; Question 59: You backed up the database at 8 a.m. today using an online b...; Question 60: You are using Recovery Manager (RMAN) with a recovery catalo...; Question 61: Identify two options that Oracle recommends while configurin...; Question 62: You issued the following commands to configure setting in RM...; Question 63: What two are the prerequisites for enabling Flashback Databa...; Question 64: When exporting metadata for the transportable tablespaces, w...; Question 65: Which of the following are true concerning block media recov...; Question 66: Identify the three persistent configuration settings for tar...; Question 67: The database is configured in ARCHIVELOG mode. The database ...; Question 68: Which is the correct command to put the database in ARCHIVEL...; Question 69: Tape streaming is not happening while performing RMAN tape b...; Question 70: The Automatic Database Diagnostic Monitor (ADDM) analysis ru...; Question 71: A user sends you an email with the following error message: ...; Question 72: Evaluate the following statements: CREATE TABLE purchase_ord...; Question 73: Which of the following describes how a distributed resumable...; Question 74: View the Exhibit to examine the output for the V$DIAG_INFO v...; Question 75: RMAN provides more granular catalog security through which f...; Question 76: A user named Arren is executing this query: select table_nam...; Question 77: You opened the encryption wallet and then issued the followi...; Question 78: The following databases are registered in the base recovery ...; Question 79: Automatic PGA Memory Management eliminates the need to manua...; Question 80: You have lost all your RMAN backup set pieces due to a disk ...; Question 81: Which is true concerning Database Replay in an Oracle Real A...; Question 82: Which of the following most closely represents an image copy...; Question 83: After you have restored and recovered a database to a new ho...; Question 84: What is the result of this command? RMAN> Report need bac...; Question 85: Which options would you consider while configuring a flash r...; Question 86: While performing the backup of the flash recovery area, you ...; Question 87: You notice that a long-running transaction is suspended due ...; Question 88: Which tasks are run automatically as part of the Automated M...; Question 89: In Recovery Manager (RMAN), you are taking image copies of t...; Question 90: Your production database is functional on the SHOST1 host. Y...; Question 91: You decided to use Direct NFS configuration in a non-RAC Ora...; Question 92: What information does the report schema command not provide?...; Question 93: Which client requests to the database can be captured as a p...; Question 94: Another DBA issues a shutdown abort command on a database on...; Question 95: The EMP table has some discrepancy in data entry with a part...; Question 96: Identify the scenarios in which the RMAN CROSSCHECK command ...; Question 97: If you issue the command shutdown abort prior to trying to p...; Question 98: While performing a regular check on your recovery catalog yo...; Question 99: Which statement is true about a running session that belongs...; Question 100: You are using Recovery Manager (RMAN) for backup and recover...; Question 101: When you are performing active database duplication, a backu...; Question 102: Which two statements are true about encrypting RMAN backup? ...; Question 103: Which three actions are required to configure the Flashback ...; Question 104: Observe the structure of the table employees: The table cont...; Question 105: An online tablespace, TEST_TBS, is full and you realize that...; Question 106: The ADMIN_EMP table has columns EMPNO, ENAME, DEPTNO, and SA...; Question 107: Your ARCHIVELOG mode database has lost three datafiles and s...; Question 108: Your company wants to upgrade the production database to a R...; Question 109: To view the results of a manual SQL Tuning Advisor task, whi...; Question 110: You have 100 segments in the USERS tablespace. You realize t...; Question 111: Compressed backups work with which of the following commands...; Question 112: Examine the following PL/SQL block: DECLARE my_plans PLS_INT...; Question 113: What is the purpose of the RMAN recovery catalog? (Choose al...; Question 114: Which statements are true regarding the system-defined movin...; Question 115: Within a resource-plan definition, what differentiates a top...; Question 116: Which commands are used for RMAN database recovery? (Choose ...; Question 117: You need to create a partitioned table to store historical d...; Question 118: Which of the following calendaring syntax expressions would ...; Question 119: The following query will provide what information about tran...; Question 120: You are using recovery Manager (RMAN) with a recovery catalo...; Question 121: You have lost all your online redo logs. As a result, your d...; Question 122: View the Exhibit. Examine the following command that is exec...; Question 123: Your database is running in ARCHIVELOG mode. You are perform...; Question 124: Note the following parameters settings in your database: (Ex...; Question 125: You executed the following command in Recovery Manager (RMAN...; Question 126: You have enabled resumable space allocation in your database...; Question 127: In which cases is reference partitioning effective in enhanc...; Question 128: What is the end result of these commands if they are success...; Question 129: Which of the following commands will perform an active datab...; Question 130: Which tuning tool recommends how to optimize materialized vi...; Question 131: You have backed up your database using image copies. You hav...; Question 132: In which two aspects does hot patching differ from conventio...; Question 133: What does the minimize load database parameter mean when bac...; Question 134: You are working on a 24X7 database. You want to design a bac...; Question 135: A developer calls and reports that he accidentally dropped a...; Question 136: Which two statements are true regarding Health Monitor check...; Question 137: Which of the following statements best describes Flashback V...; Question 138: Users notify you that their application is failing every tim...; Question 139: Your developers have asked you to restore the development da...; Question 140: To clean up old records that are in a Flashback Data Archive...; Question 141: To accomplish user-managed backup for the USERS tablespace, ...; Question 142: You want to migrate your database to ASM, so you have done a...; Question 143: You plan to set up the Automatic Workload Repository (AWR) b...; Question 144: Given the following steps, which would be the correct order ...; Question 145: Which statement is true regarding virtual private catalogs?...; Question 146: Upon starting your database, you receive the following error...; Question 147: Examine the following command used to perform incremental le...; Question 148: Which command will result in a trace file being created with...; Question 149: Which components are needed for successful and most efficien...; Question 150: The SQL Tuning Advisor configuration has default settings in...; Question 151: You want the Automatic SQL Tuning process to stop accepting ...; Question 152: View the Exhibit and examine the RMAN commands. (Exhibit) Wh...; Question 153: Which option is best practice for creating a recovery catalo...; Question 154: Which two statements are true regarding the SQL Repair Advis...; Question 155: When executing a SQL workload, you choose to generate execut...; Question 156: You want to perform an RMAN backup of database as a copy. Wh...; Question 157: For which of the following can you use Segment Shrink? (Choo...; Question 158: Which statement about the enabling of table compression in O...; Question 159: You need to maintain a record of all transactions on some ta...; Question 160: Which two statements are true about an image copy backup? (C...; Question 161: Which of the following advisors is run in every maintenance ...; Question 162: Which pseudocolumn could you use to identify a unique row in...; Question 163: You have configured flash recovery area in your database and...; Question 164: Which command would correctly start a TSPITR of the USERS ta...; Question 165: Examine the following values of the initialization parameter...; Question 166: Which of the following cannot be used as input to the SQL Tu...; Question 167: Which two are true about a fast incremental backup? (Choose ...; Question 168: To enable resumable space allocation for the instance, which...; Question 169: Which two statements are true regarding the Automatic Diagno...; Question 170: When creating a SQL tuning set, which of the following steps...; Question 171: Every resource plan must contain an allocation to which cons...; Question 172: You are managing an Oracle Database 11g database. You want t...; Question 173: View the Exhibit and examine the Data Pump architecture. Ide...; Question 174: Which of the following are not disabled by default?...; Question 175: You want to put a specific tablespace called MY_DATA in hot ...; Question 176: You plan to control idle sessions that are blocking other se...; Question 177: Which of the following are included in a transportable table...; Question 178: During the installation of Oracle Database 11g, you do not s...; Question 179: Examine the following set of RMAN commands: (Exhibit) Which ...; Question 180: Which statements are true regarding the Query Result Cache? ...; Question 181: Identify two situations in which you can use Data Recovery A...; Question 182: Which of the following is not a valid calendaring syntax ele...; Question 183: If a backup set is expired, what can you do to correct the p...; Question 184: View the Exhibit to examine the Automatic SQL Tuning result ...; Question 185: In order to perform Flashback Transaction Query operations, ...; Question 186: Which of the following are correct about block media recover...; Question 187: The database is configured in ARCHIVELOG mode and regular co...; Question 188: Your production database is running in archivelog mode and y...; Question 189: In a Database Replay workload capture, what client request i...; Question 190: You plan to execute the following command to perform a Flash...; Question 191: Which of the following advisors within the Oracle advisory f...; Question 192: You issue the following command: RMAN>CONFIGURE BACKUP OP...; Question 193: You want to enable resumable space allocation at the instanc...; Question 194: You are using RMAN to backup your ARCHIVELOG mode database. ...; Question 195: The database is currently open and the temp03.dbf tempfile b...; Question 196: True or false: RMAN offers the equivalent of the SQL command...; Question 197: Which two are true about configuring the fast recovery area?...; Question 198: Which two changes and their effect on the system can be test...; Question 199: If you back up a database without connecting to the recovery...; Question 200: Which of the following commands will fail?...; Question 201: In Oracle 11g, by default which one of the following conditi...; Question 202: You have a database with the following tablespaces: SYSTEM, ...; Question 203: In your test database: You are using Recovery Manager (RMAN)...; Question 204: Which two conditions must be met before you can create a Rec...; Question 205: Consider the following scenario for your database: - Backup ...; Question 206: Evaluate the following command and its output: SQL>SELECT...; Question 207: You have lost all your database control files. To recover th...; Question 208: Which statements are true regarding SecureFile LOBs? (Choose...; Question 209: Given below are RMAN commands to enable backup optimization ...; Question 210: You executed the following SQL statement to shrink the EMPLO...; Question 211: View the Exhibit and examine the output. (Exhibit) You execu...; Question 212: Which three types of files can be automatically placed in th...; Question 213: Given the script create script db_backup_datafile_script {ba...; Question 214: You issued the following command on the temporary tablespace...; Question 215: Which is the source used by Automatic SQL Tuning that runs a...; Question 216: View the Exhibit to examine the Automatic Database Diagnosti...; Question 217: What does the output on this report indicate? (Exhibit)...; Question 218: In your database, the flash recovery area (FRA) is configure...; Question 219: View the Exhibit and examine the output of the query in diff...; Question 220: When tuning Automatic PGA Memory Management, which of the fo...; Question 221: During recovery, you need to know if log sequence 11 is in t...; Question 222: Which statement about using RMAN stored scripts is true?...; Question 223: Your database initialization parameter file has the followin...; Question 224: Performance divergence indicated in the Workload Replay repo...; Question 225: You can back up the RMAN recovery catalog with RMAN....; Question 226: You are working on the APPDB database as a DBA. The database...; Question 227: Which of the following statements are true regarding the Rec...; Question 228: What is the impact of the results of the output of the follo...; Question 229: What is the default value for the ENABLED attribute of a job...; Question 230: You have enabled backup optimization for the RMAN environmen...; Question 231: Before a Flashback Table operation, you execute the followin...; Question 232: Which of the following statements are true about the BACKUP ...; Question 233: You need to restore your database back to 9/30/2008 at 18:00...; Question 234: Which of the following Scheduler elements encourage object r...; Question 235: Evaluate the following code: (Exhibit) What is the outcome o...; Question 236: In your production database, you: Are using Recovery Manager...; Question 237: If a job references a schedule that has been disabled, what ...; Question 238: As soon as you discover that you have lost an online redo lo...; Question 239: Which statement is true regarding the retention policy for t...; Question 240: What view might you use to try to determine how long a parti...; Question 241: Which two kinds of failures make the Data Recovery Advisor (...; Question 242: Your company wants to upgrade the current production databas...; Question 243: Which dynamic view displays the status of block-change track...; Question 244: You are in the process of creating a virtual private catalog...; Question 245: You have backed up your database twice without connecting to...; Question 246: Which statements are true regarding system-partitioned table...; Question 247: While Monitoring the space usage in your database that is in...; Question 248: You want to enable automatic PGA memory management in your d...; Question 249: Which of these recommendations should be followed before cap...; Question 250: Which three functions are performed by the SQL Tuning Adviso...; Question 251: You executed the following PL/SQL block successfully: (Exhib...; Question 252: When performing an online backup, what is the proper order o...; Question 253: The OPTIMIZER_USE_PLAN_BASELINES parameter is set to TRUE. T...; Question 254: Examine the parameter setting in your database: SQL> SHOW...; Question 255: Which three are the valid statements in relation to SQL plan...; Question 256: Which type of backup must be performed first with an increme...; Question 257: You are trying to recover your database. During the recovery...; Question 258: Which of the following are valid until command options when ...; Question 259: Which of the following is a potential performance tuning rec...; Question 260: You executed the following commands in a database session: (...; Question 261: Which view provides information on the backup status of the ...; Question 262: Which of the following represents the correct way to perform...; Question 263: Sales details are being stored on a daily basis in the SALES...; Question 264: You perform the following activities during the database upg...; Question 265: You are managing a 24*7 database. The backup strategy for th...; Question 266: You executed the following command to drop a user: DROP USER...; Question 267: View the Exhibit for some of the parameter settings. You sta...; Question 268: Which of the following can be used in conjunction with a Fla...; Question 269: You are working as a DBA on the decision support system. The...; Question 270: Which of the following is a prerequisite for running DBMS_TD...; Question 271: Which of these are valid Flashback Database recovery point p...; Question 272: In your database, the RESULT_CACHE_MODE parameter has been s...; Question 273: Evaluate the following command: SQL>ALTER SYSTEM SET db_s...; Question 274: Which statements are true regarding table compression? (Choo...; Question 275: ENCRYPT_TS is an encrypted tablespace that contains tables w...; Question 276: Which of the following parameters defines the location where...; Question 277: You are working on a CATDB database that contains an Oracle ...; Question 278: You want to take a complete database backup using RMAN. The ...; Question 279: What is the impact of the following backup if it exceeds the...; Question 280: Which two statements about workload capture and replay opera...; Question 281: As part of archiving the historical data, you want to transf...; Question 282: If you lost your entire database, including the database spf...; Question 283: View the Exhibit and note the contents of V$DIAG_INFO. Which...; Question 284: To set the history retention period for either window loggin...; Question 285: Which of these represent the main components of Database Res...; Question 286: The database users regularly complain about the difficulty i...; Question 287: You configured the default backup device type as disk for RM...; Question 288: The _______ writes the Flashback Database logs in the flash ...; Question 289: You performed the RMAN database backup with the KEEP option....; Question 290: Given the following steps, which would be the correct order ...; Question 291: Identify three channel settings that can be performed using ...; Question 292: View the Exhibit and examine the steps that you executed to ...; Question 293: What will be the result of the following configuration? Log_...; Question 294: Why would you execute the report obsolete command?...; Question 295: Which three statements must be true before transporting a ta...; Question 296: The CONTROL_FILE_RECORD_KEEP_TIME initialization parameter s...; Question 297: Which of the following RMAN structures can data from a dataf...; Question 298: Your system has been upgraded from Oracle Database 10g to Or...; Question 299: Which command is used to begin a tablespace point-in-time re...; Question 300: The following databases are registered in the base recovery ...; Question 301: What privileges must be granted to allow an account to creat...; Question 302: The RECYCLEBIN parameter is set to ON for your database. You...; Question 303: View the Exhibit to examine the details for an incident. Whi...; Question 304: For Oracle 11g, Oracle strongly recommends that you configur...; Question 305: You observed the following output for a user session: (Exhib...; Question 306: You are using a recovery catalog to maintain Recovery Manage...; Question 307: Which backup option defines a user-defined name for a backup...; Question 308: You want to create the Recovery Manager (RMAN) Virtual Priva...; Question 309: To manually configure the SGA components using Oracle Enterp...; Question 310: Which of the following tasks is not performed by the job coo...; Question 311: When setting up the Flashback Data Archive, which of these k...; Question 312: What does the SCN represent?; Question 313: View the Exhibit for the object interdependency diagram. How...; Question 314: What is the purpose of the catalog command?...; Question 315: You have three temporary tablespace groups named G1, G2, and...; Question 316: What is the purpose of the RMAN recovery catalog? (Choose al...; Question 317: Following is the list of locations in random order where ora...; Question 318: Which three statements about performance analysis by SQL Per...; Question 319: David managed to accidentally delete the datafiles for datab...; Question 320: Which of the following is not a valid setting for the PROGRA...; Question 321: You executed the following commands: SQL> ALTER SESSION S...; Question 322: You issue the following RMAN command to set a retention poli...; Question 323: Which two statements regarding a SQL profile are true? (Choo...; Question 324: Which DBMS_RESOURCE_MANAGER procedure prioritizes consumer-g...; Question 325: Which two statements are true about a job chain? (Choose two...; Question 326: You issue the following command on the RMAN prompt. REPORT N...; Question 327: Identity two advantages of using a recovery catalog in-load ...; Question 328: You executed the following commands in a database session: (...; Question 329: Which DBMS_SCHEDULER procedure(s) can be used to alter an ex...; Question 330: Which is NOT a valid way of backing up a control file?...; Question 331: When manually configuring the SGA, which of the following pa...; Question 332: Which type of backup contains only the blocks that have chan...; Question 333: You are using the control file to maintain information about...; Question 334: How many database instances are used during a database-dupli...; Question 335: Which two statements about the SQL Management Base (SMB) are...; Question 336: Your database is running In ARCHIVELOG mode. One of the data...; Question 337: What feature comes into play to help ensure the completion o...; Question 338: Which is the correct way to connect to both the target datab...; Question 339: When shrinking a table segment, you choose to shrink all the...; Question 340: True or false: tablespace point-in-time recovery is possible...; Question 341: You executed the following command: RMAN> RECOVER COPY OF...; Question 342: Flashback Database relies on which technologies to recover t...; Question 343: Which command will restore all datafiles to the date 9/30/20...; Question 344: What happens when you run the SQL Tuning Advisor with limite...; Question 345: The application tables owned by the user TEST in a test data...; Question 346: Which tasks can be accomplished using the Enterprise Manager...; Question 347: Which steps are mandatory to enable Direct NFS? 1. Mount all...; Question 348: Which package provides API's for the SQL Tuning Advisor?...; Question 349: What methods of point-in-time recovery are available? (Choos...; Question 350: Consider the following command: backup database plus archive...; Question 351: By setting the value of MEMORY_TARGET to zero and setting th...; Question 352: In Oracle 11g, which recommendations does the SQL Access Adv...; Question 353: What command would you use to set a persistent setting in RM...; Question 354: Which of the following supplied functions is used to identif...; Question 355: You have a very large table that your users access frequentl...; Question 356: Examine the following RMAN command: BACKUP DATABASE TAG TEST...; Question 357: You plan to collect the Automatic Workload Repository (AWR) ...; Question 358: Examine the following RMAN command: RMAN> CONFIGURE ENCRY...; Question 359: You want to disable resumable space allocation for all sessi...; Question 360: You plan to use SQL Performance Analyzer to analyze the SQL ...; Question 361: What command would you issue to enable automated backups of ...; Question 362: What methods are available to recover lost control files? (C...; Question 363: You want to set the following initialization parameters for ...; Question 364: Your database is running in ARCHIVELOG mode, and the databas...; Question 365: Using the LIST command in Recovery Manager (RMAN), which two...; Question 366: Which of the following identifies and creates an index to mi...; Question 367: An index called ORD_CUSTNAME_IX has been created on the CUST...; Question 368: A schedule defined entirely within the confines of a Schedul...; Question 369: Consider the following code snippet: (Exhibit) If this code ...; Question 370: Which of the following Oracle features is enabled by setting...; Question 371: What are the different logging modes available in Oracle Dat...; Question 372: You are working on a CATDB database that contains an Oracle ...; Question 373: Which files are required for a full recovery of the database...; Question 374: Examine the exhibit to view the parameters set in your param...; Question 375: Which statement describes the effect of table redefinition o...; Question 376: Which statements are true regarding the concept of problems ...; Question 377: Which of these appropriately describes the results of a manu...; Question 378: When performing a full database disaster recovery with RMAN,...; Question 379: What view would you use to determine if a given tablespace i...; Question 380: Which of the following options describes Segment Shrink?...; Question 381: The database is running in the ARCHIVELOG mode. It has three...; Question 382: In what view are you likely to see the following output? (Ex...; Question 383: What does the DB_FLASHBACK_RETENTION_TARGET parameter config...; Question 384: USER_DATA is a nonencrypted tablespace that contains a set o...; Question 385: Which of the following files cannot be backed up by RMAN? (C...; Question 386: Which statement is true when Automatic Workload Repository (...; Question 387: A database is running in ARCHIVELOGmode. You took a binary b...; Question 388: Which command is used to configure RMAN to perform a compres...; Question 389: Which of the following are prerequisite steps to transport a...; Question 390: What is the danger associated with stopping a running job by...; Question 391: You run the SQL Tuning Advisor (STA) to tune a SQL statement...; Question 392: When performing a database duplication, which duplicate data...; Question 393: View the Exhibit. As shown in the diagram, in-memory statist...; Question 394: You have created a script in the recovery catalog called bac...; Question 395: Note the following parameter settings: Which setting is NOT ...; Question 396: Which command is used to open the database after an incomple...; Question 397: You want to convert your existing non-ASM files to ASM files...; Question 398: Which of the following best describes a full backup?...; Question 399: Which two statements correctly describe the relationship amo...; Question 400: You work with a newly created database. Presently, there is ...; Question 401: True or false: you can perform an active database duplicatio...; Question 402: A user performs an update on a table. Shortly after committi...; Question 403: While tuning a SQL statement, the SQL Tuning Advisor finds a...; Question 404: Which command do you use to create a recovery-catalog schema...; Question 405: Your database is in NOARCHIVELOG mode. You start to do a bac...; Question 406: View the Exhibit1 to examine the series of SQL commands. Vie...; Question 407: What Oracle process runs when the database is in ARCHIVELOG ...; Question 408: Which are the correct steps, in order, to deal with the loss...; Question 409: While working on a data problem, Curt, Bill, Ben, Mike, and ...; Question 410: What is the correct order of the following commands if you w...; Question 411: Archived redo logs can be copied to more than one destinatio...; Question 412: In what order would you execute the following steps to creat...; Question 413: Examine the following command: SQL> ALTER TABLE booking S...; Question 414: Which statement about Automatic Memory Management with Oracl...; Question 415: Observe the following PL/SQL block: BEGIN dbms_spm.configure...; Question 416: Why would you run the delete obsolete command? (Choose all t...; Question 417: The DBA has chosen to manage SGA and PGA memory separately i...; Question 418: Which mode of database shutdown requires an instance recover...; Question 419: Which two statements about Oracle Direct Network File System...; Question 420: You executed the following commands in an RMAN session for y...; Question 421: You execute the following FLASHBACK TABLE command: SQL> F...; Question 422: Over the course of a day, a department performed multiple DM...; Question 423: Which of the following is a valid way of putting a tablespac...; Question 424: Which of these components correctly identify the unique valu...; Question 425: One of your databases is in ARCHIVELOGmode. You execute thes...; Question 426: At the request of a user, you issue the following command to...; Question 427: The SQL Tuning Advisor has been configured with default conf...; Question 428: Evaluate the following command: SQL> CREATE TABLE design_...; Question 429: On Friday at 11:30 am you decided to flash back the database...; Question 430: You need to perform a block media recovery on the tools01.db...; Question 431: You specify a nonzero value for the MEMORY_TARGET initializa...; Question 432: Which Scheduler view(s) can be queried to see which jobs are...; Question 433: You installed Oracle Database 11g and are performing a manua...; Question 434: You want the ability to recovery any time within the last se...; Question 435: Which of the following objects can be directly referenced by...; Question 436: Every Sunday the Unix system administrator has a job that ex...; Question 437: You are managing the APPPROD database as a DBA. You plan to ...; Question 438: Your archive-log destination directory runs out of space. Wh...; Question 439: Given a complete loss of your database, in what order would ...; Question 440: Which two prerequisites are needed for performing workload c...; Question 441: AUM (Automatic UNDO Management) has been retaining about 15 ...; Question 442: You want to back up your 100-GB database on a remote tape de...

Question 296/442

LEAVE A REPLY

Download PDF File