MCQ XII COMPUTER

1. In which normal form of database, atomicity is introduced?
A) First B) Second C) Third D) Fourth
The correct answer is D) Fourth.

2. Which of the following techniques is not implemented to protect a database?
A) Rollback B) Backup C) Recovery D) Firewall
The correct answer is 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 “_A%”;
C) SELECT * FROM CUSTOMER WHERE LNAME LIKE “A%”;
D) SELECT * FROM CUSTOMER WHERE LNAME LIKE “%A”;
The correct answer is B) SELECT * FROM CUSTOMER WHERE LNAME LIKE "_A%".

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
The correct answer is B) 192.168.1.

5. Which of the following is a server-side scripting language?
A) JavaScript B) MySql C) PHP D) Jquery
The correct answer is C) PHP.

6. Which of the following keywords are used to declare a variable in JavaScript?
A) int or var B) float or let C) var or let D) char or var
The correct answer is C) var or let.

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
The correct answer is 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.
The correct answer is D) It supports abstract data but not the class.

9. Which of the following feasibility study is concerned with cost benefit analysis?
A) Technical feasibility
B) Economic feasibility
C) Operational feasibility
D) Schedule feasibility
The correct answer is B) Economic feasibility.