What is an advantage of placing computations in SQL views
To save users from having to write an expression
To ensure that the results are consistent
To accomplish both of the above
None of the above
Quiz Recommendation System API Link - https://fresherbell-quiz-api.herokuapp.com/fresherbell_quiz_api
# | Quiz |
---|---|
1
Discuss
|
A reason for using an SQL view to hide columns is
Solution |
2
Discuss
|
What SQL structure is used to limit column values of a table?
Solution |
3
Discuss
|
Which of the following is correct
Solution |
4
Discuss
|
Which of the following is a valid SQL type?
Solution |
5
Discuss
|
Count function in SQL returns the number of
Solution |
6
Discuss
|
To delete a particular column in a relation the command used is
Solution |
7
Discuss
|
The SQL ALTER statement can be used to
Solution |
8
Discuss
|
Which one of the following is not true for a view
Solution |
9
Discuss
|
‘AS’ clause is used in SQL for
Solution |
10
Discuss
|
Which is NOT one of the most common types of SQL CHECK constraints?
Solution |
# | Quiz |
Copyright © 2020 Inovatik - All rights reserved