0

databases Online Quiz - 92

Description: databases Online Quiz - 92
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. Always deploy the mapping before executing

  2. Newly created/Modified Mappings need not be deployed before executing

  3. Deployment needs depends on the mapping status

  4. Execute the mapping and deploy it only when you need to export


Correct Option: C

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

  1. TO_CHAR

  2. LOWER

  3. LPAD

  4. MAX

  5. CEIL


Correct Option: C
  1. System tablespace

  2. Users tablespace

  3. Default tablespace for the user

  4. Oracle will give an error

  5. Undefined


Correct Option: C
  1. Analysis System

  2. transaction system

  3. Repository system

  4. none of the above


Correct Option: A

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

  1. Atomic History

  2. Building Block

  3. Staging

  4. Datamart


Correct Option: B
  1. Select to_date(sysdate,’DD/MONTH/YY’) from dual;

  2. Select to_date(sysdate,’DD/MM/YY’) from dual;

  3. Select to_char(sysdate,’DD/MONTH/YY’) from dual;

  4. Select to_char(sysdate,’DD/MM/YY’) from dual;


Correct Option: C

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:

  1. This procedure will not compile successfully.

  2. This procedure will print the Userid and fullname of users whose username starts with ‘D’;

  3. This procedure will print just the fullname of the users.

  4. This procedure will print just the userid of the users.


Correct Option: B

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:

  1. This procedure will print the Userid and fullname of users whose username starts with ‘D’;

  2. This procedure will not compile successfully.

  3. This procedure will print just the fullname of the users.

  4. This procedure will print just the userid of the users.


Correct Option: D

Can u Change the Query items in a Namespace.

  1. True

  2. False


Correct Option: B

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

  1. True

  2. False


Correct Option: B
  1. Returns the count of rows grouped by statuses

  2. Error - Incorrect use of COUNT. It has to have a column name.

  3. Error - because of the GROUP BY Clause or Selected columns

  4. Does not return the count, just displays the other two fields.


Correct Option: C
  1. 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

  2. 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

  3. 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_

  4. 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


Correct Option: A
- Hide questions