Which grant table scope columns are case insensitive?(a) Host(b) User(c) Password(d) DbI got this question in unit test.I would like to ask this question from Secure Connections topic in chapter Nulls and Conditions and Miscellaneous of MySQL

Which grant table scope columns are case insensitive?(a) Host(b) User(

1.	Which grant table scope columns are case insensitive?(a) Host(b) User(c) Password(d) DbI got this question in unit test.I would like to ask this question from Secure Connections topic in chapter Nulls and Conditions and Miscellaneous of MySQL
Answer» RIGHT choice is (a) Host To elaborate: ‘Db’ and ‘Table_name’ VALUES are always TREATED as case sensitive even though the TREATMENT of database and table names in SQL statements depends on the FILESYSTEM case sensitivity of the host.

Discussion

No Comment Found

Related InterviewSolutions

The MySQL server is configurable.(a) True(b) FalseThe question was asked at a job interview.This is a very interesting question from Secure Connections in portion Nulls and Conditions and Miscellaneous of MySQL
Is the following statement is true/false?(a) “An expression can be NULL,but can never equal to NULL”(b) True(c) FalseThe question was asked in an online quiz.The above asked question is from Null: the Four Letter Word in division Nulls and Conditions and Miscellaneous of MySQL
Which among the following operators is/are belongs to “Equality conditions”?(a) (b) !=(c) =(d) >/
Select odd one out?(a) Equality Conditions(b) Inequality Conditions(c) Range condition(d) BetweenI have been asked this question in an internship interview.The above asked question is from Condition Types topic in section Nulls and Conditions and Miscellaneous of MySQL
Which of the following statements is/are correct?(a) True OR true =true(b) True OR false= true(c) False OR false= false(d) All of the mentionedI got this question in my homework.This question is from Conditional Evaluation in division Nulls and Conditions and Miscellaneous of MySQL
What is the TLS protocol?(a) transparent layer security(b) transport layer security(c) transparent level security(d) transport level securityI had been asked this question in an interview for job.The query is from Secure Connections in section Nulls and Conditions and Miscellaneous of MySQL
The number of files that each end of a client/server connection including SSL support use to set up secure communications is __________(a) 0(b) 1(c) 2(d) 3The question was posed to me by my college director while I was bunking the class.Question is taken from Secure Connections in section Nulls and Conditions and Miscellaneous of MySQL
Is the following statement is true/false?(a) “Two NULL values are equal to each other”(b) True(c) FalseThis question was addressed to me by my school principal while I was bunking the class.This interesting question is from Null: the Four Letter Word topic in division Nulls and Conditions and Miscellaneous of MySQL
Which operator is used to check the expression is not “NULL”?(a) IS NULL(b) NOT NULL(c) ON(d) None of the mentionedThis question was addressed to me during an online exam.Asked question is from Null: the Four Letter Word topic in section Nulls and Conditions and Miscellaneous of MySQL
What is the meaning of “NULL” in Mysql?(a) Not applicable(b) Value not yet known(c) Value undefined(d) All of the mentionedI got this question during an interview.My doubt stems from Null: the Four Letter Word in portion Nulls and Conditions and Miscellaneous of MySQL

Which grant table scope columns are case insensitive?(a) Host(b) User(c) Password(d) DbI got this question in unit test.I would like to ask this question from Secure Connections topic in chapter Nulls and Conditions and Miscellaneous of MySQL

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment