出自:Oracle认证

Given: What can be a result?（）
A:Compilation fails.
B:An exception is thrown at runtime.
C:The code executes and prints "StartedComplete".
D:The code executes and prints "StartedComplete0123".
E:The code executes and prints "Started0123Complete".
以下ORACLE认证的级别由低到高排列正确的是（）
A:OCA->OCP->OCM
B:OCM->OCP->OCA
C:OCP->OCA->OCM
D:OCA->OCM->OCP
E:OCP->OCM->OCA
当执行COMMIT语句时，会在哪类文件上发生I/O操作（）
A:数据文件
B:控制文件
C:重做日志文件
D:归档日志文件
E:警告文件
You are performing the shrink operation on the SCOTT.EMP table. You want to perform the same operation on all dependent objects of the SCOTT.EMP table. What is NOT a prerequisite for the operation？（）
A: You must enable the row movement on the SCOTT.EMP table.
B: You must define the tablespace of the SCOTT.EMP table for automatic segment space management.
C: You must use the CASCADE clause in the ALTER TABLE SHRINK SPACE statement.
D: You must use the COMPACT clause in the ALTER TABLE SHRINK SPACE statement.
You need to give the MANAGER role the ability to select from, insert into, and modify existing rows in the STUDENT_GRADES table. Anyone given this MANAGER role should be able to pass those privileges on to others. Which statement accomplishes this? （）
A:GRANT select, insert, update ON student_grades TO manager
B:GRANT select, insert, update ON student_grades TO ROLE manager
C:GRANT select, insert, modify ON student_grades TO manager WITH GRANT OPTION;
D:GRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION;
E:GRANT select, insert, update ON student_grades TO ROLE manager WITH GRANT OPTION;  
F:GRANT select, insert, modify ON student_grades TO ROLE manager WITH GRANT OPTION;
You run a script that completes successfully using SQL*Plus that performs these actions: 1. Creates a multitenant container database (CDB) 2. Plugs in three pluggable databases (PDBs) 3. Shuts down the CDB instance 4. Starts up the CDB instance using STARTUP OPEN READ WRITE Which two statements are true about the outcome after running the script?（）
A:The seed will be in mount state.
B:The seed will be opened read-only.
C:The seed will be opened read/write.
D:The other PDBs will be in mount state.
E:The other PDBs will be opened read-only.
F:The PDBs will be opened read/write.
View the Exhibit that sets the threshold for the Current Open Cursors Count metric.Why is the Significance Level threshold type not available in the threshold setting?（）
A:because AWR baseline is not enabled
B:because Current Open Cursors Count is not a basic metric
C:because the STATISTICS_LEVEL parameter is set to BASIC
D:because the AWR baseline is a system-defined moving window baseline
假设需要在数据库中创建角色test_role，可以使用如下（）语句。
A:ALTER DATABASE ROLE test_role
B:CREATE ROLE test_role
C:UPDATE ROLE test_role
D:ALTER ROLE test_role
Which two partitioned table maintenance operations support asynchronous Global Index Maintenance inOracle database 12c?（）
A:ALTER TABLE SPLIT PARTITION
B:ALTER TABLE MERGE PARTITION
C:ALTER TABLE TRUNCATE PARTITION
D:ALTER TABLE ADD PARTITION
E:ALTER TABLE DROP PARTITION
F:ALTER TABLE MOVE PARTITION
Which of these represent the main components of Database Resource Manager？（）
A: Resource consumer groups
B: Resource plans
C: Resource-plan groups
D: Resource-plan directives
E: All of the above
The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema.Which two statements are true regarding the outcome of this action?（）
A:All the related indexes and views are automatically dropped
B:The flashback drop feature can recover only the table structure
C:Only the related indexes are dropped whereas views are invalidated
D:The flashback drop feature can recover both the table structure and its data
Given that c is a reference to a valid java.io.Console object，which two code fragments read a line of textfrom the console？（）
A:String s = c.readLine（）；
B:char[] c = c.readLine（）；
C:String s = c.readConsole（）；
D:char[] c = c.readConsole（）；
E:String s = c.readLine（"%s"， "name "）；
You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning Set as a part of the workload capturing.  What information is captured as part of this process？（）
A: the SQL text
B: the execution plan
C: the execution context
D: the execution frequency
E: the system change number （SCN）
To enable faster incremental backups， you enabled block change tracking for the database. Which two statements are true about the block change tracking file？（） 
A: Multiple change tracking files can be created for a database.
B: The change tracking file must be created after the first level 0 backup.
C: RMAN does not support backup and recovery of the change tracking file.
D: The database clears the change tracking file and starts tracking changes again，after whole database restore and recovery operations.
You have lost all your RMAN backup set pieces due to a disk failure. Unfortunately， you have an automated cross-check script that also does a delete expired backupset command. You have restored all the backup set pieces from tape.  What command would you use to get those backup set pieces registered in the recovery catalog and the control file of the database again？（）  
A: register database
B: recover catalog
C: load backupset
D: synch metadata
E: catalog start with
Click the Exhibit button to examine the structures of the EMPLOYEES and TAX tables. You need to find the percentage tax applicable for each employee. Which SQL statement would you use?（）
A:SELECT employee_id, salary, tax_percent FROM employees e JOIN tax t ON e.salary BETWEEN t.min_salary AND t.max_salary;
B:SELECT employee_id, salary, tax_percent FROM employees e JOIN tax t WHERE e.salary > t.min_salary AND < t.max_salary;
C:SELECT employee_id, salary, tax_percent FROM employees e JOIN tax t ON (MIN(e.salary) = t.min_salary AND MAX(e.salary) = t.max_salary); 
D:You cannot find the information because there is no common column between the two tables.
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
The human resources department requested an employee report to high light those employees who are due for 30 days 6 months and 1 year evaluation. The higher_data field should display blue text for 30 days employee, a red text for 6 months employees and a green text for one year employees. You created a format trigger on the higher_data field to handle this task. What will happen if the format trigger returns a false value? （）
A:The report execution will be halted. 
B:The higher_data file will not be displayed. 
C:The record will not be displayed. 
D:Nothing will happen.
You are maintaining your database in Oracle10g. You are performing the backup by using the BACKUP AS BACKUPSET command at the RMAN prompt. Which file cannot be backed up by using the BACKUP AS BACKUPSET command？（）
A:Datafiles
B: Current control file
C: Server parameter file （spfile）
D: Password file
You need to create a form for Payroll application that will allow the user to view all information for any employee ID queried. This data should be displayed to the user in a grouped format. The user should be able to choose which information they want to see from a pull down list containing the values PERSONAL and PAYROLL. Which format should you use to create this form?（）
A:One content canvas and multiple stacked canvases. 
B:One content and one stacked canvas.
C:Tab canvas with several tab pages. 
D:One content canvas. 
E:A horizontal and vertical toolbar.
If a job references a schedule that has been disabled， what will be the result？（）  
A: The job will be automatically disabled.
B: The job will never execute.
C: The job will attempt to execute but will fail.
D: The job will inherit the DEFAULT_SCHEDULE schedule.
E: A schedule object cannot be disabled.
Which NLS parameter can be used to change the default Oracle sort method from binary to linguistic for the SQL SELECT statement？（）
A: NLS_LANG
B: NLS_COMP
C: NLS_SORT
D: None of the above
Given： What is the result？（）
A:An Exception is thrown with no other output
B:B, followed by an Exception.
C:Compilation fails due to an error on line 9.
D:Compilation fails due to an error on line 15.
In order to enable remote administration of users and tablespaces on an Oracle database, which of the following types of files must exist in the database?（）
A:Password file 
B:Initialization file 
C:Datafile 
D:Control file 
E:Nothing - SYSDBA privileges are not required for these actions
The HR user creates a view with this command：  SQL> CREATE VIEW emp_v AS SELECT * FROM scott.emp；  Now HR wants to grant the SELECT privilege on the EMP_V view to the JIM user.  Which statement is true in this scenario？（）
A:HR can grant the privilege to JIM but without GRANT OPTION.
B:HR can grant the privilege to JIM because HR is the owner of the view.
C:SCOTT has to grant the SELECT privilege on the EMP table to JIM before this operation.
D:HR needs the SELECT privilege on the EMP table with GRANT OPTION from SCOTT for this operation.
Click the Exhibit button. Given the fully-qualified class names: com.foo.bar.Dog com.foo.bar.blatz.Book com.bar.Car com.bar.blatz.Sun Which graph represents the correct directory structure for a JAR file from which those classes can be used by the compiler and JVM? （）
A:Jar A
B:Jar B
C:Jar C
D:Jar D
E:Jar E
As a result of performance analysis， you created an index on the prod_name column of the prod_det table， which contains about ten thousand rows. Later， you updated a product name in the table. How does this change affect the index？（）
A:A leaf will be marked as invalid.
B:An update in a leaf row takes place.
C:The index will be updated automatically at commit.
D:A leaf row in the index will be deleted and inserted.
E:The index becomes invalid when you make any updates.
Which two statements are true about Oracle ActiveCache ？（）
A: it supports very large data-sets such as the result-sets from large search queries to be held in memory
B: it provides a set of management tools that enables automation of configuration
C: it provides enhanced visibility across the entire application infrastructure
D: it significantly increases the performance of Web-based applications with no code change
Your x86-based server will not boot Solaris 10 OS. You discover that you need to restore your pboot and boot block on the / （root） slice located on disk c0d0. You first boot off of the CD-ROM or DVD into single user mode.  What commands should you run to restore the pboot and boot block on the slice？（）
A:A
B:B
C:C
D:D
You are working on a new Oracle Database 11g server， where only the software is installed and nodatabase is created. You plan to create a database on this server using the Database Configuration Assistant （DBCA）.  Some of the requirements set for your database creation task are：  1：Configure the database to operate in shared server mode.  2：Disable automatic maintenance tasks such as optimizer statistics collection.  3：Configure a naming method to help the remote user connect to the database instance.  4：Use Automatic Storage Management （ASM） for storing the database files.  5：Configure daily database backup to flash recovery area.  6：Configure Enterprise Manager Database Control to manage the database.  Which of these requirements can be met while creating the database（）
A:4 and 6
B:2，3，4，and 6
C:1，2，4，5，and 6
D:1，2，3，4，5，and 6
首页 <上一页 55 56 57 58 59 下一页> 尾页