You are shrinking the SCOTT.EMP table by executing the ALTER TABLE SCOTT.EMP SHRINK SPACE CASCADE statement. What is a prerequisite for shrinking the SCOTT.EMP table?()
You accepted the recommended SQL Profile by executing the following code: DECLARE sqlprofile_name varchar2(30); BEGIN sqlprofile_name := DBMS_SQLTUNE.ACCEPT_SQL_PROFILE( task_name => ’my_task’, profile_name => ’my_profile’); END; Which advisor will analyze this profile?()
You have just completed an OSPF implementation. While executing your verification plan, you determine that R1 is not able to establish full OSPF adjacency with R2. The show ip ospf neighbor comman d output on R1 shows that R2 is stuck in the INIT state. What could be the cause of this problem?()
When executing a SQL workload, you choose to generate execution plans only, without collecting execution statistics. Which two statements describe the implications of this?()
While executing a Cluster Test Plan, the administrators realize that they will need to email the Operations and network on-call staff in the event of a network outage. What can be done to alert the on-call staff of network failures?()
When executing the massload command to load catalog data into a WebSphere Commerce database on a remote DB2 server,which of the following can be used as valid values for the -method command line parameter?()
Given classes defined in two different files: What is the result of executing XMLMessage.main?()
When executing a SQL workload,you choose to generate execution plans only, without collecting execution statistics. Which two statements describe the implications of this?()