Columns can not be inserted in to a table once it is created is it tru

1.	Columns can not be inserted in to a table once it is created is it true or false
Answer» Answer: False Explanation: Tables are database objects that are created to store data .In a database table individual records form ROWS WHEREAS columns define individual traits or attributes. At the time of creating tables, the columns and their data types are defined but this structure is not frozen, more columns can be added, dropped or even modified to change the data type. All this can be done keeping the data integrity features (PRIMARY & foreign key) in mind. ALTER TABLE is the SQL COMMAND that makes adding more columns to a database table, possible after it's creation. ALTER TABLE - ADD ALLOWS adding new columns. ALTER TABLE - DROP COLUMN allows dropping a column from an existing table. ALTER TABLE - MODIFY allows change of data type of the specified column. Hope this helps.

Columns can not be inserted in to a table once it is created is it true or false

Answer»

Answer:

False

Explanation:

Tables are database objects that are created to store data .In a database table individual records form ROWS WHEREAS columns define individual traits or attributes.

At the time of creating tables, the columns and their data types are defined but this structure is not frozen, more columns can be added, dropped or even modified to change the data type. All this can be done keeping the data integrity features (PRIMARY & foreign key) in mind.

ALTER TABLE is the SQL COMMAND that makes adding more columns to a database table, possible after it's creation.

ALTER TABLE - ADD ALLOWS adding new columns.

ALTER TABLE - DROP COLUMN allows dropping a column from an existing table.

ALTER TABLE - MODIFY allows change of data type of the specified column.

Hope this helps.

Discussion

No Comment Found

Related InterviewSolutions

Which sign is semicolom
There are 10,48,576 rows by 16,384 columns in excel true ot false
Comppund formula having single mathematical operator
Which is the best interpretation of the graph?A. A small amount of anxiety is not enough to help the students perform better on a test.B.The higher a student's anxiety, the greater the probability of a good test score.C. A small amount of anxiety can help students perform better on tests.D. The higher a student's anxiety, the lower the likelihood of overcoming it.
मेरी आमा र म निबन्ध
1. Which key is not used for selecting a range of cell in a worksheet?b. Shiftd. None of thesea. Ctrlc. Alt
List of Bidentate and monodentate ligands
What is Cycle case? Explain with example.
(9),CEF in base 16 to base 10
State whether it is true or false.1. 5X6 means a table with columns of 5 rows T or F2. MS PowerPoint is spreadsheet software T or F