Database Fundamentals Quiz

Question 1 Multiple Choice (Single Answer)

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

Always deploy the mapping before executing
Newly created/Modified Mappings need not be deployed before executing
Deployment needs depends on the mapping status
Execute the mapping and deploy it only when you need to export

Question 2 Multiple Choice (Single Answer)

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)

var2 NUMBER := 0;
INTO var2
WHERE name = 'JORDAN';
var1 :=var2 + 2000;
There are no errors in this PL/SQL block.

Question 3 Multiple Choice (Single Answer)

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?

8
4
2
3
5

Question 4 Multiple Choice (Single Answer)

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

TO_CHAR
LOWER
LPAD
MAX
CEIL

Question 5 Multiple Choice (Single Answer)

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

System tablespace
Users tablespace
Default tablespace for the user
Oracle will give an error
Undefined

Question 6 True/False

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

True
False

Question 7 Multiple Choice (Multiple Answers)

The different reporting systems used by Hartford line of business are

BRS
AHS
MRDP
VAS

Question 8 Multiple Choice (Single Answer)

Data Warehouse is a

Analysis System
transaction system
Repository system
none of the above

Question 9 Multiple Choice (Single Answer)

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

Atomic History
Building Block
Staging
Datamart

Question 10 Multiple Choice (Single Answer)

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

Select to_date(sysdate,’DD/MONTH/YY’) from dual;
Select to_date(sysdate,’DD/MM/YY’) from dual;
Select to_char(sysdate,’DD/MONTH/YY’) from dual;
Select to_char(sysdate,’DD/MM/YY’) from dual;

Question 11 True/False

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?

True
False

Question 12 Multiple Choice (Single Answer)

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:

This procedure will not compile successfully.
This procedure will print the Userid and fullname of users whose username starts with ‘D’;
This procedure will print just the fullname of the users.
This procedure will print just the userid of the users.

Question 13 Multiple Choice (Single Answer)

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:

This procedure will print the Userid and fullname of users whose username starts with ‘D’;
This procedure will not compile successfully.
This procedure will print just the fullname of the users.
This procedure will print just the userid of the users.

Question 14 Multiple Choice (Single Answer)

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 ;

a
b
Can't tell
both will perform the same

Question 15 True/False

Can u Change the Query items in a Namespace.

True
False

Question 16 True/False

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

True
False

Question 17 Multiple Choice (Single Answer)

SELECT count(*),status_id,status_name FROM kcrt_statuses WHERE STATUS_ID IN (SELECT STATUS_ID FROM kcrt_request_type_statuses) GROUP BY status_id; What will be the output?

Returns the count of rows grouped by statuses
Error - Incorrect use of COUNT. It has to have a column name.
Error - because of the GROUP BY Clause or Selected columns
Does not return the count, just displays the other two fields.

Question 18 True/False

Alias/Shortcuts in Framework manager use the Storage/Space in Database which we are using(oracle/DB2/server...)

True
False

Question 19 True/False

Can we Create CUBE using Framework Manager.

True
False

Question 20 Multiple Choice (Single Answer)

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’?

update KCRT_REQUEST_DETAILS reqd set reqd.visible_parameter41 = (select reqd1.visible_parameter31 from kcrt_request_details reqd1 where reqd1.batch_number= '2' and reqd1.request_id = reqd.request_id) where reqd.batch_number ='3' and reqd.request_id in (se
Update KCRT_REQUEST_DETAILS set visible_parameter41 = (select visible_parameter31 from KCRT_REQUEST_DETAILS where batch_number =2) where request_type_id = (select request_type_id from KCRT_REQUEST_TYPES where request_type_name = ‘AXA_RT_Application_Demand
Update KCRT_REQUEST_DETAILS set visible_parameter41 = (select visible_parameter31 from KCRT_REQUEST_DETAILS where batch_number =2) where batch_number = 3 and request_type_id = (select request_type_id from KCRT_REQUEST_TYPES where request_type_name = ‘AXA_
Update KCRT_REQUEST_DETAILS set visible_parameter41 = (select visible_parameter31 from KCRT_REQUEST_DETAILS where batch_number =2 and and request_type_id = (select request_type_id from KCRT_REQUEST_TYPES where request_type_name = ‘AXA_RT_Application_Deman

Database Fundamentals Quiz

Questions