网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
多选题
Users in your production database complain that they are getting the following error message while trying to insert rows into the ORDERS table: ERROR at line 1: ORA-01654: unable to extend index USERS.ORDERS_IND by 8 in tablespace INDEXES While investigating, you find that the INDEXES tablespace has run out of space and there is no more free space on the disk where the data files are available. Which two actions could you perform to overcome this error without affecting the queries that are currently being executed?()
A
drop and re-create the index
B
coalesce the ORDERS_IND index
C
coalesce the INDEXES tablespace
D
drop and re-create the ORDERS table
E
rebuild the index online and move it to another tablespace
参考答案
参考解析
解析:
暂无解析
更多 “多选题Users in your production database complain that they are getting the following error message while trying to insert rows into the ORDERS table: ERROR at line 1: ORA-01654: unable to extend index USERS.ORDERS_IND by 8 in tablespace INDEXES While investigating, you find that the INDEXES tablespace has run out of space and there is no more free space on the disk where the data files are available. Which two actions could you perform to overcome this error without affecting the queries that are currently being executed?()Adrop and re-create the indexBcoalesce the ORDERS_IND indexCcoalesce the INDEXES tablespaceDdrop and re-create the ORDERS tableErebuild the index online and move it to another tablespace” 相关考题
考题
单选题You have a disk group, DGROUP1, with three disks and NORMAL redundancy. You execute the following command to create a template for the disk group: ALTER DISKGROUP dgroup1 ADD TEMPLATE my_temp ATTRIBUTES (MIRROR FINE); Which statement is true?()A
When a file is created in DGROUP1 with the template, it would have three-way mirroring.B
When a file is created in DGROUP1, the MY_TEMP template becomes the default template.C
When a file is created in DGROUP1 with the template, it would have two-way mirroring and file striping.D
When a file is created in DGROUP1 with the template, it would have three-way mirroring and file striping.E
When a file is created in DGROUP1 with the template, it would have two-way mirroring but no file Striping.
考题
单选题You are managing a database for which incremental backups can be very time consuming. In order to perform optimized incremental backups you enable the block change tracking feature.How would you instruct RMAN to use the block change tracking feature when performing incremental backups?()A
You need to mention it with every BACKUP command.B
The block change tracking feature is used automatically by RMAN.C
You need to configure it using the CONFIGURE command.D
You need to set the necessary initialization parameters to direct RMAN to use the feature.
考题
多选题In the parameter file of the production database, the BACKGROUND_DUMP_DEST parameter is set to $ORACLE_HOME/users. Which two types of files would you find in this location?()Athe alert log fileBthe core dump filesCthe change tracking fileDthe user session trace filesEthe database audit trail filesFthe background process trace files
考题
单选题Your database is in ARCHIVELOG mode. On Friday evening, you perform an online database backup by using the BACKUP DATABASE command at the Recovery Manager (RMAN) prompt and close the database. On Monday, the System Administrator informs you about the failure of two hard disks. One of the lost disks contains two datafiles, HR1.DBF and HR2.DBF, both of which belong to a read/write tablespace named HR. The disk also contains a datafile, USERS.DBF, which belongs to a read/write tablespace named USERS. You need to restore and recover the database backup that was performed on Friday evening. After mounting the database, you issue the following RMAN commands: RMANRESTORE DATABASE; RMANRECOVER DATABASE; After successfully executing these RMAN commands, you issue the following statement using SQL*Plus: SQLALTER DATABASE OPEN; You receive the following errors when attempting to open the database: ORA-01157: cannot identify/lock data file 10 see DBWR trace file ORA-01110: data file 10: ’D:///USERS.DBF’ What is the cause of these errors?()A
The USERS.DBF datafile is corrupted and cannot be restored by RMAN.B
The USERS.DBF datafile was not backed up using the RMAN BACKUP DATABASE command.C
The USERS.DBF datafile was not restored using the RMAN RESTORE DATABASE command.D
The USERS.DBF datafile was not recovered using the RMAN RECOVER DATABASE command.
考题
多选题Last night, a media failure caused the loss of a temporary file that belongs to your database. Which two things may happen this morning when you try to open your database? ()AThe database opens normally.BThe database prompts for a database recovery.CThe database writer writes to a trace file, indicating that the temporary file is not found.DThe database gets mounted and throws an error indicating that the temporary file requires recovery.
考题
单选题You enabled the flashback logging feature, but you have not specified the location of the flash recovery area. Which location would be used as the default location for the flash recovery area?()A
The location used for control files.B
The location used for redo log files.C
The location set by using $ORACLE_BASED
The location set by using $ORACLE_HOMEE
The location set by using CORE_DUMP_DESTF
The location set by using BACKGROUND_DUMP_DEST
考题
单选题You issue the following RMAN command to set a retention policy on a database: RMANCONFIGURE RETENTION POLICY TO REDUNDANCY 2; What will be the outcome of the above command?()A
After two days, the backup will be marked obsolete.B
After two days, the backup will be deleted from the media.C
If the RMAN repository has records of two or more recent backups of a file, then the older backup will be deleted from the media.D
If the RMAN repository has records of two or more recent backups of a file, then the older backup will be marked obsolete.
考题
多选题You are using Oracle Database 10g. You performed an incomplete recovery of your database and opened the database with the RESETLOGS option. What is the effect of opening the database with the RESETLOGS option? ()AThis operation resets the SCN for the database.BThis operation creates a new incarnation of the database.CThis operation moves all the redo log files to a different location.DThis operation deletes the old redo log files and creates new redo log files.EThis operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.
考题
单选题Which component does the SQL Tuning Advisor NOT analyze for the SQL statements?()A
ADDMB
AWRC
Cursor CacheD
SQL Tuning SetsE
Flash Recovery Area
考题
单选题You recently created a database and configured the SPFILE with the following parameter settings to ensure that Oracle automatically adjusts the memory for the Program Global Area (PGA): SORT_AREA_SIZE = 150M HASH_AREA_SIZE = 150M BITMAP_MERGE_AREA_SIZE = 150M CREATE_BITMAP_AREA_SIZE = 150M WORKAREA_SIZE_POLICY = AUTO You have not included the PGA_AGGREGATE_TARGET initialization parameter in the SPFILE and the System Global Area (SGA) is currently sized at 4G. What is the total PGA memory allocated across all database server processes?()A
10MB
400MC
600MD
800M
考题
多选题You set the value of the SGA_TARGET initialization parameter to 1G to enable Oracle to automatically resize most of the memory components according to the current workload in the database. You issue the following statement: SQL SELECT name, value, isdefault 2 FROM v$parameter 3 WHERE name LIKE ’%size%’; The output of this statement displays that the DB_CACHE_SIZE, SHARED_POOL_SIZE, LARGE_POOL_SIZE, and JAVA_POOL_SIZE initialization parameters contain a zero value. What does this imply?()AThe SGA_TARGET initialization parameter cannot be set to a value less than 1GBThe SGA_TARGET initialization parameter cannot be set to a value greater than 1GCThe Memory Advisor of the Oracle Enterprise Manager 10g cannot be used to obtain advice on the important memory components of the SGADThe values of the DB_CACHE_SIZE, SHARED_POOL_SIZE, LARGE_POOL_SIZE, and JAVA_POOL_SIZE initialization parameters cannot be set manually.ENo minimum limits are imposed on the DB_CACHE_SIZE, SHARED_POOL_SIZE, LARGE_POOL_SIZE, and JAVA_POOL_SIZE initialization parameters.FThe Automatic Shared Memory Management feature cannot be disabled unless you specify values for the DB_CACHE_SIZE, SHARED_POOL_SIZE, LARGE_POOL_SIZE, and JAVA_POOL_SIZE initialization parameters in the initialization parameter file.
考题
单选题You are using Oracle Database 10g. Which statement regarding an incomplete recovery is true?()A
You do not need to restore all the data files.B
You do not need to open the database with the RESETLOGS operationC
You do not need to perform a full backup after the RESETLOGS operation.D
You do not need to recover all the data files to the same system change number (SCN).
考题
单选题Which statement will NOT create a tablespace?()A
CREATE TABLESPACE DATA1 DATAFILE ’+grp1/abc(datafile)’;B
CREATE TABLESPACE DATA1 DATAFILE ’+grp1’;C
CREATE TABLESPACE DATA1 DATAFILE ’+data1(tempfile)’;D
CREATE TABLESPACE DATA1 DATAFILE ’+grp1.256.34359’;
考题
多选题You lost the index tablespace in your database. You decided to re/x7fcreate the index tablespace and the indexes in the tablespace. What methods can you use to re/x7fcreate the indexes?()AData PumpBSQL scriptsCSQL*LoaderDFlashback databaseERecovery Manager (RMAN) script
考题
单选题You want an ASM instance to manage the files of your database. To achieve this objective, you specify the following parameters in the parameter file of the database: INSTANCE_TYPE = RDBMS DB_NAME = PROD LARGE_POOL_SIZE = 8MB DB_BLOCK_SIZE = 4K LOG_ARCHIVE_DEST = +dgroupA LOG_ARCHIVE_FORMAT = "$ORACLE_SID_%s_%t.%t" DB_CREATE_FILE_DEST = +dgroupA COMPATIBLE = 10.1.0.2.0 CONTROL_FILES = +dgroupA Which parameter would be ignored while starting up the instance for the database PROD?()A
DB_BLOCK_SIZEB
CONTROL_FILESC
LARGE_POOL_SIZED
LOG_ARCHIVE_DESTE
LOG_ARCHIVE_FORMATF
DB_CREATE_FILE_DEST
考题
单选题In an Oracle 10g database, the in/x7fmemory statistics are gathered at regular intervals and used to perform growth/x7ftrend analysis and capacity planning of the database. Which component stores these statistics?()A
recovery catalogB
Oracle Enterprise Manager RepositoryC
Automatic Workload Repository (AWR)D
Oracle 10g Enterprise Manager Grid ControlE
Automatic Database Diagnostic Monitor (ADDM)
考题
单选题You are managing a single instance Oracle 10g database that utilizes the following parameters: Which of the following set of commands must you execute to enable Flashback Database?()A
STARTUP MOUNT EXCLUSIVE ALTER DATABASE FLASHBACK ON; ALTER DATABASE OPEN;B
STARTUP MOUNT ALTER DATABASE FLASHBACK ON; ALTER DATABASE OPEN RESETLOGS;C
STARTUP MOUNT EXCLUSIVE ATLER DATABASE ARCHIVELOG; ALTER DATABASE FLASHBACK ON; ALTER DATABASE OPEN RESETLOGS;D
STARTUP MOUNT ALTER DATABASE ARCHIVELOG; ALTER DATABASE FLASHBACK ON; ALTER DATABASE OPEN;
考题
单选题At the end of the financial year, an accounts accumulation batch is run. This batch updates the company’s accounting records. During the batch run process, some incorrect entries were inserted into the ACCOUNT table. You identified the bug and immediately stopped the batch run process, but 3000 incorrect records were inserted into the ACCOUNT table before the batch process was stopped. You want to recover the table to the state it was at 11:50 P.M. Which flashback feature will you use?()A
Flashback DropB
Flashback DatabaseC
Flashback TableD
Flashback Version Query
考题
多选题You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter in the parameter file to YYYY/x7fMM/x7fDD. The default format of which two data types would be affected by this setting?()ADATEBTIMESTAMPCINTERVAL YEAR TO MONTHDINTERVAL DAY TO SECONDETIMESTAMP WITH LOCAL TIME ZONE
考题
单选题You lost a temporary file that belongs to the default temporary tablespace in your database. From the options provided, which approach would you take to solve the problem?()A
flash back the databaseB
import the temporary tablespace from the last exportC
restore all the data files and temporary files from the last full database backup and perform a recoveryD
not perform a recovery, but create a new temporary tablespace, make it the default temporary tablespace and then drop the old tablespace
考题
单选题n 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-ASM instance to an ASM instance?()A
Oracle Migration AssistantB
Recovery Manager (RMAN)C
Oracle Data Pump Export and ImportD
conventional Oracle Export and ImportE
operating system utilities to copy the files to the ASM instance
考题
单选题You are migrating your production database from non-ASM to ASM storage. You used the RMAN utility to migrate the database from non-ASM to ASM storage. Which type of backup command script will you use for migrating the database from non-ASM to ASM storage?()A
BACKUP AS BACKUPSETB
BACKUP AS COPYC
BACKUP AS COMPRESSED BACKUPSETD
BACKUP INCREMENTAL LEVEL n CUMULATIVE
考题
单选题In your datawarehousing application, you generate reports frequently. The data is static in the tables being used to generate reports. You are currently using joins, resulting in a large performance overhead. What kind of database structure would you use to reduce the response time of the query?()A
hash clustersB
index clustersC
partitioned tablesD
indexorganized table (IOT)
考题
单选题Every Sunday, consistent backups are performed on your database. Because of a user error, you performed an incomplete recovery on Tuesday and opened the database with the RESETLOGS option. A user error occurs again on Thursday, which necessitates an incomplete recovery. Sunday’s backup is the most recent backup available. What would you do in this scenario?()A
recovery cannot be performed because a backup was not performed after the last incomplete recoveryB
restore all the files from Sunday’s backup, and then perform an incomplete recovery up to the point in time when the user error occurred on ThursdayC
restore all the files from Sunday’s backup, and then recover up to the point in time when the RESETLOGS operation was performed on TuesdayD
restore all the files from Sunday’s backup, and open the database to reset the database to the point in time when the backup was performed on Sunday
考题
单选题Your database contains a temporary tablespace, index tablespace, undo tablespace, and a read-only tablespace apart from the SYSTEM and SYSAUX tablespaces. If a media failure occurs resulting in the loss of any of these tablespaces, which tablespace is NOT required for the database to start?()A
undo tablespaceB
index tablespaceC
read-only tablespaceD
temporary tablespace
考题
单选题You are using an Automatic Storage Management (ASM) instance to manage the files of your production database. While studying the parameter file of the ASM instance, you find the following entry: ASM_DISKSTRING = /devices/* What could be the reason for this setting?()A
to enable the ASM instance to identify the alert log fileB
to enable the ASM instance to identify the server parameter fileC
to enable the ASM instance to define the locations for Oracle Managed Files (OMF)D
to enable the ASM instance to identify all disks that can be accessed by it in the /devices directory
考题
单选题You are performing the shrink operation on the SCOTT.EMP table. You want to perform the same operation on all dependent objects of the SCOTT.EMP table. What is NOT a prerequisite for the operation?()A
You must enable the row movement on the SCOTT.EMP table.B
You must define the tablespace of the SCOTT.EMP table for automatic segment space management.C
You must use the CASCADE clause in the ALTER TABLE SHRINK SPACE statement.D
You must use the COMPACT clause in the ALTER TABLE SHRINK SPACE statement.
考题
多选题You are connected to Recovery Manager (RMAN) without a recovery catalog. There is no copy of the control file available. You want to restore the control file from an autobackup. To retrieve the autobackup, you need the database ID (DBID). In which two sources would you find the DBID? ()Athe alert log fileBthe server parameter fileCthe formatted name of a control file autobackupDan RMAN session log fileEthe trace file
热门标签
最新试卷