Posts

Showing posts from December 1, 2015

DATA COMMUNICATION AND NETWORKS

DATA COMMUNICATION AND NETWORKS DATA COMMUNICATION AND NETWORKS 1. Define the term Computer Networks. A Computer network is a number if computers interconnected by one or more transmission paths. The transmission path often is the telephone line, due to its convenience and universal preserve. 2. Define Data Communication. Data Communication is the exchange of data (in the form of Os and 1s) between two devices via some form of transmission medium (such as a wire cable). 3. What is the fundamental purpose behind data Communication? The purpose of data communication is to exchange information between two agents. 4. List out the types of data Communication. Data Communication is considered Local – if the communicating device are in the same building. Remote – if the device are farther apart. 5. Define the terms data and information. Data: is a representation of facts, concepts and instructions presented in a formalized manner suitable for communication, interpretation ...

DATA BASE MANAGEMENT SYSYTEM

DATA BASE MANAGEMENT SYSYTEM dbms (QNO1). A relation with redundancy can be refined by ----------- using with smaller relations that contain the same information but without redundancy A. Decomposing it B. Updating it C. Inserting it D. Deletion it The solution is : a (QNO2). Which of the following one is not an example of integrity constraints A. Functional dependency B. Multivalued dependency C. Join dependency D. Multilevel dependency The solution is : d (QNO3). Which of the following one is not caused by redundancy problems A. Redundant storage B. Update anomalies C. Insertion anomalies D. Multivalued dependency The solution is : d (QNO4). In a FD the right side contains only attributes that also appear on the left side is Called ________ A. Functional FD B. Trival FD C. Non functional FD D. Non trival The solution is : b (QNO5). ________ is more than one place within a database can occur A. Consistency B. Redundancy C. Durability D. Isolation The...