MCQ Grade 12 Computer model with solution
- In which normal form of database, atomicity is introduced?
A) First B) Second C) Third D)
Fourth
- Which of the following techniques is not implemented to protect a database?
A) Rollback B) Backup C)
Recovery D) Firewall
- 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”;
- 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
- Which of the following is a server-side scripting language?
A) JavaScript B)
MySql C) PHP
D) Jquery
- 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
- 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
- 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.
- Which of the following feasibility study is concerned with cost benefit analysis?
A) Technical feasibility
B) Economic
feasibility
C) Operational feasibility
D) Schedule feasibility
10. With SQL, how do you select all the records from a table named “Persons” where the value of the column “FirstName” ends with an “a”
a) SELECT * FROM Persons WHERE
FirstName=’a
b) SELECT * FROM Persons WHERE
FirstName LIKE ‘a%’
c) SELECT * FROM
Persons WHERE FirstName LIKE ‘%a’
