网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
单选题
The production database has been functional for the last seven days. Because of application requirements, some of the initialization parameters were changed during run time without any comments. You have asked to find out the value of the parameters when the instance was started.Which source would you use to locate this information?()
A
Fixed views
B
The alert log file
C
The parameter file
D
The server parameter file
E
Dynamic performance views
参考答案
参考解析
解析:
暂无解析
更多 “单选题The production database has been functional for the last seven days. Because of application requirements, some of the initialization parameters were changed during run time without any comments. You have asked to find out the value of the parameters when the instance was started.Which source would you use to locate this information?()A Fixed viewsB The alert log fileC The parameter fileD The server parameter fileE Dynamic performance views” 相关考题
考题
By the end of last month, three English songs() .
A. have taughtB. have been taughtC. has taughtD. had been taught
考题
Millions of pounds’ worth of damage ( ) by a storm which swept across the north of England last night.
A. has been causedB.have been causedC.will be causedD.will have been caused
考题
That man ( ) at the bus stop for the last half hour.--- Shall I tell him that the last bus ( )
A.has stood … has already goneB.has been standing… has already beenC.is standing… has already goneD.has been standing…has already gone
考题
Millions of pounds’ worth damage ______ by a storm which swept across the north of England last night.
A has been causedB had been causedC will be causedD will have been caused
考题
Joseph ______to evening classes since last month, but he still can’t say “What’s your name?” in Russian.A.has been goingB.wentC.goesD.has gone
考题
That the possible deformation or fracture of the side shell plating or supporting structure due to the lightering activities between the time of the last annual survey and the departure on its last voyage is a potential contributing factor ______.A.deserves further considerationB.has been determined by ABSC.reveals that the vessel experienced heavy lossesD.has been the general consideration of ABS surveyors
考题
The production database has been functional for the last seven days. Because of application requirements, some of the initialization parameters were changed during run time without any comments. You have asked to find out the value of the parameters when the instance was started.Which source would you use to locate this information?()A、 Fixed viewsB、 The alert log fileC、 The parameter fileD、 The server parameter fileE、 Dynamic performance views
考题
When a staging server is used as an environment for testing new data in a default WebSphere Commerce installation, which of the following are true about the staging server?()A、The database has a subset of the tables in the production server database.B、The database has a copy of selected data from the production databaseC、The database logs changes for later propagation.D、The database is accessed as read-only to prevent data corruption.E、The database includes all user and order data for offline processing.
考题
Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens? ()A、archivalB、log writerC、database writerD、system monitorE、process monitorF、change tracking writer
考题
You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on the settings done by the previous DBA. While observing the server settings, you find that the following parameter has been set in the parameter file of the database: REMOTE_OS_AUTHENT = TRUE What could have been the reason to set this parameter as TRUE?()A、to enable operating system authentication for a remote clientB、to restrict the scope of administration to identical operating systemsC、to allow the start up and shut down of the database from a remote clientD、to enable the administration of the operating system from a remote clientE、to disable the administration of the operating system from a remote client
考题
Initially, for the Automatic Workload Repository (AWR) statistics,the retention period is set to 7 days, the collection interval is set to 30 minutes and the collection level is set to Typical in your production database. You have been using the Memory Advisor for the last three months to generate recommendations for tuning memory components. However,when you observe the Memory Advisor on a Friday,you find that the statistics are available only for two days, Thursday and Friday,of that week. What would have caused the statistics to be removed?()A、On Wednesday, the statistics have been purged.B、On Wednesday, the retention period has been set to zero.C、On Wednesday, the collection interval has been set to zero.D、On Wednesday, the collection level has been changed to All.E、On Wednesday, the retention period has been set to one day.F、On Wednesday, the retention period has been set to two daysG、On Wednesday, the collection level has been changed to Typical.H、On Wednesday, the collection interval has been set to 1440 minutes.
考题
In your Oracle 10g database , you have scheduled a job to update the optimizer statistics at 05:00 pm every Friday. The job has successfully completed. Which three pieces of information would you check to confirm that the statistics have been collected?()A、average row sizeB、last analyzed dateC、size of table in bytesD、size of table in database blocksE、number of free blocks in the free listF、number of extents present in the table
考题
You work as a database administrator at Certkiller .com. In your production database there is a job, CALC_STAT, which has been scheduled to run every Friday at 5.00 p.m. CALC_STATupdates the optimizer statistics for the objects owned by the APPSschema. You want the task to be generic, thereby allowing users to modify the attributes of the task at run time without affecting the original task.Which component of Oracle Scheduler must you define to achieve this?()A、 WindowB、 ProgramC、 Job classD、 Window group
考题
单选题You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on the settings done by the previous DBA. While observing the server settings, you find that the following parameter has been set in the parameter file of the database: REMOTE_OS_AUTHENT = TRUE What could have been the reason to set this parameter as TRUE?()A
to enable operating system authentication for a remote clientB
to restrict the scope of administration to identical operating systemsC
to allow the start up and shut down of the database from a remote clientD
to enable the administration of the operating system from a remote clientE
to disable the administration of the operating system from a remote client
考题
单选题The sentence “But this has rarely been a one-way street.” in the last paragraph means that _____.A
contemporary art has been nourished by modern scienceB
modern science has been nourished by artC
artists can become scientists and scientists can become artistsD
the impacts of modern art and science are actually mutual
考题
单选题Hannah finished building her new all-purpose projects room last year, and she has been working in the room ever since.A
and she has been working in the room ever sinceB
and since that time she has worked thereC
where always since she worksD
she has been working in that room ever sinceE
and since then is working there
考题
单选题Your database is in the NOARCHIVELOG mode. Since last night’s offline backup, the logs in group 1 have been written to twice. This morning, the SYSTEM data file has become corrupted. Up to what point can it be recovered?()A
until the last commitB
cannot be recoveredC
until the last offline backupD
until the beginning of the last transaction
考题
单选题Who has been acting CEO for the last two months?A
Gerald WallaceB
Ben HolmesC
Clive WarrenD
Bella Haskins
考题
多选题When a staging server is used as an environment for testing new data in a default WebSphere Commerce installation, which of the following are true about the staging server?()AThe database has a subset of the tables in the production server database.BThe database has a copy of selected data from the production databaseCThe database logs changes for later propagation.DThe database is accessed as read-only to prevent data corruption.EThe database includes all user and order data for offline processing.
考题
单选题The international situation has been growing _____ difficult for the last few years.A
invariablyB
presumablyC
increasinglyD
dominantly
考题
单选题You work as a database administrator for Supportcenter.cn. In your production database, the size of Database Buffer Cache needs to be increased immediately for the current as well as future instances of the database. The Oracle instance has been configured to accommodate any changes in the size of the memory structures. At this is production database, you want to accomplish this task with no impact on the user’s connections. Which activity must you have completed before accomplishing this task?()A
You must have started the database instance in restricted mode.B
You must have started the database instance inNORMALmode.C
You must have started the database instance with server parameter file.D
You must have started the database instance but must not have mounted.E
You must have started the database instance but must not have opened.
考题
单选题You are using recovery Manager (RMAN) with a recovery catalog to backup up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. The database was open and transactions were recorded in the redo logs. Because of fire in the building you lost your servers having the production database and the recovery catalog database. The archive log files generated after the last backup are intact on one of the remote locations. While performing a disaster recovery of the production database what is the next step that you must perform after restoring the data files and applying archived redo logs?()A
Open the database in NORMAL modeB
Open the database in read-only modeC
Open the database in RESTRICTED modeD
Open the database with the RESETLOGS option
考题
单选题The production database has been functional for the last seven days. Because of application requirements, some of the initialization parameters were changed during run time without any comments. You have been asked to find out the value of the parameters when the instance was started. Which source would you use to locate this information?()A
fixed viewsB
the alert log fileC
the parameter fileD
the server parameter fileE
dynamic performance views
考题
单选题Initially, for the Automatic Workload Repository (AWR) statistics,the retention period is set to 7 days, the collection interval is set to 30 minutes and the collection level is set to Typical in your production database. You have been using the Memory Advisor for the last three months to generate recommendations for tuning memory components. However,when you observe the Memory Advisor on a Friday,you find that the statistics are available only for two days, Thursday and Friday,of that week. What would have caused the statistics to be removed?()A
On Wednesday, the statistics have been purged.B
On Wednesday, the retention period has been set to zero.C
On Wednesday, the collection interval has been set to zero.D
On Wednesday, the collection level has been changed to All.E
On Wednesday, the retention period has been set to one day.F
On Wednesday, the retention period has been set to two daysG
On Wednesday, the collection level has been changed to Typical.H
On Wednesday, the collection interval has been set to 1440 minutes.
热门标签
最新试卷