单选题Which statement is true regarding remote archive log file destinations？（）A Only two destinations per remote database can be specified.B Destination is an Oracle Net alias specified by using the SERVICE keyword.C The REOPEN attribute must be used when u

第1题：

Which statement is true regarding syslog on Junos devices?（）

• A、No logging is enabled by default
• B、By default the information is stored in all file named events
• C、Only the message severity level must be configured
• D、You can configure the router to send log messages to the console

第2题：

The database is running in ARCHIVELOG mode. Examine the initialization parameters and theirvalues set to enable archiving on your database server：  LOG_ARCHIVE_FORMAT = arch_%t_%s_%r.arc  LOG_ARCHIVE_DEST_1 = ’LOCATION = /disk1/archive’  DB_RECOVERY_FILE_DEST = ’/u01/oradata’  DB_RECOVERY_FILE_DEST_SIZE = 20G  Which statement is true regarding the archived redo log files（）

• A、It will be created on the local file system.
• B、It will be created only in the Flash Recovery Area.
• C、It will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the defaultlocation $ORACLE_HOME/dbs.
• D、It will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and locationspecified by the DB_RECOVERY_FILE_DEST parameter.

第3题：

You are maintaining the database in Oracle10g. You are performing an incomplete recovery by using RMAN because an important table， EMPLOYEE， is dropped and purged from the Recycle Bin. Which statement is NOT true regarding an incomplete recovery？（）

• A、 The target database must be in the MOUNT mode to ensure restoration of the datafiles.
• B、 You can restore the datafiles from the backup by using the RMAN utility only if the backups were taken using the RMAN utility.
• C、 The control file must be recreated.
• D、 The database must be opened with the RESETLOGS option.

第4题：

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？（）

• A、 online redo log files
• B、 alert log files
• C、 control file
• D、 datafiles associated with the SYSTEM tablespace

第5题：

You are working as a Database Administrator. Despite having a password in the data dictionary as change_on_install， you always log on to the database MYNEWDB using operating system authentication. Your organization is planning to recruit two junior-level DBAs. You decide to enable remote authentication in your database so that the new DBAs can log on to the database from their workstations to carry out administrative tasks.   To allow the new DBAs to perform the administrative tasks， you create a password file on the database server using the following command：   ORAPWD file=d：/oracle/ora9i/orapwU01 password=admin entries=4   After creating the password file， you remove the operating system authentication and change the value of the  REMOTE_LOGIN_PASSWORDFILE parameter to EXCLUSIVE. You also create a net service name as MYNEWDB that allows the new DBAs to connect to the database server from their workstations using this net service name. Which command must you use to connect to the database to start it？（）  

• A、 CONNECT / AS SYSDBA
• B、 CONNECT sys/admin AS SYSDBA
• C、 CONNECT sys/admin@mynewdb AS SYSDBA
• D、 CONNECT sys/change_on_install AS SYSDBA

第6题：

In your database, the flash recovery area (FRA) is configured as the default for RMAN backups. You executed the following commands to configure the settings in RMAN: RMAN> CONFIGURE DEVICE TYPE disk PARALLELISM 2 BACKUP TYPE TO BACKUPSET; RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE disk FORMAT '/home/oracle/disk1/%U'; RMAN> CONFIGURE CHANNEL 2 DEVICE TYPE disk FORMAT '/home/oracle/disk2/%U'; You issue the following RMAN command to backup the database: RMAN> RUN 2> { 3> ALLOCATE CHANNEL ch1 DEVICE TYPE disk; 4> BACKUP DATABASE; 5> } Which statement is true about the outcome?（）

• A、Only one channel is allocated and the backup is created in the flash recovery area
• B、Only one channel is allocated and the backup is created in the destination specified for channel 1
• C、Two channels are allocated and backup sets are created in the destinations specified for channels 1 and 2
• D、Three channels are allocated and backup sets are created in the destinations specified for channels 1, 2, and FRA

第7题：

Which two statements are true regarding Health Monitor checks in Oracle Database 11g？（）  

• A、 Health Monitor checks can be used to scan the contents of the redo log and archive logs for accessibility and corruption.
• B、 Health Monitor checks can be used to verify the integrity of database files and report failures if these files are inaccessible，corrupt or inconsistent.
• C、 Health Monitor checks can be used to verify the contents of dictionary entries for each dictionary object and fix it automatically.
• D、 Health Monitor checks are always initiated manually when there is some critical error.

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

An IPsec tunnel is established on an SRX Series Gateway on an interface whose IP address was obtained using DHCP.Which two statements are true? （）(Choose two.)

• A、Only main mode can be used for IKE negotiation
• B、A local-identity must be defined
• C、It must be the initiator for IKE
• D、A remote-identity must be defined

第14题：

Your database is running in NOARCHIVELOG mode. You want to put the database in ARCHIVELOG mode. Which two statements regarding archive log destinations are true？（）

• A、The destination must be global only.
• B、A maximum of five destinations can be assigned.
• C、A maximum of ten different destinations can be assigned.
• D、All the destinations are determined by the server automatically.
• E、The destination may be local or remote for a Standby Database.
• F、The destination can be changed by setting the LOG_ARCHIVE_FORMAT initialization parameter.

第15题：

You database is running an ARCHIVELOG mode. The following parameter are set in your database instance: LOG_ARCHIVE_FORMAT = arch+%t_%r.arc LOG_ARCHIVE_DEST_1 = ‘LOCATION = /disk1/archive’ DB_RECOVERY_FILE_DEST_SIZE = 50G DB_RECOVERY_FILE = ‘/u01/oradata’ Which statement is true about the archived redo log files?（）

• A、They are created only in the location specified by the LOG_ARCHIVE_DEST_1 parameter.
• B、They are created only in the Fast Recovery Area.
• C、They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and in the default location $ORACLE_HOME/dbs/arch.
• D、They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the location specified by the DB_RECOVERY_FILE_DEST parameter.

第16题：

You want to set the following initialization parameters for your database instance: LOG_ARCHIVE_DEST_1 = 'LOCATION=/disk1/arch' LOG_ARCHIVE_DEST_2 = 'LOCATION=/disk2/arch' LOG_ARCHIVE_DEST_3 = 'LOACTION=/disk3/arch' LOG_ARCHIVE_DEST_4 = 'LOCATION=/disk4/arch MANDATORY' Identify the statement that correctly describes this setting.（）

• A、The MANDATORY location must be a flash recovery area.
• B、The optional destinations may not use the flash recovery area.
• C、This setting is not allowed because the first destination is not set as MANDATORY.
• D、The online redo log file is not allowed to be overwritten if the archived log cannot be created in the fourth destination.

第17题：

Which three statements are true regarding the data types in Oracle Database 10g/11g?（）

• A、Only one LONG column can be used per table 
• B、A TIMESTAMP data type column stores only time values with fractional seconds 
• C、The BLOB data type column is used to store binary data in an operating system file 
• D、The minimum column width that can be specified for a VARCHAR2 data type column is one 
• E、The value for a CHAR data type column is blank-padded to the maximum defined column width

第18题：

The database is running in ARCHIVELOG mode and the FORMAT option is not configured in RMAN for disk backups. You configured the flash recovery area location and size by using the DB_RECOVERY_FILE_DEST and DB_RECOVERY_FILE_DEST_SIZE initialization parameters. Which statement is correct in this scenario？（）

• A、 If the FORMAT option to the RMAN BACKUP command is specified， then RMAN creates backup pieces and image copies in the flash recovery area with names in the Oracle Managed Files （OMF） format.
• B、 If any local destinations for LOG_ARCHIVE_DEST_n are set， then archived redo logs are stored in these destinations as well as in the flash recovery area.
• C、 If the flash recovery area location is configured using the DB_RECOVERY_FILE_DEST initialization parameter， then the RMAN backup of Oracle managed datafiles （OMF） only will go to the flash recovery area by default.
• D、 If no other destination is configured for recovery files， then RMAN places the control file autobackups in the flash recovery area by default.

第19题：

Which statement is true regarding remote archive log file destinations？（）

• A、Only two destinations per remote database can be specified.
• B、Destination is an Oracle Net alias specified by using the SERVICE keyword.
• C、The REOPEN attribute must be used when using remote archive log file destinations.
• D、The service name is resolved by searching sqlnet.ora file for the remote database name.

第20题：

第21题：

第22题：

第23题：