Introduction to SQL Quiz-6

Share with others

Welcome to your Introduction to SQL Quiz-6

Q51. What is the purpose of following command?

Alter Table Student Drop Fee;

Q52. Write a command to remove primary key of table EMP.

Q53. Name a constraint used to specify the default value to an attribute in a table.

Q54. Write a command to remove an attribute "Author" from the table "Book".

Q55. What is the purpose of following query?

ALTER TABLE table_name DROP PRIMARY KEY;

Q56. We can use __________________ statement to remove a database permanently from the system.

Q57. We can use __________________ statement to remove a table permanently from the system.

Q58. Write a command to delete table 'Stock' permanently.

Q59. Write a command to delete database 'mydb' permanently.

Q60. ____________________ statement is used to insert new records in a table.


Share with others

Leave a Reply

error: Content is protected !!