ISDS 7301 (Questions well answered) A+
rated latest update
What does a relational database do? - correct answer ✔✔Organizes data and tables , these are
also called relations
What are the different components of a database system? - correct answer ✔✔Database
application programs , client components , database serves(s), and databases
What is the task of a database server - correct answer ✔✔To manage data stored in a database
What are the features of a database ? - correct 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 ? - correct answer ✔✔the database applications does not
depend on physical structure,
Most databases contain a subcomponent called an? - correct answer ✔✔optimizer
What is authentication? - correct answer ✔✔The process of validating user credentials to
prevent unauthorized users
What are relational database systems based upon? - correct answer ✔✔The relational data
model
, What is a data model? - correct 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? - correct answer ✔✔dept_no , dept_name , location
Attributes of employee? - correct answer ✔✔emp_no, emp_fname, emp_lname
Attributes of project? - correct answer ✔✔Project_no, project_name, budget
works_on specifies what? and attributes ? - correct answer ✔✔The relationship between
employee and projects / ( emp_no, project_no, job, enter_date)
What is the database language of the SQL server? - correct answer ✔✔Transact- SQL
What are the sublanguages of SQL? - correct answer ✔✔Data definition language (DDL) and
Data manipulation language (DML)
What does DDL do? - correct answer ✔✔Used to describe the schema of a database table
DDL contains what three generic statements? - correct answer ✔✔Create, alter and drop
DML ? - correct answer ✔✔Emcompasses all operations that manipulate the data
Four generic operations for manipulating data> - correct answer ✔✔retrieval, insertions,
deletions, and modification
Normalization of data is the process of ? - correct answer ✔✔testing existing tables of
databases to find dependencies between columns of a table.
rated latest update
What does a relational database do? - correct answer ✔✔Organizes data and tables , these are
also called relations
What are the different components of a database system? - correct answer ✔✔Database
application programs , client components , database serves(s), and databases
What is the task of a database server - correct answer ✔✔To manage data stored in a database
What are the features of a database ? - correct 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 ? - correct answer ✔✔the database applications does not
depend on physical structure,
Most databases contain a subcomponent called an? - correct answer ✔✔optimizer
What is authentication? - correct answer ✔✔The process of validating user credentials to
prevent unauthorized users
What are relational database systems based upon? - correct answer ✔✔The relational data
model
, What is a data model? - correct 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? - correct answer ✔✔dept_no , dept_name , location
Attributes of employee? - correct answer ✔✔emp_no, emp_fname, emp_lname
Attributes of project? - correct answer ✔✔Project_no, project_name, budget
works_on specifies what? and attributes ? - correct answer ✔✔The relationship between
employee and projects / ( emp_no, project_no, job, enter_date)
What is the database language of the SQL server? - correct answer ✔✔Transact- SQL
What are the sublanguages of SQL? - correct answer ✔✔Data definition language (DDL) and
Data manipulation language (DML)
What does DDL do? - correct answer ✔✔Used to describe the schema of a database table
DDL contains what three generic statements? - correct answer ✔✔Create, alter and drop
DML ? - correct answer ✔✔Emcompasses all operations that manipulate the data
Four generic operations for manipulating data> - correct answer ✔✔retrieval, insertions,
deletions, and modification
Normalization of data is the process of ? - correct answer ✔✔testing existing tables of
databases to find dependencies between columns of a table.
