| Q 1: | What is the RDBMS terminology for a set of legal values that an attribute can have? |
| (1) | Tuple |
| (2) | Relation |
| (3) | Attribute |
| (4) | Domain |
| Correct Answer: Domain | |
| Q 2: | Which qualifier is used to remove duplicate rows from the result of SELECT statement? |
| (1) | SINGLE |
| (2) | DISTINCT |
| (3) | UNIQUE |
| (4) | ONLY |
| Correct Answer: DISTINCT | |
| Q 3: | A locked file can be |
| (1) | Accessed by only one use |
| (2) | Modified by users with the correct password |
| (3) | is used to hide sensitive information |
| (4) | Both 2 and 3 |
| Correct Answer: Both 2 and 3 | |
| Q 4: | ..... provides a basic electronic mail transport facility |
| (1) | TELNET |
| (2) | SNMP |
| (3) | SMTP |
| (4) | UDP |
| Correct Answer: SMTP | |
| Q 5: | Consider the following relational schema pertaining to a students database. Student: (rollno, name, address) Enroll: (rollno, courseno, coursename) Where the primary keys are shown underlined. The number of tuples in the Student and the Enroll tables are 120 and 8 respectively. What are the maximum and the minimum number of tuples that can be present in (Student * Enroll), where * denotes natural join? |
| (1) | 120,8 |
| (2) | 8,8 |
| (3) | 960,8 |
| (4) | 960,120 |
| Correct Answer: 960,120 | |
| Q 6: | Which of the following provide inter-switch VLAN communication? 1. ISL 2. VTP 3. 802.1 Q 4. 802.3 Z |
| (1) | 2 only |
| (2) | 1 and 3 |
| (3) | 2 and 4 |
| (4) | 2,3 and 4 |
| Correct Answer: 1 and 3 | |
| Q 7: | In computer network terminology RTS is |
| (1) | Ready to Sequence |
| (2) | Ready Task Set |
| (3) | Request to Send |
| (4) | Ready Time Status |
| Correct Answer: Request to Send | |
| Q 8: | AMPS has a frequency reuse factor of.................. |
| (1) | 1 |
| (2) | 3 |
| (3) | 5 |
| (4) | 7 |
| Correct Answer: 7 | |
| Q 9: | Deep structure testing is not designed to |
| (1) | Examine Object Behaviours |
| (2) | Exercise Communication Mechanisms |
| (3) | Exercise Object Dependencies |
| (4) | Exercise Structure Observable By The User |
| Correct Answer: Exercise Structure Observable By The User | |
| Q 10: | Traditionally, the only phase of software development where a formal approach is used is |
| (1) | Programming |
| (2) | Design |
| (3) | Requirements |
| (4) | Planning |
| Correct Answer: Programming | |