SELECT TO_CHAR (hire_date,’fmDdspth “of” MONTH,YYYY’) FROM employees

105. What will be result following SQLstatement ?selectinitcap(‘Hllo’,world),4,3)from dual Low

106.The___ operator compares a value to each value to returned by a subquery (ANY)

107.Which symbol do you use if you need to choose all the columns from the table to the result query? *

108.Which keyword is used to eliminate duplicate rows in the result?DISTINCT

109.Which of the following clauses is used to limit the rows that are retrieved by the query? WHERE ?

110.FULL OUTER JOIN is used when

A join between two tables that returns the results of an inner join as well as the results of a left and right join is a full outer join.

111.Subqueries have the following characteristics:
I. Can pass one row of data to a main statement that contains a single-row operator, such as =, <>, >, >=, <, or <=
II. Can pass multiple rows of data to a main statement that contains a multiple-row operator, such as IN
III. Are processed first by the Oracle server, after which the WHERE or HAVING clause uses the results I II and III

112.Queries containing set operators are called______________.compound queries.

113.The ____operator returns all rows that are selected by either query eliminating duplicates.UNION

114.Which of the following commands is a part of the Data Manipulation Language?

Add new rows to a table INSERT

Modify existing rows in a table UPDATE

Remove existing rows from a table DELETE

115.Consider the EMPLOYEES table. Which of the following SQL statements is correct to display the last name of the employee with its hire date providing the Employee and Hire Date aliases (case is important)?