18、You want to Install Oracle 11g database software and create a database on ASM Immediately after the Install.Your plan is to install both Oracle database and Grid Infrastructure.Which two are true in this scenario?A) Grid Infrastructure must be installed first.B) Both products ...【阅读全文】
17、Which two statements are true about tablespaces?A) A database can contain multiple undo tablespaces.B) A database can contain only a single temporary tablespace.C) A database instance stores undo data In the SYSTEM tablespace If no undo tablespace exists.D) A database instance...【阅读全文】
16、Your database Is configured In archivelog mode.The USERS01 tablespace Is currently online.You are required to take the tablespace offline.Which clause or clauses ensure that no media recovery is requiredwhen the tablespace Is brought back online?A) either the NORMAL or the ...【阅读全文】
14、Which command is used to display files that no longer conform to the backup retention policy?A) REPORT OBSOLETEB) SHOW DATAFILE BACKUP COPIESC) CROSSCHECK BACKUPD) LIST EXPIRED BACKUPAnswer:A【阅读全文】
10、Which two are true about consistent database backups?A) They can only be taken when a RECOVERY CATALOG is used.B) They can only be taken if the database Is in ARCHIVELOG mode.C) They can only be taken If shutdown NORMAL, TRANSACTIONAL, or IMMEDIATE shutdown has been performed and ...【阅读全文】
6、You are installing Oracle Grid Infrastructure by using the Oracle Universal Installer (OUI).You select the "Install and Configure Grid Infrastructure for a Standalone Server" option.Which task is performed by OUI as part of this installation?A) creation and configuration of Enterp...【阅读全文】
之前有同学想要给11gR2的RAC添加LISTENER监听器,查看了listener.ora并发现问题: [oracle@vrh2 ~]$ lsnrctl statusLSNRCTL for Linux: Version 11.2.0.3.0 - Production on 04-DEC-2011 02:51:40Copyright (c) 1991, 2011, Oracle. All rights reserved.Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PO...【阅读全文】