1Z0-053 Exam Dumps | Evaluate the following statements: CREATE TABLE purchase_orders ( po_id NUMBER(4), po

Valid 1Z0-053 Dumps shared by ExamDiscuss.com for Helping Passing 1Z0-053 Exam! ExamDiscuss.com now offer the newest 1Z0-053 exam dumps, the ExamDiscuss.com 1Z0-053 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com 1Z0-053 dumps with Test Engine here:

Access 1Z0-053 Dumps Premium Version
(698 Q&As Dumps, 35%OFF Special Discount Code: freecram)

<< Prev Question Next Question >>

Question 168/444

Evaluate the following statements:
CREATE TABLE purchase_orders (
po_id NUMBER(4),
po_date TIMESTAMP,
supplier_id NUMBER(6),
po_total NUMBER(8,2),
CONSTRAINT order_pk PRIMARY KEY(po_id))
PARTITION BY RANGE(po_date) (
PARTITION Q1 VALUES LESS THAN (TO_DATE('1-apr-2007','d-mon-yyyy'),
PARTITION Q2 VALUES LESS THAN (TO_DATE('1-jul-2007','d-mon-yyyy'),
PARTITION Q3 VALUES LESS THAN (TO_DATE('1-oct-2007','d-mon-yyyy'),
PARTITION Q4 VALUES LESS THAN (TO_DATE('1-jan-2008','d-mon-yyyy'));
CREATE TABLE purchase_order_items (
po_id NUMBER(4) NOT NULL,
product_id NUMBER(6) NOT NULL,
unit_price NUMBER(8,2),
quantity NUMBER(8),
CONSTRAINT po_items_fk FOREIGN KEY (po_id)
REFERENCES purchase_orders(po_id))
PARTITION BY REFERENCE(po_items_fk);
What are the two consequences of the above statements? (Choose two.)

A. Partitions of the PURCHASE_ORDER_ITEMS table exist in the same tablespaces as the partitions of the PURCHASE_ORDERS table.

B. Partitions of PURCHASE_ORDER_ITEMS have system-generated names.

C. Partition maintenance operations performed on the PURCHASE_ORDER_ITEMS table are automatically reflected in the PURCHASE_ORDERS table.

D. Both PURCHASE_ORDERS and PURCHASE_ORDER_ITEMS tables are created with four partitions each.

E. The PURCHASE_ORDER_ITEMS table inherits the partitioning key from the parent table by automatically duplicating the key columns.

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

Question 168/444

LEAVE A REPLY

Download PDF File