Computer Knowledge

Database and SQL

4,213 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

Update inventory set price = price*.75 where not exists (select * from invoice_details i where inventory.item_no = i.item_number and inv_no in (select inv_no from invoices where inv_date> = getdate()-30)); The purpose of the above given query is Tables: Invoice_details(item,number,price,invoice_dat,inv_no) Inventory(item_no,price,inv_date,....) Invoices(inv_no,inv_date,....)

  1. to discount only those things that have sales since the inv_date

  2. to discount only those items that have had no sales within the last 30 months

  3. to gives 25% discount to only those items that have had sales within the past 30 days

  4. to discount only those items that have had no sales within the past 30 days

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

Option 4 is the correct answer, as it gives discount to only those items that have had no sales within the past 30 days.

Multiple choice

_______ commands can be used in PL/SQL blocks.

  1. DML

  2. DDL

  3. DCL

  4. None of above
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

PL/SQL is an extension of SQL that allows for procedural logic. It supports DML (Data Manipulation Language) commands like SELECT, INSERT, UPDATE, and DELETE.

Multiple choice

PL/SQL supports all _____ statements.

  1. DML

  2. TCL

  3. SQL

  4. DCL
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

PL/SQL is a procedural extension of SQL. It supports all SQL statements, including DML and DCL, by embedding them directly into its procedural blocks.

Multiple choice

______ is available only with SQL statement.

  1. CEST

  2. CAST

  3. CUST

  4. None of above
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

CAST is a standard SQL function used to convert a value from one data type to another, which is used within SQL statements.

Multiple choice

Which of the following considerations in the design and implementation of active databases states that the condition is evaluated as part of the same transaction, as the triggering event and is evaluated immediately?

  1. Deferred consideration

  2. Immediate consideration

  3. Detached consideration

  4. Action consideration

  5. Reply consideration
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

This consideration in the design and implementation of active databases states that the condition is evaluated as part of the same transaction, as the triggering event and is evaluated immediately.