出自:Oracle认证

he Dynamic SGA feature allows the SGA to grow and shrink dynamically according to an ALTER SYSTEM command. This avoids the previous need of shutting down the instance in order to modify the components of the SGA， namely the buffer cache and shared pool components.  Which three statements are true for the Dynamic SGA feature？ （）
A:A
B:B
C:C
D:D
E:E
After executing the command alter diskgroup disk group2 drop disk dg2a； you issue the following command from the ASM instance：   Select group_number， count（*） from v$asm_operation；   What is the implication if the query against V$ASM_OPERATION returns zero rows？（）  
A: The drop disk operation is still proceeding and you cannot yet run the undrop disks operation.
B: The drop disk operation is complete and you can run the undrop disks command if needed.
C: The drop disk operation is complete and you cannot run the undrop disk command.
D: The query will fail since there is not a V$ASM_OPERATION view available in an ASM instance. 
E: None of the above is true.
Examine the code：   CREATE ROLE readonly IDENTIFIES USING app.chk_readwrite ； CREATE ROLE readwrite IDENTIFIED USING app.chk_readwrite ；   CREATE OR REPLACE PROCEDURE app.chk_readwrite  AUTHID CURRENT_USER IS  ipchk STRING（30）；  BEGIN  IF sys_context（‘USERENV’，’ISDBA’）=’TRUE’  THEN DBMS_SESSION.SET_ROLE‘READWRITE’） ；  ELSE DBMS_SESSION.SET_ROLE（‘READONLY’） ；  END； /   Which three statements correctly describe the Secure Application role definition？（）
A:No user or application has to remember or hide a password. 
B:It prevents everyone except a true DBA session from acquiring the READWRITE role. 
C:app.chk_readwrite is called whenever a user tries to access rows protected by the READONLY or READWRITE label. 
D:app.chk_readwrite is called by users or applications when they want to enable the READONLY or READWRITE role.
You are at the client site working with a WebLogic Administrator who has to type Username and Password each time he/she starts an instance og Oracle WebLogic server and is quite annoyed by it. Please suggest a secure and optimal way to reduce the typing of username passwod during server startup （）
A: Since Boot Identity file for server doesn’t exist， you recommend creating a script file that can automate the task of entering username and password
B: Since Boot Identity file for server doesn’t exist， you recommend reinstalling the server
C: Since Boot Identity file for server doesn’t exist， you recommend creating one as this file is referred for credentials
D: Since Boot Identity file for server doesn’t exist， you recommend logging a support ticket with Oracle
假设需要删除数据库中的某个用户test，可以使用如下（）语句。
A:DELETE USER test
B:DROP USER test
C:DROP test
D:DELETE test
DRAG DROP Click the Task button.
In your database server， the parameter PLSQL_OPTIMIZE_LEVEL has been set to 2. What would this setting achieve？（）
A:It degrades the run time and compiler performance.
B:It provides better run time and compiler performance.
C:It provides better optimization of the statement during parse time.
D:It forces the rule based optimizer to be used for statement optimization.
E:It provides better run time performance but slightly degraded compiler performance.
F:It provides better run time performance but slightly degraded run time performance.
You are attempting to create an Oracle-Managed Files （OMF） tablespace in a production database with the following statement and receive the following error message：   CREATE TABLESPACE tbsl；  ORA-02199： missing DATAFILE/TEMPFILE clause oerr ora 2199  02199， 00000， “missing DATAFILE/TEMPFILE clause”  *Cause： A CREATE TABLESPACE statement has no DATAFILE/TEMPFTLE clause.  *Action： specify DATAFILE/TEMPFILE clause.   What is the corrective action to create the OMF based tablespace？（）
A:A
B:B
C:C
D:D
Some data storage and transfer media have fixed-length physical records.  When the data records are short， more then one can be stored in a single， physical record to use the storage space efficiently. Consider this data：   1119 Smith 1120 Yvonne 1121 Albert 1130 Thomas   Which two statements can you use to load the data into the EMP table？（）
A:A
B:B
C:C
D:D
Which three objects can be components of a menu module?（） 
A:windows 
B:parameters 
C:object groups 
D:report objects 
E:visual attributes 
The EMPLOYEES table is stored in the SAMPLE tablespace.  The corresponding IPK_EMP index for the EMPLOYEES table’s primary key is stored in the INDX tablespace.  Out of 12 partitions， only partition P1 of the SALES table is stored in the SAMPLE tablespace.  Which object will be exported by this command？（）   exp system/manager tablespaces=SAMPLE
A:Only the EMPLOYEES table.
B:Only the EMPLOYEES table and its corresponding primary key index.
C:The EMPLOYEES table and partition P1.
D:The EMPLOYEES table， IPK_EMP index， and the SALES table.
Which four statements correctly describe functions that are available in SQL? （）
A:INSTR returns the numeric position of a named character.
B:NVL2 returns the first non-null expression in the expression list.
C:TRUNCATE rounds the column, expression, or value to n decimal places.
D:DECODE translates an expression after comparing it to each search value.
E:TRIM trims the heading or trailing characters (or both) from a character string.
F:NVL compares two expressions and returns null if they are equal, or the first expression if they are not equal.
G:NULLIF compares two expressions and returns null if they are equal, or the first expression if they are not equal.
You enabled an audit policy by issuing the following statements: SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SCOTT; SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SYS, SYSTEM; For which database users and for which executions is the audit policy now active? （）
A:SYS, SYSTEM
B:SCOTT
C:Only for successful executions
D:Only for failed executions
E:Both successful and failed executions
You want to back up your 100-GB database on a remote tape device. You are required to ensure that minimum network bandwidth is consumed while transferring the backups to the tape device.  The current consumption of your CPU is approximately 40 percent.  Which type of backup should you perform？（）  
A: standard backup set
B: image copy
C: compressed backup
D: user-managed backup
（）包含了一些潜在的由系统管理员如SYS维护的表和视图，由于当数据库运行的时候它们会不断进行更新。
A:动态数据字典
B:静态数据字典
C:dba_*视图
D:all_*视图
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_SIZE
B:The database instance starts, and Oracle automatically tunes memory and allocates 60 percent to the SGA and 40 percent to the PGA
C:The database instance starts, but Automatic Memory Management is disabled
D:The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter
Which SQL statement displays the date March 19, 2001 in a format that appears as "Nineteenth of March 2001 12:00:00 AM"?（）
A:SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'fmDdspth "of" Month YYYY fmHH:MI:SS AM') NEW_DATE FROM dual;
B:SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'Ddspth "of" Month YYYY fmHH:MI:SS AM') NEW_DATE HH:MI:SS AM') NEW _ DATE FROM dual;
C:SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'fmDdspth "of" Month YYYY NEW _ DATE FROM dual;
D:SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY), 'fmDdspth "of" Month YYYYfmtHH:HI:SS AM')NEW_DATE FROM dual;
Which two code fragments will execute the method doStuff（） in a separate thread？（）
A:new Thread（） {public void run（） { doStuff（）； }}；
B:new Thread（） {public void start（） { doStuff（）； }}；
C:new Thread（） {public void start（） { doStuff（）； }}.run（）；
D:new Thread（） {public void run（） { doStuff（）； }}.start（）；
E:new Thread（new Runnable（） {public void run（） { doStuff（）； }}）.start（）；
You find this query being used in your Oracle 12c database: Which method a used by the optimizer to limit the rows being returned?（）
A:A filter is added to the table query dynamically using ROWNUM to limit the rows to 20 percent of the total rows
B:All the rows are returned to the client or middle tier but only the first 20 percent are returned to the screen or the application.
C:A view is created during execution and a filter on the view limits the rows to 20 percent of the total rows.
D:A TOP-N query is created to limit the rows to 20 percent of the total rows
You have enabled backup optimization for the RMAN environment. Identify two criteria on which RMAN will skip the file， if it has already been backed up.（）
A: The data file backup is done with multiple channels
B: The data files is in the read-write mode after being backed up in the read only mode
C: The backup was taken after the data files was taken offline-normal or is in the read only mode
D: The data file backup complies with the back retention policy and the backup duplexing fe ture
Given： What is the result？（）
A:The code runs with no output.
B:An exception is thrown at runtime.
C:Compilation fails because of an error in line 20.
D:Compilation fails because of an error in line 21.
E:Compilation fails because of an error in line 23.
F:Compilation fails because of an error in line 25.
You are performing a database recovery because a user’s schema is dropped. While performing the recovery， you use the UNTIL SEQUENCE clause. Which type of database recovery are you performing？（）
A: user managed complete recovery
B: user managed incomplete recovery
C: RMAN-based complete recovery
D: RMAN-based incomplete recovery
You configured the flash recovery area in the database. Which two files would you expect to find in the flash recovery area？ （）
A:backup pieces
B:control file autobackups
C:copies of all the parameter files
D:trace file generated using BACKUP CONTROLFILE TO TRACE
You are creating a job class. You want access to the detailed information for all the runs of each job in the class and every operation performed on every job in the class. Which setting will you use for the LOGGING_LEVEL parameter？（）
A: LOGGING_OFF
B: LOGGING_RUNS
C: LOGGING_FULL
D: LOGGING_NULL
You are working on an instance started using the SPFILE. You want to move the Flash Recovery Area of yourdatabase to a new location. You want the Flashback log files to be stored in the new location. Given below are the steps to accomplish the task in random order： 1.Shut down the instance. 2.Change the value of the DB_RECOVERY_FILE_DEST initialization parameter to a new value. 3.Execute the ALTER DATABASE FLASHBACK OFF command. 4.Start up the instance and mount the database. 5.Execute the ALTER DATABASE FLASHBACK ON command. 6.Open the database. Select the correct order in which these tasks need to be performed.（）
A:2，1，4，3，5，6
B:1，4，3，2，6，5
C:1，4，2，6，3，5
D:3，2，1，4，5，6
Your database is functional with peak load for one hour. You want to preserve the performance statistics collected during this period so that they can be used for comparison while analyzing the performance of the database in the future.  What action would you take to achieve this task？（）
A:Set the STATISTICS_LEVEL initialization parameter to ALL.
B:Create a baseline on a pair of snapshots that have the statistics of the peak­load period in the database.
C:Decrease the snapshot interval in the AWR to collect more number of snapshots during the peak­load period.
D:Set the snapshot retention period in the Automatic Workload Repository （AWR） to zero to avoid theautomatic purging of the snapshots.
取出工资在2000到3000元（包括上下限）之间的员工（）
A:select * from emp wher sal in (2000,3000);
B:select * from emp wher sal like (2000,3000);
C:select * from emp wher sal = (2000,3000);
D:select * from emp wher sal between 2000 and 3000;
Given： What is the result？（）
A:1
B:12
C:14
D:123
Consider the following statement：   SQL> EXECUTE DBMS_STATS.GATHER_SHEMA_STATS （-  2> ownname => ‘OE’， -  3> estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE， -  4> method opt => ‘for all columns size AUTO’）；   What is the effect of ‘for all columns size AUTO’ of the METHOD_OPT option？（）
A:The Oracle server creates a new histogram based on existing histogram definitions for all table, column, and index statistics for the OE schema. 
B:The Oracle server creates a histogram based on data distribution regardless of how the application uses the column/s for all table, column, and index statistics for the OE schema.
C:The Oracle server creates a histogram based on data and application usage of the column/s for all table, column, and index statistics for the OE schema. 
D:The Oracle server creates a histogram based on application usage, regardless of data distribution, for all table, column, and index statistics for the OE schema.
You work as a database administrator for Certkiller .com. You determine that archiving was not successful in one of thedestinators. You want to check the alert log file for more information on this. Which initialization parameter gives you the location of the alert log file？（）
A:USER_DUMP_DEST
B:CORE_DUMP_DEST
C:ALERT_LOG_DEST
D:ALERT_DUMP_DEST
E:TRACE_DUMP_DEST
F:BACKGROUND_DUMP_DEST
首页 <上一页 45 46 47 48 49 下一页> 尾页