Which of the following is not a correct statement? A table can be modified only if it doesn’t contain any rows of data. The maximum number of characters in a table name is 30. You can add more than one column at a time to a table. You can’t recover data contained in a table that has been truncated.

Explain the difference between truncating a table and deleting a table.

What is the maximum number of columns you can define as a primary key when using the column-level approach to creating a table? a. 0 b. 1 c. 30 d. 255

Which command is used to create a table based on data already contained in an existing table?

How do you indicate that a column alias should be used?

Which of the following is true? a. If you truncate a table, you cant add new data to the table. b. If you change the default value of an existing column, all existing rows containing a NULL value in the same column are set to the new DEFAULT value. c. If you delete a column from a table, you cant add a column to the table with the same name as the previously deleted column. d. If you add a column to an existing table, its always added as the last column of the table.

statement can remove the definition of a table. alter table update drop table delete

When you issue the DELETE FROM tablename command without specifying a where condition, Select one: a. The last row will be deleted. b.All rows will be deleted. c.The first row will be deleted. d.No rows will be deleted.

An "Orders" table has 30 columns, and the report only needs the order total by date. Which transformation should you perform?