网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
单选题
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” 相关考题
考题 It has been a long time _____I saw you last time. A.sinceB.forC.beforeD.after

考题 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

考题 It has been raining ______ last Saturday.A、onB、 forC、tillD、 since

考题 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 company’s production has been put on the right ______.A.orbit B.course C.route D.track

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