Font size
WorksheetsDBMS Unit-1
Total questions: 52
Worksheet time: 29mins
An entity set that does not have sufficient attributes to form a primary key is termed a ________
Strong entity set
Variant set
Weak entity set
Variable set
An ER diagram can express the overall_____of a database graphically
view structure
model structure
logical structure
Architectural structure
Dashed ellipses represents
derived attributes
multi valued attributes
weak entity sets
Total participation of an entity
An entity set that has attributes to form primary key,such entity set is termed as
strong entity set
weak entity set
composite entity set
owner entity set
_________ specifies the number of instances of one entity that can or must be associated with each instance of another?
Cardinality constraint
Multi-valued attribute
participation constraint
The most common type of relationship encountered in data modelling is __________ relationship?
binary
unary
ternary
quartenary
An attribute associated with a relationship type is called
single valued attribute
key attribute
descriptive attribute
simple attribute
Which of the following is not a type of DBMS model?
Hierarchical
Relational
Sequential
Object-oriented
What is the primary key in a relational database?
A key that uniquely identifies each record in a table
A key that is used for encryption
A key that is used for indexing purposes
A key that is a combination of other keys
What does SQL stand for?
Structured Query Language
Sequential Query Language
Structured Question Language
Systematic Query Language
Which of the following is not a SQL command?
SELECT
INSERT
MOVE
UPDATE
In a relational database, what is a foreign key?
A key used for opening encrypted data
A key that uniquely identifies each record in a table
A key that links two tables together
A key that is used for indexing purposes
Which of the following is an example of a DDL (Data Definition Language) statement?
SELECT
INSERT
CREATE
UPDATE
What is the purpose of normalization in database design?
To speed up database performance
To eliminate redundancy and dependency
To make databases smaller in size
To encrypt sensitive data
Which SQL command is used to add a new column to an existing table?
ALTER TABLE
UPDATE TABLE
MODIFY TABLE
ADD COLUMN
What is the purpose of the DML (Data Manipulation Language) command "MERGE" in SQL?
To combine multiple columns into a single column
To insert new rows into a table
To update existing rows or insert new rows if they do not exist
To delete rows from a table based on specified conditions
Which type of data can be stored in the database?
Image oriented data
Text, files containing data
Data in the form of audio or video
All of the above
Identify the primary key from the following
name
mark
telephone number
Gender
can a primary key be null
yes
no
for the following two entities which is appropriate relationship Zoo/Animal
one to one
one to many
many to one
Record in a database is
can have information about a person
Known as row
group of related record
Known as column
For the following two entities which is the correct option RULER/COUNTRY
one to many
one to one
many to one
for the following two entities which one is the correct option CUTOMER/ORDER
one to one
one to many
many to one
check the incorrect option
ER is an conceptual Data model
DBMS avoids Data redundancy
we cannot create a table without a primary key
An attribute of an entity can have more than one value
What does ODBC in a database stand for:
Oral Database Connectivity
Oracle Database Connectivity
Open Database Connectivity
Object Database Connectivity
Which of the following represents a one-to-many relationship?
Many teachers have one class
Many teachers have many classes
One teacher has many classes
One teacher has one class
Which of the following is a DDL command in SQL?
SELECT
INSERT
CREATE
UPDATE
Which of the following commands is used to delete a table in
SQL?
DELETE
DROP
REMOVE
ERASE
Which command is used to insert new data into a table?
ADD
INSERT
UPDATE
APPEND
Which command is used to change the structure of a table?
ALTER
MODIFY
CHANGE
UPDATE
Which of the following commands is used to save all changes
made during the current transaction?
SAVE
APPLY
COMMIT
EXECUTE
Which command removes all rows from a table without
logging the individual row deletions?
DELETE
ERASE
CLEAR
TRUNCATE
What does the SQL command GRANT do?
Removes user privileges
Creates a new user
Modifies table structure
Gives user access privileges to the database
The data model which describes how the data is actually stored is
internal model
external model
logical model
none of these
Data about data is normally termed as
directory
data bank
meta data
none of the above
A view of database that appears to an application program is known as
schema
subschema
virtual table
none of the above
Collection of information stored in a database at a particular moment is
view
schema
instance
none of the above
DBA stands for
Data Bank Access
Database Access
Data Bank Administration
Database Administrator
Data items grouped together for storage purposes are called a :
Record
title
list
string
A different diagrammatic representation other than schema diagram is known as the
Unstructured diagram
Semi structured diagram
Structured diagram
Entity-relationship diagram
CREATE TABLE employee (name VARCHAR, id INTEGER)
What type of statement is this?
DML
DDL
View
Integrity constraint
The SQL used by front-end application programs to request data from the DBMS is called _______
A. DML
B .DDL
C .VDL
D. SDL
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
How do we select all rows for the "Designer" table?
SELECT * FROM Designer
SELECT [All] FROM Designer
SELECT Designer.*
SELECT FROM Designer
The term "Data" refers to
The electronic representation of the information( or data)
Basic information
Row Facts and figures
Both A and C
