问题:You enabled the flashback logging feature, but you have not ...
查看答案
问题:单选题You want to estimate the size of a table by using the Oracle Enterprise Manager. On which data is the size of the table NOT based?()A column sizesB column data typesC PCTFREED projected number of rowE PCTUSED...
问题:单选题A redo log file is corrupted while the database is open; as a consequence, database operations are stopped because archiving cannot continue. What would you do to solve the problem?()A clear the redo log groupB perform redo log file importC perform ...
问题:单选题You have specified the warning and critical threshold values of an application tablespace to be 60% and 70%, respectively. From the tablespace space usage metrics, you find that the actual space usage has reached the specified warning threshold value, ...
问题:You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parame...
问题:单选题Consider the following command to add a new disk group called "tdgroupA" with two failover groups: CREATE DISKGROUP tdgroupA NORMAL REDUNDANCY FAILOVERGROUP control01 DISK ’/devices/A1’, ’/devices/A2’, ’/devices/A3’ FAILOVERGROUP control02 DISK ’/de...
问题:Your database contains a temporary tablespace, index tablesp...
问题:单选题In which scenario will you perform a user-managed incomplete recovery?()A when a table is dropped and stored in the Recycle BinB when a table is dropped and purged from the Recycle BinC when you are required to recover an existing table to its previo...
问题:多选题In which two conditions are resumable statements suspended?()Awhen a user exceeds the space quotaBwhen a user session is terminatedCwhen a table that is being accessed by the current transaction is not foundDwhen a user manually suspends the statementE...
问题:单选题Your database is using shared server configuration. Which optional memory structure would you configure to store the User Global Area (UGA) information and improve the shared pool performance?()A large poolB streams poolC keep buffer cacheD recycle buf...
问题:You have configured Automatic Shared Memory Management. Whic...
问题:You used the following command in Recovery Manager (RMAN) as...
问题:You have specified the warning and critical threshold values...
问题:单选题While setting up the thresholds for tablespace space usage metrics for one of your tablespaces, you define the critical threshold as 60% and warning threshold as 75%. What would be the result of this setting?()A It would result in an error because the ...
问题:You are upgrading to the Oracle 10g Database and will use th...
问题:单选题A data file become corrupted in your database due to bad sectors on the disk. Because of corruption, you lost all the important tables in that data file. Which method would you use for recovery?()A Flash back all the tables in the data file, one by on...
问题:On Monday, you dropped the DEPT table from your schema and t...
问题:单选题Consider the recovery steps in each of the cases given below: Case 1: Shut down the database and perform a backup. Restore all the data files. Mount the database. Recover the database. Without applying all the redo log files, open the database us...
问题:多选题The current time zone for one of the user sessions is set to the database local time zone. For one application, the user session requires the time zone to be set to the local operating system time zone without affecting other user sessions. Which two s...
问题:The size of the largest datafile, data1.dbf, in your databas...