in your database instance, the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impactof this setting()
相似题目
-
You work as a database administrator for Certkiller .com. In the middle of a transaction, a user session was abnormally terminated but the instance is still up and the database is open. Which two statements are true in this scenario?()
-
The SQL Tuning Advisor configuration has default settings in your database instance. Which recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task?()
-
Your database is open and the LISTENER listener is running. The new DBA of the system stops thelistener by using the command: LSNRCTL> STOP What happens to the sessions that are presently connected to the database instance()
-
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 nonASM instance to an ASM instance?()
-
Your database is open and the LISTENER listener running. You stopped the wrong listener LISTENER byissuing the following command:lsnrctl > STOPWhat happens to the sessions that are presently connected to the database Instance?()
-
Your database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started. Which tool or utility would you use to start the listener?()
-
You are managing an Oracle Database 11g instance and an Oracle Database 10g instance on the same machine. Both instances use the ASM instance as storage. Which statement regarding the ASM disk group compatibility attributes are true in this scenario?()
-
Your database is open and the LISTENER listener is running. The new DBA of the system stops the listener byusing the command:LSNRCTL> STOP What happens to the sessions that are presently connected to the database instance()
-
Observe the following warning in an RMAN session of your database instance: WARNING: new failures were found since last LIST FAILURE command Which statement describes the scenario that must have produced this warning?()
-
You work as a database administrator for Supportcenter.cn. On a Monday morning, you find the database instance aborted. After inspecting the alert log file, you execute the STARTUP command in SQL*Plus to bring the instance up. What statement is true?()
-
The SQL Tuning Advisor has been configured with default configurations in your database instance. Which recommendation is automatically implemented without the DBA's intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework?()
-
You configured the Flash Recovery Area for your database. The database instance has been started inARCHIVELOG mode and the LOG_ARCHIVE_DEST_1 parameter is not set. What will be the implications onthe archiving and the location of archive redo log files()
-
You configure your database Instance to support shared server connections.Which two memory areas that are part of PGA are stored in SGA instead, for shared server connection?()
-
The SQL Tuning Advisor has been configured with default configurations in your database instance. Which recommendation is automatically implemented without the DBA’s intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework?()
-
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? ()
-
The SQL Tuning Advisor configuration has default settings in your database instance. Which recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task?()
-
Your database instance is running.You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener?()
-
You want to set the following initialization parameters for your database instance: https://assets.asklib.com/images/image2/2018080214463923133.jpg Identify the statement that correctly describes this setting.()
-
Observe the following warning in an RMAN session of your database instance: WARNING: new failures were found since last LIST FAILURE command Which statement describes the scenario that must have produced this warning?()
-
You work as a database administrator for Certkiller .com. On a Monday morning, you find the database instance aborted. After inspecting the alert log file, you execute the STARTUP command in SQL*Plus to bring the instance up. What statement is true?()
-
In your database instance, the STATISTICS_LEVEL initialization parameter is set to BASIC. What isthe impact of this setting()
-
You set the following parameters in the parameter file and restarted the database:Which two statements are true regarding these parameters after the database instance is restarted?()
-
The SQL Tuning Advisor has been configured with default configurations in your database instance.Which recommendation is automatically implemented without the DBA‘s intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework?()
-
Examine the parameters for your database instance:Which three statements are true about the process of automatic optimization by using cardinalityfeedback?()
推荐题目
- 机车弹簧悬挂装置的作用之一是:当机车通过钢轨接头、道岔等线路不平顺处或动轮踏面有缺陷(如擦伤、剥离)发生冲击振动时,弹簧装置可()对机车的冲击。
- 一般来说,信用等级最高的债券是()。
- 根据《飞猪规则》,商家严重违规扣分累计达四十八分节点的,给予()处理。
- 力区的距离应该是前后各为()。
- 科学创造的思维在科学活动中表现为思维运动中的()的中断或飞跃,当这种研究已成为科学结论时,也就找到了充分的逻辑根据和经验的根据。
- 铅冶炼在焙烧过程中的七不准是什么?
- 应用胰岛素控制血糖的糖尿病患者,一般就餐时间是在注射胰岛素后()
- 液压系统的传动介质是()。
- 简述备餐间的作用?
- 关于电影《精武英雄》说法错误的是: