Tag: databases

Questions Related to databases

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

  1. Atomic History

  2. Building Block

  3. Staging

  4. Datamart

Show answer
Correct Option: B

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

technology databases

  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;

Show answer
Correct Option: C

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?
technology databases

  1. True

  2. False

Show answer
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 ; 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:
technology databases

  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.

Show answer
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:
technology databases

  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.

Show answer
Correct Option: D

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 ;
technology databases

  1. a

  2. b

  3. Can't tell

  4. both will perform the same

Show answer
Correct Option: B

Can u Change the Query items in a Namespace.
technology databases

  1. True

  2. False

Show answer
Correct Option: B

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

  1. True

  2. False

Show answer
Correct Option: B

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?

technology databases

  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.

Show answer
Correct Option: C

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

technology databases

  1. True

  2. False

Show answer
Correct Option: B