出自:Oracle认证

You execute the following command to audit the database activities：   SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL；  What is the effect of this command？（）
A:One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session.
B:One audit record is created for every session when any user successfully drops a table owned by SCOTT.
C:One audit record is created for each successful DROP TABLE command executed by any user to drop tables owned by SCOTT.
D:One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users in his session.
E:One audit record is created for each successful DROP TABLE command executed in the session of SCOTT.
You are managing an Oracle Database 11g database. You want to ensure the recovery of the database to thepoint of failure. Which configuration will you do to accomplish the task（）
A:Multiplex all database files.
B:Configure the Flash Recovery Area.
C:Configure the database instance for ARCHIVELOG mode.
D:Configure the FAST_START_MTTR_TARGET initialization parameter
Your database instance is running with full workload after database creation. You have decided to useafixed-sizeundo tablespace. You want to use the Undo Advisor to estimate the capacity of the undotablespace.  Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace（）
A:the retention period to support flashback
B:the expected length of the longest-running query
C:the number of undo tablespaces in the database
D:the size of the Flash Recovery Area for the database instance
Given below is a list of scenarios： 1） A user terminates his session abnormally. 2） The connection between the server and the client application terminates because of a network failure. 3） A schema is accidentally dropped. 4） The tablespace is accidentally dropped from the database. 5） The hard disk gets corrupted and the data files in the disk are lost. 6） The database instance abnormally shuts down because of power failure.  Which scenarios require DBAintervention to perform recovery（）
A:1， 3， and 6
B:4， 5， and 6
C:3， 4， and 5
D:1， 2， and 6
Which option is best practice for creating a recovery catalog owner in the catalog database?（）
A:Granting UNLIMITED QUOTA on the SYSTEM tablespace to the owner
B:Allocating the SYSTEM tablespace as the default tablespace and granting the SYSDBA privilege to the user
C:Creating a new tablespace, allocating this as the default, and granting UNLIMITED QUOTA on this tablespace to the user
D:Allocating the SYSAUX tablespace as the default tablespace and granting UNLIMITED QUOTA on this tablespace to the user
The data file belonging to theSYSTEMtablespaceis corrupted and no backup of the file is available. How do you recover the data file？（）
A:The data file cannot be recovered.
B:The date file can be restored from theSYSTEMauto backup.
C:Take thetablespaceoffline，drop，kand re-create it.
D:Recovery Manager （RMAN） is used to recover the data file.
E:The ALTER DATABSE CREATE DATAFILE..commandis used to recover the data file.
Which SQL statement generates the alias Annual Salary for the calculated column SALARY*12?（）
A:SELECT ename, salary*12 ‘Annual Salary’   FROM employees;
B:SELECT ename, salary*12 “Annual Salary”   FROM employees;
C:SELECT ename, salary*12 AS Annual Salary   FROM employees;
D:SELECT ename, salary*12 AS INITCAP(“ANNUAL SALARY”)   FROM employees
You defined the Recovery Manager （RMAN） retention policy to recovery window of 7 days by executing the following command：  RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS；  When a backup is performed， what would be the status of this backup after seven days？（）
A: The backup would be marked as invalid.
B: The backup would be marked as obsolete.
C: The backup would be removed from the media.
D: The backup would be removed from the RMAN repository.
Which three are DATETIME data types that can be used when specifying column definitions? （）
A:TIMESTAMP
B:INTERVAL MONTH TO DAY
C:INTERVAL DAY TO SECOND
D:INTERVAL YEAR TO MONTH
E:TIMESTAMP WITH DATABASE TIMEZONE
During the installation of Oracle Database 11g, you do not set ORACLE_BASE explicitly. You selected the option to create a database as part of the installation. How would this environment variable setting affect the installation?（）
A:The installation terminates with an error.
B:The installation proceeds with the default value without warnings and errors.
C:The installation proceeds with the default value but it would not be an OFA-compliant database.
D:The installation proceeds with the default value but a message would be generated in the alert log file.
What are two benefits of installing Grid Infrastructure software for a stand-alone server before installing and creating an Oracle database?（）
A:Effectively implements role separation
B:Enables you to take advantage of Oracle Managed Files.
C:Automatically registers the database with Oracle Restart.
D:Helps you to easily upgrade the database from a prior release.
E:Enables the Installation of Grid Infrastructure files on block or raw devices.
Your database operates in ARCHIVELOGmode. The redo log files are not multiplexed and one of the online redo logs is missing. The missing redo log sequence， 230， is not archived and it contained information from 10：35 a.m. onwards. The current time is 11：00 a.m. Because of a disk crash， you executed the following command to perform an incomplete recovery：  RMAN> RUN {  2> SET UNTIL SEQUENCE 230 THREAD 1； 3> ALTER DATABASE MOUNT；  4> RESTORE DATABASE；  5> RECOVER DATABASE；  6> ALTER DATABASE OPEN RESETLOGS；  7> }；  With reference to this scenario， which statement is true？（）
A: RMAN recovers up to log sequence 230， but not including 230.
B: RMAN returns an error because the log sequence number mentioned in the command should be 229.
C: RMAN returns an error because the log sequence number mentioned in the command may never be missing.
D: RMAN recovers up to and including log sequence 229 but then returns an error because log sequence 230 is missing.
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
F:java com.company.application.MainClass if run from the /apps/com/company/application directory
According to your backup strategy， you performed an incremental level 0 backup of your database. Which statement regarding this backup is true？（）
A:The backup is similar to image copy.
B:The backup contains all used data blocks.
C:The backup contains only unused data blocks.
D:The backup contains all data blocks changed since the last incremental level 1 backup.
Given: What is the result?（）
A:Compilation fails.
B:exception is thrown at runtime.
C:The attribute id in the ItemTest object remains unchanged.
D:The attribute id in the ItemTest object is modified to the new value.
E:A new ItemTest object is created with the preferred value in the id attribute.
You want to create a consumer group， GROUP1， and you execute the following command in the command-line interface：  SQL> EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP （CONSUMER_GROUP =>’group1’， COMMENT => ’New Group’）；  This command errorsout displaying the following message：  ERROR at line 1：  ORA-01031： insufficient privileges  ORA-06512： at "SYS.DBMS_RMIN"， line 115  ORA-06512： at SYS.DBMS_RESOURCE_MANAGER"， line 108 ORA-06512： at line 1  What action would you take to overcome this error？（）
A: grant SYSDBA to the user
B: grant SYSOPER to the user
C: grant the RESOURCE role to the user
D: use the GRANT command to grant the ADMINISTER_RESOURCE_MANAGER privilege to the use
E: grant the ADMINISTER_RESOURCE_MANAGER privilege to the user by using the DBMS_RESOURCE_MANAGER_PRIVS package
Consider the following command：  Backup database plus archivelog delete input；  How many backup sets would be created by this command if the following were true：（）  Control-file a NN uto backups were enabled.  NN The size of backup sets was not restricted.  NN One channel was allocated.  
A: 1
B: 2
C: 3
D: 4
E: 5
The database administrator of your company created a public synonym called HR for the HUMAN_RESOURCES table of the GENERAL schema, because many users frequently use this table. As a user of the database, you created a table called HR in your schema. What happens when you execute this query? SELECT * FROM HR; （）
A:You obtain the results retrieved from the public synonym HR created by the database administrator.
B:You obtain the results retrieved from the HR table that belongs to your schema.
C:You get an error message because you cannot retrieve from a table that has the same name as a public synonym.
D:You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a Cartesian product.
E:You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a FULL JOIN.
View the Exhibit to examine the output produced by the following query at three different times since thedatabase instance started and has experienced workloads of different capacities：SQL> SELECT substr（component， 0， 10） COMP， current_size CS， user_specified_size US FROM v$memory_dynamic_componentsWHERE current_size!=0；What do you infer from this（）
A:The database instance is running with manual PGA management.
B:The database instance is running with manual shared memory management.
C:The database instance has the MEMORY_TARGET value set to a nonzero value.
D:All sessions are connected to the database instance in dedicated mode， and no RMAN or parallel queryoperations have been performed
Your Oracle Database 10g is online when you execute the following statement：        SQL>ALTER TABLESPACE MY_TABLESPACE FLASHBACK OFF；   What is the result of executing this statement if the Flashback Database feature is already enabled in the database？（）
A: The database does not record flashback logs for MY_TABLESPACE
B: The tables residing in MY_TABLESPACE are not protected by the Recycle Bin.
C: All the tablespaces except MY_TABLESPACE can be recovered using Flashback Database feature.
D: None of the flashback technologies， such as Flashback Table， Flashback Transaction Query and Flashback Version Query can be used to recover individual rows within the objects from MY_TABLESPACE
Automatic data conversion will occur if which of the following happens？（）
A: The client and server have different NLS_LANGUAGE settings
B: The client and server character sets are not the same，and the database character set is not a strict superset of the client character set
C: The client and server are in different time zones
D: The client requests automatic data conversion
E: The AUTO_CONVERT initialization parameter is set to TRUE
You have a login-path named "adamlocal" that was created by using the mysql_config_editor command. You need to check what is defined for this login_path to ensure that it is correct for you deployment. You execute this command: $mysql_config_editor print –login-path=adamlocal What is the expected output of this command?（）
A:The command prints all parameter for the login-path. The password is replaced with stars
B:The command prints the encrypted entry for the login-path. The is only possible to see if an entry exists
C:The command prints all parameters for the login-path. The password is shown only when you provide the  –password option
D:The command prints all parameters for the login-path. The password is printed in plain tex
The STUDENT_GRADES table has these columns: STUDENT_ID NUMBER(12) SEMESTER_END DATE GPA NUMBER(4,3) Which statement finds the highest grade point average (GPA) per semester?（）
A:SELECT MAX (gpa) FROM student _ grades WHERE gpa IS NOT NULL;
B:SELECT (gpa) FROM student _ grades GROUP BY semester_end WHERE gpa IS NOT NULL;
C:SELECT MAX (gpa) FROM student _ grades WHERE gpa IS NOT NULL GROUP BY semester_end;
D:SELECT MAX (gpa) GROUP BY semester_end WHERE gpa IS NOT NULL FROM student _ grades;
E:SELECT MAX (gpa) FROM student _ grades GROUP BY semester_end WHERE gpa IS NOT NULL;
You execute this command to drop the ITEM table， which has the primary key referred in the ORDERtable：  SQL> DROP TABLE scott.item CASCADE CONSTRAINTS PURGE；  Which two statements are true about the effect of the command（）
A:No flashback is possible to bring back the ITEM table.
B:The ORDER table is dropped along with the ITEM table.
C:The dependent referential integrity constraints in the ORDER table are disabled.
D:The dependent referential integrity constraints in the ORDER table are removed.
E:The table definition of the ITEM table and associated indexes are placed in the recycle bin.
Given： 11.double input = 314159.26； 12.NumberFormat nf = NumberFormat.getInstance（Locale.ITALIAN）； 13.String b； 14.//insert code here Which code， inserted at line 14， sets the value of b to 314.159，26？（）
A:b = nf.parse（ input ）；
B:b = nf.format（ input ）；
C:b = nf.equals（ input ）；
D:b = nf.parseObject（ input ）；
n your production database you want to use an Automatic Storage Management （ASM） instance to manage the database files. Which option would you use to migrate the database files from a non-ASM instance to an ASM instance？（）
A: Oracle Migration Assistant
B: Recovery Manager （RMAN）
C: Oracle Data Pump Export and Import
D: conventional Oracle Export and Import
E: operating system utilities to copy the files to the ASM instance
You plan to move data from a flat file to a table in your database. You decide to use SQL*Loader directpath load method to perform this task. The table in which you plan to load data is an important tablehaving various integrity constraints defined on it.  Which constraints will remain enabled by default during this operation（）
A:CHECK
B:UNIQUE
C:NOT NULL
D:PRIMARY KEY
E:FOREIGN KEY
You just completed a manual open database backup. However there seems to be a problem with the database performance. You discover that the database is generating many log switches and the LGWR is consuming lots of CPU time. You have an idea of what the problem is and you begin looking at the information in V$BACKUP and in V$DATAFILE_HEADER. What do you suspect is the problem？（）
A:A
B:B
C:C
D:D
Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables: EMPLOYEES EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2 (25) LAST_NAME VARCHAR2 (25) HIRE_DATE DATE NEW EMPLOYEES EMPLOYEE_ID NUMBER Primary Key NAME VARCHAR2 (60) Which DELETE statement is valid?（）
A:DELETE FROM employees WHERE employee_id = (SELECT employee_id FROM employees);
B:DELETE * FROM employees WHERE employee_id = (SELECT employee_id FROM new_ employees);
C:DELETE FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name = ('Carrey')'
D:DELETE * FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE last_ name = ('Carrey')'
Which of the following most closely represents an image copy? （）
A:Unix cp command of a file
B:Bit-by-bit copy of a file
C:Windows COPY command of a file 
D:All of the above
首页 <上一页 14 15 16 17 18 下一页> 尾页