Crowdly
Add to Chrome
DATABASE MANAGEMENT SYSTEMS_ADV
Looking for DATABASE MANAGEMENT SYSTEMS_ADV test answers and solutions? Browse our comprehensive collection of verified answers for DATABASE MANAGEMENT SYSTEMS_ADV at lms.klh.edu.in.
Get instant access to accurate answers and detailed explanations for your course questions. Our community-driven platform helps students succeed!
1. Which SQL command is used to define the structure of a database schema?
0%
0%
0%
0%
View this question
3. Which SQL clause is used to filter rows based on a condition?
0%
0%
0%
0%
View this question
2. Which of the following is a DML command?
0%
0%
0%
0%
View this question
9. In relational algebra, the projection operator (π) is used to:
0%
0%
0%
0%
View this question
8. In relational algebra, the selection operator (σ) is used to:
0%
0%
0%
0%
View this question
7. Which of the following types of indexes arranges data in the same order as the table’s primary key?
❌
❌
✅
❌
View this question
4. In SQL, which constraint ensures that a column cannot have duplicate values and cannot be NULL?
100%
0%
0%
0%
View this question
6. A view in SQL can be described as:
❌
❌
✅
❌
View this question
5. Which type of SQL join returns only the rows that have matching values in both tables?
0%
0%
0%
0%
View this question
10. Which of the following is a set theory operator in relational algebra?
✅
❌
❌
❌
View this question