NiC IT Academy

SQL Quiz – 7

By Mr. Chandra

Loading

1) In Oracle, Which statement can be rolled back?

2) In Oracle, Views are also called as ____?

3) Which of the following is a NoSQL database?

4) Which of the following is a NoSQL Database Type ?

5) Which of the following is the simplest type of NoSQL database?

6) NoSQL databases are used mainly for handling large volumes of ______________ data.

7) Using UPDATE without the WHERE clause will

8) What is the latest version of Oracle database?

9) A table can have ____ foreign keys

10) What is Oracle Database?

11) Which datatype is used to store images and videos?

12) What is the output of below SQL statement? select substr('Welcome to India!!!',-8,5) from dual;

13) What is returned by ROUND (789.9389, 2)?

14) Which of the following code will delete a view named ‘payments_metrics’?

15) Which SQL statement deletes all the data permanently but keeps the structure

16) DDL statement?

17) In Oracle SL, number(4,2) data type stores number up to

18) In Oracle SQL, which function is used to find the number of characters in a string?

19) In Oracle SQL, which function is used to return the current date and time?

20) Which SQL statement is used to modify data in a database?

Login with your email & password

Sign up with your email & password

Signup/Registration Form

Registred Email:

- Not Updated -

Set/Update Password