Important Objective Question For Internet & Web Techonolgy

1-A header in CGI script can specify- Format of the document & New location of the document.

2- All except ion in Java are subclasses of built in class called Throwable.

3- In 32 bit IP Addressing scheme all 1’s represent limited broadcast.

4- DMSP stands for – Distributed Mail system Protocol.

5- Presentation layer is not present in TCP/ IP Model .

6- Left Most segment of a name in DNS represents- Individual computer

7- Address 192.5.48.3 belongs to class C.

8- The term byte stuffing refers to data stuffing used with character -oriented hardware.

9- FDDI is an example of token ring.

10- Hardware that calculates CRC uses shift register and Xor unit .

11- In TCP protocol header checksum is of 16 bi ts.

12- In IP addressing scheme, class used for multicasting is class D.

13- CIDR stands for Classless Inter Domain Routing.

14- The total number of class of IP addresses are 5.

15- Parent class of all Java classes is java. lang.object .

16- Exceptions of type error in JAVA are handled by JAVA run time Environment

17- Error detecting method that can detect more errors without increasing additional informat ion in each packet is CRC.

18- MTU is specified by hardware technology.

19- Network address prefixed by 1110 is a multicast address.

20- FTP does not use User Datagram Protocol .

21- A header in CGI document can represent format of the document and the location if document used to different URL.

22- 127.0.0.1 is a loop-back address.

23- In cyclic redundancy checking CRC is the remainder.

24- Gateway uses the greatest number of layers in the OSI model .

25- 802.5 standards provides for a collision free protocol .

26- The addressing specially used by transport layer is application port address.

27- ICMP is an error reporting protocol .

28- Active web document is run at client side.

29- The main function of a browser is to interpret HTML.

30- MIB is associated with SNMP.

31- ATM is an example of- Star topology

32- The first part of the address in electronic mailbox identifies:- User’s mail  lnbox.

33- Protocol used to monitor and control network devices operates at :- Application layer .

34- DHCP stands for- Dynamic Host Configuration Protocol .

35- The transport protocol used by TFTP (Trivial File Transfer Protocol ) is: UDP.

Important Objectives For Database Management System

1.      In the relational modes, cardinality is termed as : Number of tuples.

2.      Relational calculus is a : Non- Procedural language.

3.      The view of total database content is : Conceptual view.

4.      Cartesian product in relational algebra is-a Binary operator.(It requires two operands)

5.      DML is provided for -manipulation & processing of database.

6.      Data stored in the database is processed or manipulated using data manipulation language commands as its name

7.      ‘AS’ clause is used in SQL for-Rename operation.

8.      ODBC stands for-Open Database Connectivity.

9.      Architecture of the database can be viewed as-three levels.

10.  In a relational model, relations are termed as-Tables.

11.  The database schema is written in-DDL

12.  In the architecture of a database system external level is the-view level.

13.  An entity set that does not have sufficient attributes to form primary key is -weak entity set

14.  In a Hierarchical model records are organized as-Tree.

15.  In tuple relational calculus P1 _ P2 is equivalent to ¬P1 Ú P2. (The logical implication expression A _ B, meaning if A then B,is equivalent to ¬A Ú B)

16.  The language used in application programs to request data from the DBMS is referred to as the-DML

17.  A logical schema-is the entire database.

18.  Related data fields in database are grouped to form :data record(Record is collection of related fields)

19.  The database environment has all of the following components except: Users

20.  The language which has recently become the defacto standard for interfacing application programs with relational database system is- 4GL

21.  The way a particular application views the data from the database that the application uses is a-sub schema.

22.  The DBMS language component which can be embedded in a program is-DML

23.  The relational model feature is that there-is much more data independence than some other database models.

24.  Conceptual design-involves modelling independent of the DBMS.

25.  A method in which records are physically stored in a specified order according to a key field in each record is -hash.(In hash method, a hash function is performed on the key value to determine the unique physical address of the record to store or retrieve)

26.  A subschema expresses-the external view.

27.  Data elements in the database can be modified by changing the data dictionary

28.  An advantage of the database management approach is-data is integrated and can be accessed by multiple programs.

29.  Transaction processing is associated with everything below except-confirming an action or triggering a response.

30.  SET concept is used in :- Network Model

31.  Relational Algebra is-Procedural query Language

32.  Cartesian product-produces the relation that has attributes of R1 and R2

33.  The file organization that provides very fast access to any arbitrary record of a file is Hashed File

34.  Which of the following is correct:

A.    a SQL query automatically eliminates duplicates.

B.     SQL permits attribute names to be repeated in the same relation.

C.    a SQL query will not work if there are no indexes on the relations

D.    None of these                                                                           Ans-D