Computer Knowledge

Database and SQL

3,929 Questions

Master structured query language commands, database joins, table constraints, and alias generation. This section covers relational database management concepts and query outputs essential for technical aptitude. These technical questions feature prominently in banking IT officer exams and computer knowledge sections.

SQL queries and aliasesDatabase table constraintsDatabase joins and transformationsStored procedures and functions

Database and SQL Questions

Multiple choice

Which of the following is/are false about column indexing in the database?

  1. A column indexing makes the fast access for selecting the data.

  2. A column indexing makes the DML (Data Manipulation Language) operations slow down.

  3. More than one indexes are possible in a particular table.

  4. Indexers can be applied on a part of a column.

  5. None of the above
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

All of the above are the true statements.

Multiple choice

Which of the following role is not performed by DBA in DBMS?

  1. Schema definition

  2. Liaising with users

  3. Defining security and integrity checks

  4. Defining backup/Recovery procedures

  5. Specifying primary key
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

This is not the role of the DBA in DBMS as specification of primary key is done by the user.

Multiple choice

We can't rename an object created in MS-Access.

  1. True

  2. False

  3. Can't say

  4. Sometimes

  5. None of these
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

MS-Access allows objects (tables, queries, forms, reports, macros, and modules) to be renamed by right-clicking and selecting Rename, or by selecting and pressing F2. The statement is false because renaming is a standard feature available for all database objects in Access.

Multiple choice

‘AS’ clause is used in SQL for

  1. projection operation

  2. join operation

  3. rename operation

  4. selection operation

  5. delete operation
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

‘AS’ clause is used in SQL for rename operation.

Multiple choice

How many categories fall in SQL plus commands?

  1. DDL only

  2. DML only

  3. DCL only

  4. DDL, DML and DCL
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

This is the right answer because SQL commands fall into three categories like DDL (Data Definition Language), DML (Date Manipulation Language) and DCL (Data Control Language). All these categories are a part of the SQL commands and SQL commands are also terminated by a semicolon (;) in Oracle. So, this is the right answer.