Oracle Managed Files
Oracle Grid Architecture
Optimal Flexible Architecture
Oracle database architecture
Automatic Storage Management
第1题:
You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process, you execute the following script:SQL>@utlu111i.sqlWhich statement about the execution of this script is true?()
A. It must be executed from the Oracle Database 11g environment.
B. It must be executed only after the SYSAUX tablespace has been created.
C. It must be executed from the environment of the database that is being upgraded.
D. It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.
E. It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.
第2题:
A. Effectively implements role separation
B. Enables you to take advantage of Oracle Managed Files.
C. Automatically registers the database with Oracle Restart.
D. Helps you to easily upgrade the database from a prior release.
E. Enables the Installation of Grid Infrastructure files on block or raw devices.
第3题:
During the installation of Oracle Database 11g, you do not set ORACLE_BASE explicitly. You selected the option to create a database as part of the installation. How would this environment variable setting affect the installation?()
A. The installation terminates with an error.
B. The installation proceeds with the default value without warnings and errors.
C. The installation proceeds with the default value but it would not be an OFA-compliant database.
D. The installation proceeds with the default value but a message would be generated in the alert log file.
第4题:
While planning to manage more than one database in your system, you perform the following activities: 1. Organize different categories of files into independent subdirectories. 2. Use consistent naming convention for database files. 3. Separate administrative information pertaining to each database. Which option corresponds to the type of activities performed by you?()
第5题:
The DB_BLOCK_CHECKING initialization parameter is set to FALSE. What level of block checking would be performed?()
第6题:
A. The Oracle database will perform block checking for the index blocks only
B. The Oracle database will not perform block checking for any of the data blocks
C. The Oracle database will perform block checking for the default permanent tablespace only
D. The Oracle database will perform block checking for the data blocks in all user tablespaces
E. The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only
第7题:
Which statement is true about the database and database-user used during installation of IMS Server?()
第8题:
You are in the process of creating a virtual private catalog in your Oracle Database 11g database. The PROD1, PROD2, and PROD3 Oracle Database 10g databases are registered in the base recovery catalog. The database user who owns the base recovery catalog is CATOWNER. CATOWNER executes the following command to grant privileges to a new user VPC1 using Oracle Database 11g RMAN executables:What is the outcome of the above commands?()
A. They execute and create a virtual catalog for pre-Oracle 11g clients.
B. They produce an error because PROD1 and PROD2 databases belong to the older version.
C. They produce an error because you need to connect as CATOWNER to execute this packaged procedure.
D. They produce an error because you need to connect to the target database to execute this packaged procedure.
第9题:
The DB_BLOCK_CHECKING initialization parameter is set to OFF. 数据库块检测初始化参数被设定为关 Which block checking would be performed?()
第10题:
You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode. Which two statements are true in this scenario()