COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Triggers
|
|
|
Stored procedures
|
|
|
Function
|
|
|
View
|
Detailed explanation-1: -except removes all occurrences of duplicate data from set A, whereas except all only removes one occurrence of duplicate data from set A for every occurrence in set B.
Detailed explanation-2: -The SQL EXCEPT clause/operator is used to combine two SELECT statements and returns rows from the first SELECT statement that are not returned by the second SELECT statement. This means EXCEPT returns only rows, which are not available in the second SELECT statement.
Detailed explanation-3: -Since in database we have tables, that’s why we use DESCRIBE or DESC(both are same) command to describe the structure of a table.
Detailed explanation-4: -There are two types of views in the SQL Server, namely System Defined Views and User Defined Views.