出自:Oracle认证

Which tasks are run automatically as part of the Automated Maintenance Task by default?（）
A:Segment Advisor
B:SQL Access Advisor
C:Optimizer statistics gathering
D:Automatic SQL Tuning Advisor
E:Automatic Database Diagnostics Monitor
You work as a database administrator for Supportcenter.cn. You suspect that in one of your applications the customer table is being accessed by some unauthorized users. Which option would you use to monitor the queries being executed on the customer table？（）
A:Monitor thealert.logfile
B:Enable server-side SQL tracing for user sessions
C:Enable fine-grained auditing for the customer table
D:Enable Fine-Grained Access Control （FGAC） for the customer table
E:Write a database trigger on the customer table on the SELECT event
You have issued a SHUTDOWN ABORT command to bring down your database instance. Considerthe steps that will be performed later when you open the database：  1：SGA is allocated.  2：Control file is read.  3：Redo log files are read.  4：Instance recovery is started.  5：Background processes are started.  6：Data files are checked for consistency.  7：Server parameter file or the initialization parameter file is read. Which option has the correct order in which these steps occur（）
A:7，1，5，2，3，6，4
B:1，2，3，7，5，6，4
C:7，1，4，5，2，3，6
D:1，7，5，4，2，3，6
You execute the following PL/SQL:Which two statements are true?（）
A:Fine-Grained Auditing (FGA) is enabled for the PRICE column in the PRODUCTS table for SELECT statements only when a row with PRICE > 10000 is accessed.
B:FGA is enabled for the PRODUCTS.PRICE column and an audit record is written whenever a row with PRICE > 10000 is accessed.
C:FGA is enabled for all DML operations by JIM on the PRODUCTS.PRICE column.
D:FGA is enabled for the PRICE column of the PRODUCTS table and the SQL statements is captured in the FGA audit trial.
You have included the following parameter setting in your server parameter file：       PGA_AGGREGATE_TARGET = 800M        SORT_AREA_SIZE = 100M        HASH_AREA_SIZE = 100M        BITMAP_MERGE_AREA_SIZE = 100M        CREATE_BITMAP_AREA_SIZE = 100M   Which statement is true？（）  
A: All the *_AREA_SIZE parameters are ignored.
B: The Automatic PGA Memory Management feature cannot be disabled.
C: The total Program Global Area （PGA） memory cannot be manually increased above 800M.
D: The total memory for the PGA can automatically exceed 800M using the Automatic PGA Memory Management feature.
在检索数据过程中，经常需要把检索的数据进行合并，满足实际需要。为此，需要使用（），将两个字符表达式连接起来。
A:MERGE
B:连接运算符（∥）
C:JOIN
D:GROUPBY
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 commandline 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
What is the default AU size of an ASM disk group？ What is the maximum AU size in an ASM disk group？（）
A: 100KB default， 10TB maximum
B: 256KB default， 1024MB maximum
C: 10MB default， 126PB maximum
D: 64KB default， 1EB maximum
E: 1MB default， 64MB maximum
Before a Flashback Table operation, you execute the following command: ALTER TABLE employees ENABLE ROW MOVEMENT; Why would you need this to be executed?（）
A:Because row IDs may change during the flashback operation
B:Because the object number changes after the flashback operation
C:Because the rows are retrieved from the recycle bin during the flashback operation
D:Because the table is moved forward and back to a temporary during the flashback opertion
Given： What is the result？（）
A:test
B:null
C:An exception is thrown at runtime.
D:Compilation fails because of an error in line 1.
E:Compilation fails because of an error in line 4.
F:Compilation fails because of an error in line 5.
Which setting change would you allow to make a child object to be moved out of a parent object?（）
A:Flex mode on. 
B:Flex mode off. 
C:Confined mode on. 
D:Confined mode off.
A sales analyst reviews the first draft on your Sales application, and requests that the application graphically represent revenue generated for each sales representative, in addition to the textual data currently displayed for the ORDER block. How would you incorporate this graphic in your form? （）
A:Invoke the Chart Wizard and create a chart based on the ORDER block. 
B:Create a chart using Graphics Builder and then select File Import Chart in Form Builder, positioning the new chart with the text items in the ORDER block. 
C:Invoke the Data Block Wizard in reentrant mode, select the Charts tab, and specify the chart type and column sources for the X and Y axes. 
D:Select the Chart node in the Object Navigator, Click the Create icon, and specify the details of the chart in the chart's Property Palette.
Your database is in NOARCHIVELOG mode and a logswitch happens every 20 minutes. On Thursday morning， media failure resulted in corruption of a data file belonging to the TOOLS tablespace. Backups are taken on every Sunday. What would you do in this situation？（）
A:recover using Oracle Flashback Database technology
B:restore the data files from backup and perform a complete recovery
C:restore only the corrupted data file and perform tablespace recovery
D:restore the data files from backup and perform cancel-based recovery
E:restore the entire database from the most recent backup and start the instance and open the database
You perform a backup using the following BACKUP command: RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE,Which statement is true of this command?（）
A:A different procedure is required to restore a database from compressed backups 
B:The AS COMPRESSED clause of the BACKUP command provided by RMAN is used to create compressed backup sets and image copies. 
C:Using this command to create backups minimizes the bandwidth consumed.
D:Using this command to create backups improves the performance of the backup process 
Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains one redo member. When you attempt to start the database, you receive the following errors: Which statement should you use to resolve this issue?（）
A:ALTER DATABASE DROP LOGFILE GROUP 1;
B:ALTER DATABASE CLEAR LOGFILE GROUP 1;
C:ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;
D:ALTER DATABASE DROP LOGFILE MEMBER 'D:/REDO01.LOG';
In WebLogic 10.3.6 and WebLogic 12c on ExaLogic, performance of JMS is further improved through （）.
A:Web Session Affinity
B:Concurrent Request Manager
C:Coherence
D:Elastic Message Overflow
Identify the activities performed as part of the Automatic SQL Tuning process in the maintenance window？（）
A: generating the SQL profile
B: testing and accepting the SQL profile
C: generating a list of candidate SQLs for tuning
D: adding tuned SQL plans into the SQL plan baseline
E: tuning each SQL statement in the order of importance 
F: generating baselines that include candidate SQLs for tuning
在数据库中，要防止大于100的数据保存到age列，可以（）。
A:使用主键约束
B:使用缺省约束
C:使用外键约束
D:使用检查约束
下列哪个部分不是oracle实例的组成部分？（）
A:系统全局区域
B:服务器进程
C:数据库作者
D:系统监控器
A shoot-out has erupted between your MS development teams using .NET and your Linux development teams using Java.  Knowing that your database is in danger，which command would you use to back up your NOARCHIVELOG mode database using RMAN with compression？（）
A: backup database all
B: backup compressed database
C: backup as compressed backupset database
D: backup as compressed backup database plus archivelog all
E: backup as compressed backupset database plus compress archivelog all
You want to enforce a company’s business policy on several objects by using a single policy function. Which two types of policies can be assigned to the policy_type argument in the dbms_rls.add_policy procedure to achieve the above objective？ （）
A: DBMS_RLS.STATIC
B: DBMS_RLS.DYNAMIC
C: DBMS_RLS.SHARED_STATIC
D: DBMS_RLS.CONTEXT_SENSITIVE
E: DBMS_RLS.SHARED_CONTEXT_SENSITIVE
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2 (25) LAST_NAME VARCHAR2 (25) HIRE_DATE DATE Which UPDATE statement is valid? （）
A:UPDATE employees SET first_name = 'John' SET last_name = 'Smith' WHERE employee_id = 180;
B:UPDATE employees SET first_name = 'John', SET last_name = 'Smoth' WHERE employee_id = 180;
C:UPDATE employee SET first_name = 'John' AND last_name = 'Smith' WHERE employee_id = 180;
D:UPDATE employee SET first_name = 'John', last_name = 'Smith' WHERE employee_id = 180;
What is true about sequences? （）
A:The start value of the sequence is always 1.
B:A sequence always increments by 1.
C:The minimum value of an ascending sequence defaults to 1.
D:The maximum value of descending sequence defaults to 1.
Given: What is the result?（）
A:2
B:24
C:234
D:246
E:2346
F:Compilation fails.
Which two statements are true about the WebLogic Cluster ？（）
A: Clustered Servers capacity can be increased by adding new server instance to the cluster on an existing machine
B: Clustered Servers can be on a same or different machine with same operating system only
C: Clustered Servers can only be on a same machine or different operating system
D: Clustered Servers can be on a same or different machine with same or different operating system
You enable block change tracking. You issue the following command：   BACKUP INCREMENTAL LEVEL 0 DATABASE；   The next day，you issue the following command：   BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE；   Which statement about the use of the change tracking file is true？（）  
A: RMAN reads the block change tracking file only when it performs the incremental level 0 backup.
B: RMAN reads the block change tracking file when it performs both incremental backups.
C: RMAN reads the block change tracking file only when it performs the incremental level 1 backup.
D: RMAN does not read the block change tracking file when it performs either incremental backup.
In which two aspects does hot patching differ from conventional patching？（）  
A: It consumes more memory compared with conventional patching.
B: It can be installed and uninstalled via OPatch unlike conventional patching.
C: It takes more time to install or uninstall compared with conventional patching.
D: It does not require down time to apply or remove unlike conventional patching.
E: It is not persistent across instance startup and shutdown unlike conventional patching.
Identify the channel settings that can be performed using the CONFIGURE CHANNEL or ALLOCATE CHANNEL commands in RMAN ？（）
A: Limiting the input/output （I/O） bandwidth consumption
B: Specifying the size of backup sets and backup pieces
C: Specifying vendor-specific information for a media manager
D: Specifying the parallelism for backup and restore operations
The EMP table has these columns: Management wants a list of names of employees who have been with the company for more than five years. Which SQL statement displays the required results?（）
A:SELECT ENAME   FROM EMP   WHERE SYSDATE-HIRE_DATE > 5;
B:SELECT ENAME   FROM EMP   WHERE HIRE_DATE-SYSDATE > 5;
C:SELECT ENAME   FROM EMP   WHERE (SYSDATE-HIRE_DATE)/365 > 5;
D:SELECT ENAME   FROM EMP   WHERE (SYSDATE-HIRE_DATE)* 365 > 5;
在Oracle中，（）程序包中提供了所有预定义的异常的定义。
A:DBMS_STANDARD
B:DBMS_STD
C:DBMS_SQL
D:DBMS_TYPES
首页 <上一页 95 96 97 98 99 下一页> 尾页