出自:Oracle认证

You opened the encryption wallet and then issued the following command：   SQL>CREATE TABLESPACE securespace DATAFILE ’/home/user/oradata/secure01.dbf’ SIZE 150M  ENCRYPTION USING ’3DES168’ DEFAULT STORAGE（ENCRYPT）；   Then you closed the wallet. Later， you issued the following command to create theEMPLOYEES table in the SECURESPACE tablespace and you use the NO SALT option for the EMPID column.  What is the outcome？（）  
A: It creates the table and encrypts the data in it.
B: It generates an error because the wallet is closed.
C: It creates the table but does not encrypt the data in it.
D: It generates an error because the NO SALT option cannot be used with the ENCRYPT option.
Which three statements are true about windows?（）
A:Only one window can be open at any given time
B:Consumer groups are associated with windows
C:Windows work with job classes to control resource allocation
D:The database service name must be provided during windows creation
E:Windows can automatically start job or change resource allocation among jobs for various time periods.
Click the Exhibit button and examine the data from the EMP table. The COMMISSION column shows the monthly commission earned by the employee. Which two tasks would require subqueries or joins in order to be performed in a single step? （）
A:listing the employees who earn the same amount of commission as employee 3
B:finding the total commission earned by the employees in department 10
C:finding the number of employees who earn a commission that is higher than the average commission of the company
D:listing the departments whose average commission is more than 600
E:listing the employees who do not earn commission and who are working for department 20 in descending order of the employee ID
F:listing the employees whose annual commission is more than 6000
Which two statements are true about checkpointing（）
A:The checkpoint frequency decreases with the smaller redo log file size.
B:It ensures that all committed data is written to the data files during normal shutdown.
C:The frequent full checkpoint in a database can cause the overall degradation of the database performance.
D:It prompts the Checkpoint （CKPT） process to write data to the data files and redo information to the online redo log files.
Paul wants to log in to 11i Oracle Applications. Identify the first server to which his requestwould go.（）
A:Web server
B:Reports server
C:Administration server
D:Concurrent Processing server
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER NOT NULL EMP_NAME VARCHAR2(30) JOB_ID VARCHAR2(20) DEFAULT 'SA_REP' SAL NUMBER COMM_PCT NUMBER MGR_ID NUMBER DEPARTMENT_ID NUMBER You need to update the records of employees 103 and 115. The UPDATE statement you specify should update the rows with the values specified below: JOB_ID: Default value specified for this column definition. SAL: Maximum salary earned for the job ID SA_REP. COMM_PCT: Default value specified for this commission percentage column, if any. If no default value is specified for the column, the value should be NULL. DEPARTMENT_ID: Supplied by the user during run time through substitution variable. Which UPDATE statement meets the requirements?（）
A:UPDATE employees SET job_id = DEFAULT AND Sal = (SELECT MAX(sal) FROM employees WHERE job_id = 'SA_REP') AND comm_pct = DEFAULT AND department_id = &did WHERE employee_id IN (103,115);
B:UPDATE employees SET job_id = DEFAULT AND Sal = MAX(sal) AND comm_pct = DEFAULT OR NULL AND department_id = &did WHERE employee_id IN (103,115) AND job_id = 'SA_REP';
C:UPDATE employeesC.UPDATE employees SET job_id = DEFAULT, Sal = (SELECT MAX(sal) FROM employees WHERE job_id = 'SA_REP'), comm_pct = DEFAULT, department_id = &did WHERE employee_id IN (103,115);
D:UPDATE employeesD.UPDATE employees SET job_id = DEFAULT, Sal = MAX(sal), comm_pct = DEFAULT, department_id = &did WHERE employee_id IN (103,115) AND job_id = 'SA_REP';
E:UPDATE employees SET job_id = DEFAULT, Sal = (SELECT MAX(sal) FROM employees WHERE job_id = 'SA_REP'), comm_pct = DEFAULT OR NULL, department_id = &did WHERE employee_id IN (103,115);
In your Supportcenter.cn 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.
Which two statements are correct about database transportation?（） (Choose two.)
A:The source and target platforms must be the same
B:Redo logs, control files and temp files are also transported
C:The transported database must have the same database identifier (DBID) as the source database and cannot be changed
D:The COMPATIBLE parameter must be set to 10.0.0.0 or higher and the database must be opened in readonly mode before being transported
E:Recovery Manager (RMAN) is used to convert the necessary data files of the database if the target platform is different and has different endian format
You have two listener processes， named L1 and L2. Both the listener processes are currently functional. While viewing the listener.ora file on your database server， you find the following entry： PASSWORDS_L1 = （1sanfrjp43） What would be the impact of this setting？（）
A:The listener process named L1 will disconnect the unauthorized users.
B:The listener process named L1 will be prevented from being started by unauthorized users. 
C:The listener process named L1 will be prevented from being stopped by unauthorized users. 
D:The listener process named L1 will be prevented from being reloaded by unauthorized users.
E:The listener process named L1 will be prevented from accepting connections from unauthorized users.
You are administering a database and you receive a requirement to apply the following restrictions: 1. A connection must be terminated after four unsuccessful login attempts by user. 2. A user should not be able to create more than four simultaneous sessions. 3. User session must be terminated after 15 minutes of inactivity. 4. Users must be prompted to change their passwords every 15 days. How would you accomplish these requirements?（）
A:by granting a secure application role to the users
B:by creating and assigning a profile to the users and setting the REMOTE_OS_AUTHENT parameter to false
C:By creating and assigning a profile to the users and setting the SEC_MAX_FAILED_LOGIN_ATTEMPTS parameter to 4
D:By Implementing Fine-Grained Auditing (FGA) and setting the REMOTE_LOGIN_PASSWORD_FILE parameter to none.
E:By implementing the database resource Manager plan and setting the SEC_MAX_FAILED_LOGIN_ATTEMPTS parameters to 4.
Evaluate the following command and its output: Which two statements correctly interpret the output?（）
A:FREE_SPACE indicates only the space that is currently unallocated.
B:ALLOCATED_SPACE indicates only the space currently allocated and in use.
C:FREE_SPACE indicates only the space that is currently allocated and available for reuse.
D:ALLOCATED_SPACE indicates both the space currently allocated and used, and the space that is available for reuse.
E:FREE_SPACE indicates both the space that is currently allocated and available for reuse, and the space that is currently unallocated.
触发器事件和语句是SQL语句、数据库事件、用户事件，导致触发器触发。触发器时机可以是（）。
A:对特别表（视图）的INSERT、UPDATE、DELETE语句
B:对特定模式对象的CREATE、ALTER和DROP语句
C:数据库启动、实例关闭
D:特定的错误消息和任何错误消息
The SQL Tuning Advisor configuration has default settings in your database instance.  Which recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task？（）
A: statistics recommendations
B: SQL Profile recommendations
C: Index-related recommendations
D: restructuring of SQL recommendations
Which three statements are true regarding the fine/x7fgrained auditing （FGA）？（）
A:FGA is possible on SELECT statements only.
B:The audit trail for FGA is stored in the FGA_LOG$ table.
C:The audit trail for FGA is stored in the AUD_LOG$ table.
D:FGA enables a SQL predicate to define when to audit an event.
E:FGA audits DELETE statements only when audit columns are specified.
F:FGA includes the SQL statement used by the user as part of the audit event entry.
Which two statements are true about a job chain？（）
A: A job chain can contain a nested chain of jobs
B: The jobs in a job chain cannot have more than one dependency
C: A job of the CHAIN type can be run using event-based or time-based schedules
D: The jobs in a job chain can be executed only by using the events generated by the Scheduler
Evaluate this SQL statement: SELECT e.EMPLOYEE_ID,e.LAST_NAME,e.DEPARTMENT_ID, d.DEPARTMENT_NAME FROM EMP e, DEPARTMENT d WHERE e.DEPARTMENT_ID = d.DEPARTMENT_ID; In the statement, which capabilities of a SELECT statement are performed?（）
A:Selection, projection, join
B:Difference, projection, join
C:Selection, intersection, join
D:Intersection, projection, join
E:Difference, projection, product
You query the ORDERS table and discover that order number 1101 is missing. One of your reports， generated at 5：00 A.M. on April 23， 2005 using Oracle Reports， includes this order number in the output. You have inserted 100 new orders into the ORDERS table since generating this report. Which flashback technology would you use to recover order number 1101 into the ORDERS table without losing the 100 orders that you added after the report was generated？（）  
A: Flashback Table
B: Flashback Query
C:Flashback Version Query
D: Flashback Transaction Query
Your database is set in NOARCHIVELOG mode and is backed up every night. There are 10 redo log groups on the database， each with three members， making a total of 30 redo log files. At lunchtime the server unexpectedly gets shut down. Upon restarting you notice that the data file belonging to the SYSTEM tablespace has become corrupted. You also notice that there have been 15 log switches during the day. Which solution should you use to recover as much committed data as possible？（）
A:Restore the data file for the SYSTEM tablespace then open the database. 
B:Restore all redo logs form last night's backup, then restart the database. 
C:Perform a complete restore of all files from last night's backup. Data entered into the database today must be reentered. 
D:Mount the instance, take the SYSTEM tablespace offline, open the database, and then restore the data file, recover it, and bring the tablespace online. 
Given: What is the result? （）
A:2
B:24
C:234
D:246
E:2346
F:Compilation fails.
You are using Enterprise Manager to schedule backups for your database.  Which type of script wouldbe generated by the backup scheduler（）
A:XML script
B:PL/SQL script
C:Operating system script
D:Recovery Manager （RMAN） script
Your production database uses an Automatic Storage Management （ASM） instance to manage its files. You want to add a new disk group to the ASM instance to manage the increased data load. What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users？（）
A:mount the new disk group in the ASM instance
B:restart the ASM instance and the production database instance
C:register the new disk groups in the production database instance
D:restart the ASM instance without restarting the production database instance
E:include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance
以下的PL/SQL声明哪个是正确的？（）
A:v_id NUMBER(4);
B:v_x, v_y, v_z VARCHAR2(10);
C:v_birthdate DATE NOT NULL;
D:v_in_stock BOOLEAN := 1;
You want to use the automatic management of backup and recovery operations features for your database.Which configuration must you set?（）
A:Enable the flash recovery area and specify it as the archived redo log destination.
B:Disable the flash recovery area and start the database instance in ARCHIVELOG mode.
C:Enable the flash recovery area but do not specify it as the archived redo log destination.
D:Disable the flash recovery area and start the database instance in NOARCHIVELOG mode
以下关于PL/SQL块的说法正确的是（）
A:匿名块(Anonymous Blocks)是在客户端解析后再送到服务器端执行的
B:子程序(Subprograms)是被命名的PL/SQL块,存储在数据库服务器端
C:匿名块比子程序执行效率要高
D:无论是匿名块还是子程序,其实都是PL/SQL块,在定义变量前都要以DECLARE关键字开始
E:过程(procedure)无返回值,而函数(function)是有返回值的
Given： When line 14 is reached， how many objects are eligible for the garbage collector？（）
A:0
B:1
C:2
D:3
E:4
Which setting enables the baselines by default in Oracle Database 11g？（）  
A: setting the STATISTICS_LEVEL parameter to TYPICAL
B: adding filters to the Automatic Database Diagnostic Monitor （ADDM）
C: enabling Automated Maintenance Task using Oracle Enterprise Manager
D: setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE
Evaluate the SQL statement:SELECT ROUND(TRUNC(MOD(1600,10),-1),2)FROM dual;What will be displayed?（）
A:0
B:1
C:0.00
D:an error statement
MySQL is installed on a Linux server and has the following configuration: What is the purpose of changing ownership of datadir to the ‘mysql’ user?（）
A:MySQL requires correct file ownership while remaining secure
B:MySQL needs to be run as the root user, but file cannot be owned by it
C:MySQL cannot be run as the root user
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
Which two statements are true about a bitmap index？ （）
A:It is recommended for the columns that have unique values.
B:It can be converted to a B-tree index by using the ALTER INDEX command.
C:It has a bitmap segment for each distinct value in the key column， containing a string of bits in which each bit represents the presence or absence of a key column value.
D:Updating the key column locks the whole bitmap segment that contains the bit for the key value to be updated.
首页 <上一页 7 8 9 10 11 下一页> 尾页