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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!