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

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


参考解析

解析: 暂无解析

相关考题:

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.

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 fileB、 all datafilesC、 password fileD、 online redo log fileE、 archive redo log fileF、 server parameter fileG、 only the SYSTEM datafile

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.

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_BUFFERB、 DB_CACHE_SIZEC、 JAVA_POOL_SIZED、 LARGE_POOL_SIZEE、 SHARED_POOL_SIZEF、 STREAMS_POOL_SIZE

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、 10MB、 400MC、 600MD、 800M

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.

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 existsB、 when a multiplexed copy of the current control file is missingC、 when all the control files are missing and only an ASCII representation of the binary control file existsD、 when the SPFILE is missing

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

What components are present in an ASM instance?()A、 SGAB、 Database processesC、 Database datafilesD、 Control filesE、 Database parameter file or spfile

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:       RMANBACKUP 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 DBIDD、 Issue the RECOVER DATABASE command.

Your database is running in ARCHIVELOG mode,and the database is open. You execute an RMAN backup and specify the KEEP clause.Which components are backed up when this option is specified?()A、only the control file, the current SPFILE, and data filesB、only the current SPFILE and data files if autobackup is disabledC、only the data files and the archived redo logsD、the control file, current SPFILE file, data files, and archived redo logs

Given a complete loss of your database, in what order would you need to perform the following RMAN operations to restore it?()   a. restore controlfile  b. restore database  c. restore spfile  d. recover database  e. alter database open  f. alter database open resetlogsA、 b, a, c, d, eB、 a, c, b, d, fC、 c, a, b, d, eD、 c, a, b, d, fE、 e, a, b, d, c

单选题Given a complete loss of your database, in what order would you need to perform the following RMAN operations to restore it?()   a. restore controlfile  b. restore database  c. restore spfile  d. recover database  e. alter database open  f. alter database open resetlogsA b, a, c, d, eB a, c, b, d, fC c, a, b, d, eD c, a, b, d, fE e, a, b, d, c

单选题Your database is running in ARCHIVELOG mode,and the database is open. You execute an RMAN backup and specify the KEEP clause.Which components are backed up when this option is specified?()Aonly the control file, the current SPFILE, and data filesBonly the current SPFILE and data files if autobackup is disabledConly the data files and the archived redo logsDthe control file, current SPFILE file, data files, and archived redo logs

单选题The following databases are registered in the base recovery catalog: PROD1, PROD2, and PROD3. The database user CATOWNER owns the base recovery catalog. You want a new user VPC1 to have access to only the PROD1 database and create a virtual private catalog. Given below are some of the commands required to achieve this: 1.SQL GRANT recovery_catalog_owner TO vpc1; 2.RMAN CONNECT CATALOG vpc1/password@catdb; 3.RMAN GRANT CATALOG FOR DATABASE prod1 TO vpc1; 4.RMAN CONNECT CATALOG catowner/password@catdb; 5.RMAN CREATE VIRTUAL CATALOG; What is the correct sequence in which the commands have to be executed?()A1, 4, 5, 2, 3B1, 4, 3, 2, 5C4, 5, 2, 3, 1D2, 3, 4, 5, 1E1, 4, 2, 3, 5

多选题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?()ALOG_BUFFERBDB_CACHE_SIZECJAVA_POOL_SIZEDLARGE_POOL_SIZEESHARED_POOL_SIZEFSTREAMS_POOL_SIZE

单选题You are administering a database stored in Automatic Storage management (ASM). The files are storedin the DATA disk group. You execute the following command:SQL ALTER DISKGROUP data ADD ALIAS ‘+data/prod/myfile.dbf’ FOR ‘+data.231.45678’;What is the result?()AThe file ‘+data.231.54769’ is physically relocated to ‘+data/prod’ and renamed as ‘myfile.dbf’.BThe file ‘+data.231.54769’ is renamed as ‘myfile.dbf’, and copied to ‘+data/prod’.CThe file ‘+data.231.54769’ remains in the same location and a synonym 'myfile.dbf' is created.DThe file ‘myfile.dbf’ is created in ‘+data/prod’ and the reference to ‘+data.231.54769’ in the data dictionary removed.

单选题You are connected to a pluggable database (PDB) as a common user with DBA privileges. The STATISTICS_LEVEL parameter is PDB_MODIFIABLE. You execute the following: SQL ALTER SYSTEM SET STATISTICS_LEVEL = ALL SID = ‘*’ SCOPE = SPFILE; Which is true about the result of this command?()AThe STATISTICS_LEVEL parameter is set to all whenever this PDB is re-opened.BThe STATISTICS_LEVEL parameter is set to ALL whenever any PDB is reopened.CThe STATISTICS_LEVEL parameter is set to all whenever the multitenant container database (CDB) is restarted.DNothing happens; because there is no SPFILE for each PDB, the statement is ignored.

单选题You have control-file autobackups enabled. When starting your database from SQL*Plus, you receive the following error message:   SQL startup ORA-01078: failure in processing system parameters LRM-00109:  could not open parameter file ,  C:///ORACLE/PRODUCT/11.1.0/DB_1/DATABASE/INITORCL.ORA Using RMAN,   how would you respond to this error?()A Issue the startup nomount command and then issue the restore parameter file command from the RMAN prompt.B Issue the startup nomount command and then issue the restore spfile command from the RMAN prompt.C Issue the startup nomount command and then issue the restore spfile from autobackup command from the RMAN prompt.D Issue the startup nomount command and then issue the restore spfile from backup command from the RMAN prompt.E Issue the restore spfile from autobackup command from the RMAN prompt.

单选题You want an ASM instance to manage the files of your database. To achieve this objective, you specify the following parameters in the parameter file of the database:  INSTANCE_TYPE = RDBMS DB_NAME = PROD  LARGE_POOL_SIZE = 8MB  DB_BLOCK_SIZE = 4K  LOG_ARCHIVE_DEST = +dgroupA  LOG_ARCHIVE_FORMAT = "$ORACLE_SID_%s_%t.%t"  DB_CREATE_FILE_DEST = +dgroupA  COMPATIBLE = 10.1.0.2.0  CONTROL_FILES = +dgroupA  Which parameter would be ignored while starting up the instance for the database PROD?()ADB_BLOCK_SIZEBCONTROL_FILESCLARGE_POOL_SIZEDLOG_ARCHIVE_DESTELOG_ARCHIVE_FORMATFDB_CREATE_FILE_DEST

单选题Your database is running in ARCHIVELOG mode, and the database is open. You execute an RMAN backup and specify the KEEP clause.  Which components are backed up when this option is specified?()A only the control file, the current SPFILE, and data filesB only the current SPFILE and data files if autobackup is disabledC only the data files and the archived redo logsD the control file,current SPFILE file,data files,and archived redo logs

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

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

单选题Which is the correct description of the significance of the ORACLE_HOME environmental variable?()AIt specifies the directory containing the Oracle software.BIt specifies the directory containing the Oracle-Managed Files.CIt specifies the directory for database files, if not specified explicitly.DIt specifies the base directory of Optimal Flexible Architecture (OFA) .

单选题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 existsB when a multiplexed copy of the current control file is missingC when all the control files are missing and only an ASCII representation of the binary control file existsD when the SPFILE is missing

单选题How can you make a shared server-side initialization parameter file available to all instances of a Real Application Clusters database?()AInclude an SPFILE parameter in each instance-specified initialization file.BCreate an SPFILE copy on each client from which the instance will be started.CStore the SPFILE in a raw partition with a vendor-specifies location and name.DUse a single client to start the instances and create the SPFILE on this client.

多选题Which  statements regarding the server parameter file (SPFILE) are true()AAn SPFILE is a binary file.BAn SPFILE cannot reside on a client.CAn SPFILE cannot contain static parameters.DAn SPFILE can store changes persistently across instance restarts.EAn SPFILE can be read by the database server, but it is not written to by the server.FAn SPFILE must be created manually, before creating a database, even if you use the DatabaseConfiguration Assistant (DBCA) to create the database

多选题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?()Acontrol fileBall datafilesCpassword fileDonline redo log fileEarchive redo log fileFserver parameter fileGonly the SYSTEM datafile