Related InterviewSolutions

• What will be the output of the following MySQL statement “false OR Null”?(a) True(b) Null(c) False(d) None of the mentionedThe question was asked by my college director while I was bunking the class.Enquiry is from The from Clauses in portion Select Statement of MySQL
• Which Keyword is used to remove duplicate rows in the result set?(a) DISTINCTS(b) MODIFY(c) DISTINCT(d) All of the mentionedI have been asked this question during an interview for a job.I'd like to ask this question from The select Clauses in section Select Statement of MySQL
• Find odd one out?(a) GROUP BY(b) DESC(c) ASC(d) ORDER BYThis question was addressed to me by my school teacher while I was bunking the class.The above asked question is from The order by Clauses in section Select Statement of MySQL
• How can we define the clause “FROM” in Mysql?(a) It defines the tables used by a query(b) It defines the linking of tables in Mysql(c) It defines the tables used by a query & linking of tables in Mysql(d) None of the mentionedThis question was posed to me in quiz.Origin of the question is The from Clauses in chapter Select Statement of MySQL
• Which clause is mandatory with clause “SELECT” in Mysql?(a) FROM(b) WHERE(c) Both FROM and WHERE(d) None of the mentionedI have been asked this question in my homework.The doubt is from The select Clauses topic in chapter Select Statement of MySQL
• Which of the following statements is/are correct with respect to “VIEW”?(a) “VIEW”is a query that stored in the data dictionary(b) There is no data associated with “VIEW”(c) “VIEW” creates virtual tables in Database(d) All of the mentionedThe question was asked during an interview.My question is taken from The from Clauses in chapter Select Statement of MySQL
• “CREATE VIEW …” command is used to create which type of table in Mysql?(a) Permanent Tables(b) Virtual tables(c) Temporary tables(d) All of the mentionedI have been asked this question in an international level competition.My question comes from The from Clauses topic in division Select Statement of MySQL
• “CREATE TABLE …” command is used to create which type of table in Mysql?(a) Permanent Tables(b) Virtual tables(c) Temporary tables(d) All of the mentionedI got this question in an interview for job.The origin of the question is The from Clauses in portion Select Statement of MySQL
• Which among the following can also be included with “SELECT” clause while writing query in Mysql?(a) Literals(b) Expressions(c) User defined functions(d) All of the mentionedI got this question in a national level competition.I need to ask this question from The select Clauses in portion Select Statement of MySQL
• What is the meaning of “ORDER BY” clause in Mysql?(a) Sorting your result set using column data(b) Aggregation of fields(c) Sorting your result set using row data(d) None of the mentionedI had been asked this question in homework.Query is from The order by Clauses in portion Select Statement of MySQL