SQL Programming Language

Question

Consider the following table:

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|

Determine the name and price of the product of the US country. Select the correct option.

Answer 1

SELECT product_name FROM product WHERE country= 'US'

Answer 2

SELECT product_name FROM product WHERE product_name IN (SELECT product_name FROM Product WHERE country= US)

Answer 3

SELECT product_name FROM product WHERE product_name IN (SELECT product_name FROM Product WHERE country= 'US')

Answer 4

Both (1) and (3)

Answer 5

None of the above

Answer 6

SELECT first_name, last_name, subject FROM student_details WHERE subject = 'Economics'

Answer 7

SELECT first_name, last_name, subject FROM student_details WHERE marks>90

Answer 8

SELECT first_name, last_name, subject FROM student_details WHERE marks=>90

Answer 9

Both (1) and (3)

Answer 10

None of the above

Answer 11

SELECT product_name, sum(product_price) FROM product

Answer 12

SELECT product_name, product_price FROM product group by state

Answer 13

SELECT product_name, sum(product_price) FROM product group by state

Answer 14

SELECT sum(product_price) FROM product group by state

Answer 15

None of the above

Answer 16

SELECT product SET product_name='Jeans' WHERE product_price> 2000

Answer 17

UPDATE product _nameSET product_name='Jeans' WHERE product_price> 2000

Answer 18

UPDATE product SET product_name='Jeans' WHERE product_price> 2000

Answer 19

UPDATE product SET product_name='Jeans' WHERE product_price IN (Select MAX (product_price) from product)

Answer 20

None of the above

Answer 21

A SQL GRANT is a command used to provide access or privileges on the database objects to the users.

Answer 22

A System privileges allows the user to CREATE, ALTER, or DROP the database objects.

Answer 23

The REVOKE command is used to remove the user access rights or privileges to the database objects.

Answer 24

All of the above

Answer 25

Only (1) and (2)

Answer 26

Both (3) and (4)

Answer 27

SELECT student_id, first_name FROM student WHERE subject IN (SELECT first_name FROM student WHERE subject= 'Maths');

Answer 28

SELECT student_id, first_name FROM student WHERE first_name IN (SELECT first_name FROM student WHERE subject= 'Maths');

Answer 29

SELECT student_id, first_name FROM student WHERE student_id IN (SELECT first_name FROM student WHERE subject= 'Maths');

Answer 30

SELECT student_id, first_name FROM student WHERE first_name IN (SELECT student_id FROM student WHERE subject= 'Maths');

Answer 31

None of the above

Answer 32

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;

Answer 33

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;

Answer 34

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;

Answer 35

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;

Answer 36

None of the above

Answer 37

SELECT product_name, SUM(product_price) FROM product GROUP BY category where SUM(product_price) > 1500

Answer 38

SELECT product_name, SUM(product_price) FROM product GROUP BY category HAVING SUM(product_price) > 1500

Answer 39

SELECT product_name, product_price FROM product GROUP BY category HAVING SUM(product_price) > 1500

Answer 40

SELECT product_name, SUM(product_price) FROM product GROUP BY category HAVING product_price > 1500

Answer 41

None of the above

Answer 42

SELECT student_id, first_name, last_name, subject FROM student WHERE subject != 'Chemistry'

Answer 43

SELECT student_id, first_name, last_name, subject FROM student WHERE subject NOT IN ('Chemistry' )

Answer 44

SELECT student_id, first_name, last_name, subject FROM student WHERE subject = 'Chemistry'

Answer 45

Both (1) and (2)

Answer 46

None of the above

Answer 47

SELECT student_id, first_name, last_name FROM student Where first_name IN ('Virat', 'Suresh')

Answer 48

SELECT student_id, first_name, last_name FROM student Where first_name Like ('Virat', 'Suresh')

Answer 49

SELECT student_id, first_name, last_name FROM student Where first_name IN ('Virat' and 'Suresh')

Answer 50

SELECT student_id, first_name, last_name FROM student Where first_name EXISTS ('Virat', 'Suresh')

Answer 51

None of the above

Answer 52

Delete FROM product WHERE product_price =2000;

Answer 53

Delete produce_name, Product_price FROM product WHERE product_price =2000;

Answer 54

Delete Product_price FROM product WHERE product_price =2000;

Answer 55

Delete FROM product WHERE product_price ==2000;

Answer 56

None of the above

Answer 57

SELECT * FROM product where price>1500 and price<2500

Answer 58

SELECT * FROM product where price>=1500 and price<=2500

Answer 59

SELECT * FROM product where price between 1500 and 2500

Answer 60

Both (2) and (3)

Answer 61

None of the above

Answer 62

SELECT * FROM student WHERE first_name LIKE ‘S%’

Answer 63

SELECT * FROM student WHERE name LIKE ‘S%’

Answer 64

SELECT * first_name FROM student WHERE first_name LIKE ‘S%’

Answer 65

SELECT * FROM student WHERE first_name LIKE ‘S’

Answer 66

None of the above

Answer 67

SELECT * FROM product WHERE NOT product_price=2000

Answer 68

SELECT * FROM product WHERE product_price!=2000

Answer 69

SELECT * FROM product WHERE EXCEPT product_price=2000

Answer 70

Both (1) and (2)

Answer 71

(1), (2) and (3) all are true

Answer 72

SELECT * FROM student WHERE subject != ’physics’ and subject != ’maths’

Answer 73

SELECT * FROM student WHERE subject != ’physics’, subject != ’maths’

Answer 74

SELECT * FROM student WHERE subject NOT IN (’physics’, ’maths’)

Answer 75

Both (1) and (3)

Answer 76

None of the above

Answer 77

SELECT * FROM student WHERE subject=’Maths’ OR subject='Physics’ OR subject=’sport’

Answer 78

SELECT * FROM student WHERE subject IN (’Maths’, ’Physics’, ’sport’)

Answer 79

SELECT * FROM student WHERE subject=’Maths’, subject='Physics’, subject=’sport’

Answer 80

Both (1) and (2)

Answer 81

Both (2) and (3)

SQL Programming Language

Questions

Consider the following table:

Product Table:

Consider the following table:

Product Table:

Product Table:

Student Table:

Student:

Mark:

Product Table:

Student Table:

Student Table:

Consider the following table:

Product Table:

Consider the following table:

Product Table:

Student Table:

Consider the following table:

Product Table:

Student Table:

Student Table: