MS-OFFICE Theory

 

MODEL EXAMINATION 

Subject: MS-OFFICE

Time: 2 Hrs

Max. Marks: 50

PART – A  Fill in the blanks       

1.                  ……… applies a built-in combination of formats to selected cell or range of cells or sheets.

2.                  …………..adds or changes the special effect that introduces a slide during a slide show

3.                  …………… is the extension of Power Point files

4.                  In Word………….. Searches for the specified text or formatting.

5.                  …………….option in documents window splits the active window into panes.

6.                  ………..option runs your slide to show.

7.                  In MS- Word…………… helps to quickly creates letters.

8.                  …………… changes the capitalization of a selected text.

9.                  ……………… copies the contents of the range of cells selected on the active worksheet to the same range of cells on all the selected sheets in group.

10.             In Excel…………..restricts the data entry to a particular type.

PART-B.  State whether True or False

1.                  We can set a border to a document with Paragraph option.

2.                  A work sheet contains 65565 rows

3.                  Font option on Format Menu change the character spacing formats of the select text.

4.                  Slide sorter option is used to rearranging slides.

5.                  The intersection of 4row and columns is called a cell.

PART-C  Answer any ten questions from the following

1.                  Explain the S[read Sheet concept?

2.                  What is a function?

3.                  What is the use of Header and Footer?

4.                  What is the function of Consolidation menu option in Excel?

5.                  What are the data types allowed in Excel?

6.                  What is the order in which multiple operators are evaluated?

7.                  Explain Mail merge?

8.                  How to close a work book?

9.                  What are the two ways to format?

10.             What is the default currency symbol? How to change the currency format?

11.             Explain Bullets and Numbering?

12.             Explain Cut, Copy and Paste?

13.             Explain about Work Sheet?

14.             Explain Customize Tool Bar?

15.             Explain Envelops and labels?

Visual Basic Theory

MODEL EXAMINATION 

Subject: Visual Basic

Time: 2 Hrs

Max. Marks: 50

I.Fill In The Blanks

1. IDE stands for ……………………………………………………………

2. …………………………...…… controls are also known as radio buttons

3. ……………..is used to displays directories in our system

4. Data Control is used for ………

5. Shape control displays …….types of shapes.

6. ……...…Button allows the user to perform some actions

7. …………………………………… method is used to remove an item from a list

8. For designing a menu we can use ……control

9. …………function returns the length of a string.

10. …..are the memory locations  to store the values temporary

(10 x 1=10)

II. Answer Any Five Of The Following

1. Write the code for displaying a message box?

2. Write the syntax of for loop in visual basic?

3. Difference between option Button and Check Box

4. Design and code for displaying “selected” where the age is >19

5. Explain the mathematical functions in VB?

6. Find the sum and average of n numbers using input box?

(5 x2=10)

IV. Answer The Following

1. Design and code a login form

2. Design and code a weekly payroll

3. Write about the mathematical functions in vb.

4. Describe about the control statements in visual basic

5. Design and write the code for given age in days.

6. Add and remove items to a list box

(5 x 6=30)

Oracle SQL Theory

MODEL EXAMINATION 

Subject: SQL

Time: 2 Hrs

Max. Marks: 50

I.                   Fill In The Blanks

1. …………..is the collection of related data entries

2. ………….is the collection of related relations

3. Collection of related records………….

4. The columns of a relation are called…………..

5. The rows are called…………..

6. SQL stands for……………………

7. ………...is used to modify the existing record in a table.

8. ………..is the highest level of abstraction

9. …………...returns the no: of occurrences of a value in colomn.

10. Number of attributes in a relation is called…………..

(10x1/2=5)

II.                True Or False            

1. Create is a type of DML command

2. A where clause is used to give condition in a query.

3. RDBMS is a database management system that is based on relational model.

4. commit  is used to display table

5. Primary key is used to uniquely identify a records in a database

6. Truncate is used to delete tables in a database

7. How the data actually stored in described  in logical level

8. Attributes are property used to describe an entity

9. Data Base Administrator is a type of user

10. Candidate key consist of more than one attribute  to uniquely identify rows

(10x1/2=5)

III.             Short Questions

1. What is mean by data integrity?

2. Give the syntax for create a table?

3. What is mean by abstraction?

4. What is meant by constrain in database?

5. Explain data independency?

6. Give the syntax for inserting values to a table?

7. Write about aggregate functions in database?

8. Write about select, update, having commands in SQL  ?

9. Explain DML commands?

10. What is logical data independence?

(10x2=20)

IV.              Answer Any Four from the Following

1. Different types of database languages.

2. Explain types of keys in database?

3. Explain different types of join operations?

4. Use of foreign key.

5. Write the views of a database management system

(4x5=20)

Java Programming

MODEL EXAMINATION 

Subject: Java

Time: 2 Hrs

Max. Marks: 50

I. Fill In The Blanks :-

1. Java compiler translates source code to ………..

2. The comparison done with the help of ……operators.

3. The ……operator is used to access the instance variables in java.

4. Objects in java created by using …..Operator.

5. Private is an example of …….in java

6. What is a thread?

7. A loop is continues for ever, it is called ………

8. A ……is used to initialize an object when it is declared.

9. A class that cannot be sub classed is ………….

10. Applets are initialized by calling ………method.

(10x1/2=5)

II. State Whether The Following Statement Are True

1. A  Java program basically a collection of classes.

2. If...else statements are not an extension of simple if.

3. Identifiers are user defined tokens.

4. For loop is another entry controlled loop.

5. Java is a procedure oriented language.

6. The member of a class can be a constant or variable.

7. Constructors have different name as the class.

8. do…….while is an  exit control loop

9. Java classes are reused in several ways.

10. The keyword super only be used within a subclass constructor method.

(10x1/2=5)

III. Short Questions

1. Define a class and object?

2. Syntax of for loop?

3. What is mean by a constructor?

4. What is an applet?

5. What is an array in java?

6. What is mean by inheritance?

7. What is the use of extends keyword?

8. Define method overloading?

9. Define life cycle of a thread?

10. Write the syntax of expression handling code?

(10x2=20)

IV. Answer Any Four From The Following

1. Printing multiplication table using while loop?

2. Write an applet program to display human face?

3. Explain method overloading in java?

4. Write different types of inheritance in java?

5. Explain applets life cycle?

(4x5=20)