Question set XII

SET-1

Sub code: 4281

NEB-XII Model Question 2079(2023)

Computer Science Time: -2 hrs.

Full Marks: -50 || Pass Marks: - 20

Group A

Rewrite the correct options of each question in your answer sheet. (9x1=9)

1. In which normal form of the database, atomicity is introduced?

A) First
B) Second
C) Third
D) Fourth

2. Which of the following techniques is not implemented to protect a database?

A) Rollback
B) Backup
C) Recovery
D) Firewall

3. Which one of the following SQL commands is executed to display all the records having a second letter in the LNAME (LAST NAME) as "A" from the customer table?

A) SELECT FROM CUSTOMER WHERE LNAME LIKE "?A%";
B) SELECT FROM CUSTOMER WHERE LNAME LIKE AN";
C) SELECT FROM CUSTOMER WHERE LNAME LIKE "A%";
D) SELECT FROM CUSTOMER WHERE LNAME LIKE "SA"

4. Which of the following is an incorrect IP address?

A) 192.168.0.1
B) 192.168.1
C) 172.255.0.0
D) 202.10.79.4

5. Which of the following is a server-side scripting language?

A) JavaScript
B) MySql
C) PHP
D) Jquery

6. Which of the following keywords is used to declare a variable in JavaScript?

A) int or var
B) float or let
C) var or let
D) char or var

7. Which of the following commands is executed in PHP to concatenate the variables $x with $y?

A) $x+ $y
B) $x- $y
C) concat ($x,$y)
D) $x $y

8. Which statement is incorrect about the object-oriented approach?

   A) Emphasis is on data rather than procedure.
   B) Data is hidden and cannot be accessed.
   C) Objects communicate through functions.
   D) It supports abstract data but not the class.

9. Which of the following feasibility studies is concerned with cost-benefit analysis?

A) Technical feasibility
B) Economic feasibility
C) Operational feasibility
D) Schedule feasibility

Group B

Short answer questions 5*5=25

10. Which type of database system (centralized or distributed) is mostly preferred by financial institutions like a bank? Give any four suitable reasons.

OR,

Nowadays most of the business organizations prefer applying the relational model for database design in comparison to other models. Justify the statement with your arguments.

11. Develop a program in JavaScript to exchange/swap the values of any two variables.

OR,

How can you connect a database with PHP? Demonstrate with an example.

12. Describe the concept of Object-Oriented and Procedure-Oriented Programming in brief.

13. Write down any five qualities of good software.

14. Explain mobile computing with its advantages and disadvantages.

Group C

Long answer questions. 8*2=16

15. Why do most business organizations prefer setting their network with the client-server architecture? Write its advantages and disadvantages.

16. Develop a program in C using a structure to ask for the information of any 12 students with roll_number, name, and marks scored in sub1, sub2, and sub3. Also, display them in proper format along with the calculation of total and percentage. [Note: the full marks of each subject are 100).

OR,

Demonstrate a program in C to create a data file named score.dat to store students' information with Reg no, name, gender, and address. The program should ask the user to continue or not. When finished, the program should also display all the records in the proper format.

BEST OF LUCK

SET-2

Sub code: 4281

NEB-XII Model Question 2080(2023)

Computer Science Time: -2 hrs.

Full Marks: -50 || Pass Marks: - 20

Candidates are required to give their answers in their own words as far as practicable.
The figures in the margin indicate full marks.

Very short answer questions. 1x9=9

Group 'A'

Which of the given signs is used as a shortcut for JQuery?

A) the % sign B) the & sign
C) the $ sign D) the @ sign

Which of the following is a DML statement?

A) Create B) Select
C) Create view Alter D) Drop

A collection of hyperlinked documents on the Internet is called:

A) HTML B) webpage
C) www D) email system

Which of the following IPV4 addresses is valid?

A) 192.168.1.1 B) EEE.000.33.000
C) 257.2.5.1 D) 202.70.71.262

Which jQuery method is used to hide selected elements?

A) hide() B) hide(on)
C) invisible() D) display(none)

Which function is used to connect to a MySQL database?

A) mySqLi_open() B) mySqLi_connect()
C) var mySqLi_query() D) SmySqLi_con()

Which of the following is true about FILE *fpt?

A) FILE is a keyword in C for representing files and fpt is a variable of FILE type.
B) FILE is a buffered stream.
C) FILE is a stream.
D) FILE is a structure and fpt is a pointer to the structure of FILE type.

Which SDLC phase is used to ensure quality software?

A) implementation B) maintenance
C) testing D) system study

Coaxial cable is an example of………………..

A) Communication software                                      B) Guided Transmission media
C) Unguided Transmission media D) All of them
                                                       Group 'B'
Short answer questions                                                                                5*5=25

Explain the Relational Data model with an example.

                                                               OR,
            Write SQL DDL commands to execute the following task with reference to the
             schema given below:
             student_info (regno as integer, name as character (25), class integer, gender character (1),

address character (25)).

Define a syntax for database connectivity.

Write a server-side scripting code to insert data into the table student having fields (first name, last name, mark, and email). Assume that

server name="localhost", username="root", password="", database

name="studentDB".                                                   (1+4)
                                                                   OR,
            Write a JavaScript code to calculate the factorial of a given number.        (5)

How is event-driven programming (or OOP) different from procedural-oriented programming? Explain. (5)

Explain the importance of system testing in the system development life cycle (SDLC).(1+4)

What is cloud computing? Point out the advantages and disadvantages of cloud computing. (5)

Group 'C'
Long answer questions. 8*2=16

What is network topology? Differentiate between guided (wire media) and unguided (wireless media) with examples. (2+6)

Write the advantages of pointers. Write a C-program to enter the radius of a football and find the area of the football by using a user-defined function. (3+5)

OR,
Define the structure. Write a C-program using a structure to input staff ID, name, and the salary of 50 staffs. Display staff ID, name, and salary of those staff whose salaries range from

25 thousand to 40 thousand. (2+6)

THE END

SET 3

NEB - GRADE XII 2080 (2023) Computer Science
Grade Increment (Supplementary) Examination
Candidates are required to give their answers in their own words as far as practicable. The figures in the margin indicate full marks.
Time: 2 hrs.
Group 'A'
Full Marks: 50

Very short answer questions. 9x1=9

1. Which SQL keyword is used to retrieve data from a table?

a) SELECT b) FROM
c) WHERE d) JOIN

2. Which of the following principle apply to 2NF?

a) A table must have a primary key
b) All non-key attributes must be dependent on the primary key
c) All attributes must be atomic
d) A table must have at least more than two attributes

3. Which of the following is a device that connects two or more networks and can filter and forward network traffic based on its destination address?

a) Switch
b) Router
c) Hub
d) Modem

4. Which JavaScript function use to text input?

a) alert()
b) prompt()
c) confirm()
d) console.log()

5. Which of the following PHP functions is used to connect to a MySQL database?

a) mysql_connect()
b) mysqli_connect()
c) pdo_connect()
d) db_connect()

6. What is the correct way to open a file named "data.txt" in C for reading?

a) fopen("data.txt", "r");
b) fopen("data.txt", "w");
c) fopen("data.txt", "a");
d) fopen("data.txt", "rb");

7. Which of the following concepts in object-oriented programming refers to binding data and function into a single unit.

a) Encapsulation
b) Abstraction
c) Polymorphism
d) Inheritance

8. What does the term "QA" stand for in the software development process?

a) Quality Assurance

b) Quality Analysis

c) Quality Assessment

d) Quantity Assurance

9. What type of communication technology is commonly used in IoT devices?

a) Wi-Fi

b) Bluetooth

c) Zigbee

d) All of the above

Group 'B'

Short answer questions 5x5=25

10. Describe the second normal form (2NF) with an example.

What are the importance of database security in database management systems? Describe.

11. How do you add an event handler in JavaScript? Give an example.

Explain the database connection PHP function for MySQL.

12. Describe the object and class in OOPs with an example. 2+2

13. Explain the agile software development methodology in brief.

14. Give any five examples of AI related applications.

Group 'C'

Long answer questions 2x8=16

15. Compare the bus and star network topology. Which of the network cable is suitable to design star topology in the school's network? Justify. 4+4

16. Write a program to store five employees' records (EID, Name, post and department) and display them using structure.

Describe file handling modes on C. Write a C program to create and write

data into a file. 4+4

The End

SET-4
Sub code: 4281
PABSON PRE-TEST Question 2079
Computer Science Time: -2 hrs.
Full Marks: -50 || Pass Marks: - 20

Candidates are required to give their answers in their own words as far as practicable.
The figures in the margin indicate full marks.

Attempt all the questions.

Group A

Choose the best alternatives. 1x9=9

1. Data about data is known as:

a. Database (fox auto)

b. Meta data

c. Data dictionary

d. None

2. Provides total solutions to reduce data redundancy, inconsistency, dependence, and unauthorized access of data:

a. Tables

b. DBMS

c. Using Password

d. Database

3. The first network that has planted the seeds of the internet was:

a. NSF net

b. V net

c. ARPANET

d. I net

4. PHP stands for:

a. Hypertext pre-processor

b. Program hyper pre-processor

c. Process hyper program

d. None

5. JavaScript is:

a. Object-oriented language (b. Object oriented language)

b. Procedural-oriented language

c. None of the above

d. Structured-oriented language

6. What is the minimum number of functions to be presented in a C program?

a. 0

b. 1

c. 2

d. 3

7. Which feature of OOP indicates code reusability?

a. Encapsulation

b. Polymorphism

c. Abstraction

d. Inheritance

8. Which of the following is not the phase of classical waterfall model?

a. Feasibility study

c. Building prototype

b. Requirement gathering

d. Maintenance

9. IaaS stands for

a. Infrastructure as a Service

b. Internet as a Service

c. Both a and b

d. None of the above

Group B

Give short answer to the following questions. (5x5=25)

10. Explain in brief about different types of Database model.

OR,

What is data security? What are the techniques that must be employed to achieve different levels of security in computer systems?

11. How can you add JavaScript to HTML page? Illustrate with an example.

OR,

Differentiate between client side scripting and server side scripting.

12. What do you mean by polymorphism and inheritance?

13. What is system testing? Explain different types of testing techniques used during the system development.

14. What is AI? Explain its application areas.

Group C

Give long answer to the following questions. (8x2=16)

15. What is network topology? What are the different types of LAN topology?

16. Explain different types of user-defined functions with example.

OR,

Write a C program to store student name, roll number and marks in structure and display it.

**Best of Efforts**

SET-5
Sub code: 4281
HISSAN JHAPA PRE-TEST Question 2078
Computer Science Time: -2 hrs.
Full Marks: -50 || Pass Marks: - 20

Candidates are required to give their answers in their own words as far as practicable.
The figures in the margin indicate full marks.

Attempt all the questions.

Group A

Choose the best alternatives. 1x9=9

1. DROP and RENAME are the statements of...…..?

A) DML

B) DDL

C) DCL

D) None of Above

2. How do you select all records from table named employee whose name is SMITH?

A) SELECT FROM EMPLOYEE WHERE FIRSTNAME="S";

B) SELECT FROM EMPLOYEE WHERE FIRSTNAME LIKE, SMITH%"

C) SELECT FROM EMPLOYEE WHERE FIRSTNAME "SMITH";

D) SELECT FROM EMPLOYEE WHERE FIRSTNAME="SMITH%";

3. Which of the following statement is false for primary key?

A) A primary key can contain auto number values,

B) A primary key can contain random values.

C) A primary key can contain not null values.

D) None of above.

4. MAC is the protocol of …. layer in OSI reference model.

A) Network Layer

B) Datalink Layer

C) Transport Layer

D) Physical Layer

5. The basic syntax for declaring a function in JavaScript is...…

A) function function name(). { block of code;}

B) (function name function () (block of code;}}

C) function function_name() { block of code;)

D) function name function() { block of code;)

6. How do you declare variable in PHP?

A) $variable_name= value;

C) var variable name= value;

B) $variable name= $value;

D) var $variable_name= value;

7. %ld is the format specifier for the.....data type in C.

A) Integer

B) double

C) Long double

D) short integer

8. Which of the following is not the feature of OOP?

A) Inheritance

B) Polymorphism

C) Function

D) Encapsulation

9. The study of "will the product meets the requirement of users?" is done under

study.

A) Economic feasibility

B) Operational feasibility

C) Legal feasibility

D) Schedule feasibility

Group B:

Short Answer Questions (5x5=25)

1. Differentiate between DML and DDL.

OR,

Who is DBA? What ae the responsibilities of DBA?

2. Write a Program in JavaScript to accept two numbers and display the greater one.

OR,

Write a program to display the sum of any two numbers by using function in JavaScript.

3. What are the applications of OOP?

4. Explain waterfall model with diagram.

5. What is big data? What are its types?

Group C:

Long Answer Questions (2x8=16)

6. Explain OSI reference model? Explain each of the layer with their protocols and devices.

7. Write a program in C to store and display students name, class, rollno and obtained marks of 10 students by using structure

OR,

Write a program to enter book id, name, price of books into "bookdetails.txt" file until the user types no from the keyboard.

**best of luck**

Computer Science

Search This Blog

Question set XII

Comments

Post a Comment