Multiple choice questions. Question No. 1 to 9 (Multiple Choice Questions) will be provided after 30 minutes of starting examination. Rewrite its (MCQ) correct option (answer) in the same answer sheet.
[9×1=9]Which of the following is the purpose of using primary key in database?
A) To uniquely identify a record
B) To store duplicate record
C) To backup data
D) To enhance database size
A company needs to modify an existing table by adding a new column for employee email addresses. For this, which SQL command should be used?
A) CREATE B) ALTER C) SELECT D) UPDATE
Which protocol is used for secure communication over a computer network?
A) HTTP B) FTP C) HTTPS D) Telnet
Which control structure in JS (Java Script) is used to execute a block of code repeatedly based on a given condition?
A) For loop B) if-else C) switch-case D) function
Select the invalid variable name in PHP.
A) $name B) $_name C) $1name D) $name123
The statement
int number ( int a); is a ...
A) function call B) function definition
C) function declaration D) function execution
In which of the following programming, the emphasis is given on data rather than on procedures?
A) Procedural programming B) Structural programming
C) Object-oriented programming D) Declarative programming
Which type of feasibility study evaluates whether a system can be developed with the available technology?
A) Operational feasibility B) Social feasibility
C) Technical feasibility D) Economical feasibility
Which of the following is NOT a type of cloud computing service?
A) Infrastructure as a Service (IaaS)
B) Platform as a Service (PaaS)
C) Software as a Service (SaaS)
D) Hardware as a Service (HaaS)
Short answer questions
[5×5=25]Write any three differences between DDL and DML. Give examples of each. [3+2]
OR
What is normalization? Explain 2NF and 3NF. [2+3]
Write JavaScript code to input any three numbers and find the smallest number among them. [5]
OR
Write a PHP script to connect to a MySQL database. [5]
Write short notes on class and inheritance in oops with example. [5]
What is Requirement Gathering? Explain different Requirement Gathering methods. [1+4]
What is AI? Explain application areas of AI in education. [5]
Long answer questions
[2×8=16]What is transmission medium? Explain its major types with advantages and disadvantages. [2+6]
Write a C program that reads the account_number, name and address of ten customers from users and displays the account_number, name and address of these customers using Array and structure. [8]
OR
What are the components of a function of C? Describe the Call-by-value and Call-by-reference and passing the function parameters. [4+4]