Database Questions

1. What MySQL function is use to retrieve data?

• SELECT

• UPDATE

• DELETE

• INSERT

What optimal data type for a `status` field which holds value of only 0,1,2,3 ?

• tinyint

• smallint

• int

• bigint

Is a process used to organize database into tables and columns?

• Normalization

• Sharding

• Scaling

• Join

What is a MySQL feature which enhances the speed execution of a select query?

• Indexing

• sharding

• scaling

• viewing

What MySQL keyword is used alongside other keyword to analyze your queries?

• explain

• group by

• hash

• where

What MySQL feature is used to combine rows from 2 or more tables based on related column between them?

• join

• inner join

• outer join

• select

Is a virtual table based on the result-set of an SQL statement?

• views

• query

• select

• update

What data type is optimal if it accepts date & time?

• date_time

• currdatetime

• timestamp

• date

What is the alternative to avoid using OR while still be able to use indexing?

• union

• full

• select

• update

A query nested inside a larger query

• sub-queries

• intersect

• join

• inner join