单选题 User A executes the following command to drop a large table in your database: SQL> DROP TABLE trans; While the drop table operation is in progress, user B executes the following command on the same table: SQL> DELETE FROM trans WHERE tr_type=’SL’; Which statement is true regarding the DELETE command()
It fails with a Resource Busy error.
It deletes the rows successfully because the table is locked in SHARE mode.
It fails to delete the records because the table is locked in EXCLUSIVE mode.
It deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode.
单选题 You want to check the details of few errors that users have reported. You search for the alert log file andexecute few commands to find the location of the alert log file. View the Exhibit and check the commandsexecuted. What is the location of the alert_orcl.log file()
ORACLE_HOME/dbs
ORACLE_HOME/rdbms
/u01/app/oracle/admin/orcl/adump
/u01/app/oracle/flash_recovery_area
ORACLE_BASE/diag/rdbms/orcl/orcl/alert
ORACLE_BASE/diag/rdbms/orcl/orcl/trace
多选题 You set the following parameters in the parameter file and restarted the database:MEMORY_MAX_TARGET=0MEMORY_TARGET=500M PGA_AGGREGATE_TARGET=90MSGA_TARGET=270M Which two statements are true about these parameters after the database instance is restarted()
The MEMORY_MAX_TARGET parameter is automatically set to 500 mb.
The pga_AGGREGATE_TARGET and sga_TARGET parameters are automatically set to zero.
The value of the MEMORY_MAX_TARGET parameter remains zero until it is changed manually.
The lower bounds of pga_AGGREGATE_TARGET and sga_TARGET parameters are set to 90 nb and270 mb, respectively
多选题 Which two statements describe good practices for an application developer to reduce lockingconflicts in Oracle database()
Avoid coding unnecessary long-running transactions.
Allow the database to handle locks in default locking mode.
Always explicitly code the locks as per the requirement of the application.
Allow escalation of row locks to block locks if too many row locks cause problem.
单选题 ou are in the middle of a transaction updating a very important table. The machine on which adatabase was running reboots because of power outage. This caused a database instance failure. Which statement is true in this situation()
The online redo log files and archived redo log files are required to accomplish the recovery.
The uncommitted transaction will be committed at the next startup of the database instance.
The uncommitted transaction is rolled back automatically at the next opening of the database.
The DBA has to perform the recovery on the database to recover the uncommitted transaction.
单选题 Examine the commands executed in the following sequence: 1:SQL> CREATE ROLE mgrrole; 2:SQL> GRANT create user,select any table,connect,resource TO mgrrole; 3:SQL> GRANT select,update ON sh.sales TO mgrrole; 4:SQL> CREATE ROLE ceo IDENTIFIED BY boss; 5:SQL> GRANT mgrrole,drop any table,create any directory TO ceo; 6:SQL> GRANT ceo TO mgrrole; Which statement is true about the above commands()
The commands execute successfully.
Command 6 produces an error because of circular role grant.
Command 5 produces an error because a role cannot be granted to another role.
Command 3 produces an error because the MGRROLE role already contains system privileges.
The table created by HR remains and HR still has the CREATE TABLE system privilege.
The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.
多选题 You are managing an Oracle Database 11g database. The database is open, and you plan to perform Recovery Manager (RMAN) backups. Which three statements are true about these backups()
The backups would be consistent.
The backups would be inconsistent.
The backups would be possible only if the database is running in ARCHIVELOG mode.
The backups would be possible only if the database is running in NOARCHIVELOG mode.
The backups need to be restored and the database has to be recovered in case of a media failure
单选题 Which statement is true about the PCTFREE setting for the table()
It sets the minimum percentage of a data block to be reserved to contain chained rows from other blocks.
It sets the minimum percentage of a data block to be reserved as free space before the server prevents inserts into the block.
It sets the minimum percentage of a data block to be reserved to contain the bitmap used to maintain the free block information.
It sets the minimum percentage of a block that can be used for row data plus overhead before new rows are added to the block.
单选题 You used the IMMEDIATE option to shut down your database instance. Consider the steps that mayoccur when a database instance is started and database is opened: 1:SGA is allocated. 2:Control file is read. 3:Redo log files are opened. 4:Instance recovery is started. 5:Background processes are started. 6:Data file headers are checked for consistency. 7:Server parameter file or the initialization parameter file is read. Which option has the correct order in which these steps occur()
7,1,5,2,3,6,4
1,5,7,2,3,6;step 4 is not required
7,1,5,2,3,6;step 4 is not required
1,2,3,5,6,4;step 7 is not required
在任何情况下,伸缩调节器处轨距的要求为()。
人类有两套影响学习的记忆系统:陈述性记忆和程序记忆。陈述性记忆是对事实或者词汇之类基本认识的记忆。而程序记忆,就是一个人“不劳而获”的记忆。程序记忆是人养成习惯和习得技巧的方式,比如骑自行车。在很多时候,这种学习是无意识的。人们用早期发育的程序记忆系统来学习复杂的东西,比如语法规则。帮助人们学习词汇的陈述性记忆系统,则需要更多时问完成发育。儿童拥有程序记忆系统,并且不受陈述性记忆系统的干扰。由此可以推出()。
宋末元初四大家
公平目标的实现可以通过()实现。
荟萃分析
人员安全疏散分析的性能判定标准为:可用疏散时间(A.SET)必须()必需疏散时间(RSET)。
预防HIV感染的主要措施应当为( )
简述我国混合型债券市场的发展状况。
造成水中某些污染物在生物体内含量大大高于水体中的浓度的生物放大作用是指()
输血的适应证中,不包括()