MCQ IN COMPUTER SCIENCE & ENGINEERING

Previous
Next

COMPUTER SCIENCE AND ENGINEERING

SQL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which of the following allows you to add Address column with string value up to 50 characters in your EMP table?
A
ALTER TABLE emp ADD address VARCHAR2(50);
B
ALTER TABLE emp ADD COLUMN address VARCHAR2(50);
C
ALTER TABLE emp ADD address VARCHAR2(30);
D
ALTER TABLE emp DROP COLUMN address;
Explanation: 

Detailed explanation-1: -To delete a table, use the DROP TABLE statement.

Detailed explanation-2: -You want to change the mobile number to ‘92745612’ of Student ID ‘101’, on the emp table which command will execute correctly? UPDATE emp SET mobile number = ‘92745612’ WHERE student id = ‘101’;

There is 1 question to complete.
Previous
Next