2. Abacus was the first ___ Electronic computer Mechanical computer Electronic calculator Mechanical calculator
3. If in a computer, 16 bits are used to specify address in a RAM, the number of addresses will be ___ 216 65,536 64K 128K
4. Instructions and memory address are represented by ___ Character code Binary code Binary word Parity bit
5. A set of flip flops integrated together is called ____ Counter Adder Register Flip flop
6. Which of the following is used for manufacturing chips? Bus Control unit Semiconductors a and b only
7. A special high-speed line used by large corporations to support digital communications is known as: satellite/air connection service lines cable modems digital subscriber lines T1, T2, T3 and T4 lines
8. An affordable technology that uses existing telephone lines to provide high-speed connections is called ________. ISDN Microwave cable modem DSL
9. A page fault: Is an error in a specific page Occurs when a program accesses a page of memory Is an access to a page not currently in memory None of the above
10. The process of transferring data intended for a peripheral device into a disk or intermediate store so that it can be transferred to peripheral at a more convenient time or in bulk, is known as ___. Multiprogramming Spooling Caching Virtual programmin
Score = Correct answers:
2. Web pages are saved in ______ Format http:// HTML DOC URL
3. What are the two parts of an E-mail address? User name and street address Legal name and phone number User name and domain name initials and password
4. If employees reside in different parts of the country and need to meet monthly, useful computer technology would be video-display software video digitizing video conferencing video scanning
5. The wheel located between the two standard buttons on a mouse is used to click in Web pages shut down click and select items scroll
6. The computer that hosts your e-mail account is known as a (n) Host E-mail client E-mail server Web Server
7. A touchpad responds to light pressure clicking the sense of heat from fingertips
8. What is the term for calculations used within spreadsheets? analysis ranges formulas recalculations
9. Choose the pointing device in computer System? mouse trackball touchpad pointing stick
10. This is a set of values that you want to chart in Excel? Object Numbers Data Series Formulas
2. Which command is used to remove an index from the database in SQL? DELETE INDEX DROP INDEX REMOVE INDEX ROLL BACK INDEX
3. What is the name given to the database management system which is able to handle full text data, image data, audio and video? Full media Graphics media Multimedia Hypertext
4. Which password management feature ensures a user cannot reuse a password for a specified time interval? Account Locking Password History Password Verification Password Expiration and Aging
5. Which privilege is required to create a database? SYSDBA DBA SYSOPER RESOURCE
6. What is the type of Oracle backup in which all uncommitted changes have been removed from the datafiles? Full Backup Consistent Backup Inconsistent Backup Differential Backup
7. Which type of file is part of the Oracle database? Control file Password file Parameter files Archived log files
8. What type of failure occurs when Oracle fails due to an operating system or computer hardware failure? Application failure Instance Failure Media Failure Rollback failure
9. What Oracle backup and recovery file contains user and system data? Control file Data file OnLine ReDo file Offline ReDo file
10. When is the SGA created in an Oracle database environment? When the database is created When a user process is started When the database is mounted When the instance is started
2. Each of data files has a _______ that describe the way the data is stored in the file. File Structure Records Fields Databases
3. What is the language used by most of the DBMS for helping their users to access data? High level language Query language SQL 4GL
4. Data item characteristics that are important in data management include Punctuation Language Spelling Width
5. A locked file can be Accessed by only one user Modified by users with the correct password Is used to hide sensitive information Both (b) and (c)
6. If the record management system allows you to edit values before they are recorded on disk, you can Correct spelling changes before they are recorded Change the name of a field Change the width of a field All of the above
7. Which command is used to remove an index from the database in SQL? DELETE INDEX DROP INDEX REMOVE INDEX ROLL BACK INDEX
8. What is the name given to the database management system which is able to handle full text data, image data, audio and video? Full media Graphics media Multimedia Hypertext
9. When using a database management system, the first thing that you must do is to Create a database file Activate file editor Load the software into your microcomputer Keep a floppy disk in readiness
10. If the record management system allows you to edit values before they are recorded on disk, you can Correct spelling changes before they are recorded Change the name of a field Change the width of a field All of the above
2. Memory unit accessed by content is called ______ Read only memory Programmable memory Virtual Memory Associative memory
3. n bits in operation code imply that there are ______ possible distinct operators n 2n n/2 n2
4. A three input NOR gate gives logic high output only when____ one input is high one input is low two input are low all input are high
5. The multiplicand register & multiplier register of a hardware circuit implementing booth’s algorithm have (11101) & (1100). The result shall be _____ (812)10 (-12)10 (12)10 (-812)10
6. PSW is saved in stack when there is a _____ interrupt recognized execution of RST instruction Execution of CALL instruction All of these
7. In computers, subtraction is carried out generally by _____ 1’s complement method 2’s complement method signed magnitude method BCD subtraction method
8. Cache memory works on the principle of ______ Locality of data Locality of memory Locality of reference Locality of reference & memory
9. When CPU is executing a program that is part of the Operating system, it is said to be in _____ Interrupt mode System mode Half mode Simplex mode
10. Register renaming is done in pipelined processors as an alternative to register allocation at compile time for efficient access to function parameters and local variables to handle certain kinds of hazards as part of address
2. Which of the following registers is used to keep track of address of the memory location where the next instruction is located? Memory Address Register Memory Data Register Instruction Register Program Register
3. Pipelining strategy is called implement instruction execution instruction prefetch instruction decoding instruction manipulation
4. When the RET instruction at the end of subroutine is executed, the information where the stack is initialized is transferred to the stack pointer the memory address of the RET instruction is transferred to the program counter two data bytes stored in the top two locations of the stack are transferred to the program counter two data bytes stored in the top two locations of the stack are transferred to the stack pointer
5. What is meant by a dedicated computer? which is used by one person only which is assigned to one and only one task which does one kind of software which is meant for application software only
6. The most common addressing techniques employed by a CPU is immediate direct indirect All of the above
7. When a subroutine is called, the address of the instruction following the CALL instructions stored in/on the stack pointer accumulator program counter stack
8. Interrupts which are initiated by an instruction are internal external hardware software
9. Memory access in RISC architecture is limited to instructions CALL and RET PUSH and POP STA and LDA MOV and JMP
10. MIMD stands for ______ Multiple instruction multiple data Multiple instruction memory data Memory instruction multiple data Multiple information memory data