20 Questions

Sql Quiz

1 :-

9. Concatenation operator helps

To Combine Only Columns Only Literals Only Numbers All Of These

2 :-

22. We can modify table for following:

Add/modify Column Drop Column Rename Column All Of These

3 :-

37. TCL commands are

Commit Rollback Savepoint All Of These

4 :-

38. Autocommit statement

Ddl Commit Both None Of These

5 :-

23. We define view as complex if it is contains

Group Function Join Group By All Of These

6 :-

40. environment command is not

Commit Create Drop Insert

7 :-

29. Subquery can be used in front of

From Where Having All Of These

8 :-

30. To validate input salary > 10000 while insert we use constraint

Primary Key Foreign Key Unique Check

9 :-

1. What command is used to create a new table in SQL?

Create Table Build Table Generate Table None Of The Above

10 :-

35. table or view does not exist message show ora-00000 code

Ora-00942 Ora-01400 Ora-00001 Ora-02291

11 :-

25. We can combine data without join but also table using Set operators that are

Union Intersect Minus All Of These

12 :-

26. A table emp contain 100 rows and want to create replica of table using query create table bkup_emp as select * from emp where 1=0 will show as:

Table Created With 100 Rows Table Created With 0 Rows Error While Create Table None Of These

13 :-

8. Null means

Unavailable Unassigned Unknown All Of These

14 :-

14. SELECT ROUND (65.726, -1) FROM DUAL;

65 70 65.725 65.73

15 :-

31. To see list of sequence definintion from dictionary we use

User_sequences All_sequences Both None Of These

16 :-

19. To add data to table we use dml statement

Insert Update Delete None Of These

17 :-

15. Which of the following is the basic approaches for joining tables?

Natural Join Subquery Union Join None

18 :-

12. Which operator tests column for absence of data

Not Is Null Exists None

19 :-

39. Table lock can occure while use of

Update Statment Delete Statment Both None Of These

20 :-

17. _______ is a constraint that can be defined only at the column level?

Unique Not Null Check Primary Key

Back

Mock Test Completion Certificate

You scored 0 out of 20 questions.

🏅

For your extraordinary service and contributions to your profession.

We are delighted in providing this certificate to you.

Tips for improving your score:

Make sure to read the questions and answer choices carefully.
Don't try to answer any choices that you don't know. It's better to skip a question.

Back Load More