博客
关于我
强烈建议你试试无所不能的chatGPT,快点击我
053(二十一)
阅读量:6437 次
发布时间:2019-06-23

本文共 2553 字,大约阅读时间需要 8 分钟。

101、

101.Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.)A. The user has dropped an important table that needs to be recovered.B. The database files are corrupted when the database is open.C. You are not able to start up the database instance because the required database files are missing.D. The archived log files are missing for which backup is not available.

 

102、

102.Examine the following values of the initialization parameters in the database having the SID ORCL:BACKGROUND_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/bdumpUSER_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/udumpCORE_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/cdumpDIAGNOSTIC_DEST=The environment variables have the following value:ORACLE_BASE=/u01/app/oracleORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1What is the location of the Automatic Diagnostic Repository (ADR) home?A. /u01/app/oracle/product/11.1.0/db_1B. /u01/app/oracleC. $ORACLE_HOME/bdumpD. $ORACLE_HOME/log

 

103、

103.Observe the following PL/SQL block:BEGINdbms_spm.configure('SPACE_BUDGET_PERCENT', 30);END;Which statement is correct regarding the above PL/SQL block?A. It automatically purges the SQL management objects when SMB occupies more than 30% of the SYSAUX tablespace.B. It reserves 30% of the space in the SYSAUX tablespace for SQL Management Base (SMB).C. It reserves 30% of the space in the SYSTEM tablespace for SMB. D. It generates a weekly warning in the alert log file when SMB occupies more than 30% of the SYSAUX tablespace.

 

104、

104.You are managing an Oracle Database 11g ASM instance having three disks in a disk group with ASM compatibility attribute set to 11.1.0 and redundancy set to high. One of the disks in the disk group becomes unavailable because of power failure. Which statements will be true in this scenario? (Choose all that apply.)A. The disk is immediately dropped from the disk group.B. The ASM tracks the extents that are modified during the outaC. The ASM migrates the extents from the unavailable disk to the remaining disks.D. The disk automatically goes offline.

 

105、

105.Which statements are true regarding table compression? (Choose all that apply.)A. It saves disk space and reduces memory usage.B. It saves disk space but has no effect on memory usage.C. It incurs extra CPU overhead during DML as well as direct loading operations.D. It incurs extra CPU overhead during DML but not direct loading operations.E. It requires uncompress operation during I/O.

 

转载于:https://www.cnblogs.com/huanhuanang/p/5397608.html

你可能感兴趣的文章
给各小组的建议
查看>>
linux搭建挂机宝教程,nokvm – 单ip搭建挂机宝详细教程
查看>>
小红帽linux各功能中英,中英文阅读:小红帽
查看>>
linux 找不到protoc,如何解决“make:protoc:命令未找到”
查看>>
linux zfs raid,CentOS7安装并使用zfs 新建RaidZ2阵列
查看>>
linux qos mq,Pika + RabbitMQ:将basic_qos设置为prefetch = 1仍然会消耗队列中的所有消息...
查看>>
Exchange 日常管理九之:创建证书服务器
查看>>
OSPF-LSR
查看>>
Servlet的多线程单实例导致的数据同步问题
查看>>
Shell 表达式与运算符
查看>>
记腾讯实习生面试 -- 第二面归来
查看>>
AWS - VPC Peering
查看>>
互联网公司的项目经理:大同与大不同
查看>>
37.Azure创建SQL On WinSrv的虚拟机(上)
查看>>
2011年度博客大赛奖品展示
查看>>
迎接“云”时代的全面到来
查看>>
读书笔记-袁腾飞讲高效学习法
查看>>
C#操作XML方法汇总
查看>>
ruby doc
查看>>
jruby-extras's activerecord-jdbc-adapter-1.0.3 Documentation
查看>>