SQL - Function n Joins

Count() is which kind of function?

• Single Row Function

• Many Row Function

• Multi row function

• None

Correct difference between count() and count (*) function is ....

• count () will count total no. of values/null values in an attribute.

• count (*) will count total no. of values in an attribute.

• count () will count total no. of null values in an attribute.

• count (*) will count total no. of values/null values in an attribute.

Which command is use to display all tables/ relations in a database?

• Show Databases

• Show Tables

• Display Tables

• Display Databases

Which of the following is not an aggregate function in mysql?

• lower()

• avg()

• min()

• max()

Write query to display all employee records whose city is not mentioned in city column.

Table name : Employee

Which of the following is not a constraint?

• Unique

• Primary Key

• Not Null

• Candidate key

What will be best suited for Constraints:

• fixed values

• check or condition on an attribute

• keyword

• Reserve words

Difference between where and having clause is

• WHERE clause is used to filter rows before the grouping is performed

• Having clause is used to filter rows before the grouping is performed

• WHERE clause is used to filter rows After the grouping is performed

• None

A table EMP hold 5 rows and 4 columns. Accountant Ravi added 3 more records of new employees and one column CITY in the given table. What will be degree and cardinality of the table now.

• Cardinality-5

  Degree-8

• Degree-5

  Cardinality-8

• Cardinality-5

  Degree-4

• Cardinality-4

  Degree-5

values that are permitted in an attribute

• key

• values

• domain

• set