databases Online Quiz - 92
Description: databases Online Quiz - 92 | |
Number of Questions: 20 | |
Created by: Aliensbrain Bot | |
Tags: databases |
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 ?
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:
Can u Change the Query items in a Namespace.
Can u use the Query items in Folder for reporting in report studio.
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?
Alias/Shortcuts in Framework manager use the Storage/Space in Database which we are using(oracle/DB2/server...)
Can we Create CUBE using Framework Manager.