In SQL the spaces at the end of the string are removed by                function.

Related MCQs

• Which SQL function is used to count the number of rows in a SQL query?
• In the PL/SQL block below, how many rows will be inserted in the messages table? DECLARE v_start_salesNUMBER := 2; v_end_sales NUMBER := 100; BEGIN FOR i IN v_start_sales..v_end_sales LOOP INSERT INTO messages(msgid) VALUES v_start_sales; END LOOP; END;
•                  dump, writes out SQL DDL statements and SQL insert statements to a file, which can then be reexecuted to re- create the database.
• View the Exhibit and examine the data in the EMPLOYEES tables. Evaluate the following SQL statement: SELECT employee_id, department_id FROM employees WHERE department_id= 50 ORDER BY department_id UNION SELECT employee_id, department_id FROM employees WHERE department_id= 90 UNION SELECT employee_id, department_id FROM employees WHERE department_id= 10; What would be the outcome of the above SQL statement?
• Which of the following is an aggregate function in SQL?
• Which character function can be used to return a specified portion of a character string?
• A command to remove a relation from an SQL database
• Which SQL Query is use to remove a table and all its data from the database?
• A command to remove a relation from an SQL database
• Which SQL Query is use to remove a table and all its data from the database?