Question

A table from the computer course database is given below. Answer the following questions based on
this table: 3
Tutorial ID Title Category
101 ACCESS TUTORIAL SOFTWARE
102 EXCEL TUTORIAL SOFTWARE
103 DATABASE DESIGN
TUTORIAL
SOFTWARE
104 ORACLE DBA COURSE SOFTWARE
105 RAID STORAGE TUTORIAL HARDWARE
106 NETWORK SECURITY
TUTORIAL
NETWORKS
a. What is the total number of records in the table?
b. What is the total number of fields in the table?
c. What is the title of the record with category "networks"?
d. Which category has the maximum number of records?
e. Identify the primary key of the table? Why?

Answer 1

Answer:

The SQL COUNT() function returns the number of rows in a table satisfying the criteria specified in the WHERE clause. It sets the number of rows or non NULL column values. COUNT() returns 0 if there were no matching rows