-
While tuning a SQL statement， the SQL Tuning Advisor finds an existing SQL profile for the statement that has stale statistics available. What would the optimizer do in this situation？（）
A . It updates the existing SQL profiles with current statistics
B . It makes the statistics information available to GATHER_STATS_JOB
C . It initiates the statistics collection process by running GATHER_STATS_JOB
D . It logs a warning message in the alert log so that the DBA can perform statistics collection manually
-
Identify three situations in which you would NOT be able to drop a tablespace. （）
A . when the tablespace is online
B . when the tablespace has segments with data in it
C . when the tablespace is a default permanent tablespace for the database
D . when the tablespace contains a table that is currently being used by transactions
E . when the tablespace contains undo data that is needed to rollback an uncommitted transactio
-
In which situation would you use the Oracle Shared Server configuration？（）
A . when performing export and import using Oracle Data Pump
B . when performing backup and recovery operations using Oracle Recovery Manager
C . when performing batch processing and bulk loading operation in a data warehouse environment
D . in an online transaction processing （OLTP） system where large number of client sessions are idle most of the time
-
Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancel-based recovery？ （）
A . You find that one of the redo log members in each redo log group is lost.
B . You find that a data file that belongs to the USERS tablespace is damaged.
C . You find that a data file that belongs to the SYSTEM tablespace is damaged.
D . You find that the current redo log group is damaged and is not available for recovery.
E . You realized while performing a recovery that an archived redo log file needed for recovery is lost.
-
What aspects should be emphasized in classroom teaching in the view of the scholars who advocate situational method?
A . A. Spoken language is the first; it is the base of written language.
B . B. Written language is the first; it is the base of spoken language.
C . C. Written language and spoken language are of the same importance.
D . D. Written language and spoken language are not of the same importance.
-
In which situation would you use static database registration for a listener（）
A . when multiple databases are to be registered with the listener
B . when DBAs need to connect remotely to start up the database instance
C . when users need to connect the database instance using the host naming method
D . when the database instance that is to be registered with the listener is configured in shared server mode
-
Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancelbased recovery？（）
A . You find that one of the redo log members in each redo log group is lost.
B . You find that a data file that belongs to the USERS tablespace is damaged.
C . You find that a data file that belongs to the SYSTEM tablespace is damaged.
D . You find that the current redo log group is damaged and is not available for recovery.
E . You realized while performing a recovery that an archived redo log file needed for recovery is lost.
-
What two situations prevent the supervisor from silently monitoring the phone conversation of an agent in IPCC Express Enhanced?（）
A . The agent is logged in and is on the phone.
B . The agent is logged in but is not on the phone.
C . The supervisor is a participant in a phone call.
D . The supervisor is not a participant in a phone call.
E . The supervisor has barged in.
-
You are aboard the give-way vessel in a crossing situation．What should you NOT do in obeying the Rules（）.
A . Cross ahead of the stand-on vessel
B . Make a large course change to starboard
C . Slow your vessel
D . Back your vessel
-
In which situation would the use of a static route be appropriate?（）
A . To configure a route to the first Layer 3 device on the network segment.
B . To configure a route from an ISP router into a corporate network.
C . To configure a route when the administrative distance of the current routing protocolis too low.
D . To reach a network is more than 15 hops away.
E . To provide access to the Internet for enterprise hosts.
-
You are using Recovery Manager (RMAN) to perform backups. In which three situations would you perform a compressed backup?（）
A . You are backing up to tape and your tape device performs its own compression.
B . You are making image copies, and you have not enabled tablespace compression.
C . You are using disk-based backups and disk space in your Flash Recovery Area, or other disk-based backup destinations are limited.
D . You are performing your backups to some device over a network where reduced network bandwidth is more important than CPU usage.
E . You are using some archival backup media, such as CD or DVD, where reducing backup sizes saves media costs and archival storage.
-
An overtaking situation would be one in which one vessel is approaching another from more than how many degrees abaft the beam? （）
A . 0°
B . 10°
C . 22.5°
D . None of the above
-
You are on a vessel that cannot comply with the spacing requirement for masthead lights.What is required in this situation（）.
A . The vessel must carry only the lights that comply with the rules; the others may be omitted
B . The vessel's lights must comply as closely as possible，as determined by her government
C . The vessel must be altered to permit full compliance with the rules
D . An all-round light should be substituted for the after masthead light and the stern light
-
120. You are aboard the give-way vessel in a crossing situation. What should you NOT do in obeying the Rules? ______
-
Problem solving information would NOT be used in which of the following situations?
-
In which of the following situations would you prefer to be making a loan?
-
What determines the performance of a computer in the non-networked situation?
-
Which of the following purchase situations would likely be described as high involvement in terms of consumer decision-making?
-
Positioning is how you present yourself in a market situation. Which is these would you NOT include in your positioning statement for a job?
-
When in a crowded situation, what will foreigners do to show the physical contact is involuntary (not a choice)?
-
A situation at work in which you must understand what is being presented would require_____listenmg.
A.casual
B.active
C.negative
-
The author in the second paragraph states what we need in our present situation is______.
A．a continuation of our present serious state
B．worldwide resources exploitation and energy use
C．a movement forward to a new norm to planet research work
D．a state where long range planning is essential to us
此题为多项选择题。
-
What is the situation of would-be jumpers？
-
In the sentence“After the plane took off,Jessica still stood there crying.”,what is th
A．A.”,what is the function of the underlined part？（）
B．B.It's a prepositional phrase, functioning as an adverb
C．C.It's not a phrase, but an adverbial clause
D．D.I's not a phrase, but an independent clause
E．E.It's a prepositional phrase, functioning as the subject
