When using the SQL INSERT statement
rows can be modified according to criteria only
rows cannot be copied in mass from one table to another only
rows can be inserted into a table only one at a time only
rows can either be inserted into a table one at a time or in groups
Quiz Recommendation System API Link - https://fresherbell-quiz-api.herokuapp.com/fresherbell_quiz_api
# | Quiz |
---|---|
1
Discuss
|
For what purposes are views used?
Solution |
2
Discuss
|
A _________ is a stored program that is attached to a table or a view.
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
|
The DROP TABLE statement:
Solution |
5
Discuss
|
The default extension for an Oracle SQL*Plus file is:
Solution |
6
Discuss
|
A _________ is a program that performs some common action on database data and that is stored in the database
Solution |
7
Discuss
|
To include integrity constraint in a existing relation use :
Solution |
8
Discuss
|
SQL views can be used to hide
Solution |
9
Discuss
|
What is an SQL virtual table that is constructed from other tables?
Solution |
10
Discuss
|
Which of the following is NOT a type of SQL constraint?
Solution |
# | Quiz |
Copyright © 2020 Inovatik - All rights reserved