-
You are maintaining your OLTP database in Oracle10g. You have not set the warning level and critical level threshold values for space usage of the DATA1 tablespace. What will be the impact?()
A . No warning level or critical level alert will be generated.
B . A warning level alert will never be generated, but a critical level alert will be generated when 97 percent space of the DATA1 tablespace is used.
C . A critical level alert will never be generated, but a warning level alert will be generated when 85 percent space of the DATA1 tablespace is used.
D . A warning level alert will be generated at 85 percent space usage of the DATA1 tablespace, and a critical level alert is generated at 97 percent space usage of the DATA1 tablespace.
-
You need to design a strategy to ensure that all servers are in compliance with the business requirements for maintaining security patches. What should you do?()
A . Log on to a domain controller and run the Resultant Set of Policy wizard in planning mode on the domain
B . Log on to each server and run Security Configuration and Analysis to analyze the security settings by using a custom security template
C . Create a logon script to run the secedit command to analyze all servers in the domain
D . Run the Microsoft Baseline Security Analyzer (MBSA) on a server to scan for Windows vulnerabilities on all servers in the domai
-
You are using the control file to maintain information about the database backups that are being performed by Recovery Manager (RMAN). Identify two scenarios is which you must have a recovery catalog.()
A . To store the backup information of multiple database
B . To restrict the amount of space that is used by the backups
C . To maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter.
D . To list the data files that were in a target database at a given time by using the AT option of REPORT SCHEMA command.
-
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
-
You are using the control file to maintain information about the database backups that are being performed by Recovery Manager (RMAN).Identify two scenarios is which you must have a recovery catalog. ()(Choose two.)
A . To store the backup information of multiple database
B . To restrict the amount of space that is used by the backups
C . To maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter.
D . To list the data files that were in a target database at a given time by using the AT option of REPORT SCHEMA command.
-
Your company uses Microsoft Application Virtualization (App-V). You maintain the sequencing for applications. You need to add a template to an existing sequenced application. What should you do?()
A . Edit the application, add the template, and then save the application with a new name.
B . Sequence the template as a new application to the original application installation folder.
C . Restore the sequencing computer and add the template to the original application installation folder.
D . Upgrade the existing sequencing package, add the template to the package, and then save the application.
-
You are maintaining your database in Oracle10g. You are performing the backup by using the BACKUP AS BACKUPSET command at the RMAN prompt. Which file cannot be backed up by using the BACKUP AS BACKUPSET command?()
A . Datafiles
B . Current control file
C . Server parameter file (spfile)
D . Password file
-
You are maintaining an OLTP database in Oracle10g. You have configured the Flash Recovery Area in your database. The Flash Recovery Area is full because you have set the retention policy to NONE. What will you do to resolve the problem?()
A . Increase the value of the FAST_START_MTTR_TARGET initialization parameter.
B . Increase the value of the DB_RECOVERY_FILE_DEST_SIZE parameter.
C . Increase the value of the PGA_AGGREGATE_TARGET initialization parameter.
D . Increase the value of the SGA_TARGET initialization parameter.
-
You are designing a plan for maintaining the WINS infrastructure on the new Windows Server 2003 Active Directory environment. Which factor or factors necessitate the need to maintain the WINS infrastructure?()
A . Client operating systems in use.
B . Server operating systems in use.
C . VPN client access by using PPTP.
D . Installation of Active Directory client software.
-
You use a recovery catalog for maintaining your database backups.You execute the following command:$rman TARGET / CATALOG rman / cat@catdbRMAN > BACKUP VALIDATE DATABASE ARCHIVELOG ALL;Which two statements are true?()
A . Corrupted blocks, if any, are repaired.
B . Checks are performed for physical corruptions.
C . Checks are performed for logical corruptions.
D . Checks are performed to confirm whether all database files exist in correct locations
E . Backup sets containing both data files and archive logs are created.
-
You are designing a plan for maintaining the WINS infrastructure on the new Windows Server 2003 Active Directory environment. Which factor or factors necessitate the need to maintain the WINS infrastructure?()
A . Client operating systems in use.
B . Server operating systems in use.
C . VPN client access by using PPTP.
D . Installation of Active Directory client software.
-
You are maintaining the PROD database of NetFx Corporation. You set the value of the SQL_TRACE parameter to TRUE. What will be the impact of this setting?()
A . The SQL trace facility will generate the performance statistics for all the SQL statements for an instance and write them in the USER_DUMP_DEST directory.
B . The SQL trace facility will generate the performance statistics for all the SQL statements for a session and write them in the USER_DUMP_DEST directory.
C . The SQL trace facility will generate the performance statistics for all the SQL statements for an instance and write them in the BACKGROUND_DUMP_DEST directory.
D . The SQL trace facility will generate the performance statistics for all the SQL statements for a session and write them in the BACKGROUND_DUMP_DEST directory.
-
You are using RMAN to perform a closed database backup of your database. You issue these RMAN commands: STARTUP MOUNT; BACKUP FORMAT ’/BACKUP/df_%d_%s_%p.bus’ DATABASE filesperset = 2; Which components are included in the backup?()
A . Only the data files.
B . Only the data files and the online logs.
C . The data files, control files, and the online logs.
D . The data files and control files, but not the online logs.
-
You are maintaining your database in Oracle10g. You set the value of the UNDO_RETENTION initialization parameter to zero in the initialization parameter file. What will be the impact of specifying this setting?()
A . The database will not start.
B . The database will start but will not retain the undo data in the undo segment.
C . The database will start, and the undo segment will contain the undo data for at least one hour.
D . The database will start, and the undo segment will retain the undo data for at least 15 minutes.
-
If you don’t use English from time to time, you can’t maintain your current English level, let alone upgrade your oral English to the upper level._______________
-
What would you say your weaknesses are?
-
There are 5 recorded dialogues in it. After each dialogue, there is a recorded question. When you hear a question, you should decide on the correct answer from the 4 choices marked A, B, C and D given in your test paper.
-
_______your father wants to know is________ getting on with your studies. A. What; how are you B. What ; how you are C. How ; that you are D. That ; how you are
-
You are using Recovery Manager (RMAN) with a recovery catalog to back up your production d
You are using Recovery Manager (RMAN) with a recovery catalog to back up your production database. Thebackups and the archived redo log files are copied to a tape drive on a daily basis.Because of media failure,you lost your production database completely along with the recovery catalog database.You want to recover the target database and make it functional. You consider performing the following steps to accomplish the task:1) Restore an autobackup of the server parameter file.2) Restore the control file3) Start the target database instance4) Mount the database5) Restore the data files6) Open the database with RESETLOGS option7) Recover the data files8) Set DBID for the target databaseWhich option illustrates the correct sequence that you must use?()
A.8,1,3,2,4,5,7,6
B.1,8,3,4,2,5,7,6
C.1,3,4,2,8,5,6,7
D.1,3,2,4,6,5,7,8
-
Part I Listening Comprehension Section B Directions: This section is to test your ability to understand short conversations. There are 2 recorded conversations in it. After each conversation, there are some recorded questions. Both the conversations and questions will be spoken two times. When you hear a question, you should decide on the correct answer from the 4 choices marked A), B), C) and D) given in your test paper. 9.
A.He’s giving a lecture
B.He’s attending a meeting.
C.He’s speaking on another phone
D.He’s away on a business trip.
-
where are you going on holiday?还可以等于 where are you going ()()your holiday
-
Business interest refers to() A、The amount charged for the use of borowed money You can geraly deduct al oft you pay during the iaxyear on debts related to your trade or business B、The cost of operatng and maintaining your vehicle for business purposes C、Legal and professional fees, such as fees charged by accountants, that are ordinary and necessary expensesdirectly related to operating your business. D、Any amount you pay for the use of property that you do not own
-
Here are the keys to your rooms.Your rooms are on the fifth floor.The () will take you and your luggage to the rooms.I hope you will enjoy your stay with us.
A.assistant manager
B.resident manager
C.boss
D.bellman
-
If you get_______ in a foreign city, you’d better stay where you are and wait for your friends to come to your help.
A.lose
B.to lose
C.losing
D.lost