Latest notices:

NEC licence exam preparation, made clearer.Practice questions, syllabus guides, and timed mocks for Nepal engineers.New study resources are added regularly.

Login Sign up

Syllabus

NEC Computer · Practice

Chapters & sets

1. Basic Electrical and Electronics

Basic Electrical

Set 1106

Basic Electronics

Set 171 Set 233

2. Digital Logic and Microprocessor

Digital Logic

Set 150 Set 250 Set 350 Set 450 Set 550 Set 650 Set 749 Set 851 Set 950 Set 1050 Set 1150 Set 1232

Microprocessor

Set 150 Set 250 Set 350 Set 445 Set 550 Set 650 Set 720 Set 850 Set 969

3. Programming Language and Its Applications

Mixed chapter MCQs

Set 150 Set 249 Set 349 Set 451 Set 540

4. Computer Organization and Embedded System

Mixed chapter MCQs

Set 150 Set 249 Set 350 Set 450 Set 550 Set 650 Set 750 Set 849 Set 950 Set 1050 Set 1150

5. Concept of Computer Network and Network Security System

Basic Networking

Set 150 Set 253

Advanced Networking

Set 150 Set 250 Set 350 Set 450 Set 550 Set 655

6. Theory of Computation and Computer Graphics

Theory of Computation

Set 150 Set 250 Set 360

Computer Graphics

Set 150 Set 251 Set 350 Set 450 Set 550

7. Data Structures and Algorithm, Database System and Operating System

8. Software Engineering and Object-Oriented Analysis & Design

Mixed chapter MCQs

Set 150 Set 250 Set 350 Set 450 Set 550 Set 650 Set 750 Set 926

9. Artificial Intelligence and Neural Networks

Mixed chapter MCQs

Set 150 Set 317 Set 450 Set 550 Set 650 Set 750 Set 850 Set 932

10. Project Planning, Design and Implementation

Engineering Drawing

Set 150 Set 267

Engineering Economics

Set 168

Project Planning & Scheduling

Set 188

Project Mangement

Set 150

Engineering Professional Practice

Set 120

Engineering Regulatory Body

Set 130

DBMS Set 2

57 questions

Question 1

What is a transaction in a database?

A.
A sequence of operations performed as a single logical unit of work
B.
A single SQL query
C.
A backup operation
D.
A data compression operation

Question 2

50

What is the purpose of the COMMIT statement in a database transaction?

A.
To save the changes made during the transaction permanently
B.
To undo the changes made during the transaction
C.
To start a new transaction
D.
To compress the database

Question 3

What is the purpose of the ROLLBACK statement in a database transaction?

A.
To undo the changes made during the transaction
B.
To save the changes made during the transaction permanently
C.
To start a new transaction
D.
To compress the database

Question 4

What is a deadlock in a database?

A.
A situation where two or more transactions are waiting indefinitely for one another to release locks on resources
B.
A situation where a transaction is waiting for a resource that is never released
C.
A situation where a transaction is aborted due to an error
D.
A situation where the database is compressed

Question 5

What is the purpose of the SAVEPOINT statement in a database transaction?

A.
To set a point within a transaction to which you can later roll back
B.
To save the changes made during the transaction permanently
C.
To start a new transaction
D.
To compress the database

Question 6

What is a view in a database?

A.
A virtual table based on the result set of a SQL query
B.
A physical table that stores data
C.
A backup of a table
D.
A compressed version of a table

Question 7

What is the purpose of a trigger in a database?

A.
To automatically execute a set of SQL statements in response to certain events
B.
To compress the database
C.
To back up the database
D.
To create a new table

Question 8

What is a stored procedure in a database?

A.
A precompiled collection of SQL statements that can be executed as a single unit
B.
A backup of the database
C.
A compressed version of the database
D.
A virtual table based on a SQL query

Question 9

What is the purpose of a cursor in a database?

A.
To traverse and manipulate the result set of a query row by row
B.
To compress the database
C.
To back up the database
D.
To create a new table

Question 10

What is the purpose of the GROUP BY clause in SQL?

A.
To group rows that have the same values in specified columns into summary rows
B.
To sort the result set in ascending or descending order
C.
To filter rows based on a condition
D.
To join two or more tables

Question 11

What is the purpose of the HAVING clause in SQL?

A.
To filter groups based on a condition
B.
To sort the result set in ascending or descending order
C.
To filter rows based on a condition
D.
To join two or more tables

Question 12

What is the purpose of the ORDER BY clause in SQL?

A.
To sort the result set in ascending or descending order
B.
To group rows that have the same values in specified columns into summary rows
C.
To filter rows based on a condition
D.
To join two or more tables

Question 13

What is the purpose of the DISTINCT keyword in SQL?

A.
To eliminate duplicate rows from the result set
B.
To sort the result set in ascending or descending order
C.
To filter rows based on a condition
D.
To join two or more tables

Question 14

What is the purpose of the UNION operator in SQL?

A.
To combine the result sets of two or more SELECT statements into a single result set
B.
To sort the result set in ascending or descending order
C.
To filter rows based on a condition
D.
To join two or more tables

Question 15

What is the purpose of the JOIN clause in SQL?

A.
To combine rows from two or more tables based on a related column between them
B.
To sort the result set in ascending or descending order
C.
To filter rows based on a condition
D.
To eliminate duplicate rows from the result set

Question 16

What is the purpose of the INNER JOIN in SQL?

A.
To return only the rows that have matching values in both tables
B.
To return all rows from the left table and the matched rows from the right table
C.
To return all rows from the right table and the matched rows from the left table
D.
To return all rows from both tables, with NULLs where there are no matches

Question 17

What is the purpose of the LEFT JOIN in SQL?

A.
To return all rows from the left table and the matched rows from the right table
B.
To return only the rows that have matching values in both tables
C.
To return all rows from the right table and the matched rows from the left table
D.
To return all rows from both tables, with NULLs where there are no matches

Question 18

What is the purpose of the RIGHT JOIN in SQL?

A.
To return all rows from the right table and the matched rows from the left table
B.
To return only the rows that have matching values in both tables
C.
To return all rows from the left table and the matched rows from the right table
D.
To return all rows from both tables, with NULLs where there are no matches

Question 19

What is the purpose of the FULL OUTER JOIN in SQL?

A.
To return all rows from both tables, with NULLs where there are no matches
B.
To return only the rows that have matching values in both tables
C.
To return all rows from the left table and the matched rows from the right table
D.
To return all rows from the right table and the matched rows from the left table

Question 20

What is the purpose of the CROSS JOIN in SQL?

A.
To return the Cartesian product of the two tables
B.
To return only the rows that have matching values in both tables
C.
To return all rows from the left table and the matched rows from the right table
D.
To return all rows from the right table and the matched rows from the left table

Question 21

What is the purpose of the EXISTS operator in SQL?

A.
To test for the existence of any record in a subquery
B.
To sort the result set in ascending or descending order
C.
To filter rows based on a condition
D.
To join two or more tables

Question 22

What is the purpose of the NOT EXISTS operator in SQL?

A.
To test for the non-existence of any record in a subquery
B.
To sort the result set in ascending or descending order
C.
To filter rows based on a condition
D.
To join two or more tables

Question 23

What is the purpose of the CASE statement in SQL?

A.
To perform conditional logic in SQL queries
B.
To sort the result set in ascending or descending order
C.
To filter rows based on a condition
D.
To join two or more tables

Question 24

What is the purpose of the COALESCE function in SQL?

A.
To return the first non-NULL value in a list of arguments
B.
To sort the result set in ascending or descending order
C.
To filter rows based on a condition
D.
To join two or more tables

Question 25

What is the purpose of the NULLIF function in SQL?

A.
To return NULL if two expressions are equal, otherwise return the first expression
B.
To sort the result set in ascending or descending order
C.
To filter rows based on a condition
D.
To join two or more tables

Question 26

What is the purpose of the IS NULL operator in SQL?

A.
To test whether a value is NULL
B.
To sort the result set in ascending or descending order
C.
To filter rows based on a condition
D.
To join two or more tables

Question 27

What is the purpose of the IS NOT NULL operator in SQL?

A.
To test whether a value is not NULL
B.
To sort the result set in ascending or descending order
C.
To filter rows based on a condition
D.
To join two or more tables

Question 28

What is the purpose of the BETWEEN operator in SQL?

A.
To filter rows based on a range of values
B.
To sort the result set in ascending or descending order
C.
To filter rows based on a condition
D.
To join two or more tables

Question 29

What is the purpose of the LIKE operator in SQL?

A.
To filter rows based on a pattern match
B.
To sort the result set in ascending or descending order
C.
To filter rows based on a condition
D.
To join two or more tables

Question 30

What is the purpose of the IN operator in SQL?

A.
To filter rows based on a list of values
B.
To sort the result set in ascending or descending order
C.
To filter rows based on a condition
D.
To join two or more tables

Question 31

What is the purpose of the ANY operator in SQL?

A.
To compare a value to any value in a list or subquery
B.
To sort the result set in ascending or descending order
C.
To filter rows based on a condition
D.
To join two or more tables

Question 32

What is the purpose of the ALL operator in SQL?

A.
To compare a value to all values in a list or subquery
B.
To sort the result set in ascending or descending order
C.
To filter rows based on a condition
D.
To join two or more tables

Question 33

What is the purpose of the LIMIT clause in SQL?

A.
To limit the number of rows returned by a query
B.
To sort the result set in ascending or descending order
C.
To filter rows based on a condition
D.
To join two or more tables

Question 34

What is the purpose of the OFFSET clause in SQL?

A.
To skip a specified number of rows before returning the result set
B.
To sort the result set in ascending or descending order
C.
To filter rows based on a condition
D.
To join two or more tables

Question 35

What is the purpose of the FETCH clause in SQL?

A.
To limit the number of rows returned by a query
B.
To sort the result set in ascending or descending order
C.
To filter rows based on a condition
D.
To join two or more tables

Question 36

What is the purpose of the WITH clause in SQL?

A.
To define a temporary result set that can be referenced within a SELECT, INSERT, UPDATE, or DELETE statement
B.
To sort the result set in ascending or descending order
C.
To filter rows based on a condition
D.
To join two or more tables

Question 37

What is the purpose of the UNION ALL operator in SQL?

A.
To combine the result sets of two or more SELECT statements into a single result set, including duplicates
B.
To sort the result set in ascending or descending order
C.
To filter rows based on a condition
D.
To join two or more tables

Question 38

What is the purpose of the INTERSECT operator in SQL?

A.
To return the common rows between two SELECT statements
B.
To sort the result set in ascending or descending order
C.
To filter rows based on a condition
D.
To join two or more tables

Question 39

What is the purpose of the EXCEPT operator in SQL?

A.
To return the rows that are in the first SELECT statement but not in the second SELECT statement
B.
To sort the result set in ascending or descending order
C.
To filter rows based on a condition
D.
To join two or more tables

Question 40

What is the purpose of the CREATE TABLE statement in SQL?

A.
To create a new table in the database
B.
To sort the result set in ascending or descending order
C.
To filter rows based on a condition
D.
To join two or more tables

Question 41

What is the purpose of the ALTER TABLE statement in SQL?

A.
To modify the structure of an existing table
B.
To sort the result set in ascending or descending order
C.
To filter rows based on a condition
D.
To join two or more tables

Question 42

What is the purpose of the DROP TABLE statement in SQL?

A.
To delete an existing table from the database
B.
To sort the result set in ascending or descending order
C.
To filter rows based on a condition
D.
To join two or more tables

Question 43

What is the purpose of the TRUNCATE TABLE statement in SQL?

A.
To delete all rows from a table without deleting the table structure
B.
To sort the result set in ascending or descending order
C.
To filter rows based on a condition
D.
To join two or more tables

Question 44

What is the purpose of the INSERT INTO statement in SQL?

A.
To add new rows of data to a table
B.
To sort the result set in ascending or descending order
C.
To filter rows based on a condition
D.
To join two or more tables

Question 45

What is the purpose of the UPDATE statement in SQL?

A.
To modify existing data in a table
B.
To sort the result set in ascending or descending order
C.
To filter rows based on a condition
D.
To join two or more tables

Question 46

What is the purpose of the DELETE statement in SQL?

A.
To remove rows from a table
B.
To sort the result set in ascending or descending order
C.
To filter rows based on a condition
D.
To join two or more tables

Question 47

What is the purpose of the CREATE INDEX statement in SQL?

A.
To create an index on one or more columns of a table to improve query performance
B.
To sort the result set in ascending or descending order
C.
To filter rows based on a condition
D.
To join two or more tables

Question 48

What is the purpose of the DROP INDEX statement in SQL?

A.
To delete an existing index from a table
B.
To sort the result set in ascending or descending order
C.
To filter rows based on a condition
D.
To join two or more tables

Question 49

What is the purpose of the CREATE VIEW statement in SQL?

A.
To create a virtual table based on the result set of a SQL query
B.
To sort the result set in ascending or descending order
C.
To filter rows based on a condition
D.
To join two or more tables

Question 50

What is the purpose of the DROP VIEW statement in SQL?

A.
To delete an existing view from the database
B.
To sort the result set in ascending or descending order
C.
To filter rows based on a condition
D.
To join two or more tables

Question 51

What is the purpose of the CREATE PROCEDURE statement in SQL?

A.
To create a stored procedure that can be executed later
B.
To sort the result set in ascending or descending order
C.
To filter rows based on a condition
D.
To join two or more tables

Question 52

What is the purpose of the DROP PROCEDURE statement in SQL?

A.
To delete an existing stored procedure from the database
B.
To sort the result set in ascending or descending order
C.
To filter rows based on a condition
D.
To join two or more tables

Question 53

What is the purpose of the CREATE FUNCTION statement in SQL?

A.
To create a user-defined function that can be used in SQL queries
B.
To sort the result set in ascending or descending order
C.
To filter rows based on a condition
D.
To join two or more tables

Question 54

What is the purpose of the DROP FUNCTION statement in SQL?

A.
To delete an existing user-defined function from the database
B.
To sort the result set in ascending or descending order
C.
To filter rows based on a condition
D.
To join two or more tables

Question 55

What is the purpose of the CREATE TRIGGER statement in SQL?

A.
To create a trigger that automatically executes a set of SQL statements in response to certain events
B.
To sort the result set in ascending or descending order
C.
To filter rows based on a condition
D.
To join two or more tables

Question 56

What is the purpose of the DROP TRIGGER statement in SQL?

A.
To delete an existing trigger from the database
B.
To sort the result set in ascending or descending order
C.
To filter rows based on a condition
D.
To join two or more tables

Question 57

What is the purpose of the GRANT statement in SQL?

A.
To give specific privileges to a user or role
B.
To sort the result set in ascending or descending order
C.
To filter rows based on a condition
D.
To join two or more tables

Practice another set Take a test on this chapter →