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 . 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.

A . alert_ Certkiller .log B . alertlog_ Certkiller .log C . alert_log_ Certkiller .log D . Certkiller _alert_log.log E . log_alert_： Certkiller .log F . trace_alert_ Certkiller .log

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.

A .  Accounting B .  Analog and digital voice C .  Mobility D .  Security E .  Routing and switching F .  VLAN and QoS

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

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.

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

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

A . 正确 B . 错误

A . Secure the applicators to preserve the charge in the cylinders B . Continue with your work as there is nothing you can do to stop the flow of CO C . Retreat to fresh air and ventilate the compartment before returning D . Make sure all doors and vents are secured

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.

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.

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 . diploma B . certificate C . license D . passport

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

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

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.

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.

A.we’re complete B.we’d complete C.we’ll complete D.we complete

A: where B; when C; while

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.