WorksheetsQuiz on DBMS-U4
Total questions: 10
Worksheet time: 5mins
What is the expansion of SQL?
Structured Query Language
Semi Qualifier Limit
Sample Quality Language
Data Manipulation Language (DML) provides___________ data manipulation statements.
4
3
2
1
Which of the following commands allow the user to perform audit and analysis operations within the database?
TCS
DQL
DCL
DAS
Which one of the following is not a data definition language statement?
Create
Drop
Alter
Select
Which of the following database object does not physically exist?
Basic Table
Views
Index
Non - updateable views are also called __________
Read-only views
Theoretically views
Dropping view
Alter view
Which of the following index is made up of more than one column?
Clustered Index
Simple Index
Multiple Index
Composite Index
The fact that the result of a SELECT statement is another table is referred to as the _________ property of the relational systems.
Spatial
Cluster
Closure
Which of the following clause is usually used together with aggregate functions?
ORDER BY ASC
ORDER BY DESC
GROUP BY
A _________ is resolved in a top-to-bottom fashion.
Nested Subquery
Correlated Subquery
Parallel Subquery
