Which of the folowing is true with regard to deployment manager.

You create the following PL/SQL block: DECLARE var1 CONSTANT NUMBER := 50; var2 NUMBER := 0; BEGIN SELECT acctno INTO var2 FROM bank_acct WHERE name = 'JORDAN'; var1 :=var2 + 2000; END; Which of the following lines in this block of PL/SQL code will produce an error? (Choose One)

To produce a meaningful result set without any cartesian products, what is the minimum number of conditions that should appear in the WHERE clause of a four-table join?

Which of the following SQL functions can operate on any datatype?

When a user creates an object without a TABLESPACE clause, where will Oracle store the segment?

The OR operator displays a record if ANY conditions listed are true. The AND operator displays a record if ALL of the conditions listed are true

Data Warehouse is a

This area contains tables that are scattered or merged to meet the requirement of end user

Command to retrieve today’s date in the format DD/month/YY ?

select visible_parameter1 from kcrt_table_entries where request_id = '64457' and parameter_set_field_id = ( select parameter_set_field_id from kcrt_request_details reqd , knta_parameter_set_fields psf where reqd.request_id = '64457' and psf.parameter_set_context_id = reqd.parameter_set_context_id and psf.parameter_token = 'AXA_RM_RTF_TCRELDEM') and seq = '1' If the subselect returns more than one row. This query will run fine?

create or replace procedure "test" as a_string varchar(1000 char) := NULL; b_string varchar(2000 char) := NULL; fullname VARCHAR(200 char); edate VARCHAR(200 char); SG VARCHAR(1000 char); cursor c_username is select userid, username from knta_users where username like 'D%'; Begin open c_username; for i in c_username loop a_string := ''; a_string := a_string || ' ' ||i.userid; select full_name into fullname from knta_users where username = i.username ; a_string := a_string || ' ' ||fullname; DBMS_OUTPUT.PUT_LINE( ' ' ||a_string ); END LOOP; close c_username; end "test"; Examine the procedure and choose what will happen when this procedure is executed:

create or replace procedure "test" as a_string varchar(1000 char) := NULL; b_string varchar(2000 char) := NULL; fullname VARCHAR(200 char); edate VARCHAR(200 char); SG VARCHAR(1000 char); cursor c_username is select userid, username from knta_users where username like 'D%'; Begin open c_username; for i in c_username loop a_string := ''; a_string := a_string || ' ' ||i.userid; select full_name into fullname from knta_users where username = i.username ; DBMS_OUTPUT.PUT_LINE( ' ' ||a_string ); END LOOP; close c_username; end "test"; Examine the procedure and choose what will happen when this procedure is executed:

Which query will have a better performance? a) SELECT count(), request_type_name FROM KCRT_REQUEST_TYPES WHERE request_type_id IN (SELECT request_type_id FROM kcrt_requests) GROUP BY request_type_name; OR b) SELECT count(), request_type_name FROM kcrt_requests kr,kcrt_request_types krt WHERE kr.request_type_id = krt.request_type_id GROUP BY request_type_name ;

Can u Change the Query items in a Namespace.

Can u use the Query items in Folder for reporting in report studio.

Can we Create CUBE using Framework Manager.

KCRT_REQUEST_DETAILS Request_type_id Request_id Batch_No Visible_parameter41 Visible_parameter31 --------------- ----------- --------- ------------------- ------------------- 1 31300 1 Online (null) 1 31300 2 Batch (null) 1 31300 3 Manually (null) 2 31301 1 2010-03-17 11:55:00 99 2 31301 2 2009-11-09 14:00:00 55 2 31301 3 2010-05-27 11:55:00 789 3 31302 1 TCS ACCM1 3 31302 2 INFOSYS BAPP1 3 31302 3 CTS IT1 KCRT_REQUEST_TYPES Request_Type_Id Request_Type_Name --------------- ----------------- 1 AXA_RT_Application_Demand 2 AXA_RT_Application_Definition 3 AXA_RT_Support_Release Choose the update statement to update visible_parameter41 (Batch_No 3) by visible_parameter31 (Batch_No 2) for all the request_id in table KCRT_REQUEST_DETAILS whose request_type_name is ‘AXA_RT_Application_Demand’?