1|Page
ISDS 7301 (actual 2025/2026)EXAM 2 QUESTIONS
AND verified ANSWERS CORRECT
What does a relational database do? - (answer)Organizes data and tables , these
are also called relations
What are the different components of a database system? - (answer)Database
application programs , client components , database serves(s), and databases
What is the task of a database server - (answer)To manage data stored in a
database
What are the features of a database ? - (answer)Variety of user interfaces,
physical data independence, logical data independence, query optimization, data
integrity, concurrency control, backup and recovery, database security
Physical data independence means ? - (answer)the database applications does
not depend on physical structure,
Most databases contain a subcomponent called an? - (answer)optimizer
What is authentication? - (answer)The process of validating user credentials to
prevent unauthorized users
What are relational database systems based upon? - (answer)The relational data
model
, 2|Page
What is a data model? - (answer)a collection of concepts, their relationships, and
their constraints that are used to represent data of a real-world problem
What are the attributes of department? - (answer)dept_no , dept_name ,
location
Attributes of employee? - (answer)emp_no, emp_fname, emp_lname
Attributes of project? - (answer)Project_no, project_name, budget
works_on specifies what? and attributes ? - (answer)The relationship between
employee and projects / ( emp_no, project_no, job, enter_date)
What is the database language of the SQL server? - (answer)Transact- SQL
What are the sublanguages of SQL? - (answer)Data definition language (DDL) and
Data manipulation language (DML)
What does DDL do? - (answer)Used to describe the schema of a database table
DDL contains what three generic statements? - (answer)Create, alter and drop
ISDS 7301 (actual 2025/2026)EXAM 2 QUESTIONS
AND verified ANSWERS CORRECT
What does a relational database do? - (answer)Organizes data and tables , these
are also called relations
What are the different components of a database system? - (answer)Database
application programs , client components , database serves(s), and databases
What is the task of a database server - (answer)To manage data stored in a
database
What are the features of a database ? - (answer)Variety of user interfaces,
physical data independence, logical data independence, query optimization, data
integrity, concurrency control, backup and recovery, database security
Physical data independence means ? - (answer)the database applications does
not depend on physical structure,
Most databases contain a subcomponent called an? - (answer)optimizer
What is authentication? - (answer)The process of validating user credentials to
prevent unauthorized users
What are relational database systems based upon? - (answer)The relational data
model
, 2|Page
What is a data model? - (answer)a collection of concepts, their relationships, and
their constraints that are used to represent data of a real-world problem
What are the attributes of department? - (answer)dept_no , dept_name ,
location
Attributes of employee? - (answer)emp_no, emp_fname, emp_lname
Attributes of project? - (answer)Project_no, project_name, budget
works_on specifies what? and attributes ? - (answer)The relationship between
employee and projects / ( emp_no, project_no, job, enter_date)
What is the database language of the SQL server? - (answer)Transact- SQL
What are the sublanguages of SQL? - (answer)Data definition language (DDL) and
Data manipulation language (DML)
What does DDL do? - (answer)Used to describe the schema of a database table
DDL contains what three generic statements? - (answer)Create, alter and drop
