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 the correct query to display name of student from the student table having name as 'aman' or 'harish'?

  1. select name from studentwhere name ='aman' and 'harish';

  2. select 'aman' and 'harish'from student;

  3. select namefrom studentwhere name like 'aman' or name like 'harish';

  4. select name from studentwhere name is 'aman' and 'harish';

  5. select 'aman' and 'harish'from studentwhere name = student;
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

This is the correct query as it makes use of like predicate to match the correct student names.

Multiple choice

Which of the following statements in SQL allows users to control the properties of their current session by enabling or disabling roles of users and changing language settings?

  1. DML Statements

  2. System Control Statements

  3. Embedded SQL Statements

  4. Session Control Statements

  5. Transaction Control Statements
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

These statements in SQL allow users to control the properties of their current session by enabling or disabling roles of users and changing language settings.

Multiple choice

Align is an attribute of

  1. p

  2. hr

  3. table

  4. all of the above
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The align attribute was commonly used with multiple HTML elements including paragraphs (p), horizontal rules (hr), and tables (table) to control horizontal positioning of content.