Question: Identify the function used to round numbers to a specified number of decimal places. a. MODO O b. LENGTHO O c. TRUNCO O d. ROUNDO





Identify the function used to round numbers to a specified number of decimal places. a. MODO O b. LENGTHO O c. TRUNCO O d. ROUNDO Choose the correct output for the given SQL Query. Select TRUNC (56.123,0) FROM DUAL; a. 60 b. 55 O c. 45 O d. 56 Identify the statement used to remove privileges granted to a user. O a. ROLE O b. PUBLIC O c. REVOKE O d. GRANT Identify the operator that compares a value in main query to every value returned by subquery. O a. ANY O b. IN O C. = O d. ALL Which one of the following renames a column heading in the output? O a. Modify O b. Synonym O c. Rename O d. Alias Choose the correct output for the given SQL Query Select ADD_MONTHS (date "2021-01-01', 3FROM DUAL; O a. 01-10-2020 O b. 03-03-2021 O c. 01-03-2021 O d. 30-01-2021 Which SQL statement will destroy the table? O a. DROP statement O b. TRUNCATE statement O C. DELETE statement O d. ALTER statement Identify the type of join where the table is joined with itself. O a. NATURAL Join O b. INNER Join O C. CROSS Join O d. SELF Join What happens during the execution of given SQL statement? GRANT SELECT TO MANAGER O a. Select privilege is granted to role Manager b. grants role to manager O c. Allows manager to grant select privilege to other users O d. Grants object privilege to all users Which one of the following is called as "Membership condition"? a. Like O b. || c. Between ...And O d.IN
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
