网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)

In a new installation of Oracle Database 11g, you perform these activities:  1:Organize software and data on different subdirectories to avoid poor performance.  2:Use consistent naming conventions for database files.  3:Separate administrative information pertaining to the database in different directories.  Which option corresponds to the type of activities you performed()

  • A、Oracle Managed Files
  • B、Oracle Grid Architecture
  • C、Optimal Flexible Architecture
  • D、Oracle database architecture
  • E、Automatic Storage Management

参考答案

更多 “ In a new installation of Oracle Database 11g, you perform these activities:  1:Organize software and data on different subdirectories to avoid poor performance.  2:Use consistent naming conventions for database files.  3:Separate administrative information pertaining to the database in different directories.  Which option corresponds to the type of activities you performed()A、Oracle Managed FilesB、Oracle Grid ArchitectureC、Optimal Flexible ArchitectureD、Oracle database architectureE、Automatic Storage Management” 相关考题
考题 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.

考题 You perform the following activities during the database upgrade from Oracle Database 10g to Oracle Database 11g:1. Capture plans for a SQL workload into a SQL Tuning Set (STS) before upgrade.2. Load these plans from the STS into the SQL plan baseline immediately after the upgrade.What is the reason for performing these activities? ()A. to minimize plan regression due to the use of a new optimizer versionB. to completely avoid the use of new plans generated by a new optimizer versionC. to prevent plan capturing when the SQL statement is executed after the database upgradeD. to keep the plan in the plan history so that it can be used when the older version of the optimizer is used

考题 You are managing the APPPROD database as a DBA which is not using the Oracle-managed files. You plan to duplicate this database in the same system with the name DUPDB.You want to create the same directory structure for duplicate database files as of the target database.You executed the following RMAN commands:What are the implications of this command?()A. It creates database files for the duplicate database under the Oracle base with a different directory for the duplicate database.B. It overwrites data files of the target database because a different location for data files is not mentioned for the duplicate database.C. It creates database files for the duplicate database under the same Oracle home as that of the target database with the same directory structure.D. It creates database files for the duplicate database under the same Oracle home as that of the target but with a different directory for the duplicate database.

考题 You are working on a new Oracle Database 11g server, where only the software is installed and no database iscreated. You plan to create a database on this server using the Database Configuration Assistant (DBCA).Some of the requirements set for your database creation task are: 1.Configure the database to operate in shared server mode. 2.Disable automatic maintenance tasks such as optimizer statistics collection. 3.Configure a naming method to help the remote user connect to the database instance. 4.Use Automatic Storage Management (ASM) for storing the database files. 5.Configure daily database backup to flash recovery area. 6.Configure Enterprise Manager Database Control to manage the database.  Which of these requirements can be met while creating the database()A、4 and 6B、2,3,4,and 6C、1,2,4,5,and 6D、1,2,3,4,5,and 6

考题 n your production database you want to use an Automatic Storage Management (ASM) instance to manage the database files. Which option would you use to migrate the database files from a non-ASM instance to an ASM instance?()A、 Oracle Migration AssistantB、 Recovery Manager (RMAN)C、 Oracle Data Pump Export and ImportD、 conventional Oracle Export and ImportE、 operating system utilities to copy the files to the ASM instance

考题 In a new installation of Oracle Database 11g, you perform these activities: 1. Organize software and data on different subdirectories to avoid poor performance. 2. Use consistent naming conventions for database files. 3. Separate administrative information pertaining to the database in different directories.  Which optioncorresponds to the type of activities you performed()A、Oracle Managed FilesB、Oracle Grid ArchitectureC、Optimal Flexible ArchitectureD、Oracle database architectureE、Automatic Storage Management

考题 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?()A、Oracle Managed FilesB、Oracle Grid ArchitectureC、Optimal Flexible ArchitectureD、Oracle database architecture

考题 You want to create a new optimized database for your transactional production environment to be used by a financial application. While creating the database, you want the Oracle software to take care of all basic settings to optimize the database performance. Which method would you use to achieve this objective?()A、Use the CREATE DATABASE .. command to create the database with Oracle-managed files. B、Use the Database Configuration Assistant (DBCA) to create the database with Oracle-managed files. C、Use Enterprise Manager to create a new database with the Online Transaction Processing (OLTP) option. D、Use Database Configuration Assistant (DBCA) to create the database with Transaction Processing template. E、Use the CREATE DATABASE .. command to create the database with Automatic Storage Management (ASM) file system.

考题 You are working on a new Oracle Database 11g server, where only the software is installed and nodatabase is created. You plan to create a database on this server using the Database Configuration Assistant (DBCA).  Some of the requirements set for your database creation task are:  1:Configure the database to operate in shared server mode.  2:Disable automatic maintenance tasks such as optimizer statistics collection.  3:Configure a naming method to help the remote user connect to the database instance.  4:Use Automatic Storage Management (ASM) for storing the database files.  5:Configure daily database backup to flash recovery area.  6:Configure Enterprise Manager Database Control to manage the database.  Which of these requirements can be met while creating the database()A、4 and 6B、2,3,4,and 6C、1,2,4,5,and 6D、1,2,3,4,5,and 6

考题 In your production database you want to use an Automatic Storage Management (ASM) instance to manage the database files. Which option would you use to migrate the database files from a non-ASM instance to an ASM instance?()A、Oracle Migration AssistantB、Recovery Manager (RMAN)C、Oracle Data Pump Export and ImportD、conventional Oracle Export and ImportE、operating system utilities to copy the files to the ASM instance

考题 You can use Oracle Flashback to look at past activity in your database. What are two other characteristics of Oracle Flashback?()A、Oracle Flashback uses undo information to construct consistent data. B、You can use a cursor opened while using an Oracle Flashback image to perform DML once you deactivate Oracle Flashback in your session. C、You can only use Oracle Flashback view of the data if the required records are still in the online redo log files. D、Oracle Flashback lists the DML that was executed during the period you identify when initiating your session. 

考题 You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables. While migrating the data, you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into Oracle database?()A、use the external table populationB、use the Oracle Data Pump export and import utilityC、use the conventional path data load of SQL*Loader utilityD、use the direct path data load of Oracle export and import utility

考题 You plan to configure the new Oracle Database 11g installation by performing these tasks: - Use Automatic Storage Management (ASM) as the storage option.  - Use Oracle Enterprise Manager Database Control to manage the database.  - Provide the same password for SYS, SYSTEM, SYSMAN, and DBSNMP accounts during theinstallation. - Configure the database to send email notifications.  Some tools available to you for installation are:  1:Oracle Universal Installer (OUI)  2:Database Configuration Assistant (DBCA)  3:Database Upgrade Assistant (DBUA)  4:Oracle Net Configuration Assistant  Which tools would you use for this installation()A、2B、3C、1 and 2D、3 and 4E、1,2,and 4

考题 You perform the following activities during the database upgrade from Oracle Database 10g to Oracle Database 11g: 1. Capture plans for a SQL workload into a SQL Tuning Set (STS) before upgrade. 2. Load these plans from the STS into the SQL plan baseline immediately after the upgrade. What is the reason for performing these activities? ()A、to minimize plan regression due to the use of a new optimizer versionB、to completely avoid the use of new plans generated by a new optimizer versionC、to prevent plan capturing when the SQL statement is executed after the database upgradeD、to keep the plan in the plan history so that it can be used when the older version of the optimizer is used

考题 单选题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?()A Oracle Managed FilesB Oracle Grid ArchitectureC Optimal Flexible ArchitectureD Oracle database architecture

考题 单选题n your production database you want to use an Automatic Storage Management (ASM) instance to manage the database files. Which option would you use to migrate the database files from a non-ASM instance to an ASM instance?()A  Oracle Migration AssistantB  Recovery Manager (RMAN)C  Oracle Data Pump Export and ImportD  conventional Oracle Export and ImportE  operating system utilities to copy the files to the ASM instance

考题 单选题You want to create a new optimized database for your transactional production environment to be used by a financial application. While creating the database, you want the Oracle software to take care of all basic settings to optimize the database performance. Which method would you use to achieve this objective?()A Use the CREATE DATABASE .. command to create the database with Oracle-managed files. B Use the Database Configuration Assistant (DBCA) to create the database with Oracle-managed files. C Use Enterprise Manager to create a new database with the Online Transaction Processing (OLTP) option. D Use Database Configuration Assistant (DBCA) to create the database with Transaction Processing template. E Use the CREATE DATABASE .. command to create the database with Automatic Storage Management (ASM) file system.

考题 单选题You are working on a new Oracle Database 11g server, where only the software is installed and no database iscreated. You plan to create a database on this server using the Database Configuration Assistant (DBCA).Some of the requirements set for your database creation task are: 1.Configure the database to operate in shared server mode. 2.Disable automatic maintenance tasks such as optimizer statistics collection. 3.Configure a naming method to help the remote user connect to the database instance. 4.Use Automatic Storage Management (ASM) for storing the database files. 5.Configure daily database backup to flash recovery area. 6.Configure Enterprise Manager Database Control to manage the database.  Which of these requirements can be met while creating the database()A 4 and 6B 2,3,4,and 6C 1,2,4,5,and 6D 1,2,3,4,5,and 6

考题 单选题In a new installation of Oracle Database 11g, you perform these activities:  1:Organize software and data on different subdirectories to avoid poor performance.  2:Use consistent naming conventions for database files.  3:Separate administrative information pertaining to the database in different directories.  Which option corresponds to the type of activities you performed()A Oracle Managed FilesB Oracle Grid ArchitectureC Optimal Flexible ArchitectureD Oracle database architectureE Automatic Storage Management

考题 单选题In a new installation of Oracle Database 11g, you perform these activities: 1. Organize software and data on different subdirectories to avoid poor performance. 2. Use consistent naming conventions for database files. 3. Separate administrative information pertaining to the database in different directories.  Which optioncorresponds to the type of activities you performed()A Oracle Managed FilesB Oracle Grid ArchitectureC Optimal Flexible ArchitectureD Oracle database architectureE Automatic Storage Management

考题 单选题You are managing the APPPROD database as a DBA which is not using the Oracle-managed files. You plan to duplicate this database in the same system with the name DUPDB.You want to create the same directory structure for duplicate database files as of the target database. You executed the following RMAN commands:   RMAN CONNECT TARGET sys/sys@APPPROD RMAN CONNECT AUXILIARY sys/sys@DUPDB RMAN DUPLICATE TARGET DATABASE TO dupdb  FROM ACTIVE DATABASE PASSWORD FILE SPILE  NOFILENAMECHECK;   What are the implications of this command?()A  It creates database files for the duplicate database under the Oracle base with a different directory for the duplicate database.B  It overwrites data files of the target database because a different location for data files is not mentioned for the duplicate database.C  It creates database files for the duplicate database under the same Oracle home as that of the target database with the same directory structure.D  It creates database files for the duplicate database under the same Oracle home as that of the target but with a different directory for the duplicate database.

考题 单选题You are working on a new Oracle Database 11g server, where only the software is installed and no database iscreated. You plan to create a database on this server using the Database Configuration Assistant (DBCA).Some of the requirements set for your database creation task are: 1.Configure the database to operate in shared server mode. 2.Disable automatic maintenance tasks such as optimizer statistics collection. 3.Configure a naming method to help the remote user connect to the database instance. 4.Use Automatic Storage Management (ASM) for storing the database files. 5.Configure daily database backup to flash recovery area. 6.Configure Enterprise Manager Database Control to manage the database.  Which of these requirements can be met while creating the database()A 4 and 6B 2,3,4,and 6C 1,2,4,5,and 6D 1,2,3,4,5,and 6

考题 单选题You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables.  While migrating the data, you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into Oracle database?()A use the external table populationB use the Oracle Data Pump export and import utilityC use the conventional path data load of SQL*Loader utilityD use the direct path data load of Oracle export and import utility

考题 单选题You are working on a new Oracle Database 11g server, where only the software is installed and nodatabase is created. You plan to create a database on this server using the Database Configuration Assistant (DBCA).  Some of the requirements set for your database creation task are:  1:Configure the database to operate in shared server mode.  2:Disable automatic maintenance tasks such as optimizer statistics collection.  3:Configure a naming method to help the remote user connect to the database instance.  4:Use Automatic Storage Management (ASM) for storing the database files.  5:Configure daily database backup to flash recovery area.  6:Configure Enterprise Manager Database Control to manage the database.  Which of these requirements can be met while creating the database()A 4 and 6B 2,3,4,and 6C 1,2,4,5,and 6D 1,2,3,4,5,and 6

考题 单选题You plan to configure the new Oracle Database 11g installation by performing these tasks: - Use Automatic Storage Management (ASM) as the storage option.  - Use Oracle Enterprise Manager Database Control to manage the database.  - Provide the same password for SYS, SYSTEM, SYSMAN, and DBSNMP accounts during theinstallation. - Configure the database to send email notifications.  Some tools available to you for installation are:  1:Oracle Universal Installer (OUI)  2:Database Configuration Assistant (DBCA)  3:Database Upgrade Assistant (DBUA)  4:Oracle Net Configuration Assistant  Which tools would you use for this installation()A 2B 3C 1 and 2D 3 and 4E 1,2,and 4

考题 多选题You can use Oracle Flashback to look at past activity in your database. What are two other characteristics of Oracle Flashback?()AOracle Flashback uses undo information to construct consistent data.BYou can use a cursor opened while using an Oracle Flashback image to perform DML once you deactivate Oracle Flashback in your session.CYou can only use Oracle Flashback view of the data if the required records are still in the online redo log files.DOracle Flashback lists the DML that was executed during the period you identify when initiating your session.

考题 单选题In a new installation of Oracle Database 11g, you perform these activities: 1. Organize software and data on different subdirectories to avoid poor performance. 2. Use consistent naming conventions for database files. 3. Separate administrative information pertaining to the database in different directories.  Which optioncorresponds to the type of activities you performed()A Oracle Managed FilesB Oracle Grid ArchitectureC Optimal Flexible ArchitectureD Oracle database architectureE Automatic Storage Management