Viva Questions for IP Class XII

Expected

CLASS XII IP :VIVA QUESTIONS

                                                                                                                                                                                                                                                                                                                                                                                                                      

Viva Questions – Informatics Practices

1.     Difference between setText()  and getText()?

Set text () method stores or changes text in a text based GUI component. For eg. Text field, Text area, get text() method returns the text currently stored in a text based GUI component. For eg. Label, Check Box, etc.

2.     Difference between combobox and listbox?

The list a user may directly select from list whereas in combo box user can edit if he/she wishes. List have text field where user can edit the selected item where as combo box is a cross between a text field and a list.

3.     What is entry control and exit control loop?

The loop condition is tested before entering in to the loop is called entry control loop like for and while loop. In exit control loop it first execute loop body and than evaluate the continuation condition like while loop.

4.     Give the introduction about your project?

5.     Through which property of radio button can we select  one radio button at a time?

Through button group property of radio button we can select one radio button at a time.

6.     What is the use of import in java?

7.     What is as String Class?

String class is used to accept textual data.

8.     What are data types?

9.     What is the use of parse method  in java?

10.   How can we compare two strings?

11.   How can we convert a string into upper case?

12.   What is an Interface ?

13.   What is Inheritance?

14.   What is the difference between extend and implement?

15.   What are math functions and string functions explain?

16.   What is backend and front end?

Front End :- It is the user interface that the user sees and which is resp outside for interacting with the user. The interface allows used to uses commands to the system.

Back End:- It is the Part of Application that does the real processing or get it done from the server.

17.   What is connectivity?

18.   What is the use of following methods :    forName(); getConnection();, createStatement(), executeQuery, executeUpdate(),getModel(), getRowCount();removeRow().

19.   What is HTML?

HTML stands for Hyper Text Markup language. It is a markup language used to create HTML documents. An HTML defines a Web Page.

20.   What is the difference between HTML and XML?

HTML:- New Tags cannot be created using HTML tags, HTML tags can be empty tags

XML :- New tags can be created using XML tags., XML tags cannot be empty tags.

21.   What is primary key?

Primary key is a combination of columns that uniquely identifies a row in a relational table.

22.   What is candidate key?

All possible combination of columns that can possibly serve as the primary key is called candidate key.

23.   What is foreign key?

A combination of columns where values are derived from primary key of some other table is called the foreign key of the table in which it is contained

24.   What is alternate key?

A candidate key that is not serving as aprimary key is called alternate key.

25.   How can we convert a string into upper case in mysql and java?

26.   How can we convert a string into lower case in mysql and java?

27.   What is Mysql?

Mysql is an open source RDBMS that relies on SQL for processing the data in the database. The database is available for free under the terms of General Public License (GPL)

28.   What is RDBMS ?

Relational Database Management System facilitates access, security and integrity of data & eliminates data redundancy. Eg. Mysql, Oracle, Microsoft Sql Server etc.

29.   How many types of functions are there in MYSQL?

30.   What is a Tuple, Relation, Attribute?

Tuple: the rows of the table are called tuples.

Relation : A relation is two dimensional table.

Attribute: The column of tables are called attribute.

31.   What is degree and cardinality?

Degree – Number of attributes (columns) in a relation is called degree cardinality – Number of types (rows) in a relation is called cardinality.  

32.   What is the significance of Having Clause?

33.   What is the significance of select statement?

34.   What are DDL Commands Explain with examples?

Data Definition Language (DDL) commands allow us to perform tasks related to data definition. Eg. Creating, altering, and dropping granting & revoking privileges & roles.

35.   What are DML Commands Explain with examples?

Data Manipulation Language (DML) commands allow us to perform data manipulation. Eg. Retrieval, Insertion, Deletion and Modification of data stored in a database.

36.   What are TCL Commands Explain with examples?

Transmission Control Language (TCL) commands allows us to manage and control the transaction. Eg. Commit, Rollback, Savepoint etc.

37.   What is the use of Drop Command?

Drop command is used to delete tables. Eg. Drop Table Orders, Delete commands is used to delete, rows of a table.

38.   What is the use of DESCRIBE command?

39.   What are Logical Operators  explain?

40.   What is the use of LIKE , Between and  IN Operators ?

41.   What is the difference between Update and Alter table?

42.   What is the difference between Where and Having?

43.   What are constraints?

They are used to enforce rules at table level wherever row is inserted, updated or deleted from the table.

44.   What is the difference between DROP and DELETE?

45.   What do you understand by Check Constraint?

46.   What do you understand by primary key constraint?

This constraint enforces uniqueness of the column. Only one primary key per table is allowed.

47.   What do you understand by Default constraint?

48.   What do you understand by Not null constraint?

This constraints ensures that the null values are not permitted or a specified column. This constraint can be defined at the column level not at the table level.

49.   What do you understand by unique constraint?

50.   What is significance of COUNT?

It is used to count the numbers of values in a gives column or no. of rows in a table. Eg. Select count (Roll No.) from students.

51.   Explain joins in  Mysql?

52.   What is Union operation?

Union is an operation of combining the output of two select statements.

53.   What is the difference between Where and Having?

54.   What is difference between order by and group by clause?

55.   What is difference between rollback and commit?

56.   What is SavePoint?

Save point command sreates a point in transaction upto which all changes have been saved properly and permanently.

57.   What is conditional operator?

58.   What are unary, binary and ternary operator?

59.   What is swing?

60.   Swing include a rich set of graphical component for building GUI

61.   What are top level containers?

62.   Top level container are the container which hold other container in it For eg. Frame.

63.   What is difference between text area and text field?

Text area is a component that allow us to accept multiline input from the user or display multiline information whereas text field allows editing/displaying of a single line of text.

64.   What are the type of inheritance supported by netbeans?

65.   What do you mean by save point?

66.   The savepoint statement defines a marker in a transaction. These marker are useful in roll backing a transaction.

67.   How can we delete a table in MYSQL?

We can delete a table in mysql using drop command.

68.   How can we delete a record in MYSQL?

We can delete a record in mysql using delete command.

69.   How can we add a record and add a column in a table ?

We can add a record by using insert command and we can add a column through table.

70.   What are the parts of a method?

Method can be divided into two categories : getters & setters Getters : they extract (input) information from the object -> Program Setters : They set some property of the object so that the change object’s appearance.

71.   What is difference between ‘=’ and ‘==’?

= is used for equality whereas

= = is used for assignment value

72.   What is difference between ‘a’ and “a”?

‘a’ is a char type whereas

“a” is a string type

73.   What is difference between ++a and a++?

++a in this value is incremented first then the new value is stored  back to the variable. A++ in this expression the current value is assigned to a variable and then incremented by 1.

74.   What is difference between –a and a--?

75.   Difference between while and do while?

While is a entry control loop whereas do while is exit control loop.

76.   What is Networking?

Networking is a collection of interconnected computers and other devices which are able to communicate with each other  and share hardware and software resources.

77.   What is tree Topology how does it work?

Tree topology is a communication of bus and star topology.

78.   What is Bus Topology how does it work?

In bus topology all the nodes are connected to a main cable called backbone if any node has to send information to another node it sends signal to backbone. The signal travel entire length and received by the intended node and information is absored by terminator to remove it.

79.   What is Star Topology how does it work?

In star topology each node is directly connected to hub if any node has to send some information to any other node it sends the signal to hub. The signal is broadcast to all node but it is accepted by intended node.

80.   What is Mesh Topology how does it work?

81.   What is guided media and unguided media?

Guided media include cables whereas unguided media include waves through air.

82.   What is Gateway?

A gateway is a device which is used to connect different types of networks and perform the necessary translation so that the connected networks can communicate properly.

83.   What are Network Protocols?

A networks protocol is a set of rules for communication among networked devices. Protocol generally includes rules of how and when a device can send or receive the data.

84.   What is HTTP?

HTTP is used to transfer all files and other data from one computer to another on world wide web. HTTP stands for Hyper Text Transfer Protocol.

85.   What is TCP/IP?

Every machine on a TCP?IP network has a unique identifying number called an IP address:

86.   What is PPP?

87.   What are the different types of Network?

88.   What is PAN, LAN,MAN,WAN?

PAN :- Personal Area network, LAN :- Local Area Network, Man:- Metropolitan Area Network, WAN :- Wide Area Network.

89.   What is Transmission Media?

90.   What is the difference between Twisted Pair Cable and Unshilded Twisted Pair?

91.   What are Co-axial cables ?

This type of cable consists of a solid wire core surrounded by our or more foil, each separated by some plastic insulator.

92.   What are Optical Fiber Cables?

93.   What are Radio Waves?

94.   What are Micro Waves?

95.   What are Radio Waves?

96.   What are Infrared Waves?

97.   What is Blutooth?

98.   What is Satellite Link?

99.   What is Repeater and Switch? Give Difference.

100.A repeater is a device that amplifies a signal being transited on a network. It is used in long _______

101.What is HUB?

A HUB is a hardware device used to connect several computers together. Hub can be either Active & Passive hubs.

102.What is NIC?

103.What do you understand by MAC address?

The hardware address of the networks card is caused MAC address, which becomes computers unique hardware number on a network.

104.What is the difference between IP Address and Mac Address?

MAC address refers to the physical address assigned by NIC manufacturer. IP address is a mechanism that obtains IP address using a URL of a website.

105.What is Domain Name?

106.What are Generic Domain Name?

107.What are Country Specific Domain Names?

108.What do you understand by Network Secutity?

109.What are Denial of service attacks?

DOS attacks are those attacks that present the legitimate user of the system from accessing on using the resources, information of the system.

110.What is Snooping?

Snooping refers to the unauthorized access of someone else data, Email, computer activity or data communication.

111.What is Eavesdropping?

Eavesdropping is the act of secretly listening someone else private communication/Information.

112.What is Firewall?

The system designed to prevent unauthorized access to or from a private network is caused firewall.

113.Describe the parts of an object?

The Parts of an object are :-

a.     Properties, methods and events can be used to control the objects appearance and behavior.

Properties of an object are used to specify its appearance on the form. Eg. Changing the front of text field.

Methods are used to perform some action on the object. Eg. To display something in a textfield, you can use it set Text () method.

Events are actions / performed on controls. Eg. Mouse click etc.

114.Which method can be used to make the object or components visible or invisible?

Set Visible

List of Anticipated Viva Questions

Class XII

Sub: Informatics Practices

1.    What is a frontend? Example

2.    What is a backend? Example

3.    What is an IDE?

4.    How is java compilation different from ordinary compilation?

5.    What makes java a platform independent language?

6.    What are comments, identifiers, keywords, operators?

7.    Differentiate between getText() and setText().

8.    Differentiate between if and switch.

9.    Differentiate between while and do.. while.

10.    What is the difference between component and a container?

11.    What is an event?

12.    What are Swings/AWT?

13.    What is the difference between JCheckBox and JRadioButton?

14.    Differentiate between listbox and combo box?

15.    What is a class, object, constructor?

16.    What are methods?

17.    What is inheritance?

18.    What is the default access speciifier in case of inheritance?

19.    What is the significance of break and default in a switch case?

20.    Name the method to compare two strings?

21.    What is overloading?

22.    What is overriding?

23.    Differentiate between call by value and call by reference?

24.    Name the method for getting the value of the item selected by the user from a list box  and a combo box.

25.    Name the keyword that shows that a class is inherited from the other.

26.    Name the classes useful in database connectivity?

27.    What do parse methods do?

28.    Name the methods used to convert numeric to string or vice versa?

29.    How is HTML different from XML?

30.    What is an abstract class?

31.    What are interfaces?

32.    Name the type of inheritance not allowed by java.

33.    Name the tags used for following:

a.      Horizontal line

b.      Change the font

c.       Insert an image

d.      Insert a hyperlink

e.      Create a table row and data.

f.        Ordered list

g.      Formats such as Bold, Italics,Uderlined

34.    What do you understand by constraints?

35.    What are attributes and tuples?

36.    What is the degree and cardinality of a table?

37.    What is primary key and foreign key? Compare

38.    What is the difference between DDL and DML commands

39.    What is a Cartesian product?

40.    Name the clause used for pattern checking.

41.    What clause is used for applying a condition on a range of values, including both values?

42.    Differentiate between char and varchar.

43.    Name the clause used for checking from a list of values.

44.    Differentiate between alter and update commands.

45.    What is the difference between delete and drop?

46.    What is the difference between where and having?

47.    What is the difference between single row functions and aggregate functions?

48.    What is referential integrity?

49.    Name some DDL and some DML commands.

50.    What do the following functions do:

a.      Mod()

b.      Concat()

c.       Mid()

d.      Trim()

e.      InStr()

51.    What are topologies?

52.    What is the difference between LAN and WAN?

53.    What is the difference between MAC address and IP address?

54.    What do you understand by Open Source Software?

55.    What is a network protocol?

56.    What is a gateway? How is it different from Switch?

57.    What is the difference between SQL and MySQL?

58.    What is a repeater?

59.    What is TCP/IP?

60.    What is a network?