Computer gk 24 may

In OSI network architecture, the routing is performed by ............. ?

(1) Network layer 

(2) Data link layer 

(3) Transport layer 

(4) Session layer 

(5) None of these

Q.2. Which of the following performs modulation and demodulation ? 

(1) Fiber optics 

(2) Satellite 

(3) Coaxial Cable 

(4) Encoder/Decoder 

(5) None of these 

Q.3. Which is the first layer of OSI model-

(1) Physical layer 

(2) Link layer 

(3) Transport layer 

(4) Network layer 

(5) None of these 

Q.4. Which of the following is not a transmission medium ?

(1) Telephones lines 

(2) Coaxial cables 

(3) Modem 

(4) Micro wave system 

(5) None of these

Q.5. What is the minimum number of wires needed to send data over a serial communication link layer ?

(1) 1 

(2) 2 

(3) 4 

(4) 6 

(5) None of these

Q.6. The loss in signal power as light travels down the fiber is called

(1) Attenuation 

(2) Interruption 

(3) Scattering 

(4) Propogation 

(5) None of these

Q.7. Device that connect to the network without using cables is called———.

(1) Distributed 

(2) Wireless 

(3) Centralized 

(4) Open source 

(5) None of these 

Q.8. The most important and powerful computer are typically____.

(1) Desktop 

(2) Network client 

(3) Network server 

(4) Networkstation 

(5) Super computer 

Q.9. Example of connectivity is_______.

(1) Internet 

(2) Floppy disk 

(3) Powercord 

(4) Data 

(5) None of these 

Q.10. Which of the following has highest complex interconnection ?

(1) Bus 

(2) Ring 

(3) Star 

(4) Mesh 

(5) None of these 

ANSWERS

Q.1. (1) Network layer 

Q.2. (5) None of these 

Q.3. (1) Physical layer 

Q.4. (3) Modem 

Q.5. (2) 2 

Q.6. (1) Attenuation 

Q.7. (2) Wireless 

Q.8. (5) Super computer 

Q.9. (1) Internet is example of connectivity.

Q.10. (4) Mesh 

Computer gk 23 may

Q.1. The full form of DDL is _______?

(1) Dynamic Data Language 

(2) Detailed Data Language 

(3) Data Definition Language 

(4) Data Derivation Language 

(5) Data Dimensional Language 

Q.2. Which of the following is an advantage of a View?

(1) Data security 

(2) Derived columns 

(3) Hiding of complex queries 

(4) All of the above 

(5) None of these

Q.3. Which database level is closest to the users?

(1) External 

(2) Internal 

(3) Physical 

(4) Conceptual 

(5) None of these 

Q.4. Which are the two ways in which entities can participate in a relationship?

(1) Passive and active 

(2) Total and partial 

(3) Simple and Complex 

(4) All of the above 

(5) None of these 

Q.5. The result of the UNION operation between R1 and R2 is a relation that includes _______.

(1) All the tuples of R1 

(2) All the tuples of R2 

(3) All the tuples of R1 and R2 

(4) All the tuples of R1 and R2 which have common columns 

(5) None of these 

Q.6. Which of the following option appropriate is a comparison operator in SQL?

(1) = 

(2) LIKE 

(3) BETWEEN 

(4) All of the above 

(5) None of these 

Q.7. ________ is a process when relation between two entity is treated as a single entity.

(1) Normalization 

(2) Aggregation 

(3) Generalization 

(4) Specialization 

(5) Simplification 

Q.8. In an ER Diagram, ellipse with underlying lines is used to represent _________?

(1) attribute 

(2) Key attribute 

(3) Composite attribute 

(4) Multivalued attribute 

(5) Entity 

Q.9. _________ constraint is used to restrict actions that would destroy links between tables?

(1) Primary key 

(2) Foreign Key 

(3) Check 

(4) Not Null 

(5) Unique 

Q.10. In a table of data base, degree refers- 

(1) total numer of row 

(2) row in a table 

(3) column in a table 

(4) total number of column in a table 

(5) none of these 

ANSWERS

Q.1. (3) DDL stands for Data Definition Language.

Q.2. (4) All are advantages of view.

Q.3. (1) External database level is closest to the users.

Q.4. (2) Total and partial.

Q.5. (4) All the tuples of R1 and R2 which have common columns.

Q.6. (4) =, Like and Between are comparison operators in SQL.

Q.7. (2) Aggregation is a process when relation between two entities is treated as a single entity.

Q.8. (2) In an ER Diagram, ellipse with underlying lines is used to represent Key attribute.

Q.9. (2) Foreign Key constraint is used to restrict actions that would destroy links between tables.

Q.10. (4) Total mumber of column