A directory of Objective Type Questions covering all the Computer Science subjects.

1. Given the evolution of DBMSs, business data is now:
a. Stored in main memory and stays resident there even after the application that uses it terminates.
b. Stored only if it is relevant to business decisions.
c. Stored indefinitely in case it's needed since storing it is much cheaper now.
d. None of the above.
View Answer Report Discuss Too Difficult! Search Google
Answer: (b).Stored only if it is relevant to business decisions.

2. Which of the following is not true of a DBMS?
a. It provides efficient storage and retrieval of data.
b. It has evolved over the years into a fairly simple set of tools that are relatively easy to master.
c. Marketplace demands and product innovation have led to the development of a broad range of features.
d. None of the above.
View Answer Report Discuss Too Difficult! Search Google
Answer: (b).It has evolved over the years into a fairly simple set of tools that are relatively easy to master.

3. Nonprocedural access to a database:
a. Can provide a dramatic improvement in software productivity.
b. Allows a user to submit queries to a database without having to know how the data will be retrieved.
c. Is supported by more than one tool in most DBMSs.
d. All of the above.
View Answer Report Discuss Too Difficult! Search Google
Answer: (d).All of the above.

4. Which of the following statements is not true of a desktop DBMS?
a. They usually run on personal computers or small servers.
b. They have a much lower cost than other DBMSs.
c. Although useful for processing ad hoc queries, they cannot perform transaction processing.
d. They usually support databases used by work teams and small businesses.
View Answer Report Discuss Too Difficult! Search Google
Answer: (c).Although useful for processing ad hoc queries, they cannot perform transaction processing.

5. In the evolution of database technology, second-generation products are considered to be the first true DBMSs because:
a. They were "navigational", i.e. the programmer had to write code to navigate through a network of linked records.
b. Of their foundation on mathematical relations and associated operators.
c. They supported sequential and random searching.
d. They could manage multiple entities and relationships.
View Answer Report Discuss Too Difficult! Search Google
Answer: (d).They could manage multiple entities and relationships.

6. In the evolution of database technology, third-generation products supplanted second-generation systems because:
a. Nonprocedural database access was an improvement over navigational access.
b. IBM supported the CODASYL standard of database definition and manipulation.
c. Nonprocedural languages were still not very efficient.
d. All of the above.
View Answer Report Discuss Too Difficult! Search Google
Answer: (a).Nonprocedural database access was an improvement over navigational access.

Page 1 of 9

copyright 2016 computer science bitsCompscibits.com