The DROP TABLE statement:
deletes the table structure only
deletes the table structure along with the table data
works whether or not referential integrity constraints would be violated
is not an SQL statement
Quiz Recommendation System API Link - https://fresherbell-quiz-api.herokuapp.com/fresherbell_quiz_api
# | Quiz |
---|---|
1
Discuss
|
A _________ is a stored program that is attached to a table or a view.
Solution |
2
Discuss
|
Which of the following is NOT a type of SQL constraint?
Solution |
3
Discuss
|
To update an SQL view, the DBMS must be able to associate the column(s) to be updated with
Solution |
4
Discuss
|
Triggers __________ enabled or disabled.
Solution |
5
Discuss
|
The SQL statement to create a view is
Solution |
6
Discuss
|
To include integrity constraint in a existing relation use :
Solution |
7
Discuss
|
The default extension for an Oracle SQL*Plus file is:
Solution |
8
Discuss
|
A _________ is a program that performs some common action on database data and that is stored in the database
Solution |
9
Discuss
|
What is an SQL virtual table that is constructed from other tables?
Solution |
10
Discuss
|
For what purposes are views used?
Solution |
# | Quiz |
Copyright © 2020 Inovatik - All rights reserved