Answers to Selected Questions and Problems

COUNT (*) returns the number of rows in a table, including NULL values and duplicates. On the other hand COUNT (column_name) returns number of non-null values. DELETE command is used to delete rows from the table whereas DROP command is used to drop the table from the database. 3(1 mark for each correct difference) Degree=7 and Cardinality=3 ................
................