出自:Oracle认证

In your production database， you observe that users’ transactions are consuming a lot of resources and you plan to impose resource restrictions by using Resource Manager. For which three resources can you enable usage restrictions by using Resource Manager？ （）
A:CPU usage
B:degree of parallelism
C:number of open cursors
D:number of sorts performed
E:idle time for blocking sessions
F:number of disk I/O operations performed
G:number of memory I/O operations performed
Given a correctly compiled class whose source code is： Assume that the class file is located in /foo/com/sun/sjcp/， the current directory is /foo/， and that theclasspath contains "." （current directory）. Which command line correctly runs Commander？（）
A:java Commander
B:java com.sun.sjcp.Commander
C:java com/sun/sjcp/Commander
D:java -cp com.sun.sjcp Commander
E:java -cp com/sun/sjcp Commander
What is true about joining tables through an equijoin?（）
A:You can join a maximum of two tables through an equijoin.
B:You can join a maximum of two columns through an equijoin.
C:You specify an equijoin condition in the SELECT or FROM clauses of a SELECT statement.
D:To join two tables through an equijoin, the columns in the join condition must be primary key and foreign key columns.
E:You can join n tables (all having single column primary keys) in a SQL statement by specifying a minimum of n-1 join conditions.
Which two client requests are captured during database replay Capture?（）
A:Flashback queries
B:Shared server requests
C:Login and logoff activities of sessions
D:Direct path load of data from external files by using utilities such as SQL *loader
E:Data definition language (DDL) and data manipulation language (DML) operations
You created a report from the human resources department based on all the columns in the EMP table. After viewing the report users requested that the cmp_ID columns peers first in the output. How would you change the position of the column?（）
A:After the query. 
B:Enter the report and change the column's position in the field tab. 
C:Alter the column's position in the object navigator. 
D:Enter the report wizard and change the column's position in the data tab. 
E:Alter the column's position within its group and change the layout. 
下面的时间函数，（）用于返回当前Oracle会话时区中的日期信息。
A:DATE（）
B:current_timestamp（）
C:current_date（）
D:DBTIMEZONE
Which of the following statements is true regarding implementing a Flashback Table recovery？  （）
A: An SCN is never used to perform a Flashback Table recovery.
B: If a significant number of changes have been made to the table， row movement must be enabled.
C: The tablespace must be offline before performing a Flashback Table recovery.
D: Flashback Table recovery is completely dependent on the availability of undo data in the undo  tablespace.
You are designing an application for a telecom company and you have been asked to design a database table to facilitate monthly bill generation. The bill would include details of customer calls， listed in chronological order.  Which method would you follow to achieve this objective without increasing the overhead of sorting the rows？（）
A:create a hash cluster to store the data
B:create an index cluster to store the data
C:create a partitioned table to store the data
D:create a sorted hash cluster to store the data
E:create a heap table with rowid to store the data
Examine the data in the EMPLOYEES and DEPARTMENTS tables: Also examine the SQL statements that create the EMPLOYEES and DEPARTMENTS tables: On the EMPLOYEES table, EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID. DEPT_ID is foreign key to DEPARTMENT_ID column of the DEPARTMENTS table. On the DEPARTMENTS table, DEPARTMENT_ID is the primary key. Examine this DELETE statement: What happens when you execute the DELETE statement?（）
A:Only the row with department ID 40 is deleted in the DEPARTMENTS table.
B:The statement fails because there are child records in the EMPLOYEES table with department ID 40.
C:The row with department ID 40 is deleted in the DEPARTMENTS table. Also the rows with employee IDs 110 and 106 are deleted from the EMPLOYEES table.
D:The row with department ID 40 is deleted in the DEPARTMENTS table. Also the rows with employee IDs 106 and 110 and the employees working under employee 110 are deleted from the EMPLOYEES table.
E:The row with department ID 40 is deleted in the DEPARTMENTS table. Also all the rows in the EMPLOYEES table are deleted.
F:The statement fails because there are no columns specifies in the DELETE clause of the DELETE statement.
You lost the index tablespace in your database. You are not able to use tablespace point-in-time recovery on the index tablespace. What could be the reason for this？（）
A: The index tablespace contains bitmap indexes.
B: The index tablespace contains more than one data file.
C: The index tablespace supports only complete recovery.
D: The index tablespace is not a dictionary-managed tablespace.
E: There is a dependency relationship between a table and its indexes.
Which two statements regarding the LOGGING clause of the CREATE TABLESPACE. .. statement are correct？（）
A:This clause is not valid for a temporary or undo tablespace.
B:If the tablespace is in the NOLOGGING mode， no operation on the tablespace will generate redo.
C:The tablespace will be in the NOLOGGING mode by default， if not specified while creating a tablespace.
D:The tablespace­level logging attribute can be overridden by logging specifications at the table， index， materialized view， materialized view log， and partition levels.
Your database is open and the LISTENER listener is running. The new DBA of the system stops thelistener by using the command：  LSNRCTL> STOP  What happens to the sessions that are presently connected to the database instance（）
A:The sessions are able to perform only queries.
B:The sessions are not affected and continue to function normally.
C:The sessions are terminated and the active transactions are rolled back.
D:The sessions are not allowed to perform any operations till the listener is started.
You executed the following command to back up your control file：  ALTER DATABASE BACKUP CONTROLFILE TO TRACE；  Which initialization parameter is used to specify the location of the trace file？（）
A:USER_DUMP_DEST
B:CORE_DUMP_DEST
C:TRACE_DUMP_DEST
D:BACKUP_DUMP_DEST
E:BACKGROUND_DUMP_DEST
On your Oracle 12c database, you Issue the following commands to create indexes SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customers_id, sales_rep_id) INVISIBLE; SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customers_id, sales_rep_id); Which two statement are correct?（）
A:Both the indexes are created; however, only the ORD_COSTOMER index is visible.
B:The optimizer evaluates index access from both the Indexes before deciding on which index to use for query execution plan.
C:Only the ORD_CUSTOMER_IX1 index is created.
D:Only the ORD_CUSTOMER_IX2 index is created.
E:Both the indexes are updated when a new row is inserted, updated, or deleted In the orders table.
The IT department requested a report to list each server name and the name of each department that utilizes resources from each server. You create a tabular layout that breaks on the server name. You ran the report and noticed that the department field is too large for most of the department names. Which field size setting would you use to allow the field to be smaller but not larger than the field layout size?（）
A:Fixed 
B:Expand 
C:Contract 
D:Variable
在Oracle中，通过命令（）可以释放锁。
A:INSERT
B:DELETE
C:ROLLBACK
D:UNLOCK
Given: What is the result?（）
A:Compilation fails.
B:An exception is thrown at runtime.
C:The code executes normally and prints "foo".
D:The code executes normally, but nothing is printed.
In the COURSE_ENROLLMENT form module, you define a master-detail relation between the COURSES_OFFERED data block and the STUDENT data block, respectively. To implement block coordination, which statement must be true?（）
A: The Enforce Primary Key property on the STUDENT block is set to Yes. 
B: The Alias property on the COURSES_OFFERED block is set to Student. 
C: The Copy Value from item property on the foreign key item in the STUDENT blocks is set to the primary key item of the COURSES_OFFERED block. 
D: The Synchronize with item property on the foreign key item in the STUDENT block is set to the primary key item of the COURSES_OFFERED block.
You have used the CROSSCHECK BACKUP command to verify that the backups recorded in the RMAN repository actually exist.  Which command should you now use to check if any of the files were missing？（）
A:LIST EXPIRED
B:DELETE EXPIRED
C:DELETE OBSOLETE
D:CHANGE UNCATALOG
What two are the prerequisites for enabling Flashback Database？（） 
A: The database must be in ARCHIVELOG mode
B: The database must be in MOUNT EXCLUSIVE mode
C: The database must be opened in RESTRICTED mode
D: The database instance must be started in the NOMOUNT state
E: The database instance must have the keep buffer pool defined
You are analyzing the components of the redo log mechanisms in your Oracle database. Which of the following purposes does the CKPT process serve?（）
A:Writes buffers to disk 
B:Writes current redo log number to datafile headers 
C:Writes redo log information to disk 
D:Reads information into memory for users
You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty. Which statement accomplishes this task?（）
A:ALTER TABLE students ADD PRIMARY KEY student_id;
B:ALTER TABLE students ADD CONSTRAINT PRIMARY KEY (student_id);
C:ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY student_id;
D:ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY (student_id);
E:ALTER TABLE students MODIFY CONSTRAINT stud_id_pk PRIMARY KEY (student_id);
ou executed the command to create a password file in the database server： $ orapwd file=orapworcl entries=5 ignorecase=N  Which statement describes the purpose of the above password file（）
A:It records usernames and passwords of users when granted the DBA role.
B:It contains usernames and passwords of users for whom auditing is enabled.
C:It is used by Oracle to authenticate users for remote database administration.
D:It records usernames and passwords of all users when they are added to OSDBA or OSOPER operating system groups.
What recommendations does the SQL Access Advisor provide for optimizing SQL queries? （）(Choose all that apply.)
A:selection of SQL plan baselines
B:partitioning of tables and indexes
C:creation of index-organized tables
D:creation of bitmap, function-based, and B-tree indexes
E:optimization of materialized views for maximum query usage and fast refresh
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE Which INSERT statement is valid?（）
A:INSERT INTO employees (employee_id, first_name, last_name, hire_date) VALUES (1000, 'John', 'smith','01/01/01);
B:INSERT INTO employees(employee_id, first_name, last_name, hire_date) VALUES (1000, 'John', 'smith','01 january 01');
C:INSERT INTO employees(employee_id, first_name, last_name, Hire_date) VALUES (1000, 'John', 'smith', To_ date ('01/01/01));
D:INSERT INTO employees(employee_id, first_name, last_name, hire_date) VALUES (1000, 'John', 'smith','01-Jan-01');
Which of the following options would you choose to implement controlled access using remote authentication for your networks？（）
A:OiD
B:RADIUS
C:Wallet Manager
D:Oracle Names Server
You have a production instance running on your server. UNDO_RETENTION is not long enough to satisfy read-consistency requirements. How do you change the UNDO_RETENTION value？（）
A:A
B:B
C:C
D:D
对于系统表的空间，Oracle建议的大小是（）。
A:100M
B:200M
C:300M
D:400M
E:500M
Which three possible values can be set for the TIME_ZONE session parameter by using the ALTER SESSION command？ （）
A: os
B: local
C: -8：00
D: dbtimezone Li
E: Australia
You are maintaining your OLTP database in Oracle10g. You have not set the warning level and critical level threshold values for space usage of the DATA1 tablespace. What will be the impact？（）
A: No warning level or critical level alert will be generated.
B: A warning level alert will never be generated， but a critical level alert will be generated when 97 percent space of the DATA1 tablespace is used.
C: A critical level alert will never be generated， but a warning level alert will be generated when 85 percent space of the DATA1 tablespace is used.
D: A warning level alert will be generated at 85 percent space usage of the DATA1 tablespace， and a critical level alert is generated at 97 percent space usage of the DATA1 tablespace.
首页 <上一页 1 2 3 4 5 下一页> 尾页