Database & IT Law

Ladakh Police Sub-Inspector · Computer Proficiency · 125 practice questions with answers and explanations: 49 Easy, 74 Medium, 2 Hard.

Sample questions

Sample Easy question 1

Which language is used to define the structure of a database?

  1. TCL
  2. DML
  3. DCL
  4. DDL (Data Definition Language)
Show answer

Answer: D. DDL includes CREATE, ALTER and DROP.

Sample Easy question 2

INSERT, UPDATE and DELETE belong to:

  1. DCL
  2. DML (Data Manipulation Language)
  3. DDL
  4. TCL
Show answer

Answer: B. DML works with the data.

Sample Easy question 3

GRANT and REVOKE belong to:

  1. DDL
  2. DCL (Data Control Language)
  3. TCL
  4. DML
Show answer

Answer: B. DCL controls access rights.

Sample Medium question 4

The Information Technology Act provision on the declaration of a computer resource as a protected system is:

  1. Section 66C
  2. Section 72
  3. Section 70
  4. Section 66E
Show answer

Answer: C. Section 70: the declaration of a computer resource as a protected system.

Sample Medium question 5

Section 72 of the Information Technology Act deals with:

  1. publishing or transmitting material showing children in sexually explicit acts
  2. tampering with computer source documents
  3. breach of confidentiality and privacy by a person who has access to records under the Act
  4. the power of the government to intercept, monitor or decrypt information in the interest of security
Show answer

Answer: C. Section 72: breach of confidentiality and privacy by a person who has access to records under the Act.

Sample Medium question 6

The Digital Personal Data Protection Act, which governs how personal data is processed in India, was passed in:

  1. 2023
  2. 2015
  3. 2000
  4. 2008
Show answer

Answer: A. Parliament passed the DPDP Act in August 2023.

Sample Hard question 7

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.

Sample Hard question 8

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.

More Computer Proficiency topics for Ladakh Police Sub-Inspector

Related articles