Querying using MySQL

Which SQL command is used to describe the structure of the table ?

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?

• 7, 5

• 5,7

• 5,5

• None of the above

1. All aggregate functions ignore the __________________ value.

• similar

• NULL

• column

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

• between

• select

• in

1. The ___________ character with LIKE matches any substring.

• _

• %

• *

Delete is a ___________ command , Drop is a ___________ command

• DML, DDL

• DDL, DML

• DCL,DML

1. Output of-

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

• 1

• 3

• 4

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

• UPDATE Student SET FName='Mridul' WHERE FName='Madhur' ;

• MODIFY Student SET FName='Madhur' INTO FName='Mridul ;

• UPDATE Student SET FName='Madhur' INTO FName='Mridul'

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

• False

• True

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

• YY-MM-DD

• YYYY-MM-DD

• YYY-MMM-DDD