Identify the situations in...

多项选择题X 纠错

Identify the situations in which you use the alert log file in your database to check the detail.（）

A.Running a query on a table returns "ORA-600： Internal Error."
B.Inserting a value in a table returns "ORA-01722： invalid number."
C.Creating a table returns "ORA-00955： name is already used by an existing object."
D.Inserting a value in a table returns "ORA-00001： unique constraint （SYS.PK_TECHP） violated."
E.Inserting a row in a table returns "ORA-00060： deadlock detected while waiting for resource."

参考答案：

进入题库练习

多项选择题

You set the following parameters in the parameter file and restarted the database：MEMORY_MAX_TARGET=0MEMORY_TARGET=500M
PGA_AGGREGATE_TARGET=90MSGA_TARGET=270M
Which two statements are true about these parameters after the database instance is restarted（）

A.The MEMORY_MAX_TARGET parameter is automatically set to 500 mb.
B.The pga_AGGREGATE_TARGET and sga_TARGET parameters are automatically set to zero.
C.The value of the MEMORY_MAX_TARGET parameter remains zero until it is changed manually.
D.The lower bounds of pga_AGGREGATE_TARGET and sga_TARGET parameters are set to 90 nb and270 mb， respectively

点击查看答案进入题库练习

多项选择题

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（）

A.The tablespace would require recovery to go back online.
B.A checkpoint is taken on all data files that are associated with the SALES tablespace.
C.The sessions that subsequently try to access the objects in the SALES tablespace receive an error
D.The new status of the SALES tablespace is recorded in the control file when the database instance isclosed

点击查看答案进入题库练习

多项选择题

Examine the following statement that is used to modify the primary key constraint on the SALES table：
SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE；
Which three statements aretrue regarding the above command（）

A.The constraint remains valid.
B.The index on the constraint is dropped.
C.It allows the loading of data into the table using SQL *Loader.
D.New data conforms to the constraint， but existing data is not checked.
E.It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.

点击查看答案进入题库练习

多项选择题

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 undo tablespace.
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

点击查看答案进入题库练习

多项选择题

The session of user SCOTT receives the following error after executing an UPDATE command on the EMPtable：
ERROR at line 1：
ORA-00060： deadlock detected while waiting for resource On investigation， you find that a session opened byuser JIM has a transaction that caused the deadlock.
Which two statements are true regarding the session ofSCOTT in this scenario（）

A.The session is terminated after receiving the error and JIM can continue with his transaction.
B.SCOTT should perform a COMMIT or ROLLBACK to allow JIM to continue with his transaction.
C.The session is rolled back after receiving the error and JIM can continue with his transaction.
D.SCOTT has to reexecute the last command in the transaction after he commits the transaction.

点击查看答案进入题库练习

单项选择题

The HR user creates a stand-alone procedure as follows and grants the EXECUTE privilege on the procedureto many database users：
CREATE OR REPLACE PROCEDURE create_dept （ v_deptno NUMBER， v_dname VARCHAR2， v_mgrNUMBER， v_loc NUMBER）BEGIN
INSERT INTO hr.departments VALUES （v_deptno， v_dname， v_mgr， v_loc）； END；
The users having permission to execute the procedure are able to insert records into the DEPARTMENTS tableeven though they do not have the INSERT privilege on the table. You want only those users who haveprivileges on the DEPARTMENTS table to be able to execute the procedure successfully.
What would yousuggest to the PL/SQL developers to achieve this（）

A.Create the procedure with definer’s right.
B.Create the procedure with invoker’s right.
C.Grant the EXECUTE privilege with GRANT OPTION on the procedure to selected users.
D.Create the procedure as part of a PL/SQL package and grant the EXECUTE privilege on the package toselected users

点击查看答案进入题库练习

多项选择题

User SCOTT wants to perform a bulk insert operation in the EMP_DEP table. SCOTT receives the followingerror after the INSERT statement is issued and few rows are inserted：INSERT INTO EMP_DEP （emp_id，name，salary，dep_name，mgr_id） *ERROR at line 1：
ORA-01653： unable to extend table SCOTT.EMP_DEP by 128 in tablespace USERS Identify two actions eitherof which will help you resolve this problem. （）

A.Grant the RESOURCE role to SCOTT.
B.Add data files to the USERS tablespace.
C.Grant the CREATE ANY TABLE privilege to SCOTT.
D.Increase the space for SCOTT on the USERS tablespace.
E.Increase the size of the data file associated with the USERS tablespace

点击查看答案进入题库练习

多项选择题

View the Exhibit and examine the output.
Which two statements are true regarding the LISTENER2 listener（）

A.The ORCL instance is registered dynamically with the listener.
B.The ORCL instance is registered statically in the listener.ora file.
C.The number of current client connections handled by the service handler is two.
D.The total number of client connections handled so far by the service handler is two

点击查看答案进入题库练习

单项选择题

View the Exhibit and examine the output of the query.
What do you infer from this（）

A.The SGA_TARGET is a static parameter.
B.The instance is started， but the database is not yet open.
C.The server parameter file （SPFILE） was used to start the instance.
D.The SGA_TARGET parameter does not have any effect on the database instance until theSGA_MAX_SIZE parameter is specified

点击查看答案进入题库练习

多项选择题

You are managing an Oracle Database 11g database. The database is open， and you plan to perform
Recovery Manager （RMAN） backups.
Which three statements are true about these backups（）

A.The backups would be consistent.
B.The backups would be inconsistent.
C.The backups would be possible only if the database is running in ARCHIVELOG mode.
D.The backups would be possible only if the database is running in NOARCHIVELOG mode.
E.The backups need to be restored and the database has to be recovered in case of a media failure

点击查看答案进入题库练习