SQL views can be used to hide
columns and rows only
complicated SQL syntax only
both of the above can be hidden by an SQL view
None of the above is correct
Quiz Recommendation System API Link - https://fresherbell-quiz-api.herokuapp.com/fresherbell_quiz_api
# | Quiz |
---|---|
1
Discuss
|
The default extension for an Oracle SQL*Plus file is:
Solution |
2
Discuss
|
A _________ is a stored program that is attached to a table or a view.
Solution |
3
Discuss
|
The SQL statement to create a view is
Solution |
4
Discuss
|
To update an SQL view, the DBMS must be able to associate the column(s) to be updated with
Solution |
5
Discuss
|
When using the SQL INSERT statement
Solution |
6
Discuss
|
For what purposes are views used?
Solution |
7
Discuss
|
To include integrity constraint in a existing relation use :
Solution |
8
Discuss
|
Which of the following is NOT a type of SQL constraint?
Solution |
9
Discuss
|
A _________ is a program that performs some common action on database data and that is stored in the database
Solution |
10
Discuss
|
What is an SQL virtual table that is constructed from other tables?
Solution |
# | Quiz |
Copyright © 2020 Inovatik - All rights reserved