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

题目内容 (请给出正确答案)

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” 相关考题
考题 You set the following parameters in the parameter file and restarted the database:Which two statements are true regarding these parameters after the database instance is restarted?() A. The MEMORY_MAX_TARGET parameter is automatically set to 500 MBB. The value of the MEMORY_MAX_TARGET parameter remains zero till it is changed manuallyC. The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zeroD. The lower bounds of PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90 MB and 270 MB, respectively

考题 You specify a nonzero value for the MEMORY_TARGET initialization parameter, but do not set the PGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance.Which statement about the result is true?()A. The database instance starts, and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZEB. The database instance starts, and Oracle automatically tunes memory and allocates 60 percent to the SGA and 40 percent to the PGAC. The database instance starts, but Automatic Memory Management is disabledD. The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter

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

考题 You have only two redo log groups and these groups get overwritten several times in a day. Your database operates in NOARCHIVELOG mode and user-managed consistent backups are performed every Sunday night. On Thursday morning, you find that an important table has been dropped and purged. With reference to this scenario, up to what point in time can the data be recovered?()A、 until Thursday morningB、 until that point in time when the database is openedC、 until that point in time when the recovery is performedD、 until last Sunday’s backupE、 until that point in time when the table is dropped and purgedF、 until Wednesday evening

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

考题 You are the network administrator for The network consists of a single Active Directory domain named All network servers run Windows Server 2003. All 3,500 user accounts are located in the default Users container. All user accounts have their Department attribute values set to the appropriate employee department. The network engineer creates an OU structure for the domain, based on the Testking's departments. You need to place all user accounts that have the Departmetn attribute set to Sales in the Sales OU. Because of time constraints, you need to automate this process. Which two actions should you perform? ()(Each correct answer presents part of the solution. Choose two.)A、Run the dsmod command with the appropriate parameters.B、Run the dsget command with the appropriate parameters.C、Run the dsquery command with the appropriate parameters.D、Run the dsmove command with the appropriate parameters.E、Run the dsrm command with the appropriate parameters.F、Run the find command with the appropriate parameters.

考题 You are maintaining an OLTP database in Oracle10g. You have configured the Flash Recovery Area in your database. The Flash Recovery Area is full because you have set the retention policy to NONE. What will you do to resolve the problem?()A、 Increase the value of the FAST_START_MTTR_TARGET initialization parameter.B、 Increase the value of the DB_RECOVERY_FILE_DEST_SIZE parameter.C、 Increase the value of the PGA_AGGREGATE_TARGET initialization parameter.D、 Increase the value of the SGA_TARGET initialization parameter.

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

考题 You specify a nonzero value for the MEMORY_TARGET initialization parameter,but do not set the PGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance.  Which statement about the result is true?()A、 The database instance starts,and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZEB、 The database instance starts,and Oracle automatically tunes memory and allocates 60 percent to the  SGA and 40 percent to the PGAC、 The database instance starts,but Automatic Memory Management is disabledD、 The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter

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

考题 A customer stores environmental settings in the deployment descriptors of an application. Whenever they promote the application version from testing to the production environment, they need to open the archive and modify the deployment descriptor. This process is against their security policy.    What approach should you recommend to leverage WebLogic features such that they do not have to modify the application archive for different environments?()A、Keep environmental data in the global settings of domain and the application can read it from the domain where it runs.B、Keep environmental data in Deployment Plan XML files. It allows you to change parameters in the deployment descriptor without opening the archive file.C、Keep environmental data in the database because it is the most effective way of parametrizing the environment.  D、Keep archive in exploded format so the customer does not have to open the archive files.E、Eliminate all environmental settings from the application. There should not to be any environmental settings in the application. 

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

考题 To enable resumable space allocation for the instance, which of the following initialization parameters should you set to a nonzero value?()A、 RESUMABLE_SPACE_TIMEB、 RESUMABLE_SPACEC、 RESUMABLE_TIMED、 RESUMABLE_TIMEOUTE、 TIME_RESUMABLE

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

考题 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()A、Apply fine-grained auditing.B、Implement value-based auditing.C、Impose standard database auditing to auditobject privileges.D、Impose standard databaseauditing to audit SQL statements.

考题 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 are the network administrator for Testking.com. The TestKing network contains seven application servers. Each application server runs a database application named TestKingApp. Requirements for TestKingApp state that when you add a new user, you must add the user to the server that has the most available disk space. You need to ensure that you meet the requirements when you add new users to TestKingApp. What should you do?()A、Use Event Viewer to review the application logs on each of the seven servers.B、Use Performance Logs and Alerts to record the PhysicalDisk object on all seven servers.C、Use Task Manager to view the performance data on each of the seven servers.D、Use System Monitor to generate a histogram view of the LogicalDisk object on all seven servers.

考题 多选题You are the network administrator for The network consists of a single Active Directory domain named All network servers run Windows Server 2003. All 3,500 user accounts are located in the default Users container. All user accounts have their Department attribute values set to the appropriate employee department. The network engineer creates an OU structure for the domain, based on the Testking's departments. You need to place all user accounts that have the Departmetn attribute set to Sales in the Sales OU. Because of time constraints, you need to automate this process. Which two actions should you perform? ()(Each correct answer presents part of the solution. Choose two.)ARun the dsmod command with the appropriate parameters.BRun the dsget command with the appropriate parameters.CRun the dsquery command with the appropriate parameters.DRun the dsmove command with the appropriate parameters.ERun the dsrm command with the appropriate parameters.FRun the find command with the appropriate parameters.

考题 单选题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?”

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

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

考题 单选题You have only two redo log groups and these groups get overwritten several times in a day. Your database operates in NOARCHIVELOG mode and user-managed consistent backups are performed every Sunday night. On Thursday morning, you find that an important table has been dropped and purged. With reference to this scenario, up to what point in time can the data be recovered?()A  until Thursday morningB  until that point in time when the database is openedC  until that point in time when the recovery is performedD  until last Sunday’s backupE  until that point in time when the table is dropped and purgedF  until Wednesday evening

考题 单选题You have configured the following:  RMAN CONFIGURE DEFAULT DEVICE TYPE TO ’sbt’; new RMAN configuration parameters:  CONFIGURE DEFAULT DEVICE TYPE TO ’sbt’; new RMAN configuration parameters are successfully stored RMAN SHOW DEVICE TYPE; RMAN configuration parameters are: CONFIGURE DEVICE TYPE SBT PARALLELISM 1; # CONFIGURE DEVICE TYPE DISK PARALLELISM 1; #  RMAN CONFIGURE DEVICE TYPE SET PARALLELISM 5;  RMAN SHOW DEVICE TYPE; RMAN configuration parameters are: CONFIGURE DEVICE TYPE SBT PARALLELISM 5; CONFIGURE DEVICE TYPE DISK PARALLELISM 1; #  How many channels are allocated to SBT?()A 0, because channels have not been defined.B 3, as indicated by the degree of parallelism.C 1, the default value when device is configured.D 5, as indicated by the last parallelism command.