网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
You started a long transaction. Before committing， you executed a query on one of the tables currently being modified. You received the following error： ORA-01555： snapshot too old How would you prevent such an error in the future？（）
A
guarantee undo retention
B
add one more redo log group
C
size the redo log files appropriately
D
size the UNDO tablespace appropriately
E
size the SYSTEM tablespace appropriately
F
configure an appropriate undo retention interval
G
change automatic undo management to manual
参考答案
参考解析
解析：
暂无解析
更多 “多选题You started a long transaction. Before committing， you executed a query on one of the tables currently being modified. You received the following error： ORA-01555： snapshot too old How would you prevent such an error in the future？（）Aguarantee undo retentionBadd one more redo log groupCsize the redo log files appropriatelyDsize the UNDO tablespace appropriatelyEsize the SYSTEM tablespace appropriatelyFconfigure an appropriate undo retention intervalGchange automatic undo management to manual” 相关考题
考题
Examine the output of the query that you executed to list the objects in the recycle bin:You verified that no table named SALES_TAB exists in the schema. Then you executed the following command to purge the objects in the recycle bin:SQL PURGE TABLE sales_tab;What would be the outcome of this command?（）A. All three tables in the recycle bin are purgedB. Only the table with the oldest DROPSCN is purgedC. The command returns an error because multiple entries with the same name exist in the recycle binD. Only the table with the latest DROPSCN is purged
考题
You started a long transaction. Before committing， you executed a query on one of the tables currently being modified. You received the following error： ORA-01555： snapshot too old How would you prevent such an error in the future？（）A、guarantee undo retentionB、add one more redo log groupC、size the redo log files appropriatelyD、size the UNDO tablespace appropriatelyE、size the SYSTEM tablespace appropriatelyF、configure an appropriate undo retention intervalG、change automatic undo management to manual
考题
You work as a database administrator for Supportcenter.cn. When you tried to connect to the database， you received the following error： ERROR： ORA-12541：TNS：no_listener You found that the listener is not running on the server， so you issued the following command in the Listener Control utility to start the listener. lsnrctlSTART What statement is true？（）A、It would attempt to start the default listenerB、It would start the most recently created listener.C、It would display an error with a message asking for the listener name to be specified.D、It would show you a list of listeners and prompts for the listener name that you want to start.
考题
You executed the following command to start the database： SQL STARTUP ORACLE instance started. Total System Global Area 281018368 bytes Fixed Size 789000 bytes Variable Size 229635576 bytes Database Buffers 50331648 bytes Redo Buffers 262144 bytes ORA-00205： error in identifying controlfile， check alert log for more info Which view would you query at this stage to investigate this missing control file？（）A、V$INSTANCEB、V$CONTROLFILEC、DBA_CONTROL_FILESD、V$DATABASE_PROPERTIESE、V$CONTROLFILE_RECORD_SECTION
考题
While running long running queries， you receive the Snapshot too old error. Which advisor can help you to avoid the Snapshot too old error？（）A、 Memory AdvisorB、 Segment AdvisorC、 Undo AdvisorD、 SQL Tuning Advisor
考题
Users notify you that their application is failing every time they try to add new records. Because of poor application design， the actual ORA error message is unavailable. What might be the problem？（）A、 The application user has exceeded their undo quota.B、 The FLASHBACK GUARANTEE option is set on the undo tablespace.C、 The table is currently being queried by a Flashback Transaction Query operation.D、 The table is currently being queried by a Flashback Versions Query operation.E、 The RETENTION GUARANTEE option is set on the undo tablespace.
考题
What are two reasons to create synonyms? （）A、You have too many tables.B、Your tables are too long.C、Your tables have difficult names.D、You want to work on your own tables.E、You want to use another schema's tables.F、You have too many columns in your tables.
考题
When you try to open your database， you receive the following error： ORA-00205： error in identifying control file Where would you find the details required to resolve this error？（）A、audit trailB、alert log fileC、user trace fileD、online trace fileE、background trace fileF、operating system event viewer
考题
You work as a database administrator for Supportcenter.cn. You received the following error while working on your database： ORA-01555： snapshot too old ，In which situation would you receive such an error？（）A、You performed rollback after commit.B、If a log switch occurs in your database.C、Thearchiverfails to generate an archived log file.D、Instance recovery fails to find one of the redo log files.E、A long-running query is unable to get read-consistent image.F、If you perform manual undo management operations in auto mode.
考题
You work as a database administrator for Supportcenter.cn. You decided to manage client and server connections using Local Naming method in Supportcenter.cn. When you try to connect to the database you get the following error： ERROR： ORA-12154：TNS：couldnot resolve service name Which network configuration files would you look into to resolve this error？（）A、snmp.oraB、names.oraC、spfile.oraD、sqlnet.oraE、listener.oraF、tnsnames.ora
考题
Your database is in ARCHIVELOG mode. You lost an index tablespace due to a disk failure while the database was open. You have neither a backup of the lost index tablespace nor the scripts containing the CREATE INDEX statements to recreate the indexes. Currently， several users are executing long-running queries on the database. What will happen to the ongoing activity in the database？（）A、 The queries that are currently executing will abort and an error message will be returned to the user.B、 The queries that are currently executing will execute normally but future queries will not executed.C、 Data Manipulation Language （DML） statements cannot be performed on the tables on which the indexes are based.D、 The currently executing and future queries will execute normally， but will be slower
考题
You are developing a tax report for the payroll application. You created a before parameter form report trigger to create three temporary tables to store text that are need while the report is executed. Which report trigger would you use to delete these temporary tables?（）A、Before parameter form. B、After parameter form. C、Before report. D、After report.
考题
You received the following error： ORA-01578： ORACLE data block corrupted （file # %s， block # %s） Which file will you check to view additional information regarding the cause of this error？（）A、the alert log file and the trace filesB、 the redo log filesC、 the control fileD、 the change tracking file
考题
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）
考题
You have two databases， FINDB and PAYDB， on single operating system and using Optimal Flexible architecture （OFA）. FINDB is functional and is currently being accessed by the users. While starting up the instance for the PAYDB database you get the following error： ORA-01081： cannot start - already running ORACLE - shut it down first Which environmental variable would you set before starting up the PAYDB database to overcome this error？（）A、ORA_PATHB、ORACLE_SIDC、ORACLE_BASED、ORACLE_HOMEE、LD_LIBRARY_PATH
考题
单选题Your database is in ARCHIVELOG mode. You lost an index tablespace due to a disk failure while the database was open. You have neither a backup of the lost index tablespace nor the scripts containing the CREATE INDEX statements to recreate the indexes. Currently， several users are executing long-running queries on the database. What will happen to the ongoing activity in the database？（）A
The queries that are currently executing will abort and an error message will be returned to the user.B
The queries that are currently executing will execute normally but future queries will not executed.C
Data Manipulation Language （DML） statements cannot be performed on the tables on which the indexes are based.D
The currently executing and future queries will execute normally， but will be slower
考题
单选题You want a record of all queries that are not using indexes. How would you achieve this?（）A
By enabling the Slow Query Log because all queries that are not using indexes will be logged automaticallyB
By enabling the Error Log because not using indexes is an errorC
By enabling the Slow Query Log and using the – log-queries-not-using-indexes optionD
By enabling the Error Log and using the – log-queries-not-using-indexes option
考题
单选题When you try to open your database， you receive the following error： ORA-00205： error in identifying controlfile Where would you find the details required to resolve this error？（）A
audit trailB
alert log fileC
user trace fileD
online trace fileE
background trace fileF
operating system event viewer
考题
多选题You work as a database administrator for Certkiller .com. You decided to manage client and server connections using Local Naming method in Certkiller .com. When you try to connect to the database you get the following error： ERROR： ORA-12154：TNS：couldnot resolve service name Which network configuration files would you look into to resolve this error？（）Asnmp.oraBnames.oraCspfile.oraDsqlnet.oraElistener.oraFtnsnames.ora
考题
单选题While running long running queries， you receive the Snapshot too old error. Which advisor can help you to avoid the Snapshot too old error？（）A
Memory AdvisorB
Segment AdvisorC
Undo AdvisorD
SQL Tuning Advisor
考题
单选题You work as a database administrator for Supportcenter.cn. When you tried to connect to the database， you received the following error： ERROR： ORA-12541：TNS：no_listener You found that the listener is not running on the server， so you issued the following command in the Listener Control utility to start the listener. lsnrctlSTART What statement is true？（）A
It would attempt to start the default listenerB
It would start the most recently created listener.C
It would display an error with a message asking for the listener name to be specified.D
It would show you a list of listeners and prompts for the listener name that you want to start.
考题
单选题You work as a database administrator for Certkiller .com. You received the following error while working on your database： ORA-01555： snapshot too old In which situation would you receive such an error？（）A
You performed rollback after commit.B
If a log switch occurs in your database.C
Thearchiverfails to generate an archived log file.D
Instance recovery fails to find one of the redo log files.E
A long-running query is unable to get read-consistent image.F
If you perform manual undo management operations in auto mode.
考题
单选题You have two databases， FINDB and PAYDB， on single operating system and using Optimal Flexible architecture （OFA）. FINDB is functional and is currently being accessed by the users. While starting up the instance for the PAYDB database you get the following error： ORA-01081： cannot start - already running ORACLE - shut it down first Which environmental variable would you set before starting up the PAYDB database to overcome this error？（）A
ORA_PATHB
ORACLE_SIDC
ORACLE_BASED
ORACLE_HOMEE
LD_LIBRARY_PATH
考题
单选题View the Exhibit and examine the highlighted alert. You have received an alert with the Category specified as Snapshot Too Old. Which page would you open from the Advisor Central page to determine the system recommendations to avoid such alerts in future?（）A
ADDM B
Memory Advisor C
Segment Advisor D
Undo Management E
SQL Tuning Advisor F
SQL Access Advisor
考题
多选题Users notify you that their application is failing every time they try to add new records. Because of poor application design， the actual ORA error message is unavailable. What might be the problem？（）AThe application user has exceeded their undo quota.BThe FLASHBACK GUARANTEE option is set on the undo tablespace.CThe table is currently being queried by a Flashback Transaction Query operation.DThe table is currently being queried by a Flashback Versions Query operation.EThe RETENTION GUARANTEE option is set on the undo tablespace.
考题
多选题You started a long transaction. Before committing， you executed a query on one of the tables currently being modified. You received the following error： ORA-01555： snapshot too old How would you prevent such an error in the future？（）Aguarantee undo retentionBadd one more redo log groupCsize the redo log files appropriatelyDsize the UNDO tablespace appropriatelyEsize the SYSTEM tablespace appropriatelyFconfigure an appropriate undo retention intervalGchange automatic undo management to manual
考题
多选题A user receives the following error while executing a query： ORA/x7f01555：snapshot too old Which two options can be the solutions to avoid such errors in future？（）Aincrease the size of redo log filesBincrease the size of the undo tablespaceCincrease the size of the Database Buffer CacheDincrease the size of the default temporary tablespaceEenable the retention guarantee for the undo tablespace
热门标签
最新试卷