INF 3703 ACTUAL FINALS ANSWERS AND QUESTIONS SET A.pdf

INF 3703 ACTUAL FINALS ANSWERS AND
QUESTIONS SET A+
✔✔A database management system (DBMS) must have validation, transformation, and
mapping functions, as well as other functions, in order to be classified as distributed.

a. True
b. False - ✔✔a. True

✔✔Distributed processing shares a database's logical processing among two or more
physically independent sites that are connected through a network.

a. True
b. False - ✔✔a. True

✔✔Distributed data access was needed to support geographically dispersed business
units.

a. True
b. False - ✔✔a. True

✔✔Indexes do not facilitate join operations.

a. True
b. False - ✔✔b. False

✔✔Atomicity indicates the permanence of the database's consistent state.

a. True
b. False - ✔✔b. False

✔✔Time stamping demands a lot of system resources because many transactions
might have to be stopped, rescheduled, and restamped.

,a. True
b. False - ✔✔a. True

✔✔All factors must be checked to ensure that each system component operates at its
optimum level and has sufficient resources to minimize the occurrence of bottlenecks.

a. True
b. False - ✔✔a. True

✔✔Most current-generation relational DBMSs perform automatic query optimization at
the client end.

a. True
b. False - ✔✔b. False

✔✔A distributed database management system (DDBMS) must be communications-
media-dependent.

a. True
b. False - ✔✔b. False

✔✔Data warehouse data are organized and summarized by table, such as CUSTOMER
and ADDRESS.

a. True
b. False - ✔✔b. False

✔✔When using an optimistic approach, during the read phase, a transaction reads the
database, executes the needed computations, and makes the updates to a private copy
of the database values.

a. True
b. False - ✔✔a. True

✔✔An application programming interface (API) uses script files that perform specific
functions based on the client's parameters that are passed to the web server.

a. True
b. False - ✔✔b. False

✔✔System support activities cover all tasks directly related to the day-to-day operations
of a DBMS and its applications.

a. True

,b. False - ✔✔a. True

✔✔A lock guarantees the open use of a data item to multiple transactions.

a. True
b. False - ✔✔b. False

✔✔All transaction management commands are processed during the parsing and
execution phases of query processing.

a. True
b. False - ✔✔a. True

✔✔An optimistic approach is based on the assumption that the majority of the database
operations do not conflict.

a. True
b. False - ✔✔a. True

✔✔The SQL cache stores the end-user written SQL.

a. True
b. False - ✔✔b. False

✔✔Serializability means that data used during the execution of a transaction cannot be
used by a second transaction until the first one is completed.

a. True
b. False - ✔✔b. False

✔✔Normalizing fact tables improves data access performance and saves data storage
space.

a. True
b. False - ✔✔b. False

✔✔Data stored in the company database must be protected from access by
unauthorized users. Data measures include all of the following EXCEPT....

1 - User authentication
2 - Physical security
3 - Data encryption
4 - Top down authentication - ✔✔4 - Top down authentication

, ✔✔During which phase is the right to use the database specified?

1- Logic
2- Conceptual
3- Physical - ✔✔3- Physical

✔✔The logic design translate the software ........ conceptual model into a software ......
Model

1- Dependant, independent
2- Independent, dependant
3- Dependant, dependant
4- Independent, independent - ✔✔2- Independent, dependant

✔✔Which one of the following is NOT part of the four steps of conceptual model?

1- Data analysis and requirements
2- Data model verification
3- Assigning and validating integrity constraints
4- Entity Relationship Modeling and normalization - ✔✔3- Assigning and validating
integrity constraints

✔✔The physical Design is which stage of the database design Process?

1- Stage 1
2- Stage 2
3- Stage 3
4- Stage 4 - ✔✔3- Stage 3

✔✔..... provides for data collection, storage and retrieval?

1- Information system
2- System Development
3- System analysis - ✔✔1- Information system

✔✔The performance of an Information System depends on a ... of factors?

1- Line
2- Group
3- Triad
4- Number - ✔✔3- Triad

✔✔Which of the following is NOT one of the Factors that Information system Depends
on?