CS101 Quiz 5

Q1. _________loop structure referred to as a post-test loop

1. While
2. For
3. Repeat
4. For each

Correct answer: Repeat

Q2. A subschema pertains to ______.

1. primary records
2. a particular user's needs
3. external information
4. the entire database

Correct answer: a particular user's needs

Q3. Operations that are only partially completed in commercial systems might lead to ___________ information in the database.

1. Accurate
2. Incomplete
3. Valid
4. Verified

Correct answer: Incomplete

Q4. The problem known as the ____________ can arise if one transaction is in the middle of transferring funds from one account to another when another transaction tries to compute the total deposits in the bank.

1. potential problem
2. lost update problem
3. time sharing
4. incorrect summary problem

Correct answer: incorrect summary problem

Q5. In the traditional waterfall model, what is the task of the SQA group before the design stage begins?

1. Approving software requirements specification
2. Approving the design
3. Certifying the conceptual final product
4. Overseeing the implementation

Correct answer: Approving software requirements specification

Q6. The syntax used to perform the select operation in creating a new relation is represented as ____________.

1. from NEW <- SELECT
2. NEW <- from SELECT
3. NEW <- SELECT from
4. SELECT NEW <- from

Correct answer: NEW <- SELECT from

Q7. The statement z=x+y shows

1. The sum of x and z be assigned to the variable y
2. The X and Y be assigned to the variable Z
3. The sum of X and Y be assigned to the variable Z
4. The Y be assigned to the variable Z

Correct answer: The sum of X and Y be assigned to the variable Z

Q8. Database technology, combined with data mining techniques, is an important ___________ tool.

1. Communication
2. Data storage
3. Financial
4. Decision-making

Correct answer: Decision-making

Q9. An alternative to translators

1. Interpreter
2. Compiler
3. Mnemonics
4. Assembler

Correct answer: Interpreter

Q10. Choose the correct labels for the diagrams of iterative structures given below.

1. Both are Posttest
2. A is Posttest and B is PreTest
3. Both are Pretest
4. A is Pretest and B is PostTest

Correct answer: A is Posttest and B is PreTest