Q.1. One of the functions of the arithmetic logic unit is to _______.
(1) receive data from the registers.
(2) convert negative numbers to hexadecimal code.
(3) send logical operations, such as AND or NOT, to the alphabetic unit.
(4) retrieve data from virtual memory.
(5) None of these
Q.2. Random Access Memory is ______
(1) faster than cache memory.
(2) essential for long-term storage.
(3) integrated within the CPU.
(4) determined by the type and speed of the CPU.
(5) Use for temporary storage.
Q.3. Table is synonymous with the term ________.
(1) record
(2) relation
(3) column
(4) field
(5) Tuple
Q.4. A tuple is a(n) _______.
(1) column of a table
(2) two dimensional table
(3) row of a table
(4) key of a table
(5) Attribute of table
Q.5. A key ______.
(1) must always be composed of two or more columns
(2) can only be one column
(3) identifies a row
(4) identifies a column
(5) identifies a table
Q.6. When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n) ______.
(1) transitive dependency
(2) insertion anomaly
(3) referential integrity constraint
(4) normal form
(5) Intigrity
Q.7. The simplest way to break a deadlock is to _______.
(1) preempt a resource
(2) rollback
(3) kill one of the processes
(4) lock one of the processes
(5) none of the above
Q.8. Which of the following file format supports in Windows 7 ?
(1) BSD
(2) NTFS
(3) EXT
(4) All of these
(5) None of these
Q.9. A page fault means that we referenced a page ______.
(1) outside the memory boundaries
(2) with an incorrect I/O request
(3) that was not in secondary storage
(4) that was not in main memory
(5) none of these
Q.10. The part of machine level instruction, which tells the central processor what has to be done, is _____
(1) Operation code
(2) Address
(3) Locator
(4) Flip-Flop
(5) None of the above
Answers
Q.1. (1) One of the functions of the arithmetic logic unit is to receive data from the registers
Q.2. (4) Random Access Memory is determined by the type and speed of the CPU
Q.3. (2) Table is synonymous with the term relation.
Q.4. (3) A tuple isa row of a table.
Q.5. (3) A key identifies a row.
Q.6. (3) When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a referential integrity constraint.
Q.7. (3)The simplest way to break a deadlock is to kill one of the processes.
Q.8. (2) NTFS file format supports in Windows 7.
Q.9. (4) A page fault means that we referenced a page that was not in main memory.
Q.10. (1) The part of machine level instruction, which tells the central processor what has to be done, is called operation code.