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

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 your multitenant container database (CDB) containing pluggable databases (PDB), users complain about performance degradation.How does real-time Automatic database Diagnostic Monitor (ADDM) check performance degradation and provide solutions?（）

A. It collects data from SGA and compares it with a preserved snapshot.

B. It collects data from SGA, analyzes it, and provides a report.

C. It collects data from SGA and compares it with the latest snapshot.

D. It collects data from both SGA and PGA, analyzes it, and provides a report


参考答案：B

第2题：

You realize that the control file is damaged in your production database.After restoring the control file from autobackup, what is the next step that you must do to proceed with the database recovery?（）

  • A、Mount the database
  • B、Open the database in NORMAL mode
  • C、Open the database in RESTRICTED mode
  • D、Open the database with the RESETLOGS option

正确答案:A

第3题：

You realize that the control file is damaged in your production database.After restoring the control file from autobackup, what is the next step that you must do to proceed with the database recovery?（）

A. Mount the database

B. Open the database in NORMAL mode

C. Open the database in RESTRICTED mode

D. Open the database with the RESETLOGS option


参考答案：A

第4题：

There is a problem with one of the disks used for your database and your system administrator informs you that the disk needs to be replaced. The replacement disk will not be available until tomorrow.  There was only one data file on this disk； it belongs to the USERS tablespace in your PROD database. Your PROD database runs in ARCHIVELOG mode and nightly online backups are taken. The users need to be able to access the data in the USERS tablespace before the replacement disk arrives. You have already taken the USERS tablespace offline and have restored the data file from last night’s backup to a new disk. Which additional steps are required in order to make the USERS tablespace available？（）

  • A、Only bring the tablespace back online.
  • B、Only recover the tablespace and then bring the tablespace back online.
  • C、Shut down the database， recover the data file and then start up the database.
  • D、Issue the ALTER DATABASE RENAME FILE command， recover the tablespace， and then bring the tablespace online.
  • E、Recover the tablespace， issue the ALTER DATABASE RENAME FILE command， and then bring the tablespace online.

正确答案:D

第5题：

You work as a database administrator for Supportcenter.cn. In a production environment， users complain about the slow response time when accessing the database. You have not optimized the memory usage of the Oracle instance and you suspect the problem to be with the memory. To which type of object would you refer to determine the cause of the slow response？（）

  • A、The trace file
  • B、The fixed views
  • C、The data dictionary views
  • D、The operating system log fields
  • E、The dynamic performance views.

正确答案:E

第6题：

You executed the following command in the lsnrctl utility to stop the listener： lsnrctl> STOP L1  What is the effect of this command if L1 is the only listener configured for your database？（）

  • A、It terminates all user sessions.
  • B、It prevents users from logging in to the database remotely.
  • C、It halts the server until all user transactions are completed.
  • D、The server hangs， so users will receive an error asking them to login again.
  • E、Connected users would get an error with the message "End of communication channel".

正确答案:B

第7题：

Your database is in NOARCHIVELOG mode. You start to do a backup， but your users complain that they dont want you to shut down the database to perform the backup. What options are available to you？（）  

  • A、 Put the database in hot backup mode and perform an online backup，including backing up the  archived redo logs.
  • B、 Just back up the database datafiles without shutting down the database.
  • C、 You will have to wait until you can shut down the database to perform the backup.
  • D、 Mark each datafile as backup in progress， back them up individually，and then mark them as backup not in progress. No archived redo logs will need to be backed up.
  • E、 Only back up the datafiles that the user will not be touching. Once the user has finished what they were doing，you can shut down the database and back up the datafiles the user changed during the  course of the remaining backup

正确答案:C

第8题：

You are using a recovery catalog to maintain Recovery Manager (RMAN) backup information for yourproduction database. You have registered your production database and are performing regular backups.Because of a new requirement you have added a few new tablespaces to your production database and youwant them to be included in backups.Identify two options for completing this task. （）(Choose two.)

A. Reregistering the target database in recovery catalog

B. Transporting the new tablespaces to the recovery catalog database

C. Syncronizing the recovery catalog with the target database control file

D. Performing a fresh backup of the target database to include the new data files in the catalog database


参考答案：C, D

第9题：

Your production database uses an Automatic Storage Management （ASM） instance to manage its files.  You want to add a new disk group to the ASM instance to manage the increased data load.  What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users？（）

  • A、mount the new disk group in the ASM instance
  • B、restart the ASM instance and the production database instance
  • C、register the new disk groups in the production database instance
  • D、restart the ASM instance without restarting the production database instance
  • E、include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance

正确答案:A

第10题：

单选题
There is a problem with one of the disks used for your database and your system administrator informs you that the disk needs to be replaced. The replacement disk will not be available until tomorrow.  There was only one data file on this disk； it belongs to the USERS tablespace in your PROD database. Your PROD database runs in ARCHIVELOG mode and nightly online backups are taken. The users need to be able to access the data in the USERS tablespace before the replacement disk arrives. You have already taken the USERS tablespace offline and have restored the data file from last night’s backup to a new disk. Which additional steps are required in order to make the USERS tablespace available？（）
A

Only bring the tablespace back online.

B

Only recover the tablespace and then bring the tablespace back online.

C

Shut down the database， recover the data file and then start up the database.

D

Issue the ALTER DATABASE RENAME FILE command， recover the tablespace， and then bring the tablespace online.

E

Recover the tablespace， issue the ALTER DATABASE RENAME FILE command， and then bring the tablespace online.


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

更多相关问题
相关内容