Clone
Copy
Template
Terminal
第1题:
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?()
第2题:
Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?()
第3题:
You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup?()
第4题:
You are managing an Oracle Database 11g database. You want to ensure the recovery of the database to thepoint of failure. Which configuration will you do to accomplish the task()
第5题:
Your database instance is running.You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener?()
第6题:
You are managing an Oracle Database 11g database. You want to ensure the recovery of thedatabase to the point of failure. Which configuration will you do to accomplish the task()
第7题:
The copy of the datafile created is stored in the RMAN repository.
The copy of the datafile created can be viewed using the LIST BACKUP command.
The copy of the datafile created using this COPY command can be placed only on the disk.
The copy of the datafile created is similar to the backup of the file created using the BACKUP command.
The copy of the datafile created can be used for recovering the database using the user-managed recovery method.
第8题:
Use the CREATE DATABASE .. command to create the database with Oracle-managed files.
Use the Database Configuration Assistant (DBCA) to create the database with Oracle-managed files.
Use Enterprise Manager to create a new database with the Online Transaction Processing (OLTP) option.
Use Database Configuration Assistant (DBCA) to create the database with Transaction Processing template.
Use the CREATE DATABASE .. command to create the database with Automatic Storage Management (ASM) file system.
第9题:
online redo log files
alert log files
control file
datafiles associated with the SYSTEM tablespace
第10题:
the time when the last flashback operation in your database was performed
the time when the first flashback operation in your database was performed
a list of flashback operations performed in your database using SCN and time
the approximate time and the lowest system change number (SCN) to which you can flash back your database
第11题:
The time when the last flashback operation in your database was performed.
The time when the first flashback operation in your database was performed.
A list of flashback operations performed in your database using SCN and time.
The approximate time and the lowest system change number (SCN) to which you can flash back your database.
第12题:
2
3
1 and 2
3 and 4
1,2,and 4
第13题:
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()
第14题:
While setting up an Oracle database for one of your critical applications, you want to ensure that the database is backed up at regular intervals without your intervention.What should you do to achieve the objective?()
第15题:
You executed the following query in your database: SELECT oldest_flashback_scn, oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output?()
第16题:
You executed the following query in your database: FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output?()
第17题:
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()
第18题:
You are about to create your Oracle data dictionary for use with the database. Which of the following users would you connect to the database as for this purpose in Oracle9i and later releases?()
第19题:
Oracle Net Manager
Listener Control utility
Database Configuration Assistant
Oracle Net Configuration Assistant
第20题:
4 and 6
2,3,4,and 6
1,2,4,5,and 6
1,2,3,4,5,and 6
第21题:
4 and 6
2,3,4,and 6
1,2,4,5,and 6
1,2,3,4,5,and 6
第22题:
Clone
Copy
Template
Terminal
第23题:
4 and 6
2,3,4,and 6
1,2,4,5,and 6
1,2,3,4,5,and 6
第24题:
SYSTEM
OUTLN
INTERNAL
SYS