Q .Which of following operation will create duplication of table.
1. Deleting a table
2. Copying a table
3. Creating a table
4. Moving a table
Answers
Answer:
copying a table
Explanation:
mark me as brain list
Answer:
The answer is
option (2). Copying a table
You can make several copies of a table by copying it.
Explanation:
To make a table copy. Make sure the databases inside which you would like to create the table is chosen in Object Explorer and that you are connecting to it. Select Design by performing a right-click in Object Explorer on the table you want to copy.
With the help of the MySQL copy or clone table feature, we may make an exact replica of an existing table, complete with its structures, index, constraints, initial values, etc. In a circumstance like backing up information in case of table failure, copying data from an existing database onto a new table is quite helpful.
Choose the cell or cells you would like to copy. On the Edit menu, select Copy.
Click in the cell in which you want the data to display, then select Paste from the Edit menu to copy the data there. If you want the data to
stay distinct while duplicating various cells, pick the same amount of cells as in step 1 and then select Paste from the Menu settings.
#SPJ3