Q 1: | DML is provided for |
(1) | Description of logical structure of database |
(2) | Addition of new structures in the database system |
(3) | Manipulation & processing of database |
(4) | Definition of physical structure of database system |
Correct Answer: Manipulation & processing of database | |
Q 2: | A transaction file stores |
(1) | Data that rarely changes |
(2) | Data that never changes |
(3) | Data that frequently changes |
(4) | Data that is erroneous |
Correct Answer: Data that frequently changes | |
Q 3: | Relations produced from an E-R model will always be in |
(1) | First normal form |
(2) | Second normal form |
(3) | Third normal form |
(4) | Fourth Normal Form |
Correct Answer: First normal form | |
Q 4: | A PL/SQL block can return data to SQL * plus through |
(1) | bind variables |
(2) | Subsctitution variables |
(3) | local variables |
(4) | none |
Correct Answer: bind variables | |
Q 5: | Which one is not advantage of stored procedure |
(1) | Increases network traffic |
(2) | Allows code sharing |
(3) | Greater security |
(4) | Optimise DBMS |
Correct Answer: Increases network traffic | |
Q 6: | Which of the following is reliable communication |
(1) | IP |
(2) | UPD |
(3) | UDP |
(4) | TCP |
Correct Answer: TCP | |
Q 7: | Multi point topology is |
(1) | Bus |
(2) | Star |
(3) | Mesh |
(4) | Ring |
Correct Answer: Bus | |
Q 8: | DHCP is used for |
(1) | IPv4 |
(2) | IPv6 |
(3) | Both |
(4) | None |
Correct Answer: Both | |
Q 9: | Data encryption |
(1) | is mostly used by public networks |
(2) | is not necessary, since data cannot be intercepted |
(3) | is mostly used by financial networks |
(4) | none |
Correct Answer: is mostly used by financial networks | |
Q 10: | Which one of the following is not a client-server application? |
(1) | Internet chat |
(2) | Web browsing |
(3) | |
(4) | Ping |
Correct Answer: Ping | |