多选题 Which three statements are true regarding the fine/x7fgrained auditing (FGA)?()
FGA is possible on SELECT statements only.
The audit trail for FGA is stored in the FGA_LOG$ table.
The audit trail for FGA is stored in the AUD_LOG$ table.
FGA enables a SQL predicate to define when to audit an event.
FGA audits DELETE statements only when audit columns are specified.
FGA includes the SQL statement used by the user as part of the audit event entry.
多选题 Which two statements are true about a bitmap index? ()
It is recommended for the columns that have unique values.
It can be converted to a B-tree index by using the ALTER INDEX command.
It has a bitmap segment for each distinct value in the key column, containing a string of bits in which each bit represents the presence or absence of a key column value.
Updating the key column locks the whole bitmap segment that contains the bit for the key value to be updated.
多选题 You work as a database administrator for Certkiller .com. You want to create your database with the automatic undo management feature enable.Which two tasks must you perform to achieve this?()
Set the UNDO_RETENTION parameter to AUTO.
Create an initial undo segment in undotablespace.
Set the UNDO_RETENTION parameter to 900 or more
Set the initialization parameter UNDO_MANAGEMENT to AUTO
Set the UNDO_MANAGEMENT parameter to the name of an undotablespace
多选题 You work as a database administrator for Certkiller .com. You have set the retention period for Automatic Repository (AWR) statistics to four days and collection interval to 15 minutes. You want to view the statistics collected and stored in AWR snapshot. Which two methods would you use to view the AWR statistics?()
use enterprise manager
use DBMS_SQL package
use DBMS_AWR package
use PRVT_WORKLOAD package
query the AWR snapshot repository objects
use DBMS_WORKLOAD_REPOSITORY package
多选题 You are working on a test database where instance recovery takes a considerable amount of time.How can reduce the recovery time?()
By multiplexing the control files
By multiplexing the redo log files
By decreasing the size of redo log files
By configuring mean time to recover (MTTR) to a lower value
By setting the UNDO_RETENTION parameter to a higher value
单选题 You work as a database administrator for Certkiller .com. As a result of performance analysis, you created an index on theprod_namecolumn of the Certkiller prodtable, which contains about ten thousand rows. Later, you updated a product name in the table. How does this change affect the index?()
A leaf will be marked as invalid.
An update in a leaf row takes place.
The index will be updated automatically at commit.
A leaf row in the index will be deleted and inserted.
The index becomes invalid when you make any updates
多选题 You work as a database administrator for Supportcenter.cn. Your listener process, L1, is currently listening to three databases: CertK INDB04, SupportCenter DB05 and SupportCenter DB06. Using Database Configuration Assistant (DBCA) you create one more database, SupportCenter DB07, and enable dynamic registration. Which two commands of Listener Control Utility (lsnrct1) would you use to determine whether the dynamic registration occurred for the database, SupportCenter DB07, with the L1 listener process?()
SHOW L1
SPAWN L1
STATUS L1
SERVICES L1
STATUS LISTENER
SERVICES LISTENER
SHOWcurrent_listener
单选题 The operating system filecratabin the Linux platform gets updated whenever you create a new database on the same host machine. What kind of information is stored is stored in this file?()
OracleSIDsonly
Oracle homes only
Oracle install timestamp
Oracle inventory pointer files
Oracle database creation timestamp
OracleSIDsand Oracle homes only
OracleSIDs, Oracle homes and flag for auto startup
单选题 While setting up an Oracle database for one of your critical applications, you want to ensure that the database is backed up at regular intervals without your intervention.What should you do to achieve the objective?()
configure the database to run in ARCHIVELOG mode
configure the Flash Recovery Area to enable automatic database backup
schedule the database backup using DBMS_JOB package after creating the database
schedule the database backup using Recovery Manager (RMAN)commands after creating the database
schedule the database backup using Database Configuration Assistant (DBCA)while creating the database
单选题 You work as a database administrator for Certkiller .com. In the Certkiller PRODUCTION database you have granted RESUMABLE system privilege to the CONNECT role.Resumablespace operation has been enabled for all user session. You want users NOT to be aware of any kind of space-related problems while performing transactions. Instead, you want the problem to be resolved by a database trigger automatically. Which combination of triggering time and event would you use to achieve this objective?()
AFTER CREATE
AFTER SUSPEND
BEFORE CREATE
AFTER TRUNCATE
BEFORE SUSPEND
AFTER INSERT OR DELETE OR DELETE
BEFORE INSERT OR DELETE OR DELETE
在任何情况下,伸缩调节器处轨距的要求为()。
人类有两套影响学习的记忆系统:陈述性记忆和程序记忆。陈述性记忆是对事实或者词汇之类基本认识的记忆。而程序记忆,就是一个人“不劳而获”的记忆。程序记忆是人养成习惯和习得技巧的方式,比如骑自行车。在很多时候,这种学习是无意识的。人们用早期发育的程序记忆系统来学习复杂的东西,比如语法规则。帮助人们学习词汇的陈述性记忆系统,则需要更多时问完成发育。儿童拥有程序记忆系统,并且不受陈述性记忆系统的干扰。由此可以推出()。
宋末元初四大家
公平目标的实现可以通过()实现。
荟萃分析
人员安全疏散分析的性能判定标准为:可用疏散时间(A.SET)必须()必需疏散时间(RSET)。
预防HIV感染的主要措施应当为( )
简述我国混合型债券市场的发展状况。
造成水中某些污染物在生物体内含量大大高于水体中的浓度的生物放大作用是指()
输血的适应证中,不包括()