![placeholder image to represent content](/_next/image?url=%2Fassets%2Fquiz_default_logo.jpg&w=256&q=75)
DBMS CA-2
Quiz by Yashaswini B M
Feel free to use or edit a copy
includes Teacher and Student dashboards
Measure skillsfrom any curriculum
Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.
- edit the questions
- save a copy for later
- start a class game
- automatically assign follow-up activities based on students’ scores
- assign as homework
- share a link with colleagues
- print as a bubble sheet
- Q1
Which of the following provides the ability to query information from the database and insert tuples into, delete tuples from, and modify tuples in the database?
Relational Schema
Query
DDL(Data Definition Language)
DML(Data Manipulation Language)
30s - Q2
A Database Management System is a type of _________software.
It is a kind of general software
It is a kind of application software
It is a type of system software
Both A and C
30s - Q3
Which of the following refers to the level of data abstraction that describes exactly how the data actually stored?
Conceptual Level
Logical Level
Physical Level
File Level
30s - Q4
To which of the following the term "DBA" referred?
None of the above
Data Bank Administrator
Database Administrator
Data Administrator
30s - Q5
Rows of a relation are known as the _______.
All of the above
Degree
Entity
Tuples
30s - Q6
Which of the following refers to the number of tuples in a relation?
Column
None of the above
Cardinality
Entity
30s - Q7
In a relation database, every tuples divided into the fields are known as the______.
All of the above
Relations
Queries
Domains
30s - Q8
Which of the following refers to the number of attributes in a relation?
All of the above
Column
Row
Degree
30s - Q9
Which of the following refers collection of the information stored in a database at a specific time?
Data domain
Schema
Instance of the database
Independence
30s - Q10
The term "Data independence" refers to____
Programs are not dependent on the logical attributes of the data
Programs are not dependent on the physical attributes of the data
Data is defined separately and not included in the programs
Both B & C
30s