Grade 12 /MCQ Unit 1- DBMS
1. A foreign key can have….value
A) unique and null B) duplicate and null
C) duplication and not null D) none of the above.
2. A key attribute of a master table being used in a child table for setting relationship is known as A) primary key. B) candidate key. C)foreign key. D) Super key.
3. Decision tree is a tool to:
A) Design System. B) Test the System.
C) Selling the system. D) None of the above.
4. The … ...statement is used to delete a table.
a) DELETE TABLE. b) DROP TABLE. c) DEL TABLE d) REMOVE TABLE
5. In which normal form of database, atomicity is introduced?
A) First B) Second C) Third D) Fourth
6. Which language is used by most DBMSs to help their users to access data?
A) Database Language. B) Query Language. C) computer Language. D) 4GL.
7. What is a relation in Relational Database Management System?
A) primary key. B) field. C) table. D) record.
8. In the relational model, the relations are generally termed as…
A) Tuples B) Attributes C) Rows D) Table.
9. Which of the following uniquely identifies each record in the table?
A) Fields B) Primary Key C) Row D) Record.
10. Which of the following is a group of one or more attributes that uniquely identifies a row? A) Primary Key. B) Candidate Key. C) Composite Key. D) Super Key.
11. Which of the following principles 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
12. Which one of the following keys is used in a relational database to define the referential integrity constraint?13. A foreign key can have… ... ... value.
A) unique and null B) duplicate and null. C) duplication and not null D) none of the above
14. Which of the following gives a logical structure to the database graphically? (R) A) Database diagram. B) Relational diagram
C) Entity-Relationship Diagram. D) Architecture diagram
15. The context diagram is also known as….
A) Level-0 DFD B) Level-1 DFD C) Level-2 DFD D) All of the above.
16. A decision tree is a tool to... [qn3 same]
A) Design System. b) Test the System. C) Selling the system. D) None of the above
17. Which of the following techniques is not implemented to protect the database? A) Rollback B) Backup C) Recovery D) Firewall
18. Which among the following has the maximum Bytes? DBMS
A) VARCHAR B) CHAR C) Both VARCHAR AND CHAR. D) Text Type.
19. Which SQL keyword is used to retrieve data from a table?
A) SELECT B) FROM C) WHERE D) JOIN
20. Which of the following SQL statements is used to DELETE rows from the database table? A) DELETE B) REMOVE C) DROP D) CLEAR
21. Which of the following is not a DDL command?
A) UPDATE B) TRUNCATE C) ALTER D) None of the mentioned
22. Which function is used to connect to the MySql database?
A) mysqli_connect() B) mysqli_Open() C) mysqli_query() D) $mysqli_con()
23. Which command Copies the database from one server to another?
A) Mysqlcopydb B) Mysqldbcopy . C) Mysqlflushdb D) Mysqldbflush
24. 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()
25. Which statement is appropriate to create a table in SQL?
A) CREATE TABLE table_name (column);
B) CREATE TABLE table_name (column datatype);
C) CREATE TABLE table_name (datatype);
D) CREATE TABLE table_name (column datatype constant);
26. Using SQL, how would you select all the records from a table named ‘staff’ where the value of the city’s column is ‘Biratnagar’?
A) Select * from staff where city is exactly ‘Biratnagar’.
B) Select * from staff where city is equal to ‘Biratnagar’.
C) Select * from staff where city= ‘Biratnagar’.
D) Select * from staff where city is not in ‘Biratnagar’.
27. Which one of the following given statements possibly contains the error?
A) SELECT * from emp where empid=10003;
B) SELECT empid from emp where empid=10006;
C) SELECT empid from emp;
D) SELECT empid where empid=1009 and Lastname='GELLER';
28. 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’;
D) SELECT * FROM Persons WHERE FirstName=’%a%’;
29. 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”;
30. Which one of the following SQL commands is executed to change the address of employee whose employee id (emp_id) is e10001 with “KATHMANDU” in the table employee?H
A) UPDATE EMPLOYEE SET ADDRESS= “KATHMANDU” WHERE emp_id=e10001;
B) UPDATE EMPLOYEE SET ADDRESS= “KATHMANDU”;
C) UPDATE EMPLOYEE SET ADDRESS=“KATHMANDU” WHERE emp_id= ‘e10001’;
D) ALTER EMPLOYEE MODIFY ADDRESS=“KATHMANDU” WHERE emp_id= ‘e10001’;
31. Which of the following SQL commands is executed to display all records having a third 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”;
32. What SQL statement do we use to display the name and address of all students who live in Kathmandu?
A) SELECT * FROM STUDENTS WHERE address=”Kathmandu”;
B) SELECT name, address FROM STUDENTS WHERE address=”Kathmandu”;
C) SELECT * name, address FROM STUDENTS WHERE address=”Kathmandu”;
D) SELECT FROM STUDENTS WHERE address=”Kathmandu”;
33. Which SQL statement will show the names and heights of all basketball players taller than 6 feet?
A) SELECT name FROM Player WHERE height >6;
B) SELECT name FROM Player WHERE height >=6;
C) SELECT name, height FROM Player WHERE height >6;
D) SELECT name, height FROM Player WHERE height <6;
Answers to Multiple Choice Questions.
1 2 3 4 5 6 7 8 9 10
B C A B A B C D B A
11 12 13 14 15 16 17 18 19 20
B C B C A A D B A A
21 22 23 24 25 26 27 28 29 30
A A B B B C D C B C
31 32 33
Unit 2: NW
1. Which of the following represents the fastest data transmission speed? (U)
A) Gbps. B) Kbps. C) Bps. D) Mbps.
2. What type of transmission media is commonly used in LAN networks due to its cost-effecveness and flexibility?
a. Unshielded Twisted Pair Cable(UTP). b. Digital Subscriber Line (DSL). c. Microwave. d. Satellite.
3. Which transmission media offers high bandwidth and immunity to electromagnec interference, making it suitable for long-distance communicaon?
a. Coaxial Cable. b. Bluetooth. c. Radio Waves. d). Opcal Fiber.
4. Which type of transmission media is commonly employed in cable television systems owing to its proficiency in transming high-frequency signals across extensive distances?
a) Coaxial Cable. b. Bluetooth. c. Radio Waves. d. Unshielded Twisted Pair Cable (UTP).
5. Which transmission media is characterized by its ability to transmit data wirelessly through radio frequency signals?
a) Wireless Communicaon. b. Ethernet Cable. c. Twisted Pair Cable. d. Fiber Opc Cable.
6. Select the perfect order of data communicaon system or model.
A) Source, Sink, Encoder, Decoder, Transmier, Receiver and Channel
B) Source, Encoder, Channel, Transmier, Receiver, Decoder and Sink
C) Source, Encoder, Transmier, Receiver, Channel, Decoder and Sink
D) Source, Encoder, Transmier, Channel, Receiver, Decoder and Sink.
7. Which one of the following network device does the data packets filter and forward between computer networks?
A) repeater. B) switch C) router D) hub
8. Which of the following is a device that connects two or more networks and can filter and forward network traffic based on its desnaon address?
a) Switch b) Router c) Hub d) Modem.
9. How many layers are there in the ISO OSI reference model?
A) 5 B) 6 C) 7 D) 8
10. What is the correct order of the OSI reference model of a computer network from boom to top? a. physical, datalink, network, transport, session, application and presentation.
b. physical, datalink, network, transport, presentation, session and application
c. physical, datalink, transport, network, session, presentation and application
d. physical, datalink, network, transport, session, presentation and application.
11. Which of the following is an incorrect IP address?
A) 192.168.0.1 B) 192.168.1.256 C) 172.255.0.0 D) 202.10.79.4
12. Which of the following IP addresses is wrong?
A) 192.168.0.1 B) 256.2.5.76 C) 127.1.1.1 D) 10.144.1.0
Answers to Multiple Choice Questions.
1 2 3 4 5 6 7 8 9 10 11 12 13Unit 3: Web II
1. Which of the following is generally used for either extraction or removal or changes or addition of records in the database table?
A) DML(Data Manipulation Language). B) DCL (Data Control Language)
C) Relational Schema. D) DDL (Data Definition Language)
2. 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
3. What will be the output of the following JavaScript code?
<script> var p = 100; let q = 100;
document.write(p === q);
</script>
A) 100 B) undefined. C)true. D)false.
4. What will be the output of the following JavaScript code?
<script> var p = “100”; let q = 100;
document.write(p === q);
</script>
A) 100 B) undefined. C)true. D)false
5. Critically analyze the expected output of the provided JavaScript snippet
What would be the value of ‘q’ in the following JavaScript code?”
var a=40; var b=80; q=a%b;
A) 0.5 B) 2 C) 40 D)0
6. Which of the following is a server-side scripting language?
A) JavaScript B) MySQL C) PHP D) JQuery
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. What will be the output of the following PHP code?
<?php $x = 60; $y = 120;
if ($x != $y)
echo "Nepal in Europe.";
else
echo "Nepal in Asia.";
?>
A) 60 is not equal to 120. B) Nepal in Europe. C) Nepal in Asia. D) There will be no output.
9. Which of the following is valid statement in PHP?
A) var a=15; B) let a=15; C) $a=15; D) a=15;
10. What will be the value of s calculated in the following JavaScript code if the value of a is input as 5 and that of b is input as 10? A
<script>
var a=prompt("enter a positive integer");
var b=prompt("enter another positive integer");
var s= a+b;
alert("The value of s is: "+s);
</script>
A) 15 B) garbage value C) 510 D) 0
11. How do you declare a datatype in JavaScript as a constant type?
A) var B) let C) constant D) const
12. Data types in java script are…
A) primary and secondary B) primitive and non-primitive
C) Local and universal D) None of the above.
13. Which of the following methods is used to access HTML elements using JavaScript? A) getElementById() B) getElementByClassName()
C) getElementsByTagName() D) all of the above.
14. What is the correct syntax for referring to an external JavaScript script?
A) <script src=”myscript.js”></script> B) <js href=”mscript.js></js>
C) <script href=”myscript.js”></script> D) <js src=”myscript.js”></js>
15. Predict output in the following JavaScript code:
var a=20;
a===“20” ? document.write(“true”) : document.write(“false”);
a==“20” ? document.write(“true”) : document.write(“false”);
A) true, true. B) false, false. C) false, true. D) true, false.
16. Which of the following is the correct syntax to write a PHP code?
A) <?PHP ?> B) <PHP> C) < ?PHP ?> D)<? ?>
17. Which syntax is used for opening and closing a PHP script?
A) <php> . . . </php> B) <?php . . . ?> C)? php . . .? php D) <p> . . . </p>
18. What output will be obtained from the following JavaScript?
var a=10;
var b=0;
console.log(a/b);
A) 10 is printed. B) 0 is printed. C) Infinity is printed. D) Garbage value.
19. What will be the result of combining a string with another data type in PHP?
A) float. B) int. C) string. D) double.
20. What happens in the following JavaScript code snippet?
var count=0;
while(count<10)
{
console.log(count);
count++;
}
A) The value of the count from 0 to 9 is displayed in the console. B) An exception is thrown C) The value of the count is logged or stored in a particular location or storage. D) An error is displayed
21. Which of the following is the right way to define a constant in PHP?
A) constant PI=“3.1415”; B) const $PI=“3.1415”;
C) constant PI=‘3.1415’; D) const PI=‘3.1415’;
22. What will be the output for given PHP code? <?php const $PI = '3.1415'; echo $PI; ?> A) 3.14 B) 3.1415 C) 3.141 D) PHP Parse error
23. What function do you need to call to ask the user of the program to enter text in JavaScript? A) readLine B) readln C) text D) println
24. Which JavaScript function is used to text input?
A) alert() B) prompt() C) confirm() D) console.log()
25. Which one of the followings is a standard way to show pop-up alert box in JavaScript? A) window.alert("some text") ; B) print.alert("some text ");
C) window(some text); D) show.alert(some text);
26. Which one of the following methods in JQuery simply sets the inline style display: none for the selected elements?
A) show() B) hide() C) display() D) hidden()
Answers to Mulple Choice Quesons.
1 2 3 4 5 6 7 8 9 10 11 12 13 A C C D C C D B C C D B D 14 15 16 17 18 19 20 21 22 23 24 25 26Unit 4: C programs.
1. What will be the output of the program code?
void main()
{
char str1[20]=”Hello”,str2[20]=”world”;
strcat(str1,str2);
puts(str1);
}
A) Hello B) World C) Helloworld D) WorldHello
2. What type of data a user-defined function will return even though the return type of the function has not been defined, whenever called?
A)void B)int C) float D) double.
3. The meaning of int a[5]; int *p; p=&a[0]; in C language is ………
A) p is a pointer to 5 integers
B) p is a pointer to integer array.
C) p is an array of 5 pointers to integers
D) p is a pointer to an array of 5 integers.
4. 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”);
Answers to Mulple Choice Quesons.
1 2 3 4 5 6 7 8 9 10 11 12Unit 5: OOP
1. 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.
2. Which is not a feature of OOP in general definitions?
A) Code reusability B). Efficient Code. C) Modularity. D) Duplicate/Redundant data
3. Under…. Inheritance, there is a derived class with only one base class.
A) Single B) Multiple C) Hierarchical D) None of the above
4. Which feature of OOPs derives the class from another class?
A) Inheritance. B) Data hiding. C) Encapsulaon D) Polymorphism.
5. Child class is derived from base class in ..............
A) Encapsulaon. B) Polymorphism. C) Inheritance D) Data abstracon.
6. Which concept allows you to reuse the written code in OOPs?
A) Encapsulation B) Inheritance C) Polymorphism D) Class
7. In OOPs, public, private, and protected are?
A) Classes B) Interfaces. C) Access Modifiers D) Method signatures.
8. 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
Answers to Mulple Choice Quesons.
1 2 3 4 5 6 7 8 9 10 11 12
Unit 6: Software Process Model.
1. The…. determines whether the project should go forward.
A) Feasibility assessment. B) Opportunity identification.
C) System evaluation. D) Program specification.
2. Which of the following feasibility study is concerned with cost benefit analysis?
A) Technical feasibility. B) Economic feasibility
C) Operational feasibility. D) Schedule feasibility
3. During which phase of the SDLC are system specifications documented?
A) System Design. B) System Implementation.
C) System Testing. D) Planning and Requirements Analysis
4. Conducting feasibility analysis is done in which phase of SDLC?
A) Planning B) Analysis C) Design D) Implementation
5. What is the significance of the Planning phase in the SDLC?
A) It defines the project schedule and budget.
B) It outlines the technical specifications of the system.
C) It identifies project risks and mitigation strategies.
D) It designs the user interface and system architecture.
6. What is the last step in the software development lifecycle as given below?
A) System Design. B) Coding. C) System Testing. D) Preliminary Investigation and Analysis
7. Which phase of the SDLC involves training end-users and preparing the system for deployment? A) Design. B) Implementaon. C) Maintenance. D). Tesng
8. Which phase of the System Life Cycle involves deploying the system and making sure it runs as expected? A) System development. B) System Implementation.
C) System Operations and Maintenance. D) Integration and Testing
9. What does the term “QA” stand for in the software development process?
A) Quality Assurance B) Quality Analysis
C) Quality Assessment D) Quantity Assurance.
Answers to Mulple Choice Quesons.
1 2 3 4 5 6 7 8 9 10 11 12Unit 7: Recent Trends in Technology.
1. Which of the following characteristics defines "Big Data"?
A) Data that can be easily managed with traditional database systems.
B) Data with low velocity and variety.
C) Data with a volume that exceeds the capacity of traditional data management tools. D) Data that is always structured and well-organized.
2. What is the primary benefit of using the IoT in industrial settings (Industrial IoT or IIoT)? A) Cost reduction. B) Entertainment. C) Social networking. D) Health monitoring.
3. Which type of AI system uses pre-defined rules and knowledge to make decisions? A) Deep Learning. B) Reinforcement Learning. C) Genetic Algorithms. D) Expert Systems
4. Which AI technique aims to imitate the way the human brain processes information? A) Reinforcement Learning. B) Neural Networks. C) Genetic Algorithms. D) Decision Trees.
5. What are the four V’s that best define Big Data?
A) Vacant - Victim - Volume-Validity B) Validity - Velocity - Veracity- Volume C) Volume - Velocity - Variety- Veracity D) Varsity - Velocity - Volume- Validity
6. What type of communication technology is commonly used in IoT devices?
A) Wi-Fi B) Bluetooth C) Zigbee D) All of the above
Answers to Mulple Choice Quesons.
1 2 3 4 5 6 7 8 9 10 11 12
Thank you very much for your comment.