Multiple Choice Questions. Question No. 1 to 9 will be provided after 30 minutes of starting examination. Rewrite its (MCQ) correct options (answer) in your same answer sheet.
[9×1=9]Which one of the followings given statement correct ?
A) Select * from enp where eopid = 103;
B) Select from enp where eopid = 103;
C) Select eopid where enp = 103 from emp;
D) Select eopid where eopid = 103 and table = emp;
Which database system normally offers better performance for geographically dispersed users ?
A) Centralized database system B) Distributed database system
C) NoSQL database system D) Relational database system
Which of the following is an example of a public IPV4 address ?
A) 192.168.1.1 B) 172.16.10.1
C) 10.10.10.10 D) 203.0.113.10
What is the correct syntax for a 'for-loop' in JavaScript ?
A) for (var i = 0; i < 5; i++) {} B) for (i = 0; i < 5; i--) {}
C) for (var i = 0; i < 5) {} D) for (var i < 5; i++) {}
Which PHP function is commonly used to execute SQL queries on a database connection established using mysqli extension ?
A) mysqli_query ( ) B) pdo_query ( )
C) mysql_query ( ) D) pgsql_query ( )
What is the correct syntax to declare a structure in C ?
A) struct { } B) define struct { }
C) struct [ ] D) struct <name> { }
In C, which operator is used to get the address of a variable ?
A) * B) & C) -> D) .
Which OOP feature allows a class to inherit properties and behavior from another class ?
A) Inheritance B) Encapsulation
C) Polymorphism D) Abstraction
Which model of SDLC is characterized by a linear progression of phases from requirements gathering to maintenance ?
A) Waterfall model B) Agile model
C) Spiral model D) RAD model
Short answer questions
[5×5=25]Evaluate the advantages of DBMS compared to traditional file-based data storage systems. [5]
OR
How does Second Normal Form (2NF) differ from First Normal Form (1NF), and what are the key benefits of achieving 2NF in database design ? Explain. [2+3]
Write a JavaScript function that checks if a number is even or odd and print the result. [1+4]
OR
What is purpose of the mysqli_connect ( ) function in PHP ? Describe its usage and parameters. [2+3]
Write short note on class and object in OOPs with a real-word example. [2.5+2.5]
How do various requirement gathering techniques help in achieving a careful grasp of user needs and system requirements during SDLC's analysis phase ? [5]
Give five examples of AI applications in the education. [5]
Long answer questions
[2×8=16]How does the star network topology differ from the bus network topology in terms of its architectural layout and data transmission methodology in modern computing environments ? [8]
Write a C program that uses structures to represent details of five books (title, author, publisher and price) and prints them out. [8]
OR
Discuss the concept of binary file handling in C programming and explain how putw( ) and getw( ) functions facilitate binary input/output operations. Give examples. [8]