-
You work as a database administrator for Certkiller .com. In the middle of a transaction， a user session was abnormally terminated but the instance is still up and the database is open. Which two statements are true in this scenario？（）
A . Event Viewer gives more details on the failure.
B . The alert log file gives detailed information about the failure.
C . PMON rolls back the transaction and releases the locks.
D . SMON rolls back the transaction and releases the locks.
E . The transaction is rolled back by the next session that refers to any of the blocks updates by the failed transaction.
F . Data modified by the transaction up to the last commit before the abnormal termination is retained in the database.
-
You are working in a dedicated server environment. Your database is running in the automatic Program Global Area （PGA） memory management mode. Which two statements are correct in this scenario？（）
A . The WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO.
B . The Oracle database automatically controls the amount of PGA memory allotted to SQL work areas.
C . Setting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic PGA memory management.
D . The SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA memory management mode.
-
You are working in a dedicated server environment. Your database is running in the automatic Program Global Area （PGA） memory management mode. Which two statements are correct in this scenario？ （）
A . The WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO.
B . The Oracle database automatically controls the amount of PGA memory allotted to SQL work areas.
C . Setting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic PGA memory management.
D . The SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA memory management mode.
-
You work as a network technician at Company. Your boss， Mrs.， is interested in the Cisco Compatible Extensions program. What are three features of this program？ （）
A . Accounting
B . Analog and digital voice
C . Mobility
D . Security
E . Routing and switching
F . VLAN and QoS
-
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.
-
You work as a database administrator for Supportcenter.cn. Your database is in the MOUNT state and you execute the following command to open it ALTER DATABASE OPEN； What two actions are performed as a result of this command？（）
A . All control files are opened
B . All redo files are opened
C . The password file is opened
D . The parameter file is opened
E . All online data files are opened
-
You are designing an integration test plan for a Windows Azure .NET 3.5 application. You need to recommend a testing environment that allows developers to debug the application while accessing data in the cloud. What should you recommend？（）
A . Run the application on Windows Azure. Use the development storage account.
B . Run the application on Windows Azure. Use a Windows Azure Storage account.
C . Run the application in the development fabric. Use the development storage account.
D . Run the application in the development fabric. Use a Windows Azure Storage account
-
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 a senior network administrator at TestKing, and while performing thepassword recovery procedure on your 2500 series Cisco router, you type in thefollowing command:o/r 0x2142What is the purpose of this command?（）
A . It is used to restart the router.
B . It is used to bypass the configuration in NVRAM.
C . It is used to enter ROM Monitor mode.
D . It is used to view the lost password.
E . It is used to save the changes to the configuration.
-
You work as a database administrator for Supportcenter.cn. You are using Recovery Manager （RMAN） to perform backups in your databases. Which four backup operations can be performed using RMAN？（）
A . A backup of the target database when it is mounted
B . A backup of online redo log files when the database is open
C . A backup of only used data blocks in the file beingbeingbackup up
D . A backup of online， read/write data files when the database is open
E . A backup of only those data blocks that have changed since a previous backup
F . A backup of online， read/write data files when the database is in the NOMOUNT state.
-
While logged into a router, you wish to see the RIP routing updates in real time as they are sent and received. Which command would you issue to see these updates?（）
A . Show ip protocols
B . Show ip route rip
C . Debug ip rip
D . Debug ip updates
E . Debug ip transactio
-
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
-
A customer claims that while redeploying a web application in the production system all their customers are having to log in again. What do you recommend? （）
A . Sessions can't be preserved when redeploying applications. The customer needs to consider redeployment during late nights when the traffic is low.
B . Change the flag responsible for the development mode of their environment. In the production mode, all sessions are preserved while redeploying application.
C . Change Hotspot to JRockit. Sessions can't be preserved on HotSpot when redeploying application.
D . Use flag -version when redeploying the application. This will switch on the Side By Side deployment feature and preserve existing sessions.
E . Open a service request with Oracle Support. This is unexpected behavior. Sessions are preserved without any extra settings.
-
You work as a database administrator for Certkiller .com. You received the following error while working on your database： ORA-01555： snapshot too old In which situation would you receive such an error？（）
A . You performed rollback after commit.
B . If a log switch occurs in your database.
C . Thearchiverfails to generate an archived log file.
D . Instance recovery fails to find one of the redo log files.
E . A long-running query is unable to get read-consistent image.
F . If you perform manual undo management operations in auto mode.
-
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
-
While working in setup mode, a configuration line is typed incorrectly. What should you do to exit setup mode, without executing or saving any of the mistakes you made?（）
A . Type exit at the setup dialog.
B . Type close at the setup dialog.
C . Press the Ctrl-C key combination.
D . Press the Ctrl-X key combination.
E . Issue the copy startup-config command.
F . Issue the 'write e" command.
G . Issue the "write mem" command
-
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.
-
Suppose you work in a big firm and find English very important for your job because you of- ten deal with foreign businessmen. Now you are looking for a place where you can improve your English, especially your spoken English.
Here are some advertisements about English language training from newspapers. You may find the information you need. Global English Center
.General English in all four skills: listening, speaking, reading and writing.
.3-month (700 yuan ), 6-month (1,200 yuan )and one-year (2,000 yuan )courses.
.Choice of morning or evening classes, 3 hours per day, Mon. —Fri.
.Experienced college English teachers.
.Close to city center and bus stops.
Tel: 67605272 Add: 105 Zhongshan Road, 100082
Modern Language School
.Special courses in English for business, travel, banking, hotel management and office skills.
.Small classes (12—16 students on Sat. & Sun. from 2:00—5:00pm.)
.Native English teachers from Canada and USA.
.3-month course: 1,050yuan; 6-month course: 1,850yuan.
Write or phone: Modern Language School, 675 Park Road, 100056 Tel: 67353019
The 21st Century English Training Centre
.We specialize in effective teaching at all levels.
.We offer morning or afternoon classes, both of which last three months and a half at a cost of 800yuan.
.We also have a six-week TOEFL preparation class during winter and summer holidays.
.Entrance exams: June 1 and Dec. 1.
.Only 15-minute walk from city center.
Call 67801642 for more information
The International House of English
.Three/Six-month English courses for students of all levels at very low cost: 60yuan for 12 hours per week; convenient class hours: 9: 00 - 12: 00 am. and 2: 00 - 5: 00 pm.
.A four-month evening program for developing speaking skills (same cost as day classes).
.Well-trained Chinese and foreign teachers experienced in teaching English as a second/foreign language.
.Free sightseeing and social activities.
.Very close to the Central Park.
For further information call 67432308
You work from 9:00 am to 4:30 pm every day. Which schools will you choose？
A．Global English Center and Modern Language School.
B．Global English Center and the International House.
C．Modern Language School and the 21st Century.
D．The 21st Century and the International House.
-
In today's environment, __________ people are often burned out, it's important for employees to have a personal connection with you and the work you believe in.
A: where
B; when
C; while
-
Is it difficult for you to get up in the morning？ Do you sometimes oversleep？ Are you often late for work or school？ Yes？ Then Hiroyuki Sugiyama of Japan has a special bed for you. Hiroyuki’s bed
188. Is it difficult for you to get up in the morning？ Do you sometimes oversleep？ Are you often late for work or school？ Yes？ Then Hiroyuki Sugiyama of Japan has a special bed for you. Hiroyuki’s bed will get you up in the morning! Here is how it works: The bed is connected to an alarm clock. First, the alarm clock rings. You have a few minutes to wake up. Next, a tape recorder in the bed plays soft music or other pleasant sounds. A few minutes later, a second recording plays. The second recording can be loud music or unpleasant sounds. If you don’t get up after the second recording, you’ll be sorry. A mechanical “foot” is in the bed. The mechanical foot kicks you in the head. Then the bed waits a few more minutes. What! You’re still in bed! Slowly, the top of the bed rises higher and higher. The foot of the bed goes lower and lower. Finally, the bed is vertical. You slide off the bed and onto the floor. You are awake and out of bed. Hiroyuki made his bed because he wanted to win a contest. He works for Honda Motor Company. Once every two years, Honda has a contest—the “All Honda Idea Contest”. In 1996 Hiroyuki won a prize for his bed. [共5题]
(1) The purpose of the passage is ________.
(A) to praise Hiroyuki
(B) to tell a story
(C) to introduce a special bed
(D) to wake somebody up
(2) What does the special bed do first in the morning？
(A) Its tape recorder plays soft music.
(B) Its tape recorder plays loud music.
(C) It kicks you in the head.
(D) Its alarm clock rings.
(3) If you don’t wake up after the clock rings, what will happen？
(A) The bed becomes vertical and you slide off the bed.
(B) The tape recorder plays pleasant sounds.
(C) You will be late for work.
(D) The mechanical “foot” kicks you in the head.
(4) Hiroyuki made such a special bed because ________.
(A) he wanted to win the contest held by his company.
(B) he was good at inventing new things.
(C) he wanted to make money.
(D) he sometimes overslept.
(5) Who is Hiroyuki？
(A) A scientist. (B) A company worker. (C) An inventor. (D) A carpenter.
-
In the process of completing a work sheet, you determine that the Income Statement debit column totals $83,000, while the Income Statement credit column totals $65,000. To enter net income （） for the period into the work sheet would require an entry to
A．theAdjustmentsdebitcolumnandtheAdjustmentscreditcolumn．
B．theUnadjustedTrialBalancedebitcolumnandtheAdjustmentscreditcolumn．
C．itisnotpracticaltoenterNetIncomeontheworksheet．
D．theBalanceSheet﹠StatementofOwner’sEquitydebitcolumnandtheIncomeStatementcreditcolumn．
E．theIncomeStatementdebitcolumnandtheBalanceSheet﹠StatementofOwner’sEquitycreditcolumn．
-
One silly question I simply can't stand is "How do you feel？". Usually the question is asked of a man in action --- a man on the go, walking along the street, or busily working at his desk. So what do you expect him to say？ He'll probably say, "Fine, I'm all right," but "you've put a bug in his ear" -- maybe now he's not sure. If you are a good friend, you may have seen something in his face, or his walk, that he overlooked that morning. It starts him worrying a little. First thing you know, he looks in a mirror to see if everything is all right, while you go merrily on your way asking someone else, "How do you feel？"
Every question has its time and place. It's perfectly acceptable, for instance, to ask "How do you feel？" if you're visiting a close friend in the hospital, But if the fellow is walking on both legs, hurrying to make a train, or sitting at his desk working, it's no time to ask him that silly question.When George Bernard Shaw, the famous writer of plays was in his eighties, someone asked him "How do you feel？" Shaw put him in his place. "When you reach my age," he said, "either you feel all right or you're dead."
1.According to the writer, greetings, such as "How do you feel？" ____.
A、show one's consideration for others
B、are a good way to make friends
C、are proper to ask a man in action
D、generally make one feel uneasy
2.The question "How do you feel？" seems to be correct and suitable when asked of ____.
A、a man working at his desk
B、a person having lost a close friend
C、a stranger who looks somewhat worried
D、a friend who is ill
3.The writer seems to feel that a busy man should ____.
A、be praised for his efforts
B、never be asked any question
C、not be bothered
D、be discouraged from working so hard
4.George Bernard Shaw's reply in the passage shows his ____.
A、cheerfulness
B、cleverness
C、ability
D、politeness
5.“You've put a bug in his ear ”means that you've ____.
A、made him laugh
B、shown concern for him
C、made fun of him
D、given him some kind of warning
