重要提示: 请勿将账号共享给其他人使用,违者账号将被封禁!
查看《购买须知》>>>
找答案首页 > 全部分类 > 计算机类考试
搜题
网友您好, 请在下方输入框内输入要搜索的题目:
搜题
题目内容 (请给出正确答案)
[主观题]

Examine the following commands and their output:SQL> SELECT ename, sal FROM emp WHERE e

name=‘JAMES‘; ENAME SAL JAMES 1050QL> UPDATE emp SET sal=sal+sal*1.2 WHERE ename=‘JAMES‘;1 row updated.SQL> SELECT ename, sal FROM emp WHERE ename=‘JAMES‘; ENAME SAL JAMES 2310View the exhibit and examine the Flashback Version Query that was executed after the preceding commands.What could be the possible cause for the query not displaying any row?()

Examine the following commands and their output:SQ

A. Flashback logging is not enabled for the database.

B. The changes made to the table are not committed.

C. Supplemental logging is not enabled for the database.

D. The database is not configured in ARCHIVELOG mode.

查看答案
更多“Examine the following commands and their output:SQL> SELECT ename, sal FROM emp WHERE e”相关的问题

第1题

Using the LIST command in Recovery Manager (RMAN), which two pieces of information from the RMAN repository can be listed?()

A. Stored scripts in the recovery catalog

B. Backups that can be deleted from disk

C. Backup sets and images copies that are obsolete

D. Backups that do not have the AVAILABLE status in the RMAN repository

点击查看答案

第2题

Examine the following command used to perform incremental level 0 backup:RMAN> BACKUP I

NCREMENTAL LEVEL 0 DATABASE;To enable the block change tracking, after the incremental level 0 backup you issued the following command:SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USINGFILE ‘/mydir/rman_change_track.f‘;To perform incremental level 1 cumulative backup, you issued the following command:RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;Which two statements are true in the above situation?()

A. The block change tracking data will be used only from the next incremental 0 backup.

B. The incremental backup will use change tracking data for accomplishing the backup.

C. The incremental backup will not use change tracking data for accomplishing the backup.

D. The block track file will scan all the blocks and create bitmap for all the blocks backed up in the level 0 backup.

点击查看答案

第3题

You want to use the automatic management of backup and recovery operations features for your database.Which configuration must you set?()

A. Enable the flash recovery area and specify it as the archived redo log destination.

B. Disable the flash recovery area and start the database instance in ARCHIVELOG mode.

C.Enable the flash recovery area but do not specify it as the archived redo log destination.

D. Disable the flash recovery area and start the database instance in NOARCHIVELOG mode.

点击查看答案

第4题

Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)?()

A. Alert log file

B. Archived redo log files

C. Control file autobackups

D. Server Parameter file (SPFILE)

E. Recovery Manager (RMAN) backup piece

点击查看答案

第5题

Before a Flashback Table operation, you execute the following command:ALTER TABLE employees ENABLE ROW MOVEMENT;Why would you need this to be executed?()

A. Because row IDs may change during the flashback operation

B. Because the object number changes after the flashback operation

C. Because the rows are retrieved from the recycle bin during the flashback operation

D. Because the table is moved forward and back to a temporary during the flashback opertion

点击查看答案

第6题

The EMP table has some discrepancy in data entry with a particular employee ID. You execut

e the query as shown in the Exhibit to retrieve all versions of the row that exist between two SCNs.View the Exhibit.Which two statements about the results of the query shown in the Exhibit are correct?()

A. The LAST_SCN value in the first row is NULL, which means that the versions of the row still exist at SCN 6636300. LAST_SCN

B. The LAST_SCN value in the second row in NULL, which means that the version of the row still exists at SCN 6636300.

C. The LAST_SCN value in the third row is 6636280, which means that the version of row exists above SCN 6636280.

D. The LAST_SCN value in the second row is NULL, which means that the version of the row no longer exists because it was deleted. LAST_SCN

点击查看答案

第7题

A database instance is using an Automatic Storage Management (ASM) instance, which has a disk group, DGROUP1, created as follows:What happens when the whole CONTROLLER1 Failure group is damaged?()

A. The transactions that use the disk group will halt.

B. The mirroring of allocation units occurs within the CONTROLLER2 failure group.

C. The data in the CONTROLLER1 failure group is shifted to the CONTROLLER2 failure group and implicit rebalancing is triggered.

D. The ASM does not mirror any data and newly allocated primary allocation units (AU) are stored in the CONTROLLER2 failure group.

点击查看答案

第8题

You want to set the following initialization parameters for your database instance:Identify the statement that correctly describes this setting.()

A. The MANDATORY location must be a flash recovery area.

B. The optional destinations may not use the flash recovery area.

C. This setting is not allowed because the first destination is not set as MANDATORY.

D. The online redo log file is not allowed to be overwritten if the archived log cannot be created in the fourth destination.

点击查看答案

第9题

View the Exhibit and note the contents of V$DIAG_INFO. Which statement is true about the ADR?()

A. The text alert log file will be available in Diag Trace

B. A copy alert log file will be kept in Diag Incident for every incident.

C. The XML version of the alert log file will be available in Diag Trace.

D. An Automatic Database Diagnostic Management (ADDM) report is generated and stored in the Health Monitor whenever an incident occurs.

点击查看答案

第10题

You are using the control file to maintain information about the database backups that are

being performed by Recovery Manager (RMAN). Identify two scenarios is which you must have a recovery catalog.()

A. To store the backup information of multiple database

B. To restrict the amount of space that is used by the backups

C. To maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter.

D. To list the data files that were in a target database at a given time by using the AT option of REPORT SCHEMA command.

点击查看答案
下载上学吧APP
客服
TOP
重置密码
账号:
旧密码:
新密码:
确认密码:
确认修改
购买搜题卡查看答案
购买前请仔细阅读《购买须知》
请选择支付方式
微信支付
支付宝支付
选择优惠券
优惠券
请选择
点击支付即表示你同意并接受《服务协议》《购买须知》
立即支付
搜题卡使用说明

1. 搜题次数扣减规则:

功能 扣减规则
基础费
(查看答案)
加收费
(AI功能)
文字搜题、查看答案 1/每题 0/每次
语音搜题、查看答案 1/每题 2/每次
单题拍照识别、查看答案 1/每题 2/每次
整页拍照识别、查看答案 1/每题 5/每次

备注:网站、APP、小程序均支持文字搜题、查看答案;语音搜题、单题拍照识别、整页拍照识别仅APP、小程序支持。

2. 使用语音搜索、拍照搜索等AI功能需安装APP(或打开微信小程序)。

3. 搜题卡过期将作废,不支持退款,请在有效期内使用完毕。

请使用微信扫码支付(元)
订单号:
遇到问题请联系在线客服
请不要关闭本页面,支付完成后请点击【支付完成】按钮
遇到问题请联系在线客服
恭喜您,购买搜题卡成功 系统为您生成的账号密码如下:
重要提示: 请勿将账号共享给其他人使用,违者账号将被封禁。
发送账号到微信 保存账号查看答案
怕账号密码记不住?建议关注微信公众号绑定微信,开通微信扫码登录功能
警告:系统检测到您的账号存在安全风险

为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!

- 微信扫码关注上学吧 -
警告:系统检测到您的账号存在安全风险
抱歉,您的账号因涉嫌违反上学吧购买须知被冻结。您可在“上学吧”微信公众号中的“官网服务”-“账号解封申请”申请解封,或联系客服
- 微信扫码关注上学吧 -
请用微信扫码测试
选择优惠券
确认选择
谢谢您的反馈

您认为本题答案有误,我们将认真、仔细核查,如果您知道正确答案,欢迎您来纠错

上学吧找答案