Trinity - MySQL SERVER Interview Preparation Questions
Call
whatsapp
9447387064 | 9847003556
0471-2335855 | 8089080088 | 0471-2334855
9447387064 | 9847003556
0471-2335855 | 8089080088 | 0471-2334855
Cisco Training in Trivandrum, Trinity Technologies

No.1 Training Institute in Kerala

MySQL QUESTIONS : PART 4

Which keyword in the UPDATE statement is used to assign values to columns?

ASSIGN

SET

MARK

GET

SHOW ANSWER

Which keyword is used to delete all the rows from the table?

TRUNCATE

REMOVE

DELETE ALL

CLEAR

SHOW ANSWER

What is generally done after the transactions are executed successfully?

delete

rollback

commit

update

SHOW ANSWER

What is generally done if an error occurs during the transaction?

delete

rollback

commit

update

SHOW ANSWER

Which key declares that an index in one table is related to that in another?

primary

secondary

foreign

cross

SHOW ANSWER

Which keyword is used to specify the foreign key after the table is created?

SETUP

SET

ALTER TABLE

SPECIFY

SHOW ANSWER
BACK | NEXT
TRINITY SOFTWARE SOLUTIONS,IInd floor, Radheyam Towers, Gandhari Amman Kovil Road, Pulimood, Trivandrum - 1
0471-2334855 | 2335855 | 9447387064 | 9847003556 info@trinitytechnology.in