NEW
Font size
WorksheetsDBMS Quiz
Total questions: 25
Worksheet time: 13mins
Which of the following is not a DBMS
Third normal form is based on the concept of _________
Closure Dependency
Transitive Dependency
Normal Dependency
Functional Dependency
Schema is usually stored in____________.
Tables
Data Dictionary
Views
Index
In database records are called:
Attributes
Entity
Tuples
Relations
________ is the information about data.
Attribute
Meta-Data
Entity
Relations
Which one of the following uniquely identifies the elements in the relation?
Secondary Key
Alternate key
Foreign key
Primary key
If you want to maintain and store information about your car inurance company, a car would be considered a(n) _____
Relation
Entity
Instance
Attribute
What is the purpose of the SELECT operation in relational algebra?
Combine rows from different tables
Filter rows based on a condition
Add new records to a table
Sort the table in ascending order
Which additional relational algebra operation is used to combine rows from two tables?
Union
Join
Project
Intersect
What is the full form of DML?
Data Management Language
Data Manipulation Language
Data Memory Language
Data Manipulation Label
Rows are also called as
Tuples
Columns
Attributes
Tables
Which of the following is a DML Command?
Create
Alter
Update
Drop
Which of the following is not a DDL Command?
Create
Delete
Alter
Drop
Here which of the following displays the unique values of the column?
SELECT ________ dept_name
FROM instructor;
from
like
unique
distinct
Which of the following is generally used for performing tasks like creating the structure of the relations, deleting relation?
DML(Data Manipulation Language)
Query
Relational Schema
DDL(Data Definition Language)
