| Q 1: | Which operation sets LOCK(X) to 0 |
| (1) | unlock_item(X) |
| (2) | lock_item(X) |
| (3) | dlock(X) |
| (4) | All |
| Correct Answer: unlock_item(X) | |
| Q 2: | A.......... is collection of related fields that can be treated as a unit by some application program |
| (1) | Field |
| (2) | File |
| (3) | Database |
| (4) | Record |
| Correct Answer: Record | |
| Q 3: | The syntax of the users query is verified by the |
| (1) | Parser |
| (2) | The database manager |
| (3) | Query optimizer |
| (4) | Programmer |
| Correct Answer: Parser | |
| Q 4: | A foreign key must |
| (1) | Be numeric |
| (2) | Be unique |
| (3) | Be defined in all tables within the database |
| (4) | Match the field value of a primary key in a related table |
| Correct Answer: Match the field value of a primary key in a related table | |
| Q 5: | Which of the following is not a file operation? |
| (1) | Find |
| (2) | Find next |
| (3) | Reset |
| (4) | None |
| Correct Answer: Reset | |
| Q 6: | Which of the following is dense index |
| (1) | Primary index |
| (2) | Clusters index |
| (3) | Secondary index |
| (4) | Secondary non key index |
| Correct Answer: Secondary index | |
| Q 7: | If a file consisting of 50,000 characters takes 40 seconds to send, then the data rate is |
| (1) | 1 kbps |
| (2) | 1.25 kbps |
| (3) | 2 kbps |
| (4) | 10 kbps |
| Correct Answer: 10 kbps | |
| Q 8: | The............. was designed to provide security at the transport layer |
| (1) | AH |
| (2) | ESP |
| (3) | TLS |
| (4) | None |
| Correct Answer: TLS | |
| Q 9: | IPSec defines two protocols:............ and .............. |
| (1) | AH:SSP |
| (2) | ESP:SSP |
| (3) | AH:EH |
| (4) | None |
| Correct Answer: None | |
| Q 10: | The division of a message into segments is a function of the |
| (1) | Physical |
| (2) | Network |
| (3) | Transport |
| (4) | Data link |
| Correct Answer: Transport | |