单选题
Consider the following table: Which method should used to add a new g201305 partition to the table?（）
A
B
C
D
E
单选题
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
单选题
Following a server crash, the automatic recovery of InnoDB fails. How would you begin to manually repair the InnoDB tables?（）
Start the server with the – innodb_recover_options option set to FORCE
Start the server with the – innodb_force_recovery option set to a non-zero value
Start the server as usual, and then execute the REPAIR TABLE command
Start the server as usual, and then execute the CHECK TABLE command
单选题
以下关于SQL的说法正确的是（）
SQL是一种过程化的语言，可实现各种流程控制
SQL是ORACLE所独有数据库操作语言
SQL是一种数据库的驱动程序
SQL是一种非过程化的语言，也是数据库的工业标准
SQL是一种结构化和过程化相结构的语言
单选题
在Oracle中，关于锁，下列描述不正确的是（）。
锁用于在用户之间控制对数据的并发访问
可以将锁归类为行级锁和表级锁
insert、update、delete语句自动获得行级锁
同一时间只能有一个用户锁定一个特定的表
单选题
对于系统表的空间，Oracle建议的大小是（）。
100M
200M
300M
400M
500M
单选题
Which statement is true about Oracle Net Listener?（）
It acts as the listening endpoint for the Oracle database instance for all local and non-local user connections.
A single listener can service only one database instance and multiple remote client connections.
Service registration with the listener is performed by the process monitor (PMON) process of each database instance.
The listener.ora configuration file must be configured with one or more listening protocol addresses to allow remote users to connect to a database instance.
单选题
Your database supports a DSS workload that involves the execution of complex queries: Currently, the library cache contains the ideal workload for analysis. You want to analyze some of the queries for an application that are cached in the library cache. What must you do to receive recommendations about the efficient use of indexes and materialized views to improve query performance?（）
Create a SQL Tuning Set (STS) that contains the queries cached in the library cache and run the SQL Tuning Advisor (STA) on the workload captured in the STS.
Run the Automatic Workload Repository Monitor (ADDM).
Create an STS that contains the queries cached in the library cache and run the SQL Performance Analyzer (SPA) on the workload captured in the STS.
Create an STS that contains the queries cached in the library cache and run the SQL Access Advisor on the workload captured in the STS.
单选题
You wish to enable an audit policy for all database users, except SYS, SYSTEM, and SCOTT.You issue the following statements: SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS;SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM; SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT; For which database users is the audit policy now active?（）
All users except SYS
All users except SCOTT
All users except sys and SCOTT
All users except sys, system, and SCOTT
单选题
You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup?（）
Database Datafiles
Database Control Files
Online redo logs
Archived redo logs
The database SPFILE
None of the above, all these files are backed up.
推荐考题
-
简述我国混合型债券市场的发展状况。
-
宋末元初四大家
-
预防HIV感染的主要措施应当为（ ）
-
造成水中某些污染物在生物体内含量大大高于水体中的浓度的生物放大作用是指（）
-
输血的适应证中，不包括（）
-
公平目标的实现可以通过（）实现。
-
人员安全疏散分析的性能判定标准为：可用疏散时间（A.SET）必须（）必需疏散时间（RSET）。
-
人类有两套影响学习的记忆系统：陈述性记忆和程序记忆。陈述性记忆是对事实或者词汇之类基本认识的记忆。而程序记忆，就是一个人“不劳而获”的记忆。程序记忆是人养成习惯和习得技巧的方式，比如骑自行车。在很多时候，这种学习是无意识的。人们用早期发育的程序记忆系统来学习复杂的东西，比如语法规则。帮助人们学习词汇的陈述性记忆系统，则需要更多时问完成发育。儿童拥有程序记忆系统，并且不受陈述性记忆系统的干扰。由此可以推出()。
-
在任何情况下，伸缩调节器处轨距的要求为（）。
-
荟萃分析
粤公网安备 44030402003701号