Database & IT Law

J&K Bank PO · Computer Aptitude · 125 practice questions with answers and explanations: 49 Easy, 74 Medium, 2 Hard.

Sample questions

Sample Easy question 1

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 Easy question 2

A report in a database is used to:

  1. Create tables
  2. Encrypt data
  3. Present data in a printable format
  4. Delete data
Show answer

Answer: C. Reports format output.

Sample Easy question 3

A query is:

  1. A request for data from a database
  2. A table
  3. A keyboard
  4. A virus
Show answer

Answer: A. Queries retrieve or change data.

Sample Medium question 4

SELECT DISTINCT:

  1. Sorts the values
  2. Removes duplicate values from the result
  3. Counts the rows
  4. Deletes the rows
Show answer

Answer: B. DISTINCT returns unique values.

Sample Medium question 5

GROUP BY is used with:

  1. Permissions
  2. Table creation
  3. Aggregate functions to group rows
  4. Encryption
Show answer

Answer: C. It groups rows that share a value.

Sample Medium question 6

Referential integrity ensures that:

  1. Tables have equal rows
  2. Data is sorted
  3. Data is encrypted
  4. A foreign key value matches a primary key in the related table
Show answer

Answer: D. It prevents orphan records.

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 Computer Aptitude topics for J&K Bank PO

Related articles