©GRACEAMELIA 2024/2025 ACADEMIC YEAR. ALL RIGHTS RESERVED
FIRST PUBLISH OCTOBER 2024
CS 430 Database System Exam Practice
Questions and Answers
What are the data structures the storage manager implements as part of the physical system? - Ans:✔✔-
-Data files
-Data dictionary
-Indices
I've just added a new person to the Employee database and I did not have to alter my application that
uses this database. This is an example of which type of abstraction? - Ans:✔✔-Logical
T/F: An object-oriented data model permits the specification of data where individual data items of the
same type many have different sets of attributes. - Ans:✔✔-False
Typical functions of a database administrator would include what? - Ans:✔✔--Storage structure and
access-method definition
-Schema definition
-Security and access rights definition
Page 1/62
, ©GRACEAMELIA 2024/2025 ACADEMIC YEAR. ALL RIGHTS RESERVED
FIRST PUBLISH OCTOBER 2024
What are disadvantages to file processing systems? - Ans:✔✔--Operating systems provide only a
password mechanism for access control
-We must protect the data from inconsistent changes made by different users accessing the data
concurrently
-We must ensure the data is restored to a consistent state if the system cashes while changes are being
made
-We need special programs to answer each question a user may want to ask about the data
Database users and definition - Ans:✔✔--Naive user: unsophisticated users accessing the system through
application programs
-Application programmers: Computer professionals who write packages that facilitate access for end
users
-Sophisticated/Specialized users: Users who interact with the system and/or write specialized database
applications
-Database administrators: Professionals that design and maintain the database
T/F: The DDL interpreter of the query processor is responsible for query optimization. - Ans:✔✔-False
What operations require the relation instances they are operating on to be union-compatible? - Ans:✔✔-
Intersection, Union, Set-difference
Page 2/62
, ©GRACEAMELIA 2024/2025 ACADEMIC YEAR. ALL RIGHTS RESERVED
FIRST PUBLISH OCTOBER 2024
What are common subqueries - a select-from-where expression nested within another query? - Ans:✔✔-
-set comparison
-test for empty relations
-test for the absence of duplicate tuples
-set membership
A language that is used to express database queries and updates is called? - Ans:✔✔-A data
manipulation language
T/F: An attribute takes a null value when the value of the attribute is computed to be zero. - Ans:✔✔-
False
T/F: Data mining refers loosely to the process of semiautomatically analyzing raw input such as
newspapers and field data to create reports. - Ans:✔✔-False
Responsibility for the component of DBMS architecture - Ans:✔✔--Recovery manager: Ensures
transaction atomicity and durability
-Transaction manager: Controls the execution of the transactions
-Lock managers: Grants and releases locks appropriately
Page 3/62
, ©GRACEAMELIA 2024/2025 ACADEMIC YEAR. ALL RIGHTS RESERVED
FIRST PUBLISH OCTOBER 2024
T/F: Durability refers to the fact that values within a database must survive system failures. - Ans:✔✔-
True
T/F: The person that has central control over a DBMS is called a DataBase Administrator (DBA). -
Ans:✔✔-True
I've just changed the indexing scheme for a certain database. The change is transparent to the rest of the
database and other applications. This is an example of which type of abstraction? - Ans:✔✔-Physical
A data dictionary contains _____, data about data. - Ans:✔✔-metadata
A language in which a user specifies a database schema is called? - Ans:✔✔-a data definition language
In what phases does the design move from an abstract data mode to the design of the database? -
Ans:✔✔-Logical design phase and Physical design phase
What are the components of the query processor? - Ans:✔✔--DML compiler
-DDL interpreter
-Query evaluation engine
T/F: It is desirable for all users to see the entire logical model. - Ans:✔✔-False
T/F: Atomicity refers to the requirements that either all of a transaction must occur or none of it. -
Ans:✔✔-True
Page 4/62
FIRST PUBLISH OCTOBER 2024
CS 430 Database System Exam Practice
Questions and Answers
What are the data structures the storage manager implements as part of the physical system? - Ans:✔✔-
-Data files
-Data dictionary
-Indices
I've just added a new person to the Employee database and I did not have to alter my application that
uses this database. This is an example of which type of abstraction? - Ans:✔✔-Logical
T/F: An object-oriented data model permits the specification of data where individual data items of the
same type many have different sets of attributes. - Ans:✔✔-False
Typical functions of a database administrator would include what? - Ans:✔✔--Storage structure and
access-method definition
-Schema definition
-Security and access rights definition
Page 1/62
, ©GRACEAMELIA 2024/2025 ACADEMIC YEAR. ALL RIGHTS RESERVED
FIRST PUBLISH OCTOBER 2024
What are disadvantages to file processing systems? - Ans:✔✔--Operating systems provide only a
password mechanism for access control
-We must protect the data from inconsistent changes made by different users accessing the data
concurrently
-We must ensure the data is restored to a consistent state if the system cashes while changes are being
made
-We need special programs to answer each question a user may want to ask about the data
Database users and definition - Ans:✔✔--Naive user: unsophisticated users accessing the system through
application programs
-Application programmers: Computer professionals who write packages that facilitate access for end
users
-Sophisticated/Specialized users: Users who interact with the system and/or write specialized database
applications
-Database administrators: Professionals that design and maintain the database
T/F: The DDL interpreter of the query processor is responsible for query optimization. - Ans:✔✔-False
What operations require the relation instances they are operating on to be union-compatible? - Ans:✔✔-
Intersection, Union, Set-difference
Page 2/62
, ©GRACEAMELIA 2024/2025 ACADEMIC YEAR. ALL RIGHTS RESERVED
FIRST PUBLISH OCTOBER 2024
What are common subqueries - a select-from-where expression nested within another query? - Ans:✔✔-
-set comparison
-test for empty relations
-test for the absence of duplicate tuples
-set membership
A language that is used to express database queries and updates is called? - Ans:✔✔-A data
manipulation language
T/F: An attribute takes a null value when the value of the attribute is computed to be zero. - Ans:✔✔-
False
T/F: Data mining refers loosely to the process of semiautomatically analyzing raw input such as
newspapers and field data to create reports. - Ans:✔✔-False
Responsibility for the component of DBMS architecture - Ans:✔✔--Recovery manager: Ensures
transaction atomicity and durability
-Transaction manager: Controls the execution of the transactions
-Lock managers: Grants and releases locks appropriately
Page 3/62
, ©GRACEAMELIA 2024/2025 ACADEMIC YEAR. ALL RIGHTS RESERVED
FIRST PUBLISH OCTOBER 2024
T/F: Durability refers to the fact that values within a database must survive system failures. - Ans:✔✔-
True
T/F: The person that has central control over a DBMS is called a DataBase Administrator (DBA). -
Ans:✔✔-True
I've just changed the indexing scheme for a certain database. The change is transparent to the rest of the
database and other applications. This is an example of which type of abstraction? - Ans:✔✔-Physical
A data dictionary contains _____, data about data. - Ans:✔✔-metadata
A language in which a user specifies a database schema is called? - Ans:✔✔-a data definition language
In what phases does the design move from an abstract data mode to the design of the database? -
Ans:✔✔-Logical design phase and Physical design phase
What are the components of the query processor? - Ans:✔✔--DML compiler
-DDL interpreter
-Query evaluation engine
T/F: It is desirable for all users to see the entire logical model. - Ans:✔✔-False
T/F: Atomicity refers to the requirements that either all of a transaction must occur or none of it. -
Ans:✔✔-True
Page 4/62
