CMS专题
单选题In your database， the RESULT_CACHE_MODE parameter has been set to MANUAL in the initialization parameter file. You issued the following command： SQL>SELECT /*+ RESULT_CACHE */ sale_category， sum（sale_amt） FROM sales GROUP BY sale_category； Where w
题目
database buffer cache
shared pool
PGA
large pool
相似问题和答案
第1题：
--- Hi, Terry, can I use your computer for a while this afternoon?
--- Sorry. .
A. It' s repaired B. It has been repaired
C. It's being repaired D. It had been repaired
第2题：
In your database， the RESULT_CACHE_MODE parameter has been set to MANUAL in the initialization parameter file. You issued the following command： SQL>SELECT /*+ RESULT_CACHE */ sale_category， sum（sale_amt） FROM sales GROUP BY sale_category； Where would the result of this query be stored（）？
- A、 database buffer cache
- B、 shared pool
- C、 PGA
- D、 large pool
正确答案:B
第3题：
--- Hi, Terry, can I use your computer for a while this afternoon?
--- Sorry. __ . A． It' s repaired
B． It has been repaired
C． It's being repaired
D． It had been repaired
第4题：
You work as a database administrator for Certkiller .com. Users complain that their query is taking a long time to complete. You suspect the database buffer cache size to be the reason， and you define an alert to be generated when the buffer cache hit metric goes below 85%. When you observe the dynamic performance views， you find that the buffer cache hit ratio is 81% but no alerts are being generated. What could be the reason for this problem？（）
- A、The advisory memory has been turned off.
- B、The DB_CACHE_ADVICE parameter has been set to OFF in the parameter file.
- C、The STATISTICS_LEVEL parameter has been set to BASIC in the parameter file.
- D、The TIMED_STATISTICS parameter has been set to FALSE in the parameter file.
- E、The STATISTICS_LEVEL parameter has been set to TYPICAL in the parameter file.
正确答案:C
第5题：
In your Certkiller .com database server the parameter PLSQL_CODE_TYPE has been set to NATIVE. Which object would be achieved by the setting？（）
- A、The source PL/SQL code will be stored in native machine code.
- B、The source PL/SQL code will be stored in interpreted byte code.
- C、The compiled PL/SQL code will be stored in native machine code.
- D、The compiled PL/SQL code will be stored in interpreted byte code.
正确答案:C
第6题：
Joseph ______to evening classes since last month, but he still can’t say “What’s your name?” in Russian.
A．has been going
B．went
C．goes
D．has gone
第7题：
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
第8题：
In your database, the LDAP_DIRECTORY_SYSAUTH initialization parameter has been set to YES and the users who need to access the database as DBAs have been granted SYSDBA enterprise role in Oracle Internet Directory (OID). SSL and the password file have been configured. A user SCOTT with the SYSDBA privilege tries to connect to the database instance from a remote machine using the command:Which authentication method would be used first?（）
A. authentication by password file
B. authentication by using certificates over SSL
C. authentication by using the Oracle Internet Directory
D. authentication by using the local OS of the database server
第9题：
In your database， you discovered that a tempfile in a locally managed temporary tablespace has been deleted at the operating system level. How would you recover the tablespace？（）
- A、flash back the database
- B、perform point-in-time recovery
- C、perform a full database recovery
- D、drop and re-create the tablespace
- E、use Recovery Manager （RMAN） to recover the database
正确答案:D
第10题：
You have joined a new organization as a Database Administrator. The Security Administrator in your organization has kept human errors， such as erroneously dropping users， tables， and important data， to a minimum by carefully granting only the necessary privileges to each user. As a result of several ongoing transactions within your database， you discover that the flashback logs are rapidly increasing in the flash recovery area. To avoid out-of-space errors， you decide to delete the flashback logs from the flash recovery area. How can you delete the flashback logs from the database if your database is up and running？（）
- A、 Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command and disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.
- B、 Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement while the database is up and running.
- C、 Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command. Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement. Disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.
- D、 Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement. Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command and disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.
正确答案:A