-
You want a record of all queries that are not using indexes. How would you achieve this?()
A . By enabling the Slow Query Log because all queries that are not using indexes will be logged automatically
B . By enabling the Error Log because not using indexes is an error
C . By enabling the Slow Query Log and using the – log-queries-not-using-indexes option
D . By enabling the Error Log and using the – log-queries-not-using-indexes optio
-
You find today’s performance of your production database to be the best ever. Therefore, you want to be notified in the future whenever the performance degrades by 10% of today’s performance. What is the first step that you would take to ensure this?()
A . create baseline metrics for today’s performance
B . write the current database metrics to a database table and create a trigger to compare with future database statistics
C . write the current database metrics to a flat file and create an operating script to compare with future database statistics
D . write the current database metrics to a database table and create a procedure to compare with future database statistics
E . write the current database metrics to a database table and submit a job using DBMS_JOB to compare with future database statistic
-
When you try to open your database, you receive the following error: ORA-00205: error in identifying control file Where would you find the details required to resolve this error?()
A . audit trail
B . alert log file
C . user trace file
D . online trace file
E . background trace file
F . operating system event viewer
-
You have altered a non-unique index to be invisible to determine if queries execute within an acceptable response time without using this index. Which two are possible if table updates are performed which affect the invisible index columns?()
A . The index remains invisible.
B . The index is not updated by the DML statements on the indexed table.
C . The index automatically becomes visible in order to have it updated by DML on the table.
D . The index becomes unusable but the table is updated by the DML.
E . The index is updated by the DML on the table.
-
When you try to open your database, you receive the following error: ORA-00205: error in identifying controlfile Where would you find the details required to resolve this error?()
A . audit trail
B . alert log file
C . user trace file
D . online trace file
E . background trace file
F . operating system event viewer
-
View the Exhibit and examine the output of the query.
https://assets.asklib.com/images/image2/2018080116223452518.jpg
What do you infer from this()
A . The SGA_TARGET is a static parameter.
B . The instance is started, but the database is not yet open.
C . The server parameter file (SPFILE) was used to start the instance.
D . The SGA_TARGET parameter does not have any effect onthe databaseinstance untiltheSGA_MAX_SIZE parameter is specified.
-
You“ ll find this Travel Guide to be of great ___ in helping you and your children to get around Malaysia.
A . cost
B . price
C . value
D . expenditure
-
After jacking down your liftboat you have an unexpected list.You find that the only cause of this list must be a flooded leg.Your next course of action should be to().
A . Jack the vessel back up to a safe height
B . Proceed on to your next destination since the list is unimportant
C . Pump out all ballast to gain reserve buoyancy
D . Notify the Coast Guard
-
You started a long transaction. Before committing, you executed a query on one of the tables currently being modified. You received the following error: ORA-01555: snapshot too old How would you prevent such an error in the future?()
A . guarantee undo retention
B . add one more redo log group
C . size the redo log files appropriately
D . size the UNDO tablespace appropriately
E . size the SYSTEM tablespace appropriately
F . configure an appropriate undo retention interval
G . change automatic undo management to manual
-
During consultation, you find that a customer has multiple asset closets and will be adding more in the future. Which NAS physical deployment model would you suggest to this customer?()
A . edge
B . central
C . Layer2
D . Layer3
-
ou need to create a data block for query operations in the RETIRED_EMPLOYEES form module. Which three data sources can you use for this block?()
A . vector
B . database view
C . database table
D . transactional trigger
E . PL/SQL table of records
F . multi-dimensional array
-
One of the redo log members in your database is lost. You queried V$logfile for further details. What would be the member’s status?()
A . LOST
B . INVALID
C . EXPIRED
D . DELETED
E . CORRUPT
F . UNKNOWN
G . OBSOLETE
-
If you keep walking in this __________ , you will find a restaurant just around the corner.
-
If you visit a hospital, you will surely find medical sitting at counters, ready to answer queries of people visiting the hospital.
-
Do you find getting up in the morning so difficult that it's painful? This might be called laziness, but Dr. Kleitman has a new explanation. He has proved everyone has a daily energy cycle.
During the hours when you labor through your work you may say that you're "hot. "That's true. The time of day when you feel most energetic is when your cycle of body tem-perature is at its peak (顶峰). For some people, the peak comes during the forenoon. For others it comes in the afternoon or evening. No one has discovered why this is so, but it leads to such familiar monologues (自言自语) as: "Get up, John. You'll be late for work again. " The possible explanation to the trouble is that John is at his temperature-an-ener-gy peak in the evening. Much family quarrelling ends when husbands and wives real-ize what these energy cycles mean and which cycle each member of the family has.
You can't change your energy cycle, but you can learn to make your life fit it better. Dr. Kleitman believes that habit can help. Maybe you're sleepy in the evening but feel you must stay up late anyway. Counteract (对抗) your cycle to some extent by habitually stay-ing up later than you want. If your energy is low in the morning but you have an important job to do early in the day, rise before your usual hour. This won't change your cycle, but you'll get up steam (振作精神) and work better at your low point.
Get off to a slow start which saves your energy. Get up with a leisurely yawn (打哈欠) and stretch. Sit on the edge of the bed a minute before putting your feet on the floor. Avoid the troublesome search for clean clothes by laying them out the night before. When-ever possible, do routine work in the afternoon and save tasks requiring more energy or concentration for your sharper hours.
According to the writer, if a person finds getting up early a problem, most proba-bly ______.
A.he refuses to follow his own energy cycle
B.he is a lazy person
C.he is not sure when his energy is low
D.he is at his peak in the afternoon or evening
-
Oh,boy,why are you killing your time this way?Can’t you find something()doing at all?
A.useful
B.valuable
C.worth
D.good
-
Enclosed please find our Order No.ST 112.If the quality is up to our expectation, we are prepared to place a large order with you next year. Your close attention to this order will be highly appreciated.(英译中)
-
听力原文:W: This is the third time you have been late this week, Robert. You'll have to do better than that, or I might find it necessary to let you go.
M: It won't happen again, I assure you.
W: This is the last time I believe you.
What is the most probable relationship of the two people?
A.Doctor and patient.
B.Boss and employee.
C.Receptionist and tourist.
D.Teacher and student.
-
You can find out about school clubs from this prospectus.
-
You have altered a non-unique index to be invisible to determine if queries execute within an acceptable response time without using this index.Which two are possible if table updates are performed which affect the invisible index columns?()
A. The index remains invisible.
B. The index is not updated by the DML statements on the indexed table.
C. The index automatically becomes visible in order to have it updated by DML on the table.
D. The index becomes unusable but the table is updated by the DML.
E. The index is updated by the DML on the table.
-
听力原文:Woman: You know that some people will be there because they want to be and some will be there because they have to be. So it helps if you start with a joke or something that captures their attention, and if you stop on a high note as well, you’ll find most people go away feeling good. If you find you’ve got time left, you can use that for questions from the audience.
(16)
-
Stage plays, at first, seem a lot like films. Both use actors, dialogue and scenery. But if you try to make a film by setting up a camera in front of the stage, you will find it won't work. A film made in this way will leave the audience cold. And even worse you'll be wasting a powerful tool— the camera.
A stage is actually a box. One side of the box has been removed so the audience can see what's going on inside. The actors remain at a fixed audience. In the film, however, the camera can bring the audience up close and fix their attention on small but important things: a frightened look, a whisper, a trembling of hands.
The camera offers the film maker freedom allowing him to move easily across barriers (界限) of time and space. He can show his action in real cities and on real farms. He can also use the camera to change the scene dozens of times in one film. No expert of the stage can do this.
The main idea of the text is that______.
A.stage plays and films are two different kinds of art
B.it is always disappointing to turn play into films
C.films have certain advantages over stage plays
D.the camera has made film making easy and possible
-
You’ll find this dictionary most()for learners of English.
A.help
B.helpful
C.helpless
D.helpfully
-
Passage Three:Questions 31 to 35 are based on the following passage.Do you find getting up in the morning so difficult that it’s painful? This might be called laziness, but Dr. Kleitman has a new explanation. He has proved that everyone has a daily energy cycle.
During the hours when you labor through your work you may say that you’re “hot”. That’s true. The time of day when you feel most energetic is when your cycle of body temperature is at its peak. For some people the peak comes during the afternoon. For others it comes in the afternoon or evening. No one has discovered why this is so, but it leads to such familiar monologues (自言自语) as: “Get up, John! You’ll be late for work again!” The possible explanation to the trouble is that John is at his temperature-and-energy peak in the evening. Much family quarrelling ends when husbands and wives realize what these energy cycles mean, and which cycle each member of the family has. You can’t change your energy cycle, but you can learn to make your life fit it better. Habit can help, Dr. Kleitman believes. Maybe you’re sleepy in the evening but feel you must stay up late anyway. Counteract (对抗) your cycle to some extent by habitually staying up later than you want to. If our energy is low in the morning but you have an important job to do early in the day, rise before your usual hour. This won’t change your cycle, but you’ll get up steam (鼓起干劲) and work better at your low point.
Get off to a slow start which saves your energy. Get up with a leisurely yawn and stretch. Sit on the edge of the bed a minute before putting your feet on the floor. Avoid the troublesome search for clean clothes by laying them out the night before. Whenever possible, do routine work in the afternoon and save tasks requiring more energy or concentration for your sharper hours.
第31题:If a person finds getting up early a problem, most probably ________.
A) he is a lazy person
B) he refuses to follow his own energy cycle
C) he is not sure when his energy is low
D) he is at his peak in the afternoon or evening