DBMS Practical Quiz
Authored by Dr. Sharma
Professional Development
University
Used 1+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
40 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Which of the following is a property of database
Represents some aspect of the real world
Logically related collection of data
Built, and populated with data for a specific purpose
All the above
2.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
A database management system (DBMS) is a collection of programs that enables users to
create a database
manipulate a database
both create and manipulate a database
for storing data only
3.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Which one of the following is used to define the structure of the relation, deleting relations and relating schemas?
DML(Data Manipulation Langauge)
DDL(Data Definition Langauge)
Query
Relational Schema
4.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Which one of the following is used to define the structure of the relation, deleting relations and relating schemas?
DML(Data Manipulation Langauge)
DDL(Data Definition Langauge)
Query
Relational Schema
5.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
CREATE TABLE employee (name VARCHAR, id INTEGER)
What type of statement is this?
DML
DDL
View
Integrity constraint
6.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
The SQL used by front-end application programs to request data from the DBMS is called _______
A. DML
B .DDL
C .VDL
D. SDL
7.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
The command used to delete a particular column in a relation is ____________
A.UPDATE TABLE
B.TRUNCATE COLUMN
C.ALTER , DROP
D.DELETE COLUMN
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Classlink
Continue with Clever
or continue with
Microsoft
%20(1).png)
Apple
Others
Already have an account?
