Oracle认证 - 自考题库

出自:Oracle认证

Evaluate the following function code： CREATE FUNCTION get_dept_avg（dept_id NUMBER） RETURN NUMBER RESULT_CACHE RELIES_ON （EMPLOYEES） IS avgsal NUMBER（6）； BEGIN SELECT AVG（SALARY）INTO avgsal FROM EMPLOYEES WHERE DEPARTMENT_ID = dept_id； RETURN avgsal； END get_dept_avg； Which statement is true regarding the above function？（）
A: The cached result becomes invalid when any structural change is done to the EMPLOYEES table.
B: If the function execution results in an unhandled exception，the exception result is also stored in the cache.
C: Each time the function is invoked in a different session，the current result in the result cache gets overwritten.
D: If the function is invoked with a different parameter value，the existing result in the result cache gets overwritten by the latest value.

唯一性约束和非空约束的作用是什么？

Examine the structures of the EMPLOYEES and TAX tables. EMPLOYEES EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2 (30) JOB_ID VARCHAR2 (20) SALARY NUMBER References MGR_ID NUMBER EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT _ID column of the DEPARTMENT table TAX MIN_SALARY NUMBER MAX_SALARY NUMBER TAX_PERCENT NUMBER Percentage tax for given salary range 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, tax t WHERE e.salary BETWEEN t.min _ salary AND t.max_salary
B:SELECT employee_id, salary, tax_percent FROM employees e, tax t WHERE e.salary > t.min_salary, tax_percent
C:SELECT employee_id, salary, tax_percent FROM employees e, tax t WHERE 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.

36 You are creating a report wizard to create a matrix report. The query build, you select the patient_name column from the patient table; the doctor_name from the doctors table; and the doctor_ID, patient_ID and ID columns from the procedure table. In the report wizard you select patient_name as the row value, doctor_ID as the column values and the count as the cell values. You need to add a total for each doctors column. In the wizard report which tab will allow you to create the summary column?（）
A:Rows
B:Totals
C:Columns
D:Cells
E:Data

Which two statements are true about mouse button variables?（）
A:SYSTEM.MOUSE_BUTTON_PRESSED returns a string.
B:SYSTEM.MOUSE_BUTTON_PRESSED returns a numeric value. 1Z0-132 World Leaders In Certifications Material - Test-king.com
C:A possible value for SYSTEM.MOUSE_BUTTON_MODIFIERS is Control+Alt+Delete.
D:SYSTEM.MOUSE_BUTTON_MODIFIERS can only be references in form-level triggers.
E:SYSTEM.MOUSE_BUTTON_MODIFIERS identifies which special key was pressed in conjunction with the usual mouse button action.

You were recently hired by an organization as a database administrator. You are asked to find out whether the currently functional listener process， named L1， has been password protected or not. You are not familiar with the file system of the new organization. How would you accomplish the task？（）
A:by using the STATUS command of the Listener control utility
B:by using the STATUS L1 command of the Listener control utility
C:by using the SHOW RULES command of the Listener control utility
D:by using the SET PASSWORD command of the Listener control utility
E:by searching for the PASSWORD_LISTENER entry in the listener.ora file

Which of the following are not fundamental tasks of the Support Workbench？（）
A: View long-running SQL workloads
B: View problem details
C: Gather additional diagnostic information
D: Create a Service Request
E: Clean up incident data after upload to Oracle Support

Which task would you perform before you run Oracle Universal Installer （OUI） in silent or suppressed mode foran installation？（）
A:Run the root.sh script.
B:Create the oraInst.loc file.
C:Create the tnsnames.ora file.
D:Run the oraInstRoot.sh script.

You used the following command in Recovery Manager （RMAN） as part of the recovery process： RESTORE CONTROLFILE FROM AUTOBACKUP； How does RMAN find the control file autobackup？（）
A: By using the trace file.
B: By using the alert log file.
C: By using the database ID
D: By using the server parameter file.
E: By using the V$CONTROLFILE view.
F: By using the autobackup format configuration setting.

You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online. Which statement about performing user-managed backups in a 24x7 environment is true？（）
A: You must have change tracking enabled in your database
B: Your database must be running in NOARCHIVELOG mode
C: To back up a tablespace，it must be in backup mode
D: To back up a tablespace，it must first be taken offline

You created a tabular report for the sales department to display each customer and the sales person assign to the customer. The data is sorted by customer using the order by clause in this query. This is department manager asks you to alter the report so that data is sorted by sales person rather than by customer. What is the best way to make the needed change?（）
A:Recreate the query and default the layout.
B:Alter the query, default the layout and redo the boiler plates.
C:Query and manually change the layout to save the boiler plate.
D:Alter the query and make no further change.

You want to set the following initialization parameters for your database instance: LOG_ARCHIVE_DEST_1 = 'LOCATION=/disk1/arch' LOG_ARCHIVE_DEST_2 = 'LOCATION=/disk2/arch' LOG_ARCHIVE_DEST_3 = 'LOACTION=/disk3/arch' LOG_ARCHIVE_DEST_4 = 'LOCATION=/disk4/arch MANDATORY' Identify the statement that correctly describes this setting.（）
A:The MANDATORY location must be a flash recovery area.
B:The optional destinations may not use the flash recovery area.
C:This setting is not allowed because the first destination is not set as MANDATORY.
D:The online redo log file is not allowed to be overwritten if the archived log cannot be created in the fourth destination.

Click the Exhibit button. What is the result？（）

A: The code will deadlock.
B: The code may run with output "2 0 6 4".
C: The code may run with no output.
D: The code may run with output "0 6".
E: An exception is thrown at runtime.
F: The code may run with output "0 2 4 6".

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 ( employee_id NUMBER, name VARCHAR2(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 set 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.

Automatic Shared Memory Management is disabled for your database instance. You realize that there arecases of SQL statements performing poorly because of repeated parsing activity， resulting in degradation ofperformance. What would be your next step to improve performance（）
A:Run the SQL Access Advisor
B:Run the Memory Advisor for the sga.
C:Run the Memory Advisor for the pga.
D:Run the Memory Advisor for the shared pool.
E:Run the Memory Advisor for the buffer cache

ABC Corp. has many service requests and tasks that have not met customer requirements. Using CRM Application Foundation module, identify the component that helps ABC Corp. designate resources who will own and work on the task.（）
A:Task Manager
B:Resource Manager
C:Escalation Manager
D:Assignment Manager

In order to exploit some new storage tiers that have been provisioned by a storage administrator, the partitions of a large heap table must be moved to other tablespaces in your Oracle 12c database? Both local and global partitioned B-tree Indexes are defined on the table. A high volume of transactions access the table during the day and a medium volume of transactions access it at night and during weekends. Minimal disrupt ion to availability is required. Which three statements are true about this requirement?（）
A:The partitions can be moved online to new tablespaces.
B:Global indexes must be rebuilt manually after moving the partitions.
C:The partitions can be compressed in the same tablespaces.
D:The partitions can be compressed in the new tablespaces.
E:Local indexes must be rebuilt manually after moving the partitions.

In which two conditions are resumable statements suspended？（）
A: when a user exceeds the space quota
B: when a user session is terminated
C: when a table that is being accessed by the current transaction is not found
D: when a user manually suspends the statement
E: when the maximum extents of a segment is reached

You have a large amount of historical data in an operating system file. Some analysts in your organization need to query this data. The file is too large to load into your current database. Which is the most effective method to accomplish the task？（）
A:Upgrade the hardware/memory to accommodate the data.
B:Load the data into your database by using the PARALLEL clause.
C:Give analysts DBA privilege， so that they can query DBA_EXTERNAL_TABLES.
D:Use an external table so you can have the metadata available in your database， but leave the data in the operating system files.

You find today’s performance of your production database to be the best ever. Therefore， you want to be notified in the future whenever the performance degrades by 10% of today’s performance. What is the first step that you would take to ensure this？（）
A:create baseline metrics for today’s performance
B:write the current database metrics to a database table and create a trigger to compare with future database statistics
C:write the current database metrics to a flat file and create an operating script to compare with future database statistics
D:write the current database metrics to a database table and create a procedure to compare with future database statistics
E:write the current database metrics to a database table and submit a job using DBMS_JOB to compare with future database statistics

Which naming method uses the tnsnames.ora file to store the connect descriptor used by the client whileconnecting to the database instance from a remote machine（）
A:Host naming method
B:Local naming method
C:External naming method
D:Directory naming method

You are developing a report to allow customers in a department store to view product information. You added a button to the layout to allow customers to view the picture of the product. Which button property would you alter to specify the source of the .BMP file?（）
A:Type
B:Multimedia file
C:Multi media file type
D:Label type

You create a data block based on a relational table containing a REF column. You select the REF column for your form module. What is true about the items based on the REF column attributes?（）
A:The Query Only property is set to Yes.
B:The Conceal Data property is set to Yes.
C:The Insert Allowed property is set to Yes.
D:The Update Allowed property is set to Yes.

You need to create a partitioned table to store historical data and you issued the following command： CREATE TABLE purchase_interval PARTITION BY RANGE （time_id） INTERVAL （NUMTOYMINTERVAL（1，’month’）） STORE IN （tbs1，tbs2，tbs3）（ PARTITION p1 VALUES LESS THAN（TO_DATE（’1-1-2005’， ’dd-mm-yyyy’））， PARTITION p2 VALUES LESS THAN（TO_DATE（’1-1- 2007’， ’dd-mm-yyyy’））） AS SELECT * FROM purchases WHERE time_id < TO_DATE（’1-1-2007’，’dd-mm-yyyy’）； What is the outcome of the above command？（）
A: It returns an error because the range partitions P1 and P2 should be of the same range.
B: It creates two range partitions （P1， P2）. Within each range partition， it creates monthwise subpartitions.
C: It creates two range partitions of varying range. For data beyond ’1-1-2007，’ it creates partitions with a width of one month each.
D: It returns an error because the number of tablespaces （TBS1，TBS2，TBS3）specified does not match the number of range partitions （P1，P2） specified.

Which three operations can be performed as multipartition operations in Oracle?（）
A:Merge partitions of a list partitioned table
B:Drop partitions of a list partitioned table
C:Coalesce partitions of a hash-partitioned global index.
D:Move partitions of a range-partitioned table
E:Rename partitions of a range partitioned table
F:Merge partitions of a reference partitioned index

The user SYS creates a job by using the following command:

Which two statements are true about the job that was created by the preceding command? （）(Choose two.)
A:The job is enabled by default after creation
B:The job is automatically dropped after the end date
C:The job executes with the privileges of the user SYS
D:The globalization environment that exists at the time of the job creation prevails at the job runs

You executed the following command in Recovery Manager （RMAN）： RMAN> RESTORE CONTROLFILE； Which operation must you perform before this command is executed？（）
A:back up the control file to trace
B:bring database to the MOUNT state
C:open a connection to the RMAN recovery catalog， which contains the RMAN metadata for the target database
D:set the database ID （DBID）， but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog

Your application demands frequent connection and disconnection from the database. You have three listener processes that are listening for the database PROD. While setting up the connect string using Oracle Enterprise Manager 10g Database Control， which two options would you select to balance the connection load across all the listener processes？（）
A:Use only the first address.
B:Try one address，selected at random.
C:Try each address，in order，until one succeeds.
D:Try each address，randomly，until one succeeds.

You plan to control idle sessions that are blocking other sessions from performing transactions. Your requirement is to automatically terminate these blocking sessions when they remain idle for a specified amount of time. How would you accomplish this task?（）
A:Set metric threshold
B:Implement Database Resource Manager
C:Enable resumable timeout for user sessions
D:Add directives to Automatic Database Diagnostic Monitor (ADDM)

To accomplish user-managed backup for the USERS tablespace， you issued the following command to put the database in backup mode： SQL> ALTER TABLESPACE users BEGIN BACKUP； While copying the file to the backup destination a power outage caused the instance to te minate abnormally. Which statement is true about the next database startup and the USERS tablespace？（）
A: The database will open，and the tablespace automatically comes out of the backup mode.
B: The database will be mounted，and recovery must be performed on the USERS tablespace.
C: The database will be mounted，and data files in the USERS tablespace must be taken out of the backup mode.
D: The database will not be mounted，and you must restore all the data files for the USERS tablespace from the backup，and perform recovery.

首页 <上一页 135 136 137 138 139 下一页> 尾页