-
编辑 删除
042-090
90. Redo log files are not multiplexed in your database. Redo log blocks are corrupted in group 2, and archiving has stopped. All the redo logs are filled and database activity is halted. Database wri...
-
编辑 删除
042-090
90. Redo log files are not multiplexed in your database. Redo log blocks are corrupted in group 2, and archiving has stopped. All the redo logs are filled and database activity is halted. Database wri...
-
编辑 删除
042-088
88. A user receives the following error while executing a query:ORA-01555: snapshot too oldWhich two options can be the solutions to avoid such errors in future? (Choose two.) A) increase the size of ...
-
编辑 删除
042-085
85. You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application...
-
编辑 删除
042-079
79. A user complains that he gets the following error message repeatedly after executing some SQL statements. The error message forces the user to log off from and log on to the database to continue h...
-
编辑 删除
042-077
77. On which three can you use Recovery Manager (RMAN) to perform. incremental backup? (Choose three.)A) data filesB) control filesC) tablespacesD) password fileE) parameter fileF) whole databaseG) fl...
-
编辑 删除
042-076
76. Your database is not configured for session failover. Your tnsnames.ora file contains the following details:test.us.oracle.com=(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=off)(FAILOVER=ON)(ADDRESS= (...
-
编辑 删除
042-075
75. In your database, the Log Writer (LGWR) process is unable to write to a member of a current redo log group due to read/write failure. Which two effects would you see in your database? (Choose two....
-
编辑 删除
043-072
72. The SAVE_AMT column in the ACCOUNTS table contains the balance details of customers in a bank. As part of the year-end tax and interest calculation process, all the rows in the table need to be ac...
-
编辑 删除
042-067
67.Your database is configured with the following parameters related to SGA)SGA_TARGET=256MBSHARED_POOL_SIZE=32MBDB_CACHE_SIZE=100MBLARGE_POOL_SIZE=0JAVA_POOL_SIZE=0STREAMS_POOL_SIZE=0Which two statem...
-
编辑 删除
043-065
65. You are creating a locally managed tablespace to meet the following requirementsAll the extents should be of the same size.The data should be spread across two data files.A bitmap should be used t...
-
编辑 删除
042-058
58. Which two statements regarding archive log destinations are true? (Choose two.)A) A maximum of 10 destinations can be specified.B) The archive logs must be written to all the destinations.C) The a...
-
编辑 删除
042-54
54. Which three pieces of information are considered while deciding the size of the undo tablespace in your database? (Choose three.)A) the size of an undo blockB) the size of the redo log filesC) und...
-
编辑 删除
042-97
97. You specified segment space management as automatic for a tablespace. What effect would this have on space management?A) Extents would be managed by the freelists.B) The segment would be managed b...
-
编辑 删除
042-050
50. Which two statements about Automatic Storage Management (ASM) are true? (Choose two.)A) ASM provides mirroring on file by file basis.B) ASM provides automatic load balancing across all ASM disks.C...
-
编辑 删除
047
47. Which two statements are true about the primary key constraint in a table? (Choose two.)A) It is not possible to disable the primary key constraint.B) It is possible to have more than one primary ...
-
编辑 删除
042-046
46. You want to create a new optimized database for your transactional production environment to be used by a financial application. While creating the database, you want the Oracle software to take c...
-
编辑 删除
042-045
45. You find that the database performance degrades while you backup the PROD database using Recovery Manager (RMAN). The PROD database is running in shared server mode. The database instance is curre...
-
编辑 删除
042-045
45. You find that the database performance degrades while you backup the PROD database using Recovery Manager (RMAN). The PROD database is running in shared server mode. The database instance is curre...
-
编辑 删除
042-041
41. You are working on the 24X7 database with high transaction volume, to ensure faster instance recovery on your database you set the FAST_START_MTTR_TARGET initialization parameter to a very low val...
