移动端

  • 题王微信公众号

    微信搜“题王网”真题密题、最新资讯、考试攻略、轻松拿下考试

计算机考试 | Oracle认证考试

模式切换

0 0 0
我的错题 我的收藏 学习笔记

章节目录

单选题 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?()

A

–skip-networking, to prohibit access from remote locations

B

–reset-grant-tables, to start the server with only the mysql database accessible

C

–read-only,to set all data to read-only except for super users

D

–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?()

A

Start the server with the – innodb_recover_options option set to FORCE

B

Start the server with the – innodb_force_recovery option set to a non-zero value

C

Start the server as usual, and then execute the REPAIR TABLE command

D

Start the server as usual, and then execute the CHECK TABLE command

单选题 以下关于SQL的说法正确的是()

A

SQL是一种过程化的语言,可实现各种流程控制

B

SQL是ORACLE所独有数据库操作语言

C

SQL是一种数据库的驱动程序

D

SQL是一种非过程化的语言,也是数据库的工业标准

E

SQL是一种结构化和过程化相结构的语言

单选题 在Oracle中,关于锁,下列描述不正确的是()。

A

锁用于在用户之间控制对数据的并发访问

B

可以将锁归类为行级锁和表级锁

C

insert、update、delete语句自动获得行级锁

D

同一时间只能有一个用户锁定一个特定的表

单选题 对于系统表的空间,Oracle建议的大小是()。

A

100M

B

200M

C

300M

D

400M

E

500M

单选题 Which statement is true about Oracle Net Listener?()

A

It acts as the listening endpoint for the Oracle database instance for all local and non-local user connections.

B

A single listener can service only one database instance and multiple remote client connections.

C

Service registration with the listener is performed by the process monitor (PMON) process of each database instance.

D

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?()

A

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.

B

Run the Automatic Workload Repository Monitor (ADDM).

C

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.

D

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 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?()

A

Database Datafiles 

B

Database Control Files 

C

Online redo logs

D

Archived redo logs 

E

The database SPFILE 

F

None of the above, all these files are backed up. 

最新资讯

1 2 3 4 5 下一页 尾页 /

到第