Chinaunix首页 | 论坛 | 博客
  • 博客访问: 135986
  • 博文数量: 255
  • 博客积分: 0
  • 博客等级: 民兵
  • 技术积分: 2916
  • 用 户 组: 普通用户
  • 注册时间: 2018-07-05 13:59
个人简介

Oracle dba培训、OCP、OCM、MYSAL认证,可以找我们,cuug专业做这些

文章分类

全部博文(255)

文章存档

2019年(217)

2018年(38)

我的朋友

发布时间:2019-09-11 10:48:07

SYS executes this command:What will be the outcome?B)It will succeed and USER2 will be unable to perform sELECT or UPDATE on USER1.EMP because updates require select be done internallyD)It will fail because USER1 owns USER1.EMP赵:属主对自己拥有的对象的权限不可被收回.........【阅读全文】

阅读(56) | 评论(0) | 转发(0)

发布时间:2019-09-10 13:03:28

Sys executes this command:What will be the outcome?B)It will succeed but neither USER1 nor USER2 will be able to perform SELECT, INSERT, or UPDATE on USER1.EMP.D)It will succeed and neither USER1 nor USER2 will be able to perform INSERT or UPDATE on USER1.EMP, but both will be able to .........【阅读全文】

阅读(59) | 评论(0) | 转发(0)

发布时间:2019-09-10 09:28:12

SQL> ALTER SYSTEM SET db_recovery_file_dest_size=2G;A) It changes DB_RECOVERY_FILE_DEST_SIZE to 2G and deletes the obsolete backupsC) It fails because DB_RECOVERY_FILE_DEST_SIZE is a static parameterE) It fails because the new size is less than 5GCUUG:因为当前还有空闲的空间 3G,所.........【阅读全文】

阅读(74) | 评论(0) | 转发(0)

发布时间:2019-09-09 13:17:48

LOG_ARCHIVE_DEST is set to Fast Recovery Area (FRA) and It is 100% full when a log switch takes place.What is the outcome?B)All active sessions hang until the database administrator (DBA) makes space available in the FRA.D)All active sessions are disconnected and their transactions rol.........【阅读全文】

阅读(70) | 评论(0) | 转发(0)

发布时间:2019-09-09 11:38:35

A)It should be larger than the database.C)Space management in the FRA is influenced by the database backup retention policy.E)A database must be in ARCHIVELOG mode to use the FRA.赵:排除 only 和 must 选项。......【阅读全文】

阅读(77) | 评论(0) | 转发(0)
给主人留下些什么吧!~~
留言热议
请登录后留言。

登录 注册