-
You are working on a test database where instance recovery takes a considerable amount of time.How can reduce the recovery time？（）
A . By multiplexing the control files
B . By multiplexing the redo log files
C . By decreasing the size of redo log files
D . By configuring mean time to recover （MTTR） to a lower value
E . By setting the UNDO_RETENTION parameter to a higher value
-
You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true？ （）
A . Flashback logs are not archived.
B . Flashback logs are maintained in redo log files.
C . Flashback logs are maintained in the Flash Recovery Area.
D . Flashback logs are used to maintain Flashback Database related errors.
E . Flashback logs need to be cleared manually after you disable Flashback Database.
-
You are working on Oracle Database 10g， which is in ARCHIVELOG mode. All the archived log files are intact. In which scenario would performing a recovery require the opening of the database with the RESETLOGS option？（）
A . loss of a tempfile
B . loss of a system data file
C . loss of one of the control files
D . loss of one of the tablespaces
E . loss of a member from each redo log group
F . loss of the only member of an unarchived redo log grou
-
You have a portable computer that runs Windows 7. The computer is configured to keep an offline versionof files located in a network share. You need to identify whether you are working on an offline version of a file. What should you do?（）
A . From Sync Center， click View sync partnerships.
B . From Action Center， click View archived messages.
C . From Windows Explorer， select the file and then view the toolbar.
D . From Windows Mobile Device Center， click the Connection settings.
-
When testing a Class A EPIRB you will know the EPIRB is working properly if you hear on 99.5 Mhz FM or any vacant frequency on a nearby AM radio（）.
A . a distinctive signal
B . the Morse Code signal for SOS
C . a computerized voice announcement of Mayday
D . your vessel's International Radio Call Sig
-
You are working on an Oracle Database 10g database. Because of data loss， you decided to perform a Flashback Database operation using the following command： SQL> FLASHBACK DATABASE TO TIMESTAMP（SYSDATE ？5/24）； Which two statements are true？ （）
A . SYSDATE should not be used with TIMESTAMP.
B . The database must have multiplexed redo log files.
C . The database must be in the MOUNT state to execute the command.
D . The database must be opened with the RESETLOGS option after the flashback operation.
E . The entire database needs to be restored from the most recent backup before the flashback operation.
-
You are working on Oracle Database 10g， which is in ARCHIVELOG mode. All the archived log files are intact. In which scenario would performing a recovery require the opening of the database with the RESETLOGS option？（）
A . loss of one of the tablespaces
B . loss of a system data file
C . loss of one of the control files
D . loss of a tempfile
E . loss of the only member of an unarchived redo log group
F . loss of a member from each redo log grou
-
You are working on the cost budget for one project. Which of the following is true（）
A . This process assigns cost estimates to project activities including risks and contingency plans.
B . The cost baseline will be used to measure variances and future project performance.
C . This process assigns cost estimates for expected future period operating costs.
D . The cost baseline is the expected cost for the project.
-
If you know that the vessel you are about to call on the VHF radio maintains a radio watch on both the working and the calling frequencies，which frequency should you call on? （）
A . Calling frequency
B . Distress frequency
C . Urgency frequency
D . Working frequency
-
You are working on the APPDB database as a DBA. The database has a default Flashback Data Archive DFLA1 created on it. You issued the following command to drop the Flashback Archive FLA1: DROP FLASHBACK ARCHIVE fla1,What is the effect of this command?（）
A . The Flashback Archive FLA1 is dropped only if it is empty.
B . The tablespace having Flashback Archive is dropped.
C . The Flashback Archive FLA1 is dropped after moving the existing data in it to the default Flashback Archive.
D . The Flashback Data Archive and historical data are dropped.
-
A Cisco Catalyst switch is part of the CIS network. As an experienced network administrator, you are thinking of filtering the traffic within VLANI00 with the use of a VACL named "test" on that switch. Which of the following command will enable that?（）
A . interface vlan 100 ip access-group test in
B . interface vlan 100 ip access-group test
C . vlan access-map test 100
D . vlan filter test vlan-list 100
-
You work as a technician at TestKing. You are configuring a Cisco router. You want to configure the IP address on an interface.Which command should you use?（）
A . router(config-if)#ip address 142.8.2.1 subnet mask 255.255.252.0
B . router(config-if)#142.8.2.1 0.0.3.255
C . router(config-if)#ip address 142.8.2.1 255.255.252.0
D . router(config-if)#142.8.2.1 subnet mask 255.255.252.0
E . router(config-if)#ip address 142.8.2.1 0.0.3.255
F . router(config-if)#ip address 142.8.2.1 subnet mask /22
-
You are working on a 24x7 （available 24 hours per day， 7 days per week） production database. An operating system （OS） user deletes the alert log file accidentally. Which statement in this scenario is true？（）
A . The database crashes.
B . The DBA needs to re-create the file.
C . The file gets re-created automatically.
D . The file gets restored automatically from the last backup.
E . The DBA needs to perform a complete database recovery.
F . The DBA needs to perform an incomplete database recovery.
-
You are working on a database that must be functioning 24 hours a day， 7 days a week. The database isconfigured in ARCHIVELOG mode. Which two options do you have for performing user-managed backups（）
A . You can perform consistent backups only.
B . You can perform a complete database backup without shutting down the database instance.
C . You can back up data files only when all data files have the same SCN recorded in the control file.
D . You can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGINBACKUP or ALTER DATABASE BEGIN BACKUP command
-
You are working on an Oracle Database 10g database. Because of data loss， you decided to perform a Flashback Database operation using the following command： SQL> FLASHBACK DATABASE TO TIMESTAMP（SYSDATE 5/24）; Which two statements are true？ （）
A . SYSDATE should not be used with TIMESTAMP.
B . The database must have multiplexed redo log files.
C . The database must be in the MOUNT state to execute the command.
D . The database must be opened with the RESETLOGS option after the flashback operation.
E . The entire database needs to be restored from the most recent backup before the flashback operation.
-
You work as a database administrator for Certkiller .com. You find that users with DBA role are using more CPU resources than what is allocated in their profiles. Which action would you take to ensure that resources limits are imposed on these users？ （）
A . Assign the DEFAULT profile to the users
B . Set the RESOURCE_LIMIT parameter to TRUE in the parameter file
C . Create a new profile with CPU restrictions and assign it to the users
D . Specify the users as members of the DEFAULT_CONSUMER_GROUP
E . Revoke the DBA role and grant CONNECT and RESOURCE role to the user
-
You are working on an Oracle Database 10g database. For which purposes would you use the Flashback Transaction Query feature？ （）
A . To recover a dropped table.
B . To recover a dropped schema.
C . To recover data from a truncated table.
D . To view changes made by all the transactions during a given period of time.
E . To view changes made by a single transaction during a given period of time.
-
You work as a database administrator for Supportcenter.cn. You find that users with DBA role are using more CPU resources than what is allocated in their profiles. Which action would you take to ensure that resources limits are imposed on these users？（）
A . Assign the DEFAULT profile to the users
B . Set the RESOURCE_LIMIT parameter to TRUE in the parameter file
C . Create a new profile with CPU restrictions and assign it to the users
D . Specify the users as members of the DEFAULT_CONSUMER_GROUP
E . Revoke the DBA role and grant CONNECT and RESOURCE role to the user
-
You are working on a database that must be functioning 24 hours a day， 7 days a week. The databaseis configured in ARCHIVELOG mode. Which two options do you have for performing user-managed backups（）
A . You can perform consistent backups only.
B . You can perform a complete database backup without shutting down the database instance.
C . You can back up data files only when all data files have the same SCN recorded in the control file.
D . You can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGINBACKUP or ALTER DATABASE BEGIN BACKUP commands.
-
M:Hi, Jane! How are things with you?W: Oh, I’m now working on a new project.Question: What’s the woman doing now?
-
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.
-
听力原文：M: When are you going to finish this report？ You've been working on it for three months.
W: Only two and a half. But it does seem longer.
Q: What does the woman say about the report？
(18)
A．It's the longest report she's ever written.
B．She's only half way done with it.
C．She'll finish it in two weeks.
D．She has spent less time on it than the man thinks.
-
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．
-
Direction:This part is to test your ability to do practical writing.You are required to write a thanks letter based on the followinginformation given in Chinese.Remember to do your writing on the Answ
