出自:Oracle认证

In your database instance， the user sessions are connected to the database server from the remotemachines. You want to achieve the following for these users：  1：The user account must be locked after four unsuccessful login attempts.PASSWORD_LOCK_TIME  2：The user must be prompted to change the password at regular intervals.PASSWORD_LIFE_TIME  3：The user may not have more than three simultaneous sessions.SESSIONS_PER_USER  4：The user session must automatically be logged off if more than 10 minutes elapsed time used.CONNECT_TIME  How would you accomplish the above（）
A:by assigning profiles for the users
B:by implementing Fine-Grained Auditing （FGA）
C:by granting a secure application role to the users
D:by implementing the Database Resource Manager plan
You lost the PRODSTD tablespace， which was read-only. The tablespace was read-only when the last backup was taken. How would you recover the tablespace？（）
A: restore the tablespace from the backup， and then perform an incomplete recovery
B: restore the tablespace from the backup， and then apply all the redo information
C: restore all the data files in the database， and then perform an incomplete recovery
D: restore the tablespace from the backup
You experienced a loss of data files in your database. You did not lose any of your control files. You are going to use RMAN to restore and recover the database. Currently， your instance is shut down.  Which sequence of commands is correct to restore and recover your database？（）
A:A
B:B
C:C
D:D
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE You issue these statements: CREATE table new_emp ( employe_id NUMBER, name VARCGAR2(30)); INSERT INTO new_emp SELECT employee_id, last_name from employees; Savepoint s1; UPDATE new_emp set name = UPPER(name); Savepoint s2; Delete from new_emp; Rollback to s2; Delete from new_emp where employee_id=180; UPDATE new_emp set name = 'James'; Rollback to s2; UPDATE new_emp sey name = 'James' Where employee_id=180; Rollback; At the end of this transaction, what is true? （）
A:You have no rows in the table.
B:You have an employee with the name of James.
C:You cannot roll back to the same savepoint more than once.
D:Your last update fails to update any rows because employee ID 180 was already deleted.
The user HR owns the EMP table. The user HR grants privileges to the user SCOTT by using this command：  SQL> GRANT SELECT，INSERT，UPDATE ON emp TO scott WITH GRANT OPTION； The user SCOTT executes this command to grant privileges to the user JIM： SQL> GRANT SELECT，INSERT，UPDATE ON hr.emp TO jim；  Now， the user HR decides to revoke privileges from JIM using this command： SQL> REVOKE SELECT，INSERT，UPDATE ON emp FROM jim； Which statement is true after HR issues the REVOKE command（）
A:The command fails because SCOTT still has privileges.
B:The command succeeds and privileges are revoked from JIM.
C:The command fails because HR cannot revoke the privileges from JIM.
D:The command succeeds and only HR has the privilege to perform the SELECT， INSERT， and UPDATEoperations on the EMP table.
说明数据库内存结构中SGA和PGA的组成，以及这两个内存区存放信息的区别。
Which is a command-line scripting interface based  on Jython used for automation of WebLogic Server administration ？（）
A: WebLogic Scripting Tool
B: Weblogic OPMN
C: WeblogicDeployer
D: WeblogicICommand
Two database users, Jack and Bill, are accessing the SupportCenter STAFF table of the SupportCenter DB database. When Jack modifies a value in the table, the new value is invisible to Bill. Which is the modified value invisible to Bill?（）
A:The modified data are not available on disk.
B:The modified data have been flushed out from memory.
C:The modified rows of the SupportCenter STAFF table have been locked.
D:Jack has not committed the changes after modifying the value.
E:Both users are accessing the database from two different machines.
What is the danger associated with stopping a running job by using the STOP_JOB procedure？（）  
A: The job will need to be reenabled before it will execute again.
B: The job may hold locks on objects referenced within it.
C: All jobs within the job group will also be stopped.
D: The job may leave data in an inconsistent state.
E: There is no danger in using the STOP_JOB procedure.
A PL/SQL procedure queries only those columns of a redefined table that were unchanged by the online table redefinition. What happens to the PL/SQL procedure after the online table redefinition?（）
A:It remains valid.
B:It becomes invalid for all options of online table redefinition but automatically gets revalidated the next time it is used.
C:It becomes invalid for all options of online table redefinition and is automatically recompiled during online redefinition of the table.
D:It becomes invalid only if the storage parameters have been modified and it automatically gets revalidated the next time it is used.
You notice a performance change in your production Oracle database and you want to know which change has made this performance difference. You generate the Compare Period Automatic Database Diagnostic Monitor (ADDM) report to further investigation. Which three findings would you get from the report?（）
A:It detects any configuration change that caused a performance difference in both time periods.
B:It identifies any workload change that caused a performance difference in both time periods.
C:It detects the top wait events causing performance degradation.
D:It shows the resource usage for CPU, memory, and I/O in both time periods.
E:It shows the difference in the size of memory pools in both time periods.
F:It gives information about statistics collection in both time periods.
What happens when you run the SQL Tuning Advisor with limited scope?（）
A:Access path analysis is not performed for SQL statements.
B:SQL structure analysis is not performed for SQL statements.
C:SQL Profile recommendations are not generated for SQL statements.
D:Staleness and absence of statistics are not checked for the objects in the SQL Tuning Advisor. In this case, SQL Tuning Advisor produces recommendations based on statistical checks, access path analysis, and SQL structure analysis. SQL profile recommendations are not generated.
Which two statements about bigfile tablespaces are true？ （）
A:The bigfile tablespace have only one data file.
B:The segment space management is automatic.
C:The extent management is dictionary managed.
D:The database can have only one bigfile tablespace.
E:The bigfile tablespace can be converted to a smallfile tablespace.
写出一个SQL语句，语句当中需要使用到“同义词”。
Which two statements are true regarding single row functions?（）
A:They accept only a single argument 
B:They can be nested only to two levels 
C:Arguments can only be column values or constants 
D:They always return a single result row for every row of a queried table 
E:They can return a data type value different from the one that is referenced
You have configured OMF in your database. You enabled the ALTER DATABASE ENABLE BLOCK CHANGE TRACKING； statement to enable the block change tracking feature.  What information will be written in the change tracking file？（）
A: the system change number
B: the locations of the redo log files
C: the locations of the datafiles
D: the physical location of all the database changes
How can the command-line Coherence application in Windows and UNIX be started ？（）
A: navigate to the $COHERENCE_HOME directory and type bin/coherence.cmd （Windows） or ./bin/coherence.sh （UNIX）
B: navigate to the $COHERENCE_HOME directory and type coherence.cmd （Windows） or bin/coherence.sh （UNIX）
C: navigate to the $COHERENCE_HOME directory and type bin/coherence.cmd （Windows） or coherence.sh （UNIX） 
D:  All of the above
You want to estimate the size of a table by using the Oracle Enterprise Manager.  On which data is the size of the table NOT based？（）
A: column sizes
B: column data types
C: PCTFREE
D: projected number of row
E: PCTUSED
You need to display the last names of those employees who have the letter "A" as the second character in their names. Which SQL statement displays the required results? （）
A:SELECT last_name FROM EMP WHERE last_ name LIKE '_A%';
B:SELECT last_name FROM EMP WHERE last name ='*A%'
C:SELECT last_name FROM EMP WHERE last name ='_A%';
D:SELECT last_name FROM EMP WHERE last name LIKE '*A%'
You want to rebuild a free list in the free lists of the EMPLOYEE table in the Scott schema. Which package will you use to accomplish this？（）
A: DBMS_REPAIR
B: DBMS_SCHDULER
C: DBMS_STATS
D: DBMS_RESOURCE_MANAGER
（）是用PL/SQL、Java和C编写的过程，能够在对表或视图执行DML语句时执行。
A:过程
B:触发器
C:函数
D:程序包
Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES,DEPARTMENTS, and LOCATIONS tables. She granted SELECT privilege to Scott on this view. Which option enables Scott to eliminate the need to qualify the view with the name MARY .EMP_DEP_LOC_VU each time the view is referenced? （）
A:Scott can create a synonym for the EMP_DEPT_LOC_VU bus using the command: CREATE PRIVATE SYNONYM EDL_VU FOR mary. EMP DEPT_LOC_VU; then he can prefix the columns with this synonymn.
B:Scott can create a synonym for the EMP_DEPT_LOC_VU by using the command: CREATE SYNONYM EDL_VU FOR mary. EMP DEPT_LOC_VU; then he can prefix the columns with this synonym.
C:Scott can create a synonym for the EMP_DEPT_LOC_VU by using the command: CREATE LOCAL SYNONYM EDL_VU FOR mary. EMP DEPT_LOC_VU; then he can prefix the columns with this synonym.
D:Scott cannot create a synonym because synonyms can be created only for tables.
E:Scott cannot create any synonym for Mary's view. Mary should create a private synonym for the view and grant SELECT privilege on that synonym to Scott.
Given： What is the result？（）
A:3
B:23
C:32
D:123
E:321
显示本月月末的日期（）
A:select last_date(sysdate) from dual;
B:select finally_day(sysdate) from dual;
C:select last_day(sysdate) from dual;
D:select tail_day(sysdate) from dual;
You need to create a data block for DML operations in the NEW_EMPLOYEE form module. Which data source can you use for this block?（）
A:REF cursor query. 
B:Stored function. 
C:From clause query. 
D:Transactional trigger.
Which of the following is not a valid calendaring syntax element?（）
A:FREQ
B:BYHOUR
C:RUNDATE
D:INTERVAL
E:BYMINUTE
You write a procedure that will be called from two level triggers and a database trigger. Where should you store this code? （）
A:On the Oracle server. 
B:Locally in each form module. 
C:In an attached PL/SQL library 
D:On your file network server.
Examine the following command that is used to duplicate a database on the same host: Which two statements describe the effect after the database is duplicated successfully? （）
A:The data files of the read-only tablespaces in the target database are not duplicated
B:The read-only tablespaces in the target database are still defined in new the database
C:The read-only tablespaces in the target database are changed to online after duplication
D:The data files of the read-only tablespaces in the target database get duplicated
E:The read-only tablespaces in the target database are not defined in the new database
In which situation are you NOT required to perform an incomplete recovery？（）
A: when all the control files are lost
B: when all the members of a redo log group are lost
C: when a table is dropped and purged from the Recycle Bin
D: when a temporary file of the default temporary tablespace is lost
Given： What is the result？（）
A:No output is produced. 1 2 3
B:No output is produced. 2 3 4
C:No output is produced. 1 2 3 4
D:An exception is thrown at runtime. 1 2 3
首页 <上一页 90 91 92 93 94 下一页> 尾页