A table ‘Student’ contains 5 rows and 4 columns initially. 2 more rows are added and 1 more column is added . What will be the degree and cardinality of the table student after adding these rows and columns?

1. All aggregate functions ignore the __________________ value.

1. To perform condition based on a list, we need to use ____________ clause

1. The ___________ character with LIKE matches any substring.

Delete is a ___________ command , Drop is a ___________ command

1. Output of-

SELECT INSTR(‘UNICODE’,’CO’);

1. Which statement is appropriate to change the first name "Madhur" to "Mridul" in the "FName" column in the 'Student' table?

1. Quotes are required around the standard date and time formats.

1. The default way to store a date in MySQL is with –

1. ______________statement can be used to delete all rows of a table.

Logical operator _______________is used to negate a condition

1. The OR operator displays a record if ANY of the conditions listed are true. The AND operator displays a record if ALL of the conditions listed are true

Which of the following are single row functions:

1. The HAVING clause places conditions on _____________

1. What is the output of-

SELECT ROUND(6.5675, 2);

1. Can a table have multiple primary keys? Can it have multiple foreign keys?