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 1

50 questions

Question 1

Which of the following is a property of a relational database?

A.
Data is stored in tables
B.
Data is stored in a hierarchical structure
C.
Data is stored in a network structure
D.
Data is stored in a linked list

Question 2

50

What is the primary key in a relational database?

A.
A key that uniquely identifies each record in a table
B.
A key that is used to join two tables
C.
A key that is used to sort records in a table
D.
A key that is used to encrypt data in a table

Question 3

What is the purpose of a foreign key in a relational database?

A.
To uniquely identify each record in a table
B.
To establish a relationship between two tables
C.
To sort records in a table
D.
To encrypt data in a table

Question 4

What is normalization in a relational database?

A.
The process of organizing data to reduce redundancy and improve data integrity
B.
The process of encrypting data to ensure security
C.
The process of sorting data in a specific order
D.
The process of compressing data to save storage space

Question 5

What is the first normal form (1NF) in database normalization?

A.
A table that contains no repeating groups or arrays
B.
A table that has a composite primary key
C.
A table that has no foreign keys
D.
A table that is fully normalized

Question 6

What is the second normal form (2NF) in database normalization?

A.
A table that is in 1NF and all non-key attributes are fully functionally dependent on the primary key
B.
A table that has no foreign keys
C.
A table that is fully normalized
D.
A table that contains no repeating groups or arrays

Question 7

What is the third normal form (3NF) in database normalization?

A.
A table that is in 2NF and has no transitive dependencies
B.
A table that has no foreign keys
C.
A table that is fully normalized
D.
A table that contains no repeating groups or arrays

Question 8

What is Boyce-Codd Normal Form (BCNF)?

A.
A table that is in 3NF and every determinant is a candidate key
B.
A table that has no foreign keys
C.
A table that is fully normalized
D.
A table that contains no repeating groups or arrays

Question 9

What is the purpose of an index in a database?

A.
To speed up data retrieval operations
B.
To encrypt data for security
C.
To sort data in a specific order
D.
To compress data to save storage space

Question 10

What is the time complexity of searching for a record in a table with a B-tree index?

A.
$O(\log n)$
B.
$O(n)$
C.
$O(n \log n)$
D.
$O(1)$

Question 11

What is a composite key in a relational database?

A.
A key that consists of two or more columns to uniquely identify a record
B.
A key that is used to join two tables
C.
A key that is used to sort records in a table
D.
A key that is used to encrypt data in a table

Question 12

What is a candidate key in a relational database?

A.
A column or set of columns that can uniquely identify a record in a table
B.
A key that is used to join two tables
C.
A key that is used to sort records in a table
D.
A key that is used to encrypt data in a table

Question 13

What is the difference between a primary key and a unique key?

A.
A primary key cannot contain NULL values, while a unique key can contain one NULL value
B.
A primary key is used to join tables, while a unique key is used to sort records
C.
A primary key is automatically indexed, while a unique key is not
D.
A primary key can contain duplicate values, while a unique key cannot

Question 14

What is a foreign key constraint in a relational database?

A.
A constraint that ensures referential integrity between two tables
B.
A constraint that ensures all values in a column are unique
C.
A constraint that ensures all values in a column are not NULL
D.
A constraint that ensures data is encrypted

Question 15

What is a self-referencing foreign key?

A.
A foreign key that references the primary key of the same table
B.
A foreign key that references the primary key of another table
C.
A foreign key that is used to sort records in a table
D.
A foreign key that is used to encrypt data in a table

Question 16

What is a join in SQL?

A.
A clause used to combine rows from two or more tables based on a related column
B.
A clause used to sort records in a table
C.
A clause used to encrypt data in a table
D.
A clause used to delete records from a table

Question 17

What is an INNER JOIN in SQL?

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

Question 18

What is a LEFT JOIN in SQL?

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

Question 19

What is a RIGHT JOIN in SQL?

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

Question 20

What is a FULL JOIN in SQL?

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

Question 21

What is a Cartesian product in SQL?

A.
The result of a CROSS JOIN, which combines each row of the first table with each row of the second table
B.
The result of an INNER JOIN, which combines only matching rows from both tables
C.
The result of a LEFT JOIN, which combines all rows from the left table with matching rows from the right table
D.
The result of a RIGHT JOIN, which combines all rows from the right table with matching rows from the left table

Question 22

What is a subquery in SQL?

A.
A query nested inside another query
B.
A query that returns all rows from a table
C.
A query that sorts records in a table
D.
A query that encrypts data in a table

Question 23

What is a correlated subquery in SQL?

A.
A subquery that depends on the outer query for its values
B.
A subquery that returns all rows from a table
C.
A subquery that sorts records in a table
D.
A subquery that encrypts data in a table

Question 24

What is a view in SQL?

A.
A virtual table based on the result set of an SQL query
B.
A physical table that stores data
C.
A table that is used to sort records
D.
A table that is used to encrypt data

Question 25

What is a stored procedure in SQL?

A.
A precompiled collection of SQL statements that can be executed as a single unit
B.
A table that stores data
C.
A table that is used to sort records
D.
A table that is used to encrypt data

Question 26

What is a trigger in SQL?

A.
A database object that automatically executes a set of SQL statements when a specific event occurs
B.
A table that stores data
C.
A table that is used to sort records
D.
A table that is used to encrypt data

Question 27

What is a transaction in SQL?

A.
A sequence of operations performed as a single logical unit of work
B.
A table that stores data
C.
A table that is used to sort records
D.
A table that is used to encrypt data

Question 28

What is the purpose of the COMMIT statement in SQL?

A.
To save the changes made during the current transaction
B.
To undo the changes made during the current transaction
C.
To start a new transaction
D.
To encrypt data in a table

Question 29

What is the purpose of the ROLLBACK statement in SQL?

A.
To undo the changes made during the current transaction
B.
To save the changes made during the current transaction
C.
To start a new transaction
D.
To encrypt data in a table

Question 30

What is the purpose of the SAVEPOINT statement in SQL?

A.
To set a point within a transaction to which you can later roll back
B.
To save the changes made during the current transaction
C.
To undo the changes made during the current transaction
D.
To encrypt data in a table

Question 31

What is the purpose of the GRANT statement in SQL?

A.
To give specific privileges to a user or role
B.
To revoke specific privileges from a user or role
C.
To encrypt data in a table
D.
To sort records in a table

Question 32

What is the purpose of the REVOKE statement in SQL?

A.
To revoke specific privileges from a user or role
B.
To give specific privileges to a user or role
C.
To encrypt data in a table
D.
To sort records in a table

Question 33

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 of a SELECT statement
C.
To encrypt the result set of a SELECT statement
D.
To delete records from a table

Question 34

What is the difference between UNION and UNION ALL in SQL?

A.
UNION removes duplicate rows, while UNION ALL includes all rows, including duplicates
B.
UNION includes all rows, including duplicates, while UNION ALL removes duplicate rows
C.
UNION sorts the result set, while UNION ALL does not sort the result set
D.
UNION encrypts the result set, while UNION ALL does not encrypt the result set

Question 35

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 of a SELECT statement
C.
To encrypt the result set of a SELECT statement
D.
To delete records from a table

Question 36

What is the purpose of the HAVING clause in SQL?

A.
To filter groups based on a specified condition
B.
To sort the result set of a SELECT statement
C.
To encrypt the result set of a SELECT statement
D.
To delete records from a table

Question 37

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

A.
To sort the result set of a SELECT statement
B.
To group rows that have the same values in specified columns into summary rows
C.
To encrypt the result set of a SELECT statement
D.
To delete records from a table

Question 38

What is the purpose of the DISTINCT keyword in SQL?

A.
To eliminate duplicate rows from the result set of a SELECT statement
B.
To group rows that have the same values in specified columns into summary rows
C.
To encrypt the result set of a SELECT statement
D.
To delete records from a table

Question 39

What is the purpose of the LIMIT clause in SQL?

A.
To restrict the number of rows returned by a SELECT statement
B.
To group rows that have the same values in specified columns into summary rows
C.
To encrypt the result set of a SELECT statement
D.
To delete records from a table

Question 40

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 group rows that have the same values in specified columns into summary rows
C.
To encrypt the result set of a SELECT statement
D.
To delete records from a table

Question 41

What is the purpose of the LIKE operator in SQL?

A.
To search for a specified pattern in a column
B.
To group rows that have the same values in specified columns into summary rows
C.
To encrypt the result set of a SELECT statement
D.
To delete records from a table

Question 42

What is the purpose of the IN operator in SQL?

A.
To specify multiple values in a WHERE clause
B.
To group rows that have the same values in specified columns into summary rows
C.
To encrypt the result set of a SELECT statement
D.
To delete records from a table

Question 43

What is the purpose of the BETWEEN operator in SQL?

A.
To filter the result set within a specified range
B.
To group rows that have the same values in specified columns into summary rows
C.
To encrypt the result set of a SELECT statement
D.
To delete records from a table

Question 44

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

A.
To check if a column contains NULL values
B.
To group rows that have the same values in specified columns into summary rows
C.
To encrypt the result set of a SELECT statement
D.
To delete records from a table

Question 45

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

A.
To check if a column does not contain NULL values
B.
To group rows that have the same values in specified columns into summary rows
C.
To encrypt the result set of a SELECT statement
D.
To delete records from a table

Question 46

What is the purpose of the EXISTS operator in SQL?

A.
To check if a subquery returns any rows
B.
To group rows that have the same values in specified columns into summary rows
C.
To encrypt the result set of a SELECT statement
D.
To delete records from a table

Question 47

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

A.
To check if a subquery does not return any rows
B.
To group rows that have the same values in specified columns into summary rows
C.
To encrypt the result set of a SELECT statement
D.
To delete records from a table

Question 48

What is the purpose of the CASE statement in SQL?

A.
To perform conditional logic in SQL queries
B.
To group rows that have the same values in specified columns into summary rows
C.
To encrypt the result set of a SELECT statement
D.
To delete records from a table

Question 49

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 group rows that have the same values in specified columns into summary rows
C.
To encrypt the result set of a SELECT statement
D.
To delete records from a table

Question 50

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 group rows that have the same values in specified columns into summary rows
C.
To encrypt the result set of a SELECT statement
D.
To delete records from a table

Practice another set Take a test on this chapter →