出自:Oracle认证

Which of the following is not an advantage of block media recovery （BMR）？（）
A: Reduced MTTR.
B: Datafiles remain offline while corrupt blocks are repaired.
C: Datafiles remain online while corrupt blocks are repaired.
D: A and C
You have a disk group， DGROUP1， with three disk and NORMAL redundancy. You execute the following command to create a template for the disk group： ALTER DISKGROUP dgroup1 ADD TEMPLATE my_temp ATTRIBUTES （MIRROR FINE）；Which statement is true？（）
A: When a file is created in DGROUP1 with the template， it would have three-way mirroring.
B: When a file is created in DGROUP1， the MY_TEMP template becomes the default template.
C: When a file is created in DGROUP1 with the template， it would have two-way mirroring and file striping.
D: When a file is created in DGROUP1 with the template， it would have three-way mirroring and file striping.
E: When a file is created in DGROUP1 with the template， it would have two-way mirroring but no file striping.
What does the Metadata Application Programming Interface （API） allow you to do？（）
A:Repair damaged data dictionary entries.
B:Delete data dictionary information about database objects you no longer need.
C:Extract data definition commands from the data dictionary in a variety of formats.
D:Prepare pseudocode modules for conversion to Java or PL/SQL programs with a Metadata code generator
You are trying to recover your database. During the recovery process， you receive the following error：   ORA-00279： change 5033391 generated at 08/17/2008 06：37：40 needed for thread 1ORA-00289： suggestion ：  /oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17 /o1_mf_1_11_%u_.arc  ORA-00280： change 5033391 for thread 1 is in sequence #11 ORA-00278： log  file ，，/oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17  /o1_mf_1_10_4bj6wnqm_.arc no longer needed for this recovery Specify log： {=suggested | filename | AUTO | CANCEL} ORA-00308： cannot open archived log  ，，/oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17 /o1_mf_1_11_%u_.arc  ORA-27037： unable to obtain file status Linux Error： 2： No such file or directory Additional information： 3   How do you respond to this error？（）
A: Restore the archived redo log that is missing and attempt recovery again.
B: Recovery is complete and you can open the database.
C: Recovery needs redo that is not available in any archived redo log. Attempt to apply an online redo log if available.
D: Recover the entire database and apply all archived redo logs again.
E: Recovery is not possible because an archived redo log has been lost.
以下对于事务的叙述，比较全面的是（）
A:事务中的操作是一个整体，要成功都成功，要失败都失败
B:事务可以把所操作的数据库由一个状态转变到另一个状态
C:事务在提交之前，其它事务看不到它对数据库的影响
D:事务提交后，其结果将在数据库中得以体现
E:以上所述都是正确的
While setting up the database for your production environment， you want to create a user with following requirements.  1.The objects created by the user must be stored in a tablespace， TBS1， if the TABLESPACE option is not defined during the object creation.  2.The user should be able to use 10MB of space in the tablespace TBS1.  3.The user must change the password immediately after logging in for the first time. Which three options of the CREATE USER command would you use to achieve this objective？（）
A:profile
B:account lock
C:account unlock
D:password expire
E:quota 10MB on TBS1
F:password never expire
G:default tablespace TBS1
H:quota unlimited on TBS1
I:temporary tablespace TEMP
J:temporary tablespace SYSTEM
While setting up the thresholds for tablespace space usage metrics for one of your tablespaces， you define the critical threshold as 60% and warning threshold as 75%. What would be the result of this setting？（）
A:It would result in an error because the warning threshold cannot be more than the critical threshold.
B:The warning threshold is ignored and alerts would be generated when space usage exceeds the critical threshold.
C:The critical threshold is ignored and alerts would be generated when space usage exceeds the warning threshold.
D:Both threshold values are used and alerts are generated when space usage exceeds the respective threshold values.
Given: What is the result?（）
A:null
B:zero
C:some
D:Compilation fails.
E:An exception is thrown at runtime.
You are administering a database stored in Automatic Storage Management (ASM). You use RMAN to back up the database and the MD_BACKUP command to back up the ASM metadata regularly. You lost an ASM disk group DG1 due to hardware failure. In which three ways can you re-create the lost disk group and restore the data?（）
A:Use the MD_RESTORE command to restore metadata for an existing disk group by passing the existing disk group name as an input parameter and use RMAN to restore the data.
B:Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group and data on the disk group.
C:Use the MD_RESTORE command to restore the disk group with the changed disk group specification, failure group specification, name, and other attributes and use RMAN to restore the data.
D:Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group name and same set of disks and failure group configuration, and use RMAN to restore the data.
E:Use the MD_RESTORE command to restore both the metadata and data for the failed disk group.
F:Use the MKDG command to add a new disk group DG1 with the same or different specifications for failure group and other attributes and use RMAN to restore the data.
Exhibit： You are working on a database created with the Oracle Database 10g software in which the initialization parameter COMPATIBLE is set to 10.0.0. The hr_tbs tablespace in the database is created as follows：  CREATE TABLESPACE hr_tbs DATAFILE ’/oracle/oradata/hr_tbs.dbf’ SIZE 50M； View the Exhibit to see the properties of the database. Which statement is correct in this scenario？（）
A:hr_tbs is a bigfile tablespace.
B:hr_tbs is a dictionary-managed tablespace.
C:All the tablespaces in the database will be locally managed by default.
D:All the tablespaces in the database must be of the smallfile tablespace type.
E:The tablespace type bigfile or smallfile must be mentioned in the command.
查询出所有名字以’S’开始的员工（）
A:select * from emp where ename in 'S%';
B:select * from emp where ename='S%';
C:select * from emp where ename like 'S%';
D:select * from emp where ename like 'S_';
View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERTS view. After 30 minutes， you executed the following command：  SQL> SELECT reason，metric_value FROM dba_outstanding_alerts； REASON         METRIC_VALUE  ------------------------------------------------------------  ------------  Tablespace [TEST] is [28 percent]full  28.125  What could be the reason for the elimination of the other rows in the output（）
A:An Automatic Workload Repository snapshot has been taken recently.
B:The non-threshold-based alerts are transferred to DBA_ALERT_HISTORY.
C:The threshold alerts conditions are cleared and the alerts are transferred to DBA_ALERT_HISTORY.
D:The threshold alerts related to database metrics are permanently stored in DBA_ALERT_HISTORY but not the threshold alerts related to instance metrics.
Given： And MainClass exists in the /apps/com/company/application directory.  Assume the CLASSPATH environment variable is set to "." （current directory）. Which two java commands entered at the command line will run MainClass？（）
A:java MainClass if run from the /apps directory
B:java com.company.application.MainClass if run from the /apps directory
C:java -classpath /apps com.company.application.MainClass if run from any directory
D:java -classpath . MainClass if run from the /apps/com/company/application directory
E:java -classpath /apps/com/company/application：. MainClass if run from the /apps directory
Which two are character manipulation functions? （）
A:TRIM
B:REPLACE
C:TRUNC
D:TO_DATE
E:MOD
F:CASE
You want to create a temporary table named OLD_INVENTORY in the OLD_INVENTORY database on the master server. This table is not to be replicated to the slave server. Which two changes would ensure that the temporary table does not propagate to the slave?（）
A:Use the – replicate-do-db, — replicate-do-table, or – replicate-wild-do-table option with the value equal to OLD_INVENTORY
B:Change the binlog_format option to ROW and restart mysqld before you create the OLD_INVENTORY table
C:Stop SQL_THREAD on the slave until you have finished using the OLD_INVENTORY temporary table
D:Set binlog_format=MIXED with the – replicate-ignore-temp-table option
E:Use the – replicate-ignore-table option with the value equal to OLD_INENTORY.OLD_INVENTORY and restart mysqld before creating the temporary table
What are the different logging modes available in Oracle Database 11g？（） 
A: NOLOG mode
B: NOARCHIVELOG mode
C: LOGGING mode
D: HOTDATABASE mode
E: ARCHIVELOG mode
View the Exhibit to examine the replay settings for replay parameters.What is the implication for setting the values for replay parameters?（）
A:The COMMIT order in the captured workload is preserved during replay.
B:The value 100 in the THINK_TIME_SCALE parameter attempts to make the replay client shorten the think time between calls.
C:The value 100 in the CONNECT_TIME_SCALE parameter attempts to connect all sessions as captured.
D:The value 100 in the THINK_TIME_SCALE parameter attempts to match the captured user think time while replaying.
E:The value 100 in the CONNECT_TIME_SCALE parameter attempts to connect all sessions immediately as soon as the replay begins.
Evaluate the SQL statement: What is the result of the statement?（）
A:The statement produces an error at line 1.
B:The statement produces an error at line 3.
C:The statement produces an error at line 6.
D:The statement returns the employee name, salary, department ID, and maximum salary earned in the department of the employee for all departments that pay less salary then the maximum salary paid in the company.
E:The statement returns the employee name, salary, department ID, and maximum salary earned in the department of the employee for all employees who earn less than the maximum salary in their department.
In your multitenant container database (CDB) containing pluggable databases (PDB), users complain about performance degradation. How does real-time Automatic database Diagnostic Monitor (ADDM) check performance degradation and provide solutions?（）
A:It collects data from SGA and compares it with a preserved snapshot.
B:It collects data from SGA, analyzes it, and provides a report.
C:It collects data from SGA and compares it with the latest snapshot.
D:It collects data from both SGA and PGA, analyzes it, and provides a report
You work as a database administrator for Certkiller .com. In the Certkiller PRODUCTION database you have granted RESUMABLE system privilege to the CONNECT role.Resumablespace operation has been enabled for all user session. You want users NOT to be aware of any kind of space-related problems while performing transactions. Instead， you want the problem to be resolved by a database trigger automatically. Which combination of triggering time and event would you use to achieve this objective？（）
A:AFTER CREATE
B:AFTER SUSPEND
C:BEFORE CREATE
D:AFTER TRUNCATE
E:BEFORE SUSPEND
F:AFTER INSERT OR DELETE OR DELETE
G:BEFORE INSERT OR DELETE OR DELETE
When you try to open your database， you receive the following error：  ORA-00205： error in identifying controlfile  Where would you find the details required to resolve this error？（）
A:audit trail
B:alert log file
C:user trace file
D:online trace file
E:background trace file
F:operating system event viewer
You want to convert your existing non-ASM files to ASM files for the database PROD.  Which method or command would you use to accomplish this task？（）  
A: Data Pump Export and Import
B: conventional export and import
C: the CONVERT command of RMAN
D: the BACKUP AS COPY. command of RMAN
In your Supportcenter.cn production database，you find that the database users are able to create and read files with unstructured data，available in any location on the host machine from an application. You want to restrict the database users to access files in a specific location on the host machine. What could do to achieve this？（）
A:Modify the value for the UTL_FILE_DIR parameter in the parameter file
B:Grant read and write privilege on the operating system path to the database users
C:Modify the value for the LDAP_DIRECTORY_ACCESS parameter in the parameter file
D:Modify the value for the PLSQL_NATIVE_LIBRARY_DIR parameter in the parameter file
E:Create a directory object referring to the operating system path， and grant read and write privilege on the directory object to the database users
Which command would you use to determine what database backups are currently available for restore？（）  
A: list database backup
B: report database backup
C: list backup of database
D: list summary backup
E: report backup of database
You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference. Which method or feature should you use?（）
A:Compare Period ADDM report
B:AWR Compare Period report
C:Active Session History (ASH) report
D:Taking a new snapshot and comparing it with a preserved snapshot
You want to disable resumable space allocation for all sessions.Which value should be assigned to the RESUMABLE_TIMEOUT parameter to disable resumable spaceallocation for all sessions?（）
A:0
B:10
C:100
D:NULL
Click the Exhibit button. What is the output if the main（） method is run？（）
A:4
B:5
C:8
D:9
在Oracle中，当FETCH语句从游标获得数据时，下面叙述正确的是（）。
A:游标打开
B:游标关闭
C:当前记录的数据加载到变量中
D:创建变量保存当前记录的数据
You suspect unauthorized data manipulation language （DML） operations on a particular table. You want to track users who are performing the transactions and the values used in the transactions. Also， you plan to transfer these values to another table for analysis.  How would you achieve this？（）
A:by using triggers
B:by using external tables
C:by using anonymous PL/SQL blocks
D:by auditing all DML operations on the table
You work as a database administrator for Certkiller .com. Users in the Certkiller .com PROD database complain about the slow response of transactions. While investigating the reason you find that the transactions are waiting for the undo segments to be available， and undo retention has been set to zero. What would you do to overcome this problem？（）
A:Increase the undo return
B:Create more undo segments
C:Create another undotablespace
D:Increase the size of the undotablespace
首页 <上一页 62 63 64 65 66 下一页> 尾页