问题:One of the tablespaces is read-only in your database. The lo...
查看答案
问题:You are using Oracle Enterprise Manager to estimate the size...
问题:单选题Your database is running on the automatic Program Global Area (PGA) memory management and Shared Memory Management mode. You want to increase the memory available for the SQL work areas. What would you do?()A modify the HASH_AREA_SIZE initialization p...
问题:单选题You have configured your database to use RMAN for backup and recovery. You must back up the datafile contained in the TS1 tablespace. The size of the datafile in the TS1 tablespace is 200 MB. You issue the following command from the RMAN prompt to per...
问题:单选题The backup retention policy is configured as RECOVERY WINDOW 2. You executed the following command in Recovery Manager (RMAN) against your database: RMAN REPORT OBSOLETE; What would you see in the output?()A a list of all those files that have been de...
问题:One of the tablespaces is read/x7fonly in your database. The...
问题:单选题Your database operates in ARCHIVELOGmode. The redo log files are not multiplexed and one of the online redo logs is missing. The missing redo log sequence, 230, is not archived and it contained information from 10:35 a.m. onwards. The current time is 1...
问题:You lost a data file that belongs to an index tablespace in ...
问题:You have created an Oracle 10g database named SALES, which w...
问题:You are the Database Administrator (DBA) of your company. Yo...
问题:多选题You want to use the SQL Tuning Advisor to generate recommendations for badly written SQL statements in your development environment. Which three sources can you select for the advisor to analyze? ()ATop SQLBsnapshotsCSQL Tuning setsDindex access path...
问题:View the Exhibits. You performed operations on the DEPT4 tab...
问题:单选题In your production database you want to use an Automatic Storage Management (ASM) instance to manage the database files. Which option would you use to migrate the database files from a non/x7fASM instance to an ASM instance?()A Oracle Migration Assist...
问题:Your database is running in the automatic Program Global Are...
问题:You were recently hired by an organization as a database adm...
问题:多选题You are the Database Administrator (DBA) of your company. You execute the following statement on an Oracle 10g instance: SQL ALTER SYSTEM SWITCH LOGFILE; Which two tasks are performed when the statement is executed? ()AThe DBWn process writes to th...
问题:单选题You have created a resource plan, PROD_DB_PLAN, that uses the RATIO policy. The following consumer groups and their respective plan directives have been assigned to this resource plan: Consumer group HIGH_CG with CPU_P1 as 10. Consumer group MEDIUM_CG...
问题:In which scenario will you perform a cancel-based recovery?(...
问题:单选题Which type of PL/SQL construct would you use to automatically correct the error resulting from a statement that was suspended due to a space-related problem?()A functionsB packageC procedureD database triggerE anonymous PL/SQL block...
问题:多选题Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager (RMAN) to perform backups. Which two backups would you be able to perform when the database is being accessed by users?()Abackup...