1) What is the full form of SQL?
2) What is returned by ROUND (789.9389, 2)?
3) Which of the following code will delete a view named ‘payments_metrics’?
4) Which command is used to withdraw user privileges?
5) Which of the following shows a comment in SQL?
6) Which one of the following is an RDBMS?
7) What is the maximum byte for Varchar2 data type?
8) SELECT length(UPPER('Hi Hello')) FROM dual;
9) SELECT UPPER(25/5) FROM dual;
10) SELECT lower(upper(initcap('Welcome to NiC') )) FROM dual;
11) What will be the output of the below query? SELECT 1000+NULL+999 FROM dual;
12) Which one of the following is not true for a view?
13) Which of the following is not a valid Oracle index structure?
14) Which SQL keyword is used to sort the result-set?
15) Which SQL statement is used to extract data from a database?
16) Which SQL statement is used to update data in a database?
17) Which SQL statement is used to insert new data in a database?
18) Which SQL statement is used to return only different values?
19) Which operator is used to search for a specified pattern in a column?
20) Which command is used to remove the table 'CUSTOMER'?