NEW
Font size
WorksheetsDBMS&SE
Total questions: 26
Worksheet time: 26mins
In an Entity-Relationship Diagram “Diamonds” represents
Attributes
Multi valued attributes
Weak entity set
Relationships
How many types of keys in Database Design?
Candidate Key
Primary key
Foreign key
All of these
Administrate supervision of database activities is the responsibility of the
Database administrator
DP Manager
DB Manager
DP administration
What is the abbreviation used for a software package that permits the users to create, retrieve and maintain records in a database?
DMS
DBMS
DS
FMS
In SQL, which command is used to add a column/integrity constraint to a table
ADD COLUMN
INSERT COLUMN
MODIFY TABLE
ALTER TABLE
Which language has recently become the de-facto standard for interfacing application programs with relational database system?
Oracle
SQL
4GL
None of the above
The data dictionary tells the DBMS
What files are in the database
What attribute are possessed by the data
What these files contain
All of the above
Disadvantages of File systems to store data is:
Data redundancy and inconsistency
Difficulty in accessing data
Data isolation
All of the above
Column header is refer as
Table
Relation
Attributes
Domain
Data Manipulation Language (DML) is not to
Create information table in the Database
Insertion of new information into the Database
Deletion of information in the Database
Modification of information in the Database
The minimal set of super key is called
Primary key
Secondary key
Candidate key
Foreign key
In any hierarchy of data organization, the smallest entity to be processed as a single unit is called
Data field
Data record
Data file
Database
Related fields in a data base are grouped to form
Data file
Data record
Menu
Bank
In SQL, which command is used to select only one copy of each set of duplicable rows
SELECT DISTINCT
SELECT UNIQUE
SELECT DIFFERENT
All of the above
In SQL, which command is used to select data in rows and column from one or more tables?
CHOOSE
SELECT
LIST
BROWSE
After you _______ a record, many data management the environments require you to issue a command to save the changes you made.
Delete
Update
Sort key
Index
In SQL, the CREATE TABLE is used
To create a table, defining its columns, integrity constrains, and storage allocation
To add a column/integrity constraint to a table
To redefine a column
To change a table's storage characteristics
Who is the father of Software Engineering?
Margaret Hamilton
Watts S. Humphrey
Alan Turing
Boris Beizer
What are the features of Software Code?
Simplicity
Accessibility
Modularity
All of the above
____________ is a software development activity that is not a part of software processes.
Validation
Specification
Development
Dependence
What is a Functional Requirement?
specifies the tasks the program must complete
specifies the tasks the program should not complete
specifies the tasks the program must not work
All of the mentioned
What does SDLC stands for?
System Design Life Cycle
Software Design Life Cycle
Software Development Life Cycle
System Development Life cycle
Who proposed the spiral model?
Barry Boehm
Pressman
Royce
IBM
__________ is not suitable for accommodating any change?
RAD Model
Waterfall Model
Build & Fix Model
Prototyping Model
What is the full form of the “COCOMO” model?
Cost Constructive Estimation Model
Constructive Cost Estimation Model
Constructive Case Estimation Model
Constructive Cost Estimating Model
Which e-learning platform has been featured in Time Magazine's 2021 list of 100 most influential companies?
BYJU's
Edukart
Unacademy
Toppr
