Database and SQL

Foreign key

Primary key

Check

Default

None of these

Savepoint

Commit

Rollback

Set transaction

None of these

Declaring the cursor

Opening a cursor

Fetching data from cursor

Closing the cursor

Active data set

Procedure

Triggers

Cursor

Function

Alert

Create

Alter

Delete

Drop

Grant

To replicate the data.

To enforce business rules.

To execute business rules

All of the above.

Only (1) and (2).

1NF

2NF

3NF

4NF

BCNF

Structured Query Luggage

Structured Query Language

Structured Quite Language

Standard Query Language

SELECT product_name FROM product WHERE country= 'US'

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

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

Both (1) and (3)

None of the above

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

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

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

Both (1) and (3)

None of the above

SELECT product_name, sum(product_price) FROM product

SELECT product_name, product_price FROM product group by state

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

SELECT sum(product_price) FROM product group by state

None of the above

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

INSERT

SELECT

UPDATE

EXECUTE

Both (3) and (4)

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

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