-
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 on the Certkiller database. What is the default name of the alert log file in this 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
-
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 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
-
Network topology Exhibit：
https://assets.asklib.com/images/image2/2018073108484671566.jpg
You work as a network engineer for. You are required to set up the network being displayed in the network topology exhibit through the console using IOS commands.
A . 正确
B . 错误
-
While you are working in a space，the fixed CO2 system is accidentally activated．You should（）.
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
-
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 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.
-
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 should have a health（）if you work in a restaurant.
A . diploma
B . certificate
C . license
D . passport
-
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 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.
-
You are likely ________ the job offer as you have some work experience in this business.
-
It is advisable to think carefully before entering in to a career in medicine, as this is a field which _____ a lot of dedication and long working hours.
-
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.
-
“When are you going to visit your uncle in Chicago？”“As soon asour work for tomorrow．”
A.we’re complete
B.we’d complete
C.we’ll complete
D.we complete
-
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 past, people would look upon dedication to work with contempt. （）
