违法和不良信息举报 联系客服
免费注册 登录

The SPFILE for the PROD database specifies the following ini

题目
单选题
The SPFILE for the PROD database specifies the following initialization parameter values：   SGA_TARGET = 2G   DB_8K_CACHE_SIZE = 128M   You create a tablespace named HR with the non-standard block size of 8K. Four database users are running queries on a table in the HR tablespace. These users complain that the queries are taking longer than usual to complete. While investigating the reasons for this delay， you discover that the database encounters extensive cache misses on the database buffer cache with the block size of 8K. You issue the following statement to increase the value of the DB_8K_CACHE_SIZE initialization parameter to 256M：   SQL>ALTER SYSTEM SET DB_8K_CACHE_SIZE=256M SCOPE = BOTH；   What is the result of this statement？（）
A

 The statement fails because you cannot set the memory components manually if the SGA_TARGET initialization parameter is set to a nonzero value.

B

 The statement fails because the DB_8K_CACHE_SIZE initialization parameter is not a dynamic parameter.

C

 The statement increases the value of the DB_8K_CACHE_SIZE initialization parameter to 256M and extracts an additional 128M of memory from the automatically sized memory components.

D

 The statement increases the value of the DB_8K_CACHE_SIZE initialization parameter to 256M and reallocates an additional 128M memory from the memory components that are not auto-tuned.

如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

If you lost your entire database，including the database spfile，control files，online redo logs，and database datafiles，what kind of recovery would be required with RMAN？（）  

  • A、 Complete database recovery.
  • B、 Incomplete database recovery.
  • C、 Approximate database recovery.
  • D、 Archived database recovery.
  • E、 The database could not be recovered with RMAN.

正确答案:B

第2题：

You recently created a database and configured the SPFILE with the following parameter settings to ensure that Oracle automatically adjusts the memory for the Program Global Area （PGA）：   SORT_AREA_SIZE = 150M   HASH_AREA_SIZE = 150M   BITMAP_MERGE_AREA_SIZE = 150M   CREATE_BITMAP_AREA_SIZE = 150M   WORKAREA_SIZE_POLICY = AUTO   You have not included the PGA_AGGREGATE_TARGET initialization parameter in the SPFILE and the System Global Area （SGA） is currently sized at 4G.   What is the total PGA memory allocated across all database server processes？（）  

  • A、 10M
  • B、 400M
  • C、 600M
  • D、 800M

正确答案:D

第3题：

You are in the process of creating a virtual private catalog in your Oracle Database 11g database. The PROD1, PROD2, and PROD3 Oracle Database 10g databases are registered in the base recovery catalog. The database user who owns the base recovery catalog is CATOWNER. CATOWNER executes the following command to grant privileges to a new user VPC1 using Oracle Database 11g RMAN executables:What is the outcome of the above commands?（）

A. They execute and create a virtual catalog for pre-Oracle 11g clients.

B. They produce an error because PROD1 and PROD2 databases belong to the older version.

C. They produce an error because you need to connect as CATOWNER to execute this packaged procedure.

D. They produce an error because you need to connect to the target database to execute this packaged procedure.


参考答案：A

第4题：

What components are present in an ASM instance？（）

  • A、 SGA
  • B、 Database processes
  • C、 Database datafiles
  • D、 Control files
  • E、 Database parameter file or spfile

正确答案:A,B,E

第5题：

In which situation will you run the script containing the following statement？（）   CREATE CONTROLFILE REUSE DATABASE SALES NORESETLOGS ARCHIVELOG        MAXLOGFILES 20        MAXLOGMEMBERS 3        MAXDATAFILES 30        MAXINSTANCES 10        MAXLOGHISTORY 1200        LOGFILE        GROUP 1 （   ’/disk1/prod/orders/db/log1a.dbf’，        ’/disk2/prod/orders/db/log1b.dbf’        ）SIZE 100K        GROUP 2 （   ’/disk1/prod/orders/db/log2a.dbf’，        ’/disk2/prod/orders/db/log2b.dbf’        ） SIZE 100K，        DATAFILE   ’/disk1/prod/orders/db/database1.dbf’，                                           ’/disk2/prod/orders/db/file1.dbf ’；  

  • A、 when all the control files are missing and only a binary backup of the current control file exists
  • B、 when a multiplexed copy of the current control file is missing
  • C、 when all the control files are missing and only an ASCII representation of the binary control file exists
  • D、 when the SPFILE is missing

正确答案:B

第6题：

The Automatic Shared Memory Management feature is enabled for the PROD database. Currently， a lot of insert activity is taking place in the database， and the memory structures are allocated according to the database workload. As the workload reduces， you decide to perform batch jobs in the database. Which of the following initialization parameters are NOT automatically resized according to the new workload and continue to remain unchanged？（）

  • A、 LOG_BUFFER
  • B、 DB_CACHE_SIZE
  • C、 JAVA_POOL_SIZE
  • D、 LARGE_POOL_SIZE
  • E、 SHARED_POOL_SIZE
  • F、 STREAMS_POOL_SIZE

正确答案:A,F

第7题：

You issued the following RMAN command：  RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON；     What is NOT an impact of using the above command？（）

  • A、 When a successful backup is recorded in the RMAN repository， then a backup of the current control file is performed.
  • B、 When a structural change is made to the database， then a backup of the current control file is performed.
  • C、 When a successful backup is performed in the RMAN repository， then a backup of the spfile is performed.
  • D、 When a structural change is made to the database， then a backup of the alert log file will be performed.

正确答案:D

第8题：

Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt：     RMAN> CONFIGURE CONTROLFILE AUTOBACKUP OFF；   RMAN> BACKUP DATABASE；   Which files from the database will be backed up as a result of this BACKUP command？（）

  • A、 control file
  • B、 all datafiles
  • C、 password file
  • D、 online redo log file
  • E、 archive redo log file
  • F、 server parameter file
  • G、 only the SYSTEM datafile

正确答案:A,B,F

第9题：

Which  statements regarding the server parameter file （SPFILE） are true（）

  • A、An SPFILE is a binary file.
  • B、An SPFILE cannot reside on a client.
  • C、An SPFILE cannot contain static parameters.
  • D、An SPFILE can store changes persistently across instance restarts.
  • E、An SPFILE can be read by the database server， but it is not written to by the server.
  • F、An SPFILE must be created manually， before creating a database， even if you use the DatabaseConfiguration Assistant （DBCA） to create the database

正确答案:A,B,D

第10题：

You are maintaining the PROD database for NetFx Corporation. You have configured controlfile autobackup in your database. At 6：00 P.M. on Monday， you issue the following command：       RMAN>BACKUP DATABASE；  At 8：00 A.M. on Tuesday， you are unable to start the database because all the control files are missing. You decide to restore the control files from the backup by using the RMAN> RESTORE CONTROLFILE FROM AUTOBACKUP； command. Which operation should you perform before using the RMAN> RESTORE CONTROLFILE FROM AUTOBACKUP； command？（）

  • A、 Start the database in the MOUNT stage.
  • B、 Back up the control file to trace.
  • C、 Set the DBID
  • D、 Issue the RECOVER DATABASE command.

正确答案:C

更多相关问题
相关内容