Tuesday 11 October 2011

JAVA VIVA QUESTIONS

1.      What is an object.
2.      What is a class.
3.      Polymorphism examples.Two types of polymorphism.
4.      Over riding. Over loading difference.
5.      Abstraction ,Encapsulation.
6.      Inheritance.
7.      OOPs.
8.      Java features.
9.      Web browser and different web browsers.
10.  Minimum requirements of  java.
11.  APIs egs.
12.  Commands for compiling and executing.
13.  What will be generated if you compile a program.
14.  Syntax for class declaration.
15.  Syntax for creating an object and instantiation.
16.  How do you call a method(using what)? Syntax of calling a method.
17.  Syntax of writing a main() function. Explain each keyword in that statement.
18.  Command which is used to print a message on screen.
19.  Identifiers and rules for defining them.
20.  JVM(Java Virtual Machine).
21.  Explain what are command line arguments. Where do you pass them. Write the syntax of passing those arguments.
22.  What is variable, constant, datatype.
23.  How many types of datatypes. Examples.
24.  Ranges of datatypes.
25.  How can you declare symbolic constants. And why.
26.  What is difference between instance variables and class variables.
27.  What are locall and global variables.
28.  What is type casting .Examples.How many types.Write the syntax of casting them.
29.  Operators. Different types.
30.  Syntax of conditional operator. Explain.
31.  Precedence of operators.(Which is highest and lowest priorities).
32.  What are collections.
33.  If  statements and types of if with syntax and explain switch.
34.  Difference between while and do-while loops in execution(How is the execution from both)
35.  Enhanced for loop with a sample example with explanation.
36.  What are labeled loops. Jumping loops.
37.  What are members , methods.How are they declared.(Should be explained using classes)
38.  What are the 2 steps involved in creating an object.(Declaration and instantiation explanation).
39.  How are the members of class accessed.
40.  Example program of Method Overloading.
41.  What are static members.
42.  Inheritence concepts.Outline of a program which illustrates inheritance.
43.  What is a super class, sub class.What are other names given to them.
44.  What is over riding.
45.  Final variables and method. Finalizer method.
46.  What are abstract methods and classes.
47.  Purpose of varargs. Syntax.
48.  Different accessspecifiers.
49.  What are arrays. How do you declare an array?
50.  What is an index. What is the other name of index.
51.  Syntax of creating two-dimentional arrays.
52.  Which is the class used to difine a sring variable.
53.  What are various methods of stings. Explain with syntax.
54.  Vector . How to declare them.
55.  What are the different ways of converting numbers using constructor methods.
56.  Boxing and unboxing.
57.  What are interfaces. How do you implement them. Syntax.
58.  Different possible ways where the interface can be implemented.
59.  What are packages. What are different predefined packages in the system.
60.  Explain the overall concept of how the packages are saved and how do we import them.
61.  What should be done to add a new class to an existing package.
62.  Purpose of ststic import.
63.  What is a thread. Explain the concept of multithreading.
64.  Run() method.
65.  How to create a new thread.(What are the two ways of creating).
66.  Which method calls the run() method.
67.  How can you block a thread, and method used to stop a thread?
68.  How can you make a thread into runnable state from blocked state?(methods used).
69.  What are the different states where a thread can go into?
70.  What does a yield() method do?
71.  How can you set priorities to threads.(method used to set priority)
72.  Concept of synchronization.
73.  What is dead lock.
74.  Using Runnable Interface . What are the 4 steps involved in using the interface.
75.  Compile time and run time errors.
76.  How can we handle run time errors.
77.  Explain try and catch blocks.(what are the tasks done in each of the block)
Need toi explain ‘hit’,’throw’,’catch’.
78.  Name few commonly used exceptions and cause.
79.  How does multiple catch statements work.
80.  Use of finally statement.
81.  How to throw our own exceptions. Explain with example(what is the statement which is used throw such exceptions)
82.  Applet definitions. How to run them. Few main differences between an applet and a stand alone application.
83.  Explain paint(), Graphics class, init(), start() methods.
84.  What are packages needed to imported. What does that package contain.(why do you import only those packages).
85.  Different states of an applet. And methods called when an applet is in that state.
86.  Small applet code to define an applet.
87.  Write a HTML code that calls an applet to execute.
88.  Steps performed to run an applet.
89.  Use of align attribute.
90.  Explain some tags used in html.
91.  What is the class which is used to insert a text box. Write the syntax of entering a text box in applet.
92.  How can you pass parameters in an applet.( what is the method used).
93.  All the questions based on an applet program which is asked for you in your lab examination. i.e., All the new concepts that are used in your program which you have executed.
                                         
                                                  DATA STRUCTURES

1.      Sorting definition. And what are different ways of sorting.
2.      Algorithm for each type of sorting.(just the method where the sorting is done)
3.      What is a stack. On what basis it is processed. Explain about ‘top’, and ‘push()’,’pop’ methods.
4.      Queue, Circular queues, Deques, Priority queues.
5.      Write the method how the values are inserted in the queue.
6.      Method how the values are inserted in a priority queue.
7.      Quick sorting.
8.      What are binary search trees.
9.      What are linked lists. How many types. Differences between them.
10.  What is a node.
11.  Depth first search and breadth first first search algorithms.
12.  And all the important terminologies used in this unit.

SHORT ANSWERS IN MS-OFFICE & C

1.      Cache memory.
2.      Recycle bin.
3.      Headers & Footers.
4.      Templates.
5.      Table feature in MS-Word.
6.      Cell address.
7.      Conditional operator.
8.      Function.
9.      Structure.
10.  Goto statement.
11.  Folder.
12.  Difference between structure & union.
13.  Floppy disk.
14.  Internet explorer.
15.  Graphics.
16.  What is database.
17.  What is a string.
18.  What is global variable.
19.  Union.
20.  Formatting text in MS-Word.
21.  Saving a presentation.
22.  Break statement.
23.  Local variables.
24.  Enumerated datatypes.

VIVA QUESTIONS FOR MS-OFFICE

MS word
1.      What are good features of a word processor?
2.      What are different menu options available in Ms-word?
3.       Explain what is a mail merge
4.      What are macros?
5.      What are different formatting tools of MS-Word
6.      Name the various parts of the word window?
7.      In how many ways can you set margins in a word document?
8.       Explain various printing options available in Ms- word?
9.       What are t he various views available in MS Word?
10.  How do you insert graphics in ms-word?
11.   Name different types of templates available in word?
12.  How do you create tables in MS word.
13.  Explain what are the headers and footers in MS-Word.
MS-Power Point
1.      Explain various features of power point
2.      In how many ways can you create a power point presentation.
3.      What are the various types of views available in PowerPoint?        
4.      How do you add animation effects to your presentations.
5.      What is the importance of slide transition in Power point.
6.      Explain the importance of transition and build effects in Ms-Powerpoint.

DBMS VIVA Questions


DBMS VIVA QUESTIONS
1.     What are file oriented systems.  How are they stored?
2.     Difference between information and data.
3.     Difference between random accessing and file oriented systems.
4.     Various data models. Explain.
5.     What is a pointer?
6.     What is a data dictionary? What is stored in it?
7.     What is Meta data?
8.     What is view?
9.     What is an application program?
10.                        Three different types of data sharing. Explain.
11.                        What automated systems are used at three different levels users in data sharing?
12.                        Differences between centralized data base and distributed data base.
13.                        Who is DBA? What are his duties?
14.                        What is database planning?
15.                        What the three levels in a database.
16.                        DDLC. Outline each step.
17.                        SDLC.
18.                        Give a comparison between model and reality.
19.                        What is mapping.
20.                        What is object oriented model.
21.                        Differences between object, Object set, object instance.
22.                        How do you indicate them in diagram?
23.                        Different types of keys. Give the differentiation between them.
24.                        Specialization and generalization representing diagrams. Give an example showing it.
25.                        What is meant by relationship? How can you represent them in a diagram and explain.
26.                        What is minimum and maximum cardinality?
27.                        How many types of relationships can be there between objects? How do you indicate then through diagram?
28.                        What are attributes? How can you show them as relationships?
29.                        What is aggregation? Explain higher level relationship, binary relation ship and ternary relationship
30.                        Differentiate between physical and conceptual objects? give example
31.                        What is a Relational Data Model?
32.                        How can you say that a relationship is recursive?
33.                        Explain the terms tuple, degree of relation, attribute domain, null values and different types of keys?
34.                        What is meant by “to functionally determine”?
35.                        What is a constraint? What is entity integrity and referential integrity?
36.                        What is a schema?
37.                        Types of anomalies?
38.                        Normalization process definition?
39.                        What is data redundancy?
40.                        State each normal form and explain?
41.                        What is atomic value?
42.                        What are functional dependencies? Explain by showing an example?
43.                        What is a determinant?
44.                        When does a transitive dependency occur
45.                        State BOYCEE CODD Normal form.
46.                        What are multivalued dependencies?
47.                        Give an example how conceptual models are transformed into relational models.
48.                        Differentiate between relational algebra and relational calculus.
49.                        Explain Union, Intersection, product, Divide, Difference, Select, Project.
50.                        What are joins? Explain different types of joins
51.                        Explain terms Target list, Qualifying statement in relational calculus.
52.                        Define existential and universal quantifiers.
53.                        How do you create schemas? Write the syntax of creating them.
54.                        What are default values? When are they used?
55.                        Queries may be asked to write a SELECT statement, CREATE statement, insertion of records, Sub queries, Exists and non-exists operators.
56.                        How many built in functions are there. Write the query showing those functions.
57.                        When do you use a “HAVING” clause?
58.                        What is the use of ‘group by’ clause? Write syntax of group by
59.                        Queries showing UNION, INTERSECT and EXCEPT operators.
60.                        Write a query which joins 2 tables and displays the columns of selected columns from both the tables.
61.                        What is Cartesian product? What is alias?
62.                        What is a cursor? How are the embedded SQL statements written?
63.                        Write the query to update any column value in a table, and how to delete any row from a table.
64.                        Write a query to create a VIEW. What are DDL, DCL, DML commands?
65.                        How can the SQL queries be executed using QBE?
66.                        Define target table and QBE.
67.                        What is an example element in QBE?
68.                        What is paradox for windows? What is it useful for?
69.                        What is a client server platform?
70.                        What are the user defined data types?
71.                        How do you define a primary key? Write a query.
72.                        How do you set a foreign key for a column? Write a query.
73.                        Why are Check constraints useful?
74.                        What is a stored procedure?
75.                        Queries using if..else statements, break and continue, while statements.
76.                        What are triggers useful for?
77.                        All the terminology used in power builder approach.
78.                        Differentiate between primary memory (main memory) and secondary memory.
79.                        What is buffer manager, file manager?
80.                        What are disk drives?
81.                        What is cylinder, tracks, blocks, surfaces?
82.                        What is balanced tree?
83.                        How are pointers used in mapping relations?
84.                        What is linked list?
85.                        What is head list?
86.                        What are secondary keys?
87.                        Who is DBA, and what are his primary goals in the organization.
88.                        How can you avoid concurrency control?
89.                        What are deadlocks, when are they occurred?
90.                        What is 2 phased locking?
91.                        What is transaction?
92.                        What are an aborted transaction and a committed transaction?
93.                        What is a log?
94.                        Encryption
95.                        What is DDBMS?
96.                        What are different DDBMS?
97.                        And all the important terminologies in 5th unit.