Database and SQL

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

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

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

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

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

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

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

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

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)

Translate()

Unistr()

Substr()

Upper()

Ascii()

Select

From

Where

Order by

Group by

Alternate key

Candidate key

Foreign key

Tertiary key

Secondary key

DDL

DSL

DML

TCL

DDD

Primary key and foreign key of a database are not the same.

Structure of the database is not defined during the database construct.

Users are not affected by changes to the structure of the database.

Structure of the database can be altered by anyone.

Changes made to the physical structure is affected to the logical structure of the database.

The name should not contain more than 16 characters.

The name must start with a letter.

The name can contain letters, numbers and underscores.

The name should not contain spaces.

The table name may contain any special character other than underscore.