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
|
Which of the following is a legal expression in SQL?
Solution |
2
Discuss
|
Which of the following is a valid SQL type?
Solution |
3
Discuss
|
Which of the following is an SQL trigger supported by Oracle?
Solution |
4
Discuss
|
The statement in SQL which allows changing the definition of a table is
Solution |
5
Discuss
|
What SQL structure is used to limit column values of a table?
Solution |
6
Discuss
|
Which one of the following is not true for a view
Solution |
7
Discuss
|
Which of the following is correct
Solution |
8
Discuss
|
A report generator is used to
Solution |
9
Discuss
|
‘AS’ clause is used in SQL for
Solution |
10
Discuss
|
Which of the following is an advantage of view?
Solution |
# | Quiz |
Copyright © 2020 Inovatik - All rights reserved