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
|
To delete a particular column in a relation the command used is
Solution |
2
Discuss
|
The statement in SQL which allows changing the definition of a table is
Solution |
3
Discuss
|
Which of the following is a legal expression in SQL?
Solution |
4
Discuss
|
A reason for using an SQL view to hide columns is
Solution |
5
Discuss
|
What is not an advantage of stored procedures?
Solution |
6
Discuss
|
The SQL ALTER statement can be used to
Solution |
7
Discuss
|
What SQL structure is used to limit column values of a table?
Solution |
8
Discuss
|
Which of the following is an SQL trigger supported by Oracle?
Solution |
9
Discuss
|
A report generator is used to
Solution |
10
Discuss
|
‘AS’ clause is used in SQL for
Solution |
# | Quiz |
Copyright © 2020 Inovatik - All rights reserved