EVISWANG的博客

You have set Tablespace Full Metrics Threshold values for the USERS tablespace as follows:  Warning (%): 90  Critical (%): 95  Which background process is responsible for issuing alerts when the th

46: Which two statements are true about setting the FAST_START_MTTR_TARGET initialization parameter to a nonzero value? (Choose two.) 选项 A.The MTTR advisor will be disabled. B.Automatic checkpoint

50:Which two statements are true about alerts? (Choose two.) 选项 A.Clearing an alert sends the alert to the alert history. B.Response actions cannot be specified with server-generated alerts. C.The

The HR user creates a stand-alone procedure as follows and grants the EXECUTE privilege on the procedure to many database users: CREATE OR REPLACE PROCEDURE create_dept( v_deptno NUMBER, v_dname VARCH

Identify two situations in which the blockheader grows in a data block. (Choose two.) 选项 A.when row directories need more row entries B.when there is rowmigration in the data block C.when there is

63: Some non-DBAusers in your database have been granted ANY TABLE system privileges and they are able toaccess data dictionary base tables. You decide to restrict their access to data dictionaryobj

The session of user SCOTT receives the following error after executing an UPDATE command on the EMP table: ERROR at line 1: ORA-00060: deadlock detected while waiting for resource On investigation, yo

Your database instance is running with full workload after database creation. You have decided to use a fixed-size undo tablespace. You want to use the Undo Advisor to estimate the capacity of the u

Which three statements are correct about temporary tables? (Choose three.) A. Indexes and views can be created on temporary tables B. Both the data and structure of temporary tables can be exported

You execute the following command to change the status of the SALES tablespace: SQL> ALTER TABLESPACE sales OFFLINE; Which statements describe the effect of the command? (Choose all that apply.) A. T

You want toconfigure and schedule offline database backups to run automatically. Whichtool or utility wouldyou use to achieve this? A.the XML script B.the PL/SQL script C.the DBMS_SCHEDULER packag

You are working on a database that must be functioning 24 hours a day, 7 days a week. The database is configured in ARCHIVELOG mode. Which two options do you have for performing user-managed backups

Which statement istrue about loading data using the conventional path of SQL*Loader? A.Redo is notgenerated while performing conventional path loads. B.Only PRIMARY KEY,UNIQUE KEY, and NOT NULL cons

User SCOTT executes the following command on the EMP table but has not issued COMMIT, ROLLBACK, or any data definition language (DDL) command: SQL> SELECT ename FROM emp 2 WHERE job='CLERK' FOR UPD

QUESTION 56 Automatic Shared Memory Management is disabled for your database instance. You realize that there are cases of SQL statements performing poorly because of repeated parsing activity, result