Database & IT Law

JKSSB Junior Assistant · Basic Concepts of Computers · 108 practice questions with answers and explanations: 44 Easy, 62 Medium, 2 Hard.

Sample questions

Sample Easy question 1

Which SQL command changes existing data?

  1. INSERT
  2. CREATE
  3. UPDATE
  4. SELECT
Show answer

Answer: C. UPDATE modifies stored values.

Sample Easy question 2

Which SQL command removes rows from a table?

  1. UPDATE
  2. SELECT
  3. DELETE
  4. INSERT
Show answer

Answer: C. DELETE removes records.

Sample Easy question 3

Which SQL command creates a new table?

  1. NEW TABLE
  2. MAKE TABLE
  3. CREATE TABLE
  4. ADD TABLE
Show answer

Answer: C. CREATE TABLE defines a table.

Sample Medium question 4

The Information Technology Act provision on cheating by personation using a computer resource is:

  1. Section 66D
  2. Section 66B
  3. Section 69
  4. Section 72
Show answer

Answer: A. Section 66D: cheating by personation using a computer resource.

Sample Medium question 5

Section 66E of the Information Technology Act deals with:

  1. violation of privacy by capturing or sharing the private images of a person
  2. tampering with computer source documents
  3. the power of the government to intercept, monitor or decrypt information in the interest of security
  4. breach of confidentiality and privacy by a person who has access to records under the Act
Show answer

Answer: A. Section 66E: violation of privacy by capturing or sharing the private images of a person.

Sample Medium question 6

Section 66F of the Information Technology Act deals with:

  1. publishing or transmitting material showing children in sexually explicit acts
  2. dishonestly receiving a stolen computer resource or communication device
  3. identity theft, such as the fraudulent use of someone's password or digital signature
  4. cyber terrorism
Show answer

Answer: D. Section 66F: cyber terrorism.

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 Junior Assistant

Related articles