Database & IT Law

JKSSB Assistant Training Officer (Handicrafts & Handlooms) · Basic Concepts of Computers · 108 practice questions with answers and explanations: 44 Easy, 62 Medium, 2 Hard.

Sample questions

Sample Easy question 1

A form in a database is used to:

  1. Enter and view records easily
  2. Compress files
  3. Print mail
  4. Delete the DBMS
Show answer

Answer: A. Forms give a friendly data-entry screen.

Sample Easy question 2

In SQL, the WHERE clause is used to:

  1. Sort rows
  2. Create tables
  3. Filter rows based on a condition
  4. Join databases
Show answer

Answer: C. WHERE restricts the rows returned.

Sample Easy question 3

In SQL, ORDER BY is used to:

  1. Delete rows
  2. Create an index
  3. Filter rows
  4. Sort the result
Show answer

Answer: D. ORDER BY sorts ascending or descending.

Sample Medium question 4

Section 43 of the IT Act provides for:

  1. E-governance
  2. Digital signatures
  3. Cyber terrorism
  4. Compensation for unauthorised access to and damage of a computer system
Show answer

Answer: D. Section 43 deals with damage and compensation.

Sample Medium question 5

The Controller of Certifying Authorities (CCA):

  1. Regulates the Certifying Authorities that issue digital certificates in India
  2. Regulates banks
  3. Issues Aadhaar numbers
  4. Runs internet providers
Show answer

Answer: A. The CCA is set up under the IT Act.

Sample Medium question 6

In 2015 the Supreme Court struck down Section 66A of the IT Act in:

  1. Shreya Singhal v. Union of India
  2. Vishaka v. State of Rajasthan
  3. Maneka Gandhi v. Union of India
  4. Kesavananda Bharati v. State of Kerala
Show answer

Answer: A. Section 66A violated free speech.

Sample Hard question 7

A table is in third normal form (3NF) when:

  1. No non-key attribute depends on another non-key attribute
  2. All columns are numeric
  3. It has just one row
  4. It has no primary key
Show answer

Answer: A. 3NF removes transitive dependencies.

Sample Hard question 8

A deadlock occurs when:

  1. Two transactions wait for each other's locked resources indefinitely
  2. A password is wrong
  3. A table is full
  4. Memory is cleared
Show answer

Answer: A. Neither transaction can proceed.

More Basic Concepts of Computers topics for JKSSB Assistant Training Officer (Handicrafts & Handlooms)

Related articles