自考题库
首页
所有科目
自考历年真题
考试分类
关于本站
游客
账号设置
退出登录
注册
登录
出自:Oracle认证
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE You issue these statements: CREATE table new_emp ( employee_id NUMBER, name VARCHAR2(30)); INSERT INTO new_emp SELECT employee_id , last_name from employees; Savepoint s1; UPDATE new_emp set name = UPPER(name); Savepoint s2; Delete from new_emp; Rollback to s2; Delete from new_emp where employee_id =180; UPDATE new_emp set name = 'James'; Rollback to s2; UPDATE new_emp set name = 'James' WHERE employee_id =180; Rollback; At the end of this transaction, what is true?()
A:You have no rows in the table.
B:You have an employee with the name of James.
C:You cannot roll back to the same savepoint more than once.
D:Your last update fails to update any rows because employee ID 180 was already deleted.
当需要查询用户的表空间限额时,可以使用如下()数据字典视图。
A:DBA_USERS
B:ALL_USERS
C:DBA_TS_QUOTAS
D:USER_PASSWORD_LIMITS
在oracle程序中处理语句时发生的逻辑错误导致()故障。
A:实例
B:介质
C:语句
D:用户进程
在非归档方式下操作的数据库禁用了()。
A:归档日志
B:联机日志
C:日志写入程序
D:日志文件
Which three tasks can be performed using a duplicate database?()
A:Testing the backup and recovery procedures
B:Testing the upgrade of an Oracle database to a new release
C:Testing the effect of an application changes on database performance
D:Continuously updating archive log files from the target database to support failover
Which option provides a hierarchy of data security across lines of business?()
A:Alerts
B:Multi-Org
C:Flexfields
D:Shared entities
E:Business Intelligence
下列哪种约束实现域完整性?()
A:主关键字约束
B:检查约束
C:唯一约束
D:缺省约束
Evaluate the SQL statement: SELECT ROUND(45.953, -1), TRUNC(45.936, 2) FROM dual; Which values are displayed? ()
A:46 and 45
B:46 and 45.93
C:50 and 45.93
D:50 and 45.9
E:45 and 45.93
F:45.95 and 45.93
()像表一样由列组成,其查询方式与表相同,但是不包含数据。
A:同义词
B:视图
C:索引
D:过程
使用()命令可查看在创建触发器时发生的编译错误。
A:View errors
B:Show errors
C:Display errors
D:Check errors
Which statement is true regarding Flashback Version Query? ()
A: It returns versions of rows only within a transaction.
B: It can be used in subqueries contained only in a SELECT statement.
C: It will return an error if the undo retention time is less than the lower bound time or SCN specified.
D: It retrieves all versions including the deleted as well as subsequently reinserted versions of the rows.
Given:
Which two statements are true about the result if the default locale is Locale.US?()
A:The value of b is 2.
B:The value of a is 3.14.
C:The value of b is 2.00.
D:The value of a is 3.141.
E:The value of a is 3.1415.
F:The value of a is 3.1416.
Over the course of a day,a department performed multiple DML statements (inserts, updates, deletes) on multiple rows of data in multiple tables. The manager would like a report showing the time, table name,and DML type for all changes that were made. Which Flashback technology would be the best choice to produce the list?()
A: Flashback Drop
B: Flashback Query
C: Flashback Transaction Query
D: Flashback Versions Query
E: Flashback Table
Which two are valid locking levels that are used by transactions in an Oracle database?()
A:row level
B:block level
C:object level
D:schema level
E:database level
Exhibit: Using Database Control, you have scheduled a job to shrink the TRANStable residing on the TTtablespace. The job would run at 5:00 p.m. every Friday.When you examine the space usage of the table after the completion of the job, you find that the table has not been shrunk. What could have been the reason for this?()
A: The tablespace that contains the TRANS table is online.
B: The tablespace that contains the TRANS table is permanent.
C: The tablespace that contains the TRANS table is locally managed.
D: The segment space management of the tablespace that contains the TRANS table is manual in nature.
Which is not a valid locale definition file type?()
A: Language
B: Linguistic sort
C: Calendar
D: Territory
E: Character set
Click the Exhibit button and examine the data from the ORDERS and CUSTOMERS tables. Evaluate the SQL statement: SELECT * FROM orders WHERE cust_id = (SELECT cust_id FROM customers WHERE cust_name = 'Smith'); What is the result when the query is executed?()
A:A
B:B
C:C
D:D
E:E
You are maintaining the PROD database of NetFx Corporation. You set the value of the SQL_TRACE parameter to TRUE. What will be the impact of this setting?()
A: The SQL trace facility will generate the performance statistics for all the SQL statements for an instance and write them in the USER_DUMP_DEST directory.
B: The SQL trace facility will generate the performance statistics for all the SQL statements for a session and write them in the USER_DUMP_DEST directory.
C: The SQL trace facility will generate the performance statistics for all the SQL statements for an instance and write them in the BACKGROUND_DUMP_DEST directory.
D: The SQL trace facility will generate the performance statistics for all the SQL statements for a session and write them in the BACKGROUND_DUMP_DEST directory.
This is a special WebLogic Server instance included by the WebLogic Server Domains. It represents a central point from which you configure and manage all resource domain. ()
A: Managed Server
B: Web Server
C: Administration Server
D: Node Server
The Oracle Database 11g database is running in the ARCHIVELOG mode. The archived redo log files are stored on three locations. The Flash Recovery Area is one of the locations. The details are given below: LOG_ARCHIVE_DEST_1 = ’LOCATION = /disk1/archive’ LOG_ARCHIVE_DEST_2 = ’SERVICE = stdb1’ DB_RECOVERY_FILE_DEST = ’/u01/oradata’ Examine the following RMAN command issued to set the deletion policy for archived log files: RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO sbt; Which statement is true regarding what this command accomplishes?()
A: All archived redo log files backed up at least twice to tape are deleted.
B: All archived redo log files backed up at least once to tape are eligible for deletion.
C: All archived redo log files backed up at least twice to tape are deleted from the flash recovery area.
D: All archived redo log files in local archiving destinations and the flash recovery area backed up at least twice to tape are eligible for deletion.
The database is running in NOARCHIVELOG mode. A data file is lost. Which two are valid options for recover?()
A:Restore the data file and perform incomplete recovery.
B:Restore the data file and perform point-in-time recover.
C:Drop the tablespace and lose all data in the tablespace.
D:Restore the database and lose all data since the last backup.
以下关于ORACLE数据块的叙述正确的是()
A:数据块是数据库读写的最小单位,一个数据块对应一个操作系统块
B:一个数据块存放表中的一条记录,当记录增加时,数据块也相应增加
C:连续的数据块构成区,当表的数据段需要扩展时,是按区进行扩展的
D:数据块是数据库存储的最小单位,一个数据块有时分属于不同的表空间
E:数据块是可以跨磁盘的,这样可以优化数据库系统I/O的性能
A user wants to connect to the database instance from an application that is running on a remote machine. Which tools should the DBA use to establish the required configuration to ensure that the user is able to connect to the database instance?()
A:Data Pump
B:Oracle Net Manager
C:Oracle Enterprise Manager
D:Oracle Universal Installer (OUI)
E:Database Configuration Assistant (DBCA)
You work as a database administrator for Supportcenter.cn. You want to create your database with the automatic undo management feature enable.Which two tasks must you perform to achieve this?()
A:Set the UNDO_RETENTION parameter to AUTO.
B:Create an initial undo segment in undotablespace.
C:Set the UNDO_RETENTION parameter to 900 or more
D:Set the initialization parameter UNDO_MANAGEMENT to AUTO
E:Set the UNDO_MANAGEMENT parameter to the name of an undotablespace
You want to make sure that your database backup does not exceed 10 hours in length. What command would you issue that would meet this condition?()
A:backup database plus archivelog
B:backup database plus archivlog until time ‘10:00‘
C:backup database plus archivelog timeout ‘10:00‘
D:backup database plus archivelog duration 10:00
Evaluate the following command: SQL> CREATE TABLE design_data (id NUMBER, doc CLOB) LOB(doc) STORE AS SECUREFILE(DEDUPLICATE); Which statement is true regarding the above command?()
A: The LOB values are automatically compressed.
B: The LOB values are cached by default in the buffer cache.
C: The LOB values are automatically stored in encrypted mode.
D: All LOB data that is identical in two or more rows in a LOB column share the same data blocks.
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()
A:The commands execute successfully.
B:Command 6 produces an error because of circular role grant.
C:Command 5 produces an error because a role cannot be granted to another role.
D:Command 3 produces an error because the MGRROLE role already contains system privileges.
E:The table created by HR remains and HR still has the CREATE TABLE system privilege.
F:The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.
在Hibernate中,Session类提供了()接口,提供了参数绑定、结果集处理以及运行实际查询的方法。
A:createSQLQuery()
B:save()
C:update()
D:delete()
The EMP table exists in your schema. You want to execute the following query: SELECT ename, sal FROM emp AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL ’6’ MINUTE) WHERE ename = ’ALLEN’; What are the minimum requirements for the statement to execute successfully?()
A: ARCHIVELOG mode must be enabled
B: Row Movement must be enabled for the table
C: FLASHBACK must be set to ON for the database
D: The UNDO_MANAGEMENT parameter must be set to AUTO
E: The UNDO_RETENTION parameter must be set appropriately
Which two statements are true regarding the usage of the SQL*Loader utility()
A:You can load data into multiple tables during the same load session.
B:You can load data from multiple files to a table during the same load session.
C:You cannot perform selective data loading based on the values available in the records.
D:You can use an export file generated by the EXPDP utility as an input data file to load the data.
E:You can load data only if the input file is available on the disk and tape but not in a named pipes.
首页
<上一页
106
107
108
109
110
下一页>
尾页