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

Product Table:

|Category|Product_Name|Product_Price|State|Country| |---|---|---|---|---| |Furniture|Chair|700 Rs|Colordo|US| |Furniture|Bed|2000 Rs|Colordo|US| |Electronics|TV|1200 Rs|Capetown|Africa| |Electronics|Radio|700 Rs|Delhi|India| |Leather|Bag|800 Rs|Mumbai|India| |Garments|Jacket|2300 Rs|Nairobi|Kenya|

SELECT product SET product_name='Jeans' WHERE product_price> 2000
UPDATE product _nameSET product_name='Jeans' WHERE product_price> 2000
UPDATE product SET product_name='Jeans' WHERE product_price> 2000
UPDATE product SET product_name='Jeans' WHERE product_price IN (Select MAX (product_price) from product)
None of the above

Reveal answer Fill a bubble to check yourself

Multiple choice

Which of the following object privileges is used for stored procedure in a database programming?

INSERT
SELECT
UPDATE
EXECUTE
Both (3) and (4)

Reveal answer Fill a bubble to check yourself

Multiple choice

Student Table:

|Student_ID|First_Name|Last_Name|Subject| |---|---|---|---| |101|Ajit|Sharma|Physics| |102|Ranjit|Singh|Maths| |103|Virat|Kohli|Sport| |104|Suresh|Saxena|Art| |105|Gagan|Chandra|Chemistry|

SELECT student_id, first_name FROM student WHERE subject IN (SELECT first_name FROM student WHERE subject= 'Maths');
SELECT student_id, first_name FROM student WHERE first_name IN (SELECT first_name FROM student WHERE subject= 'Maths');
SELECT student_id, first_name FROM student WHERE student_id IN (SELECT first_name FROM student WHERE subject= 'Maths');
SELECT student_id, first_name FROM student WHERE first_name IN (SELECT student_id FROM student WHERE subject= 'Maths');
None of the above

Reveal answer Fill a bubble to check yourself

Multiple choice

Consider the following two tables:

Student:

|Student_ID|Name| |---|---| |101|Ajit| |102|Ranjit| |103|Virat| |104|Suresh| |105|Gagan|

Mark:

|Student_ID|Total_marks| |---|---| |101|95| |102|91| |103|80| |104|74| |105|69|

Display the students which have marks more than 80.

SELECT a.student_id, a.name, b.total_marks FROM student a, marks b WHERE a.student_id = b.student_id AND total_marks >80;
SELECT a.student_id, a.name, b.total_marks FROM student a, marks b WHERE a.student_id = b.student_id AND a.total_marks >80;
SELECT a.student_id, a.name, b.total_marks FROM student a, marks b WHERE a.student_id = b.student_id AND b.total_marks >80;
SELECT a.student_id, a.name, b.student_id, b.total_marks FROM student a, marks b WHERE a.student_id = b.student_id AND a.total_marks >80;
None of the above

Reveal answer Fill a bubble to check yourself

Multiple choice

Product Table:

SELECT product_name, SUM(product_price) FROM product GROUP BY category where SUM(product_price) > 1500
SELECT product_name, SUM(product_price) FROM product GROUP BY category HAVING SUM(product_price) > 1500
SELECT product_name, product_price FROM product GROUP BY category HAVING SUM(product_price) > 1500
SELECT product_name, SUM(product_price) FROM product GROUP BY category HAVING product_price > 1500
None of the above

Reveal answer Fill a bubble to check yourself

Multiple choice

Student Table:

|Student_ID|First_Name|Last_Name|Subject| |---|---|---|---| |101|Ajit|Sharma|Physics| |102|Ranjit|Singh|Maths| |103|Virat|Kohli|Sport| |104|Suresh|Saxena|Art| |105|Gagan|Chandra|Chemistry|

SELECT student_id, first_name, last_name, subject FROM student WHERE subject != 'Chemistry'
SELECT student_id, first_name, last_name, subject FROM student WHERE subject NOT IN ('Chemistry' )
SELECT student_id, first_name, last_name, subject FROM student WHERE subject = 'Chemistry'
Both (1) and (2)
None of the above

Reveal answer Fill a bubble to check yourself

Multiple choice

Student Table:

|Student_ID|First_Name|Last_Name|Subject| |---|---|---|---| |101|Ajit|Sharma|Physics| |102|Ranjit|Singh|Maths| |103|Virat|Kohli|Sport| |104|Suresh|Saxena|Art| |105|Gagan|Chandra|Chemistry|

SELECT student_id, first_name, last_name FROM student Where first_name IN ('Virat', 'Suresh')
SELECT student_id, first_name, last_name FROM student Where first_name Like ('Virat', 'Suresh')
SELECT student_id, first_name, last_name FROM student Where first_name IN ('Virat' and 'Suresh')
SELECT student_id, first_name, last_name FROM student Where first_name EXISTS ('Virat', 'Suresh')
None of the above

Reveal answer Fill a bubble to check yourself

Multiple choice

Consider the following table:

Product Table:

Write the SQL query to delete those products, which have price equal to 2000 Rs.

Delete FROM product WHERE product_price =2000;
Delete produce_name, Product_price FROM product WHERE product_price =2000;
Delete Product_price FROM product WHERE product_price =2000;
Delete FROM product WHERE product_price ==2000;
None of the above

Reveal answer Fill a bubble to check yourself

Multiple choice

Consider the following table:

Product Table:

Find the details of products which have prices within a range of 1500 and 2500 Rs.

SELECT * FROM product where price>1500 and price<2500
SELECT * FROM product where price>=1500 and price<=2500
SELECT * FROM product where price between 1500 and 2500
Both (2) and (3)
None of the above

Reveal answer Fill a bubble to check yourself

Multiple choice

Student Table:

|Student_ID|First_Name|Last_Name|Subject| |---|---|---|---| |101|Ajit|Sharma|Physics| |102|Ranjit|Singh|Maths| |103|Virat|Kohli|Sport| |104|Suresh|Saxena|Art| |105|Gagan|Chandra|Chemistry|

SELECT * FROM student WHERE first_name LIKE ‘S%’
SELECT * FROM student WHERE name LIKE ‘S%’
SELECT * first_name FROM student WHERE first_name LIKE ‘S%’
SELECT * FROM student WHERE first_name LIKE ‘S’
None of the above

Reveal answer Fill a bubble to check yourself

Multiple choice

Consider the following table:

Product Table:

WAQ to find the details of products whose price is not equal to 2000.

SELECT * FROM product WHERE NOT product_price=2000
SELECT * FROM product WHERE product_price!=2000
SELECT * FROM product WHERE EXCEPT product_price=2000
Both (1) and (2)
(1), (2) and (3) all are true

Reveal answer Fill a bubble to check yourself

Multiple choice

Student Table:

|Student_ID|First_Name|Last_Name|Subject| |---|---|---|---| |101|Ajit|Sharma|Physics| |102|Ranjit|Singh|Maths| |103|Virat|Kohli|Sport| |104|Suresh|Saxena|Art| |105|Gagan|Chandra|Chemistry|

SELECT * FROM student WHERE subject != ’physics’ and subject != ’maths’
SELECT * FROM student WHERE subject != ’physics’, subject != ’maths’
SELECT * FROM student WHERE subject NOT IN (’physics’, ’maths’)
Both (1) and (3)
None of the above

Reveal answer Fill a bubble to check yourself

Multiple choice

Student Table:

|Student_ID|First_Name|Last_Name|Subject| |---|---|---|---| |101|Ajit|Sharma|Physics| |102|Ranjit|Singh|Maths| |103|Virat|Kohli|Sport| |104|Suresh|Saxena|Art| |105|Gagan|Chandra|Chemistry|

SELECT * FROM student WHERE subject=’Maths’ OR subject='Physics’ OR subject=’sport’
SELECT * FROM student WHERE subject IN (’Maths’, ’Physics’, ’sport’)
SELECT * FROM student WHERE subject=’Maths’, subject='Physics’, subject=’sport’
Both (1) and (2)
Both (2) and (3)

Reveal answer Fill a bubble to check yourself

Multiple choice

Which of the following functions in oracle converts a string into unicode in the database unicode character set?

Translate()
Unistr()
Substr()
Upper()
Ascii()

Reveal answer Fill a bubble to check yourself

Multiple choice

Which of the following components of SQL tells the database how a user wants the data to be sorted?

Select
From
Where
Order by
Group by

Reveal answer Fill a bubble to check yourself

← Previous
1
2
…
232
233
234
235
236
237
238
239
240
…
261
262
Next →