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 is NOT one of the most common types of SQL CHECK constraints?
Solution |
2
Discuss
|
The language which has recently become the defacto standard for interfacing application programs with relational database system is
Solution |
3
Discuss
|
The statement in SQL which allows changing the definition of a table is
Solution |
4
Discuss
|
Which of the following is an advantage of view?
Solution |
5
Discuss
|
Which of the following is a valid SQL type?
Solution |
6
Discuss
|
Views constructed from SQL SELECT statements that conform to the SQL-92 standard may not contain
Solution |
7
Discuss
|
A reason for using an SQL view to hide columns is
Solution |
8
Discuss
|
The SQL ALTER statement can be used to
Solution |
9
Discuss
|
Count function in SQL returns the number of
Solution |
10
Discuss
|
Which of the following is a comparison operator in SQL?
Solution |
# | Quiz |
Copyright © 2020 Inovatik - All rights reserved