Question

Plzz answer this question​

Answer 1

Answer:

google pe search karlo

Answer 2

Answer:

Explanation: (A)

1. SQL&>CREATE TABLE STUDENTS (  

2. BOOK ID INT   NOT NULL,  

3. SUBJECT VARCHAR (20) NOT NULL,  

4. BOOK PRICE INT NOT NULL,  

5. );  

(B)

INSERT INTO STUDENTS (BOOKID,SUBJECT,BOOKPRICE,...);

VALUES (‘1001’ ‘INFORMATION TECHNOLODGY’ ‘180’,’1002’ ‘SCIENCE’ ‘100’

, ‘1003’ ‘MATHS’ ‘125’, ‘1004’ ‘ENGLISH’ ‘150’);

(C)

SELECT BOOK ID 1001 ;

FROM STUDENTS ;

(D)

SELECT BOOK ID 1003;

MODIFY BOOK PRICE FROM 125 TO 175 ;

FROM STUDENTS

(E)

DELETE FROM BOOK ID ‘1004’ WHERE condition;

(F)

1. Select anywhere in the table.

2. Select Table Tools Layout & Sort.