Before replacing a MAG Series device, using the admin GUI, you export two backup files, system.cfg from "Maintenance" > "ImportfExport Configuration" and user.cfg from "Maintenance" > "Import/Export Users". When you receive the new hardware, you import a

第1题：

You are installing a MAG Series device for access control using an SRX Series device as the firewall enforcer. The MAG Series device resides in the same security zone as users. However, the users reside in different subnets and use the SRX Series device as an IP gateway.Which statement is true?（）

• A、You must configure a security policy on the SRX Series device to allow traffic to flow from the user devices to the MAG Series device.
• B、No security policy is necessary on the SRX Series device to allow traffic to flow from the user devices to the MAG Series device.
• C、You must configure host-inbound traffic on the SRX Series device to allow SSL traffic between the MAG Series device and the user devices.
• D、You must configure host-inbound traffic on the SRX Series device to allow EAP traffic between the MAG Series device and the user devices.

第2题：

In your database， online redo log files are multiplexed and one of the members in a group is lost due to media failure？ How would you recover the lost redo log member？（）

• A、 import the database from the last export
• B、 restore all the members in the group from the last backup
• C、 drop the lost member from the database and then add a new member to the group
• D、 restore all the database files from the backup and then perform a complete recovery
• E、 restore all the database files from the backup and then perform an incomplete recovery

第3题：

Which  statements are true regarding the Oracle Data Pump export and import operations（）

• A、You cannot export data from a remote database.
• B、You can rename tables during an import operation.
• C、You can overwrite existing dump files during an export operation.
• D、You can compress the data during export but not the metadata because it is not supported

第4题：

Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt：   RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON；   After executing this command， in which of the following cases will RMAN make an auto-backup of the control file？ （）

• A、 when you change the name of a datafile
• B、 when you drop a table from the database
• C、 when you take an export of the database
• D、 when you back up the database using OS utilities
• E、 when you issue an ALTER SYSTEM SWITCH LOGFILE statement
• F、 when you issue a BACKUP command from inside the RMAN run block

第5题：

You are required to remove the default EXTPROC entry from the default listener configuration to create a listener that will listen specifically for EXTPROC calls. Which two methods can you use to remove the default EXTPROC entry from the default listener configuration？ （）

• A、 the RMAN utility
• B、 the import/export utility
• C、 the Oracle Enterprise Manager
• D、 the change tracking feature
• E、 the Net Manager utility

第6题：

You want to migrate your existing non-ASM files to ASM files for the database PROD. Which method  or command would you use to accomplish this task？（）

• A、the CONVERT command of RMAN
• B、Data Pump Export and Import into the same database
• C、conventional export and import into the same database
• D、the BACKUP DATABASE and RESTORE DATABASE commands of RMAN
• E、the BACKUP AS COPY DATABASE and SWITCH DATABASE TO COPY command of RMAN

第7题：

In which situation would you use the Oracle Shared Server configuration？（）

• A、when performing export and import using Oracle Data Pump
• B、when performing backup and recovery operations using Oracle Recovery Manager
• C、when performing batch processing and bulk loading operation in a data warehouse environment 
• D、in an online transaction processing （OLTP） system where large number of client sessions are idle most of the time

第8题：

You want to migrate your existing non/x7fASM files to ASM files for the database PROD. Which method or command would you use to accomplish this task？（）

• A、the CONVERT command of RMAN
• B、Data Pump Export and Import into the same database
• C、conventional export and import into the same database
• D、the BACKUP DATABASE and RESTORE DATABASE commands of RMAN
• E、the BACKUP AS COPY DATABASE and SWITCH DATABASE TO COPY command of RMAN

第9题：

You are the network administrator for TestKing.com. All network servers run Windows Server 2003. The network includes a file server named Testking1. Testking1 contains a single disk for system files and two SCSI hard disks that comprise a 72-GB mirrored volume with 65 GB of read-only data. Users connect to this data by using shortcuts on their desktops. Testking1 is scheduled for replacement. You have a scheduled maintenance window to complete this task. Before the maintenance window, you build a new server. You need to bring the new server online with current data and re-establish redundancy as quickly as possible. You must also ensure that the desktop shortcuts will continue to function. What should you do?（）

• A、Name the new server Testking1. Create a new mirrored volume by using two 72-GB disks. Connect Testking2 to the network and copy the data from Testking1. When copying is complete, shut down the old Testking1.
• B、Name the new server Testking1. Move both disks from the old Testking1 to the new Testking1. Scan the disks for changes. Import the disks.Connect the new Testking1 to the network.
• C、Name the new server Testking1. Break the mirror on the old Testking1. Move one of the disks from the old Testking1 to the new Testking1. Scan the disk for changes. Initialize the disk. Select the spare disk and create the mirror. Connect the new Testking1 to the network.
• D、Name the new server Testking1. Remove one of the disks in the mirror from the old Testking1. Move the disk on the new Testking1. Scan the disk for changes. Import the disk, Shut down the old Testking1 and connect the new Testking1 to the network.

第10题：

第11题：

第12题：

第13题：

You lost a temporary file that belongs to the default temporary tablespace in your database. From the options provided， which approach would you take to solve the problem？ （）

• A、flash back the database
• B、import the temporary tablespace from the last export
• C、restore all the data files and temporary files from the last full database backup and perform a recovery
• D、not perform a recovery， but create a new temporary tablespace， make it the default temporary tablespace and then drop the old tablespace

第14题：

Very soon you will be performing maintenance operations. You would have several jobs to run as soon as the maintenance period starts. Which method would you use to create jobs without specifying the time period when the job should be run？（）

• A、 use DBMS_IJOB package
• B、 use Oracle Scheduler
• C、 use DBMS_JOB package
• D、 use Oracle Data Pump Export and Import

第15题：

You work as a database administrator for Supportcenter.cn. One of the database users accidentally deleted all the rows of a critical table and committed the delete at 1：30 p.m. You senior database administrator， SupportCenter， asks you to retrieve the lost data. Which two actions would you use to ensure that there is no impact on other connected users while retrieving the deleted rows？（）

• A、Use a flashback query to retrieve the rows that were deleted
• B、Useconventialincremental export and then import the affected object
• C、Shutdown the database inNORMALmode and restart the database instance
• D、Use DBMS_META package to reconstruct the object using undo segments
• E、UseTablespacePoint in Time Recovery （TSPITR） method to recover the table and the data
• F、Use Oracle DataPumptwithflashback_timeoption toentableflashback export and then import the affected object.

第16题：

Which three statements are true about Oracle Data Pump export and import operations?（）

• A、You can detach from a data pump export job and reattach later.
• B、Data pump uses parallel execution server processes to implement parallel import.
• C、Data pump import requires the import file to be in a directory owned by the oracle owner.
• D、The master table is the last object to be exported by the data pump.
• E、You can detach from a data pump import job and reattach later.

第17题：

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 population
• B、use the Oracle Data Pump export and import utility
• C、use the conventional path data load of SQL*Loader utility
• D、use the direct path data load of Oracle export and import utility

第18题：

You are maintaining your database in Oracle10g. On Tuesday at 8：00 A.M.， while starting the database， you discover that all the control files are missing. The backup of the full database was performed on Sunday at 6：00 P.M. Which type of recovery will you perform？（）

• A、 incomplete recovery
• B、 complete recovery
• C、 recovery using the Flashback Database feature
• D、 recovery using the export/import utility

第19题：

Which two statements are true regarding the Oracle Data Pump export and import operations（）

• A、You cannot export data from a remote database.
• B、You can rename tables during an import operation.
• C、You can overwrite existing dump files during an export operation.
• D、You can compress the data during export but not the metadata because it is not supported.

第20题：

You are designing a strategy for migrating the UNIX user accounts to Active Directory.  Which three actions should you perform？（）

• A、 Import the user accounts as inetOrgPerson objects.
• B、 Import the user accounts into Active Directory by using the Ldifde command-line tool.
• C、 Export all user accounts from the UNIX servers to a text file.
• D、 Export all user accounts and their passwords from the UNIX servers to a text file. Encrypt this file to achieve extra security.
• E、 Assign random passwords to each user object， and securely distribute the password to the users.
• F、 Create the same strong password for each user object， and require users to change their passwords at first logon.
• G、 Instruct users to use the same name and password as they used on the UNIX servers.

第21题：

第22题：

第23题：