自考题库
首页
所有科目
自考历年真题
考试分类
关于本站
游客
账号设置
退出登录
注册
登录
出自:Oracle认证
查询出EMP表中1982年及以后入职的员工信息()(注:字段hiredate为入职日期,数据类型为DATE型)
A:select * from emp where hiredate>='19820101';
B:select * from emp where hiredate>=to_char('19820101','YYYYMMDD');
C:select * from emp where to_date(hiredate,'YYYYMMDD')>='19820101';
D:select * from emp where to_char(hiredate,'YYYYMMDD')>='19820101';
Which tuning tool recommends how to optimize materialized views so that these views can take advantage of the general query rewrite feature?()
A:Segment Advisor
B:SQL Access Advisor
C:Undo Advisor
D:SQL Tuning Advisor
In which situation may the UNDO_RETENTION parameter be ignored, even if it is set to a value()
A:when the data file of the undo tablespace is autoextensible
B:when there are more than one undo tablespaces available in the database
C:when the undo tablespace is of a fixed size and retention guarantee is not enabled
D:when the undo tablespace is autoextensible and retention guarantee is not enabled
You want to create a consumer group, GROUP1, and you execute the following command in the command/x7fline interface: SQL> EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP (CONSUMER_GROUP =>’group1’, COMMENT => ’New Group’); This command errors out displaying the following message: ERROR at line 1: ORA/x7f29371: pending area is not active ORA/x7f06512: at "SYS.DBMS_RMIN", line 115 ORA/x7f06512: at "SYS.DBMS_RESOURCE_MANAGER", line 108 ORA/x7f06512: at line 1 What action would you take to overcome this error?()
A:create the Pending Area before creating the consumer group
B:activate the Pending Area before creating the consumer group
C:increase the size of the large pool to accommodate the Pending Area
D:increase the size of the shared pool to accommodate the Pending Area
E:increase the size of the database buffer cache to accommodate the Pending Area
Your application regularly issues the following statement: SELECT * FROM BANK_ACCT WHERE ACCT_BALANCE BETWEEN 1000 and 10000; Which of the following database objects would be inappropriate for use with this statement?()
A:Materialized views
B:Indexes
C:Index-organized tables
D:Hash clusters
Given:
Which statement is true?()
A:The code will compile without changes.
B:The code will compile if public Tree() { Plant(); } is added to the Tree class.
C:The code will compile if public Plant() { Tree(); } is added to the Plant class.
D:The code will compile if public Plant() { this("fern"); } is added to the Plant class.
E:The code will compile if public Plant() { Plant("fern"); } is added to the Plant class.
In Solaris 10, this tool provides an automated and proactive approach to patch management. It provides a graphical user interface as well as a command line interface. Which tool is it? ()
A: smpatch
B: Patchtool
C: Update manager
D: Patch manager
View the Exhibit and examine the privileges granted to the MGR_ROLE role. The user SKD has been grantedthe CONNECT and RESOURCE roles only. The database administrator (DBA) grants MGR_ROLE to the userSKD by executing the command: SQL> GRANT MGR_ROLE TO SKD WITH ADMIN OPTION; Which statement is true about the user SKD afterhe/she is granted this role()
A:The user SKD can grant only the MGR_ROLE role to other users, but not the privileges in it.
B:The user SKD can revoke the MGR_ROLE only from the users for whom he/she is the grantor.
C:The user SKD can grant the privileges in the MGR_ROLE role to other users, but not with ADMIN OPTION.
D:The user SKD can grant the privileges in the MGR_ROLE role to other users, but cannot revoke privilegesfrom them
列出EMP表中,从事每个工种(JOB)的员工人数()
A:select job from emp;
B:select job,count(*) from emp;
C:select distinct job,count(*) from emp;
D:select job,count(*) from emp group by job;
E:select job,sum(empno) from emp group by job;
DRAG DROP Click the Task button.
()是由PL/SQL所提供的系统异常。当PL/SQL应用程序违反了Oracle规则或者系统限制,则会隐含地触发一个内部异常。
A:预定义异常
B:自定义异常
C:系统错误
D:内存溢出
写出“概要文件”的作用之一。
For Oracle 11g, Oracle strongly recommends that you configure your database to use which of the following memory-management features?()
A: Automatic PGA Memory Management
B: Automatic SGA Memory Management
C: Automatic Shared Memory Management
D: Automatic Memory Management
E: Manual SGA Memory Management
F: None of the above
An index-organized table (IOT) called SPARSE has had many records deleted. Which command reorganizes the IOT so that the empty space is removed, while minimizing the impact for users?()
A:EXPORT with TABLES and IMPORT with the INDEX and IGNORE options.
B:ALTER TABLE … COALESCE ;
C:ALTER INDEX …REBUILD ONLINE;
D:CREATE TABLE …AS SELECT_ONLINE;
You install a copy of Mysql 5.6.13 on a brand new Linux server by using RPM packages. The server starts successfully as verified by the following commands: $ pidof mysqld 3132 $tail – n2 /var/lib.mysql/hostname.err 2013-08-18 08:18:38 3132 [Note] /usr/sbin/mysqld:ready for connections. Version: '5.6.13-enterprise-commercial-advaced' socket:'/tmp/mysql.sock' port; 3306 Mysql Enterprise Server – Advanced Edition (Commercial) You attempt to log in as the root user with the following command: $mysql – u root ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) Which statement is true about this scenario?()
A:The RPM installation script sets a default password of password for new installations
B:The local root user must log in with a blank password initially: mysql –u root –p
C:New security measures mean that the mysql_secure_installation script must be run first on all new installations
D:The mysql_install_bd post-installation script used – random-password
While designing the database for one of your online transaction processing (OLTP) applications, you want to achieve the following: a) high availability of data b) faster primary key access to the table data c) compact storage for the table Which type of tables would you use to achieve these objectives?()
A:heap tables
B:object tables
C:partitioned tables
D:index-organized tables (IOTs)
在Oracle中,使用了如下的语句创建用户TOM,则对于该用户而言,以下说法错误的是()。 CREATE USER TOM IDENTIFIED BY TOMSYS
A:该用户的口令为TOMSYS
B:TOM默认为表空间为SYSTEM
C:TOM的临时表空间为TEMP
D:使ORANTUPDATE命令可以修改TOM的口令
The loss of the control file forced you to re/x7fcreate the control file. After re/x7fcreating it and opening the database, you find that some of the data files are named as MISSINGnnnnn, where nnnnn is a five/x7fdigit number starting with 0. What could be the possible reason?()
A:These are the data files that are corrupted.
B:There is no SYSAUX tablespace in your database
C:There is a readonly tablespace in your database.
D:These are the data files that cannot be recovered.
You work as a database administrator for Certkiller .com. You suspect that in one of your applications the customer table is being accessed by some unauthorized users. Which option would you use to monitor the queries being executed on the customer table?()
A:Monitor thealert.logfile
B:Enable server-side SQL tracing for user sessions
C:Enable fine-grained auditing for the customer table
D:Enable Fine-Grained Access Control (FGAC) for the customer table
E:Write a database trigger on the customer table on the SELECT event
Oracle用于保存二进制大对象的数据类型是()。
A:BINARY
B:BIGOBJECT
C:BLOB
D:CLOB
ROW-based replication has stopped working. You investigate the error log file and find the following entries: 2013-08-27 14:15:47 9056 [ERROR] Slave SQL: Could not execute Delete_rows event on table test.t1; Can't find record in 't1', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log 56_master-bin. 000003, end_log_pos 851, Error_code: 1032 2013-08-27 14:15:47 9056 [warning] Slave: Can't find record in 't1' Error_code: 1032 2013-08-27 14:15:47 9056 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log '56_masterbin. 000003' position 684 Why did you receive this error?()
A:The slave SQL thread does not have DELETE privileges to execute on test.t1 table.s
B:The table definition on the slave -litters from the master
C:Multi-threaded replication slaves can have temporary errors occurring for cross database updates
D:The slave SQL thread attempted to remove a row from the test.t1 table, but the row did not exist
Examine the description of the MARKS table: STD_ID NUMBER(4) STUDENT_NAME VARCHAR2(30) SUBJ1 NUMBER(3) SUBJ2 NUMBER(3) SUBJ1 and SUBJ2 indicate the marks obtained by a student in two subjects. Examine this SELECT statement based on the MARKS table: SELECT subj1+subj2 total_marks, std_id FROM marks WHERE subj1 > AVG(subj1) AND subj2 > AVG(subj2) ORDER BY total_ marks; What is the result of the SELECT statement?()
A:The statement executes successfully and returns the student ID and sum of all marks for each student who obtained more than the average mark in each subject.
B:The statement returns an error at the SELECT clause.
C:The statement returns an error at the WHERE clause.
D:The statement returns an error at the ORDER BY clause.
hich of the following RMAN structures can data from a datafile span?()
A:RMAN backup-set pieces spanning backup sets
B:RMAN backup-set pieces within a given backup sets
C:RMAN backups
D:RMAN channels
E:None of the above
Assuming that the serializeBanana() and the deserializeBanana() methods will correctly use Javaserialization and given:
What is the result?()
A:restore 400
B:restore 403
C:restore 453
D:Compilation fails.
E:An exception is thrown at runtime.
You want to create a template to be used as a standard for all company reports. What is the easiest way to do this?()
A:Open an existing template file, rename it and modify the template objects.
B:Open the report wizard and create a new template.
C:Open the layout model and copy the paste items from the default templates provided in report builder.
D:Templates cannot be modified in release 2.
Given:
What is the result? ()
A: A new Item object is created with the preferred value in the id attribute.
B: The attribute id in the Item object is modified to the new value.
C: Compilation fails.
D: An exception is thrown at runtime.
E: The attribute id in the Item object remains unchanged.
()是Oracle的集成管理平台,能够管理整个Oracle环境,对组织中的所有设备,包括主机、数据库、侦听器、应用服务器、HTTP服务器、Web应用都能够进行管理。
A:SQL*Plus
B:Oracle企业管理器
C:Net Manager
D:数据库管理器
Given:
What is the result when the go() method is invoked?()
A:00
B:0001
C:000120
D:00012021
E:Compilation fails
F:An exception is thrown at runtime
When does a transaction complete?()
A:when a DELETE statement is executed
B:when a ROLLBACK command is executed
C:when a PL/SQL anonymous block is executed
D:when a data definition language (DDL) statement is executed
E:when a TRUNCATE statement is executed after the pending transact ion
You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature.Which statement should you use to enable the block change tracking feature?()
A:ALTER DATABASE ENABLE BLOCK CHANGE TRACKING
B:ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE
C:ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE
D:ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING
首页
<上一页
20
21
22
23
24
下一页>
尾页