Oracle()开始,回滚段只存在于SYSTEM表空间中。
A . 8i
B . 9i
C . 10g
D . 11g
相似题目
-
在2段式提交数据库事务中,回滚过程发生于()。
A . 当客户端和服务器通讯协议不能达成一致时
B . 在多层架构中需要拒绝代理请求时
C . 当提交的事务不能被参与的服务器和客户端完全执行时
D . 当会话的所有人不能得到确认和被提交时
-
请写出以system用户用登陆到数据库的SQLPLUS命令,其中system用户的密码为“oracle”,数据库实例号是tomc,ORACLE数据库安装机器的IP地址为192.168.1.1,sqlplus()
-
()语句可以使用户设置事务处理的各种属性,例如它的隔离层次、它是只读的还是可以进行读写的、是否需要使用特定的回滚段等。
A . set savepoint
B . set rollback
C . set transaction
D . set commit
-
DM的回滚段是如何管理的()。
A . 回滚段由一定数量的回滚数据块组成,这些块的结构同一般的数据块一样
B . 回滚段的管理同一般数据文件一样
C . 回滚数据块的分配、淘汰和释放是由数据缓冲区完成的
D . 所有的回滚段组成一个回滚日志文件
-
系统表空间是在创建数据库时一同创建的,它用于存储数据字典对象,并且包含系统回滚段(System Undo Segment)。
A . 正确
B . 错误
-
Oracle9i中有4中数据段,分别是:数据段、()、回滚段、临时段。
-
You completed your workflow definition. You want to save a copy of the definition to the file system for source control purposes. How does Oracle Workflow Builder save that file?()
A . as a flat file
B . as a BPEL-compiled definition
C . as an XML file with an associated document type definition (DTD)
D . as an XML file without an associated document type definition (DTD)
-
Oracle数据库在安装完成后,对于系统用户System,其对应的口令应该是()。
A . A.没有口令
B . B.CHANGE_ON_INSTALL,大小写无关
C . C.MANAGER,大小写无关
D . D.INTERNAL,大小写无关
-
回滚段用来存储()。
A . 事务改变前的旧数据
B . 事务改变后的新数据
C . 事务改变前后的数据
D . 重做日志
-
Which two statements about Oracle Direct Network File System (NFS) are true?()
A . It bypasses the OS file system cache.
B . A separate NFS interface is required for use across Linux, UNIX, and Windows platforms.
C . It uses the operating system kernel NFS layer for user tasks and network communication modules.
D . File systems need not be mounted by the kernel NFS system when being served through Direct NFS.
E . Oracle Disk Manager can manage NFS on its own, without using the operating system kernel NFS driver.
-
Which statements are true regarding the system-defined moving window baseline in Oracle Database 11g?()
A . It does not allow you to change the moving window size.
B . Adaptive threshold functionalities use it by default to compute statistics.
C . It is created by default with the window size being equal to the AWR retention time.
D . It is created when the first snapshot is collected by the Automatic Workload Repository (AWR).
-
You are the Database Administrator (DBA) of your company. You execute the following statement on an Oracle 10g instance: SQL> ALTER SYSTEM SWITCH LOGFILE; Which two tasks are performed when the statement is executed? ()
A . The DBWn process writes to the datafile.
B . Changes in the background process are recorded.
C . The log file is updated with the current SCN number.
D . The System Change Number (SCN) is recorded in the control file.
E . The changes to the listener configuration in the listener.ora file are recorded.
-
Oracle中关闭数据库时,不允许启动新事务,回滚到未提交事务并关闭实例的命令为:()
A . shutdown
B . shutdown immediate
C . shutdown abort
D . shutdown nomount
-
UE采用基于下行覆盖的切换方式,从3G切换到2G,切换失败后,回滚到3G网络。可能是存在了GSM网络拥塞,那么下列说法错误的是。()
A . A、由于目前的切换机制,语音电话在切换前,UE和RNC都不知道GSM网络的负荷情况,就可能出现GSM网络拥塞造成切换失败的情况
B . B、GSM网络拥塞造成切换失败情况应该是在某个特定时段出现的,不会总是切换失败
C . C、GSM网络拥塞造成切换失败,可以通过调整TD侧的2G外部邻区来避免
D . D、GSM网络拥塞造成的2/3G切换失败,UE无法回滚回TD网络
-
回滚段的PCTINCREASE参数值为下列哪一个()
A . 0
B . 10
C . 20
D . 50
E . 100
-
以数据库超级管理员的身份连接到一个用户名system、密码oracle、名称为lteomc的数据库,命令为()。
-
A system administrator needs to upgrade the Oracle database from Version 7 to Version 8. Which of the following scheduling concerns should be considered?()
A . Schedule enough down time to backup, upgrade and reboot.
B . Backup, upgrade, then schedule enough down time to reboot the system.
C . Backup, then schedule enough down time to upgrade and reboot the system.
D . There are no scheduling concerns because no down time is required.
-
oracle不能提交或回滚的操作有()
A . commit
B . select
C . update
D . drop
E . delete
-
Which two statements are true about the Oracle Direct Network File system (DNFS)?()
A . It utilizes the OS file system cache.
B . A traditional NFS mount is not required when using Direct NFS.
C . Oracle Disk Manager can manage NFS on its own, without using the operating kernel NFS driver.
D . Direct NFS is available only in UNIX platforms.
E . Direct NFS can load-balance I/O traffic across multiple network adapters.
-
双向循环链表的头指针为head,若带头结点,则表空的条件是head->next=NULL或head->prior=NULL( )
-
In the Oracle system, sets of SQL statements and control flow statements that have been named, compiled, and stored in the database are referred to as stored()。
A.PL/SQL
B.procedures
C.triggers
D.transactions
-
某IS审计师在分析数据库管理系统(DBMS)的审计日志时发现,由于存在某个错误,有些交易仅被部分执行,并且没有进行回滚。这违反了下面哪项交易处理特性()
A.一致性
B.隔离性
C.持久性
D.原子性
-
创建回滚段之前,应该设置系统的()参数为”MANUAL
A.UNDO_MANAGEMENT
B.UNDO_TABLESPACE
C.UNDO_BLOCK
D.以上说法都不对
-
Oracle的HTTP 的基本验证可选择SYS破解,因为他始终存在和有效。()
是
否