NiC IT Academy

SQL Quiz – 01

By Mr. Chandra

Loading

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'?

Login with your email & password

Sign up with your email & password

Signup/Registration Form