单选题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？（）Afixed viewsBthe alert log fileCthe parameter fileDthe server parameter fileEdynamic 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 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 views
B
the alert log file
C
the parameter file
D
the server parameter file
E
dynamic performance views
参考解析
解析：
暂无解析
相关考题：
My money______. Could you please lend me some?A. has run out ofB. has run outC. was run out ofD. has been run out
Where there has been delay in carrying goods， the measure of damages ________ generally the difference between the market value of the goods at the time when they ought to have been delivered and the time when they were in fact delivered．A.haveB.hasC.areD.is
In your production database there is a job， CALC_STAT， which has been scheduled to run every Friday at 5：00 p.m. CALC_STAT updates the optimizer statistics for the objects owned by the APPS schema. 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
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
A customer reports the optical drive is no longer responding. Which of the following questionsshould be asked FIRST?（）A、“Did you log in with an administrator account?”B、“Have you been to any inappropriate websites?”C、“What have you changed since the optical drive worked properly?”D、“What has changed since the optical drive worked properly?”
WebSphere Commerce has been successfully installed and tested. WebSphere Commerce Analyzer has been installed and the extraction programs have run with no errors but there is no data in any reports when viewed from the WebSphere Commerce Accelerator. What could be the cause of this problem？（）A、The WebSphere Commerce application server was not startedB、The web server was not startedC、SSL has not been configured on the web serverD、The appropriate listeners were not enabled in Configuration ManagerE、The database server was not started
During initial cluster planning session， a requirement is mandated that application monitoring will Be used to monitor the production database and three application servers. Since all the application servers rely on the database being active， only one resource group has been planned to manage the starting/stopping of the cluster resources. How ill the initial design impact the use of application monitoring？（） A、 Only one application server per resource group can be monitored.B、 Process monitoring is part of RSCT and requires no special scripts.C、 Any application can be monitored as long as it has an application server.D、 Having all application servers in one resource group improves recovery time.
In your production database， data manipulation language （DML） operations are executed on the SALES table.You have noticed some dubious values in the SALES table during the last few days. You are able to track users， actions taken， and the time of the action for this particular period but the changes in data are not tracked.You decide to keep track of both the old data and new data in the table along with the user information. Whataction would you take to achieve this task（）A、Apply fine-grained auditing.B、Implement value-based auditing.C、Impose standard database auditing to audit object privileges.D、Impose standard database auditing to audit SQL statements.
You were recently hired by Certkiller .com as a database administrator. You are asked to find out whether the currently functional listener process， named L1， has been password protected or not. You are not familiar with the file system of the new organization. How would you accomplish the task？（）A、 by using the STATUS command of the Listener control utilityB、 by using the STATUS L1 command of the Listener control utilityC、 by using the SHOW RULES command of the Listener control utilityD、 by using the SET PASSWORD command of the Listener control utilityE、 by searching for the PASSWORD_LISTENER entry in the listener.ora file
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 days.G、On Wednesday， the collection level has been changed to Typical.H、On Wednesday， the collection interval has been set to 1440 minutes.
You are part of the DBA team working for a multinational bank. The team is responsible for performing administrative tasks on the database server located at the home office. The database server at the home office has a production database and a test database named TESTDB. The test database is primarily used for testing database commands and configuration settings befor implementing these settings on the production database. The test database is also used for the development of database applications. You have been asked by the senior DBA to grant the SYSDBA privilege to a new team member， John， so that he can perform some administrative tasks， such as shutdown and startup operations， on TESTDB. You use the password file to configure remote authentication on the TESTDB database. You execute the following statement to grant the SYSDBA privilege to John： SQLGRANT SYSDBA TO john； However， you receive the following error： ORA-01996： GRANT failed： password file ’c：/oracle/ora9i/dbs/testdb.pwd’ is full Which action should you take to add the user john to the password file without removing any of the existing users？（）A、 Create another password file and then re-execute the GRANT statement.B、 Re-create the password file， specifying a larger number of allowed entries， and then re-execute the GRANT statement.C、 Change the value of the REMOTE_LOGIN_PASSWORDFILE initialization parameter in theinitialization parameter file to NONE and then re-execute the GRANT statement.D、 Change the value of the REMOTE_LOGIN_PASSWORDFILE initialization parameter in the initialization parameter file to SHARED and then re-execute the GRANT statement.
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
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 work as a database administrator for Certkiller .com. You have been asked to use a centralized administrative tool to administer your database servers and application servers. In order to achieve the objective， which component would you configure on each database server？（）A、Database ControlB、Management ServerC、Management RepositoryD、Application Server ControlE、Oracle Management Agent
单选题You are part of the DBA team working for a multinational bank. The team is responsible for performing administrative tasks on the database server located at the home office. The database server at the home office has a production database and a test database named TESTDB. The test database is primarily used for testing database commands and configuration settings befor implementing these settings on the production database. The test database is also used for the development of database applications. You have been asked by the senior DBA to grant the SYSDBA privilege to a new team member， John， so that he can perform some administrative tasks， such as shutdown and startup operations， on TESTDB. You use the password file to configure remote authentication on the TESTDB database. You execute the following statement to grant the SYSDBA privilege to John： SQLGRANT SYSDBA TO john； However， you receive the following error： ORA-01996： GRANT failed： password file ’c：/oracle/ora9i/dbs/testdb.pwd’ is full Which action should you take to add the user john to the password file without removing any of the existing users？（）A Create another password file and then re-execute the GRANT statement.B Re-create the password file， specifying a larger number of allowed entries， and then re-execute the GRANT statement.C Change the value of the REMOTE_LOGIN_PASSWORDFILE initialization parameter in theinitialization parameter file to NONE and then re-execute the GRANT statement.D Change the value of the REMOTE_LOGIN_PASSWORDFILE initialization parameter in the initialization parameter file to SHARED and then re-execute the GRANT statement.
单选题In your production database there is a job， CALC_STAT， which has been scheduled to run every Friday at 5：00 p.m. CALC_STAT updates the optimizer statistics for the objects owned by the APPS schema. 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？（）AWindowBProgramCJob classDWindow group
单选题You are maintaining your database in Oracle10g. You are required to view the list of files that have not been backed up for the last seven days. Which RMAN command will you use？（）A LIST commandB CROSSCHECK commandC REPORT commandD SHOW command
单选题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
单选题A customer reports the optical drive is no longer responding. Which of the following questionsshould be asked FIRST?（）A“Did you log in with an administrator account?”B“Have you been to any inappropriate websites?”C“What have you changed since the optical drive worked properly?”D“What has changed since the optical drive worked properly?”
填空题What has been done by the heating system supplier?____ has been asked to find out the cause of the accident.
单选题WebSphere Commerce has been successfully installed and tested. WebSphere Commerce Analyzer has been installed and the extraction programs have run with no errors but there is no data in any reports when viewed from the WebSphere Commerce Accelerator. What could be the cause of this problem？（）AThe WebSphere Commerce application server was not startedBThe web server was not startedCSSL has not been configured on the web serverDThe appropriate listeners were not enabled in Configuration ManagerEThe database server was not started
单选题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 were recently hired by an organization as a database administrator. You are asked to find out whether the currently functional listener process， named L1， has been password protected or not. You are not familiar with the file system of the new organization. How would you accomplish the task？（）Aby using the STATUS command of the Listener control utilityBby using the STATUS L1 command of the Listener control utilityCby using the SHOW RULES command of the Listener control utilityDby using the SET PASSWORD command of the Listener control utilityEby searching for the PASSWORD_LISTENER entry in the listener.ora file
单选题In your production database， data manipulation language （DML） operations are executed on theSALES table. You have noticed some dubious values in the SALES table during the last few days. Youare able to track users， actions taken， and the time of the action for this particular period but the changesin data are not tracked. You decide to keep track of both the old data and new data in the table along withthe user information. What action would you take to achieve this task（）AApply fine-grained auditing.BImplement value-based auditing.CImpose standard database auditing to auditobject privileges.DImpose standard databaseauditing to audit SQL statements.
单选题You work as an application developer at Certkiller .com. You have been asked by you superiors at Certkiller .com to create a child application domain. The new child application domain has to specify a different assembly path than that of the parent application domain.You need to ensure that your solution meets Certkiller .com’s requirements.What should you do？（）A AB BC CD D
单选题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？（）AOn Wednesday， the statistics have been purged.BOn Wednesday， the retention period has been set to zero.COn Wednesday， the collection interval has been set to zero.DOn Wednesday， the collection level has been changed to All.EOn Wednesday， the retention period has been set to one day.FOn Wednesday， the retention period has been set to two daysGOn Wednesday, the collection level has been changed to Typical.HOn Wednesday, the collection interval has been set to 1440 minutes.
单选题In your production database， data manipulation language （DML） operations are executed on the SALES table.You have noticed some dubious values in the SALES table during the last few days. You are able to track users， actions taken， and the time of the action for this particular period but the changes in data are not tracked.You decide to keep track of both the old data and new data in the table along with the user information. Whataction would you take to achieve this task（）AApply fine-grained auditing.BImplement value-based auditing.CImpose standard database auditing to audit object privileges.DImpose standard database auditing to audit SQL statements.