20 Questions

Sql Quiz

1 :-

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

65 70 65.725 65.73

2 :-

8. Null means

Unavailable Unassigned Unknown All Of These

3 :-

33. To define alternative name of an object for forever we can use

Alias Synonym Sequence Index

4 :-

11. Which operator is used to compare a value to a specified list of values?

Any Between All In

5 :-

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

Create Table Build Table Generate Table None Of The Above

6 :-

34. To generate primary key value automatically for column we use

Sequence Synonym Index View

7 :-

27. We can use single row function with in

Select Where Order By All Of These

8 :-

9. Concatenation operator helps

To Combine Only Columns Only Literals Only Numbers All Of These

9 :-

12. Which operator tests column for absence of data

Not Is Null Exists None

10 :-

6. We use alias?

For Column For Expression For Table All Of These

11 :-

5. SQL views are also known as?

Schema Virtual Table Instance None Of The Above

12 :-

18. Which of the following operator can be used with a multiple-row subquery?

= <> Between In

13 :-

7. What is output for select 100+200+null from dual;

300 Null 0 None Of These

14 :-

38. Autocommit statement

Ddl Commit Both None Of These

15 :-

21. Which Join will multiply data from table a(10 records) and table b(5 records) and reproduce result of row count 50?

Cross Join Natural Join Join On Join Using

16 :-

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

Primary Key Foreign Key Unique Check

17 :-

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

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

18 :-

16. ______ is NOT a type of constraint in SQL language?

Foreign Key Primary Key Unique Alternate Key

19 :-

23. We define view as complex if it is contains

Group Function Join Group By All 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