NEW
Font size
WorksheetsBCA - IV SEM DBMS
Total questions: 20
Worksheet time: 2hrs 36mins
Cartesian product in relational algebra is
Unary operator
Binary operator
Ternary operator
Not defined
ODBC stands for
Object Database Connectivity.
Oral Database Connectivity.
Oracle Database Connectivity.
Open Database Connectivity.
DML is provided for
Description of the logical structure of a database.
The addition of new structures in the database system.
Manipulation & processing of the database.
Definition of a physical structure of the database system.
The view of total database content is
Conceptual view
Internal view
External view
Physical View
Architecture of the database can be viewed as
two levels
four levels
three levels
one level
In the architecture of a database system external level is the
Physical level
Logical level
Conceptual level
View level.
The database schema is written in
HLL
DML
DDL
DCL
An entity set that does not have sufficient attributes to form a primary key is a
Strong entity set
Weak entity set
Simple entity set
Primary entity set
In an E-R diagram attributes are represented by
Rectangle
Square.
Ellipse
Triangle.
A logical Schema
is the entire database.
is a standard way of organising information into accessible parts.
describes how data is actually stored on disk.
both (A) and (C)
In an E-R diagram an entity set is represented by a
Rectangle
Ellipse
Diamond box
Circle
Conceptual design
is a documentation technique
needs data volume and processing frequencies to determine the size of the database
involves modelling independent of the DBMS
is designing the relational model
A subschema expresses
The logical view
The physical view
The external view
All of the above.
The statement in SQL which allows changing the definition of a table is
Alter
Update
Create
Select
Key to represent the relationship between tables is called
Primary key
Secondary Key
Foreign Key
None of these
Which database level is closest to the users?
External
Internal
Physical
Conceptual
A set of possible data values is called
Attribute
Degree
Tuple
Domain
In E-R Diagram derived attribute is represented by
Ellipse
Dashed ellipse
Rectangle
Triangle
Hierarchical model is also called
Tree structure
Plex Structure
Normalise Structure
Table Structure
To delete a particular column in a relation the command used is
UPDATE
DROP
ALTER
DELETE
