NEW
Font size
WorksheetsDBMS
Total questions: 50
Worksheet time: 25mins
A merit of DBMS is
data is dependent on programs.
data redundancy increases.
) data is integrated and can be accessed by multiple programs
A query language supports
support end-users who use English-like commands
support in the development of complex applications software.
all of the above.
The database schema as a whole is designed using
VDL and DDL.
DDL and DML.
VDL and DML.
It changes the description of a table
Alter.
Update.
Create
The weak entity set of E-R model?
Dotted rectangle.
Doubly outlined rectangle
Diamond
The relationship between tables is denoted by
Primary key
Foreign Key
None of these
To connect front end and back end, we use
Object Database Connectivity.
Oral Database Connectivity.
Open Database Connectivity.
The database architecture is of
two levels
three levels
one level
The relations in relational algebra are termed as
Tuples
Tables
Attributes
The schema of database is developed using
HLL
DDL
DML
In an E-R diagram attributes are represented by
rectangle
square
ellipse
The whole view of database is
Conceptual view
Internal view
Physical View
Modification to the database by unauthorised users is referred to as
Integrity issue
Productivity
Consistency
The command to add a column to an existing relation
Create
Alter
Update
The command to provide access on the database to users
Grant
Revoke
commit
Multiple relations can be linked with relationship to _____
Ensure data integrity
Ensure data entry
Create Primary Key
Each category of information in a table is called ________
Tuple
Record
Field
The term used to refer to a information stored at a specific moment at database
Instance
Schema
Attribute
The properties of entities are otherwise known as
Attribute
Tuple
Schema
The DDL stands for
Dynamic Data Language
Detailed Data Language
Data Definition Language
A primary key with a foreign key
creates Parent-Child relationship between the tables that connect them
creates Many to many relationships between the tables that connect them.
None of the above.
Join is a
Unary Operator
Ternary Operator
Binary Operator
The relationship type in ER model is represented by
Rectangle
Ellipse
Diamond
A super key is a set of one or more attributes
to identify uniquely an entity in the entity set
to make the key most powerful for faster retrieval
to increase effectiveness of database access
……..is a combination of columns that uniquely identifies any row within a relational database management
Candidate key
super key
Foreign key
Aadhar no is an example for
Foreign key
Super key
Primary key
Which one of the following statements are true
A prime attribute can be transitively dependent on a key in a BCNF relation.
A relation in which every key has only one attribute is in 2NF
All of above
Choose the formula to find the Maximum number of possible superkeys for a table with n attributes
2^(n-1)
2^(n)
(n-1)
For a table Emp( sid, cid. stuname) find how many numbers of super keys are possible
6
5
4
.........normalization satisfies "no transitive dependency" condition
2NF
3NF
1NF
Statement I : Is it possible to send multiple parameters in procedures Statement II : Is it possible to combine function and procedure in a single program
true, false
true,true
false, false
which project operator combines the related tuples in the relation
select
rename
Join
Relational algebra is a
Non-procedural query
Procedural query
Complex query
Which command is used inserts & delete attributes based on constraints
update
alter
delete
Which SQL keyword is used to sort the attribues
Distinict
Group by
order by
Which of the following command is not used for subqueries
view
all
in
The users friendly interface is used by
Naïve users
Sophisticated end users
Admin
Primary key must be made by combining two columns
True
False
May be
To ensure the candidate key, it must be
minimal
optimal
dual
From the following functional dependency professor → subject falls in
3NF
BCNF
2NF
..... is the constraint which specifies uniqueness
row
key
field
Cartesian product produces the relation that has attributes of R1 and R2
R1 and R2
R1
R2
………..operation takes two tables as input with a single common column
Cartesian Product
Join
Restriction
Which of the following relational algebra operations do not require the participating tables to be union-compatible?
Join
Difference
Union
Relational Algebra does not have contain
Selection operator.
Aggregation operators
Projection operator
......... constraint is used to limit the value range that can be placed in a column
is
As
Check
which symbol is used to matches all substring pattens
//
\\
%
..... command is not used to check the presence of the attribute
not exists
exists
null
...... which command checks the valid date, date-time, etc
istime
isdate
date
.....function returns the values of the last row in an ordered partition
Last Value
Rank
Lead
