单选题
You have forgotten the root user account password. You decide to reset the password and execute the following: Shell＞ /etc/init.d/mysql stop Shell＞ /etc/init.d/mysql start – skip-grant tables Which additional argument makes this operation safer?（）
–skip-networking, to prohibit access from remote locations
–reset-grant-tables, to start the server with only the mysql database accessible
–read-only,to set all data to read-only except for super users
–old-passwords, to start Mysql to use the old password format while running without the grant tables
单选题
You adjust a default configuration to the following /etc/my.cnf on a Linux installation:[mysqld] Loq-bin Binrylog_format=ROW You do not notice the spelling error in binrylog_format and restart your production server. How does the MySQL server behave with incorrectly spelled options?（）
Mysqld uses internal configuration versioning and reverts to the previous configuration
When using mysql_config_editor for configuration adjustments, it detects incorrect syntax and typing mistakes
The mysqld_safe script skips the unknown variable and starts using the remaining configuration changes
Mysqld prints to the error log about an unknown variable, and then exits
单选题
A simple master-to-slave replication is currently being used. The following information is extracted from the SHOW SLAVE STATUS output: Last_SQL_Error: Error 'Duplicate entry '8' for key 'PRIMARY' ' on query. Default database: 'mydb'. Query: 'insert into mytable VALUES ('8' , 'George') ' Skip_Counter: 0 Retrieved _Gtid_Set: 38f32e23480a7-32a1-c323f78067fd37821: 1-8 Auto _Position: 1 You execute a "SHOW CREATE TABLE mytable" on the slave: CREATE TABLE 'mytable' ( 'ID' int(11) NOT NULL DEFAULT '0', 'name' char(10) DEFAULT NULL, PRIMARY KEY ('ID') ) The table mytable on the slave contains the following:
You have issued a STOP SLAVE command. One or more statements are required before you can issue a START SLAVE command to resolve the duplicate key error. Which statement should be used?（）
SET GTID_NEXT="CONSISTENCY"; BEGIN; COMMIT; SET GTID_NEXT="AUTOMATIC"
SET GLOBAL enforce_gtid_consistency=ON
SET GTID_EXECUTED="38f32e23480a7-32a1-c323f78067fd37821 : 9"
SET GTID_NEXT="38f32e23480a7-32a1-c323f78067fd37821 : 9"; BEGIN; COMMIT; SET GTID_NEXT="AUTOMATIC"
SET GLOBAL SQL_SKIP_SLAVE_COUNTER=1
单选题
Oracle创建（）来处理连接到实例的用户进程的请求。
服务器进程
SGA
应用程序代码
网络服务进程
单选题
如果经常执行类似于下面的查询语句SELECT * FROM STUDENT where substr(sname,0,2)=’陈’，应该为STUDENT表的SNAME列创建（）索引。
B树唯一索引
B树不唯一索引
基于函数的索引
位图索引
单选题
采用Select语句返回的结果是一个结果集。用户只能浏览该结果集中的数据，无法对数据进行操作。如果需要逐行对数据进行访问和操作，可以使用（）。
视图
过程
函数
游标
单选题
You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB) as a pluggable database (PDB). The characteristics of the non-CDB are as follows: -Version: Oracle Database 12c Releases 1 64-bit -Character set: WE8ISO8859P15 -National character set: AL16UTF16 -O/S: Oracle Linux 6 64-bit The characteristics of the CDB are as follows: -Version: Oracle Database 12c Release 1 64-bit -Character set: AL32UTF8 -O/S: Oracle Linux 6 64-bit Which technique should you use to minimize down time while plugging this non-CDB into the CDB?（）
Transportable database
Transportable tablespace
Data Pump full export / import
The DBMS_PDB package
RMAN
多选题
Which two statements are true when row archival management is enabled?（）
The ORA_ARCHIVE_STATE column visibility is controlled by the ROW ARCHIVAL VISIBILITY session parameter.
The ORA_ARCHIVE_STATE column is updated manually or by a program that could reference activity tracking columns, to indicate that a row is no longer considered active.
The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows only.
The ORA_ARCHIVE_STATE column is visible if referenced in the select list of a query.
The ORA_ARCHIVE_STATE column is updated automatically by the Oracle Server based on activity tracking columns, to Indicate that a row is no longer considered active.
单选题
Which statement is true concerning dropping a pluggable database (PDB)?（）
The PDB must be open in read-only mode.
The PDB must be in mount state.
The PDB must be unplugged.
The PDB data files are always removed from disk.
A dropped PDB can never be plugged back into a multitenant container database (CDB).
多选题
Indentify two advantages of using recovery catalog instead of the control file of the database in Recovery Manager (RMAN)？（）
You can use RMAN stored scripts
Recovery is faster if data is stored in catalog in addition to the control file
You can store backup information of all registered databases in one place
Database backups are automatically deleted when they are older than the specified time period
推荐考题
-
在任何情况下，伸缩调节器处轨距的要求为（）。
-
公平目标的实现可以通过（）实现。
-
人员安全疏散分析的性能判定标准为：可用疏散时间（A.SET）必须（）必需疏散时间（RSET）。
-
人类有两套影响学习的记忆系统：陈述性记忆和程序记忆。陈述性记忆是对事实或者词汇之类基本认识的记忆。而程序记忆，就是一个人“不劳而获”的记忆。程序记忆是人养成习惯和习得技巧的方式，比如骑自行车。在很多时候，这种学习是无意识的。人们用早期发育的程序记忆系统来学习复杂的东西，比如语法规则。帮助人们学习词汇的陈述性记忆系统，则需要更多时问完成发育。儿童拥有程序记忆系统，并且不受陈述性记忆系统的干扰。由此可以推出()。
-
简述我国混合型债券市场的发展状况。
-
荟萃分析
-
宋末元初四大家
-
预防HIV感染的主要措施应当为（ ）
-
输血的适应证中，不包括（）
-
造成水中某些污染物在生物体内含量大大高于水体中的浓度的生物放大作用是指（）