违法和不良信息举报 联系客服
免费注册 登录

Users in your production database complain that they are get

题目
多选题
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

如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

多选题
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？（）
A

the alert log file

B

the core dump files

C

the change tracking file

D

the user session trace files

E

the database audit trail files

F

the background process trace files


正确答案： F,D
解析： 暂无解析

第2题：

多选题
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？ （）
A

The database opens normally.

B

The database prompts for a database recovery.

C

The database writer writes to a trace file， indicating that the temporary file is not found.

D

The database gets mounted and throws an error indicating that the temporary file requires recovery.


正确答案： D,C
解析： 暂无解析

第3题：

单选题
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.


正确答案： B
解析： 暂无解析

第4题：

单选题
Which component does the SQL Tuning Advisor NOT analyze for the SQL statements？（）
A

ADDM

B

AWR

C

Cursor Cache

D

SQL Tuning Sets

E

Flash Recovery Area


正确答案： C
解析： 暂无解析

第5题：

单选题
You issue the following RMAN command to set a retention policy on a database：       RMAN>CONFIGURE 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.


正确答案： A
解析： 暂无解析

第6题：

单选题
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：        RMAN>RESTORE DATABASE；        RMAN>RECOVER DATABASE；   After successfully executing these RMAN commands， you issue the following statement using SQL*Plus：        SQL>ALTER 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.


正确答案： A
解析： 暂无解析

第7题：

单选题
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_BASE

D

 The location set by using $ORACLE_HOME

E

 The location set by using CORE_DUMP_DEST

F

 The location set by using BACKGROUND_DUMP_DEST


正确答案： F
解析： 暂无解析

第8题：

单选题
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.


正确答案： A
解析： 暂无解析

第9题：

多选题
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？ （）
A

This operation resets the SCN for the database.

B

This operation creates a new incarnation of the database.

C

This operation moves all the redo log files to a different location.

D

This operation deletes the old redo log files and creates new redo log files.

E

This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.


正确答案： C,D
解析： 暂无解析

第10题：

单选题
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

 10M

B

 400M

C

 600M

D

 800M


正确答案： B
解析： 暂无解析

更多相关问题
相关内容