SQL Quiz 10

Question 1 of 15

1. Question

View is

an SQL statement that is stored in the table with an associated ID/ name
an SQL statement that is stored in the database with an associated ID/ name
an SQL statement that is stored in the database with an associated table
an SQL table that is stored in the database with an associated ID/ name

Question 2 of 15

2. Question

View can be created from one or more tables depending upon the written SQL query

True
False

Question 3 of 15

3. Question

Which of the following is a view?

create view <table name> as select * from <view name> where <condition>;>
create view <view name> as select * from <view name> where <condition>;>
create view <table name> as select * from <table name> where <condition>;>
create view <view name> as select * from <table name> where <condition>;>

Question 4 of 15

4. Question

Views allow the user to summarize data from various tables

True
False

Question 5 of 15

5. Question

Which of the following are conditions for updating the view

select clause may not contain distinct keyword
from clause can contain multiple tables
select clause may not contain set operations
where clause can contain subqueries

Question 6 of 15

6. Question

Not null columns from the base table must be included in the view is a condition for updating the view

True
False

Question 7 of 15

7. Question

Which of the following are SQL inbuilt functions?

Count
Sort
Concat
View

Question 8 of 15

8. Question

Which of the following SQL inbuilt functions returns a random number?

Sum
Min
Random
Rand

Question 9 of 15

9. Question

Sort is a SQL inbuilt function

True
False

Question 10 of 15

10. Question

Which of the following is a SQL string function

COUNT
ASCII
CONCAT
RAND

Question 11 of 15

11. Question

Left, Right, Len are part of SQL string functions

True
False

Question 12 of 15

12. Question

What is the functionality of reverse()

extracts some characters from a string
reverses a string and returns the result
extracts a number of characters from a string
none of the above

Question 13 of 15

13. Question

What is the date format used in SQL

DD-MM-YYYY
MM-DD-YYYY
YYYY-MM-DD
YYYY-DD-MM

Question 14 of 15

14. Question

Which of the following are SQL date functions?

datediff()
getdate()
dateadd()
datepart()

Question 15 of 15

15. Question

Which of the following are SQL string functions

Charindex
Upper
Concat
Count

Quiz Summary

Information

Results