1) Which of the following is not a valid constraint in Oracle?

2) In inner join, the keyword inner is ----

3) What is the output of the below statement? Select initcap(‘ORACLE SQL’) from dual;

4) Which of the following statement is true?

5) Which operator eliminates duplicate records?

6) Which of the following are DCL command?

7) Select ceil(487.45) from dual

8) How can you return all the records from a table named "Customer" sorted descending by "FirstName"?

9) How can you insert a new record into the "Customer" table?

10) In SQL, Attribute is a

11) Substr(56789.1234,4,5) gives the output ----

12) How can you insert "Kumar" as the "LastName" in the "Customer" table?

13) How can you change "Chennai" into " Hyderabad" in the "City" column in the Customer table?

14) How can you delete the records where the "FirstName" is "NIC" in the CUSTOMER Table?

15) How can you return the number of records in the "Customer" table?

16) The primary key of a table can have ___

17) Name the functions to remove unnecessary leading and trailing space characters comes with string

18) Aggregate functions are also known as

19) If the given string is not available in a string, the INSTR() functions returns

20) --- is used to give different name for the column in select statement