1. What is SMTP?
- Simpler Mailer Transport Protocol
- Simple Mail Transport Protocol
- Single Mail Transport Protocol
- Simple Message Transport Protocol
2. What is the default port number for FTP?
- 21
- 25
- 18
- 20
3. An array consists of components which are all of the same type, called its base type; it is therefore called ….. structure.
- Relational
- Homogenous
- Heterogenous
- Base
4. A ………. is a data structure that organizes data similar to a line in the supermarket, where the first one in line is the first one out.
- Queue linked list
- stacks linked list
- both of them
- none of them
5. SQL was developed as an integral part of
- A hierarchical database
- a flat file database
- a data warehouse
- a relational database
6. Which of the following statements will list only those students who have children and order the output by the number of children they have a (running from those who have 1 child through to those who have most)
- SELECT * from studrec WHERE kids>0 ORDER BY kids;
- SELECT * from studrec WHERE kids>0 ORDER BY kids;
- SELECT * from studrec ORDER BY kids WHERE kids>0;
- SELECT * from studrec ORDER BY kids DESC WHERE kids>0;
7. ….. enables a process to use a memory (RAM) adress space that is independent of other processes running in the same system and use a space that is larger than the actual amount of RAM present, temporarily relagating some contents from RAM to a disk. with little or no overhead.
- Virtual memory
- Main memory
- Volatile memory
- Secondary memory
8. Which of the following statements is true?
- The more data a data warehouse has, the better it is
- A data warehouse is a relatively straight-forward thing to set up\
- A data warehouse automatically makes a copy of every transaction recorded in an OLTP system
- Adding data for the same of it may well degrade the effectiveness of data warehousing analysis
9. Which of the following binary number is equivalent to decimal 10
- 1000
- 1100
- 1010
- 1001
10. Which command will delete all data from a table and will not write to the rollback segment?
- DROP
- DELETE
- CASCADE
- TRUNCATE
11. A RAID system is useful because
- it increases processor speed
- increases disk storage capacity
- increases OS efficiency
- increases disk storage capacity and availability
12. The communication mode that supports two way traffic but only one direction at a time is
- simplex
- half duplex
- duplex
- multi duplex
13. Which memory does not require programming equipment
- PROM
- EEPROM
- ROM
- EPROM
14. TCP divides the data into chunks called …. and gives each one a number
- Packets
- Bits
- Byte
- Frames
15. The Primary Key Constraints ensure that
- Column cannot be null
- Unique Value
- Both
- None of these
16. The process related to process contro, file management, device management information about system and communication that is requested by any higher level language can be performed by ….
- Editors
- Compilers
- System call
- Caching
17. FIFO scheduling is
- Preemptive scheduling
- None Preemptive scheduling
- Deadline scheduling
- Fair share scheduling
18. Which of the Following contains a compelte record of all activity that affected the contents of a database during a certain period of time?
- Report writer
- query language
- data manipulation language
- transaction log
19. IP telephony refers to
- Voice as IP packets over Packet-switched Network
- Telephone though public Switching telephone Network
- Voice over Telephone Network
- Voice as Packet in PSTN