Model Question-CFAN-SET A

Set--A

Group – A Multiple Choice Questions (1*9=9)

1. Which of the following is an example of DML?

  a. CREATE b. UPDATE c. DROP d. ALTER

2. Which query is used to select records from a table named “students” where

value of column name roll_no = 02?

a. SELECT * FROM students.

b. SELECT * FROM STUDENTS WHERE roll_no = 02

c. SELECT * FROM STUDENTS HAVING roll_no = 02

d. SELECT * FROM roll_no = 02

3. Which of the following is a programming language to make our webpages

dynamic?

a. JavaScript b. HTML c.CSS d. ActionScript

4. In OOP the focus is given to which of the following entities?

a. Data b. Functions c. Structured. All of the above

5. What is the tag used to insert links in HTML?

a. <a> b. <p> c. <h1> d. <font>

6. Which of the following is not a proper file operation mode?

a. close b. read c. write d. append

7. Which of the following is the first step in SDLC framework?

a. Feasibility Study b. Requirement Gathering

c. Communication d. System Analysis

8. MAN Stands for _____.

a. Metropolitan Area Network b. Main Area Network

c. Metropolitan Access Network d. Metro Access Network

9. IOT stands for

a. Internet of This b. Internet of That

c. Internet of Things d. Internet or Thing

Group – B Short Question Answers (5*5=25)

1. What is normalization. Explain its 1NF and 2NF with example.

OR

What do you mean by DDL explain with an example

2. Write a program to check if a number is even or odd in JavaScript.

OR

Explain what you understand by client-side scripting language and server-side

scripting language.

3. Describe the different features of OOP

4. What do you understand by waterfall model? Explain different stages of

Waterfall model.

5. What do you mean by E-commerce, E-governance, E-medicine, E-banking.

Group – C: Long Question Answers (8*2=16)

6. What are the different network topologies. Eplain each with 2 merits and 2

demerits?

7. Write a program that reads name, roll_no, marks and address of 20 students

using structure and display them.