173 + Interview Questions in Using Sql To Manage Data in Mysql Page 3 InterviewSolution

101.	The comma operator can also be used to join tables.(a) True(b) FalseI have been asked this question during a job interview.My question is based upon Performing Multiple topic in division Using SQL to Manage Data of MySQL
Answer» Correct choice is (a) True Easy explanation: The COMMA (,) operator can be USED to join the tables as well. It JOINS them in the ‘INNER JOIN’ type. It is not desirable to USE the comma operator since it has different PRECEDENCE rules.

Discussion

102.	CROSS JOIN and JOIN are similar to __________(a) INNER JOIN(b) NATURAL JOIN(c) OUTER JOIN(d) CARTESIAN JOINI had been asked this question by my school principal while I was bunking the class.This key question is from Performing Multiple in portion Using SQL to Manage Data of MySQL
Answer» RIGHT ANSWER is (a) INNER JOIN The best I can explain: The joins ‘CROSS JOIN’ and ‘JOIN’ types are EXACTLY similar to the ‘INNER JOIN’. The statements containing ‘INNER JOIN’ can replace it with ‘CROSS JOIN’ or ‘JOIN’ to get exactly the same RESULT.

Discussion

103.	The clause that filters JOIN results is called _________(a) WHERE(b) SORT(c) GROUP(d) GROUP BYThis question was posed to me in a job interview.Asked question is from Performing Multiple topic in section Using SQL to Manage Data of MySQL
Answer» Correct answer is (a) WHERE To elaborate: Sometimes the RESULT of a join is very LARGE and is not desirable. In these cases, the RESULTS can be filtered with the HELP of the ‘WHERE’ clause which is FOLLOWED by a set of condition(s).

Discussion

104.	The join where all possible row combinations are produced is called _________(a) INNER JOIN(b) OUTER(c) NATURAL(d) CARTESIANThe question was asked in semester exam.This question is from Performing Multiple topic in section Using SQL to Manage Data of MySQL
Answer» Correct answer is (d) CARTESIAN To explain I would SAY: In ‘cartesian PRODUCT’, each row of each table is COMBINED with each row in every other table to produce all POSSIBLE combination. This produces a very large number of rows SINCE the number is the product of rows.

Discussion

105.	In inner join, result is produced by matching rows in one table with rows in another table.(a) True(b) FalseThe question was asked in quiz.Query is from Performing Multiple in portion Using SQL to Manage Data of MySQL
Answer» Correct choice is (a) True Easy explanation: The inner join is a form of join in MySQL that is USED to combine the result of concatenating the CONTENTS of two TABLES into a new table. In inner join, result is produced by matching rows in ONE table with rows in ANOTHER table.

Discussion

106.	SELECT select_list FROM table_list WHERE row_constraint GROUP BY grouping_columns; Which of these is not optional?(a) select_list(b) table_list(c) row_constraint(d) grouping_columnsI had been asked this question in an online interview.I'd like to ask this question from Performing Multiple in section Using SQL to Manage Data of MySQL
Answer» RIGHT ANSWER is (a) select_list The explanation: GIVEN above was a basic syntax of the SELECT statement. Everything in the syntax is OPTIONAL EXCEPT the ‘select_list’ option. All the others are free to be omitted, and will work fine.

Discussion

107.	The option in mysqlshow to show information about indexes in a table is _________(a) –no-data(b) –indexes(c) –keys(d) –flagI got this question in an interview for job.My doubt stems from Obtaining Database Metadata in section Using SQL to Manage Data of MySQL
Answer» The CORRECT answer is (c) –keys Explanation: The ‘mysqlshow’ command has VARIOUS FLAGS to PROVIDE a lot of options on displaying tables. The ‘–keys’ flag is specifically used to SHOW information about indexes in a table.

Discussion

108.	The command which lists databases managed by the server is _____________(a) mysqld(b) mysqlshow(c) mysqllist(d) mysqldbI have been asked this question in homework.This interesting question is from Obtaining Database Metadata topic in portion Using SQL to Manage Data of MySQL
Answer» Correct answer is (b) MYSQLSHOW For explanation: The ‘mysqlshow’ command provides ALMOST the similar information as some ‘SHOW’ statements. It also enables to EXTRACT DATABASE and table information at the command PROMPT.

Discussion

109.	Which table stores information about the threads executing within the server?(a) PROCESS(b) PROCESSLIST(c) LIST(d) THREADSLISTThis question was posed to me during an online interview.The query is from Obtaining Database Metadata topic in chapter Using SQL to Manage Data of MySQL
Answer» Right answer is (b) PROCESSLIST Easiest explanation: The table ‘PROCESSLIST’ is RESPONSIBLE for storing all the INFORMATION about the THREADS executing within the SERVER. The other TABLES are not valid tables in the INFORMATION_SCHEMA.

Discussion

110.	INFORMATION_SCHEMA is more portable than SHOW statements.(a) True(b) FalseThe question was asked during an interview.Query is from Obtaining Database Metadata topic in section Using SQL to Manage Data of MySQL
Answer» The correct choice is (a) True Easiest explanation: The ‘INFORMATION_SCHEMA’ is a METHOD to access INFORMATION about the databases and its OBJECTS known as METADATA. Its content is MySQL-specific which makes it more PORTABLE.

Discussion

111.	Which table in INFORMATION_SCHEMA stores information about storage engines and server plugins?(a) ENGINES, PLUGINS(b) FILES, PLUGINS(c) ENGINES, FILES(d) PLUGINS, STATISTICSThe question was posed to me during an online interview.This key question is from Obtaining Database Metadata topic in division Using SQL to Manage Data of MySQL
Answer» CORRECT option is (a) ENGINES, PLUGINS The best I can EXPLAIN: The ‘INFORMATION_SCHEMA’ is a very useful in MySQL. It has many tables each serving its INDIVIDUAL purpose. The storage ENGINE information is stored in ENGINES and PLUGIN information in PLUGINS.

Discussion

112.	The information about table index characteristics is stored in which table of INFORMATION_SCHEMA?(a) FILES(b) STATISTICS(c) SCHEMATA(d) VIEWSThis question was addressed to me during a job interview.I would like to ask this question from Obtaining Database Metadata in division Using SQL to Manage Data of MySQL
Answer» Correct CHOICE is (B) STATISTICS The EXPLANATION: The ‘STATISTICS’ table in the ‘INFORMATION_SCHEMA’ stores information about the table index characteristics. ‘INFORMATION_SCHEMA’ is responsible for storing DATABASE metadata.

Discussion

113.	Which disk data does FILES table in INFORMATION_SCHEMA store?(a) NDB(b) NBD(c) NBK(d) NCDI have been asked this question in an online interview.I would like to ask this question from Obtaining Database Metadata topic in section Using SQL to Manage Data of MySQL
Answer» Correct option is (a) NDB For explanation I would SAY: The ‘INFORMATION_SCHEMA’ is a method to access INFORMATION about the DATABASES and its objects KNOWN as METADATA. It has various tables that can be viewed with ‘SHOW’ statement.

Discussion

114.	INFORMATION_SCHEMA is based on the SQL standard.(a) True(b) FalseI had been asked this question in an international level competition.Query is from Obtaining Database Metadata in division Using SQL to Manage Data of MySQL
Answer» Correct CHOICE is (a) True Explanation: ‘INFORMATION_SCHEMA’ is another way to access INFORMATION about the DATABASES and its objects (metadata). It is based on the ‘SQL STANDARD’, although some content is MySQL-specific.

Discussion

115.	Which statement is used to determine the storage engine for individual tables?(a) SHOW STATUS OF TABLE(b) SHOW STATUS TABLE(c) SHOW TABLE STATUS(d) SHOW DEFAULT STATUSI got this question at a job interview.The above asked question is from Obtaining Database Metadata in division Using SQL to Manage Data of MySQL
Answer» Correct option is (C) SHOW TABLE STATUS To elaborate: MySQL PROVIDES a method to determine the storage engine for each table with the ‘SHOW TABLE STATUS’ STATEMENT. The output of this statement is the NAME of the storage engine indicator.

Discussion

116.	The general term for information about databases and the objects in MySQL is _________(a) datum(b) info(c) record(d) metadataThe question was asked in class test.I'd like to ask this question from Obtaining Database Metadata topic in section Using SQL to Manage Data of MySQL
Answer» RIGHT ANSWER is (d) metadata Best EXPLANATION: There are various ways in which MySQL facilitates the methods to obtain information about DATABASES and the objects in them. For example, ‘SHOW’ statements and ‘INFORMATION_SCHEMA’.

Discussion

117.	The statement to change the table name is __________(a) CHANGE(b) CHANGENAME(c) CHANGENM(d) RENAMEI got this question in class test.This intriguing question comes from Creating, Dropping, Indexing and Altering Tables topic in portion Using SQL to Manage Data of MySQL
Answer» The correct choice is (d) RENAME Easy explanation: To change the name of a table, the keyword ‘RENAME’ can be used. It can be used with the ‘ALTER TABLE’ clause. It can ALSO be used as a statement in itself LIKE ‘RENAME TABLE old_tbl new_tbl’.

Discussion

118.	The default index type for MEMORY tables is __________(a) HASH(b) SPATIAL(c) FULLTEXT(d) UNIQUEI had been asked this question in a national level competition.My query is from Creating, Dropping, Indexing and Altering Tables topic in section Using SQL to Manage Data of MySQL
Answer» The correct option is (a) HASH The best explanation: The ‘HASH’ index is the default index TYPE for ‘MEMORY’ tables. ‘SPATIAL’ can only be used with ‘MyISAM’ tables for the spatial DATA types. ‘FULLTEXT’ is used for performing full-text searches.

Discussion

119.	It is possible to drop multiple tables in the same statement.(a) True(b) FalseThe question was posed to me in exam.This intriguing question originated from Creating, Dropping, Indexing and Altering Tables in division Using SQL to Manage Data of MySQL
Answer» Right CHOICE is (a) True Easy EXPLANATION: To drop a table, all that is required is the table name. No additional information like table format or TYPE is necessary. Multiple TABLES are DROPPED in the same DROP TABLE statement.

Discussion

120.	Which storage engine enables to access tables from a MySQL server managed by another server?(a) InnoDB(b) EXAMPLE(c) MyISAM(d) FEDERATEDThe question was asked by my college professor while I was bunking the class.My question is taken from Creating, Dropping, Indexing and Altering Tables in portion Using SQL to Manage Data of MySQL
Answer» The correct CHOICE is (d) FEDERATED Easiest EXPLANATION: There are many storage engines that are used in MySQL. By default, MyISAM is used as the storage engine unless specified OTHERWISE. FEDERATED ENABLES access to a foreign MySQL server.

Discussion

121.	Which keyword is used to create a table as a temporary copy of itself?(a) TEMP(b) TEMPO(c) TEMPR(d) TEMPORARYThis question was posed to me at a job interview.This intriguing question comes from Creating, Dropping, Indexing and Altering Tables topic in division Using SQL to Manage Data of MySQL
Answer» Correct OPTION is (d) TEMPORARY To EXPLAIN: The ‘CREATE TABLE’ CLAUSE has a very vast FORMAL format, although its USAGE is extremely simple and intuitive. One of the many ways is to create a table as a temporary copy of itself.

Discussion

122.	In the CREATE TABLE statement, the engine name specified is case sensitive.(a) True(b) FalseThis question was addressed to me in unit test.My question is taken from Creating, Dropping, Indexing and Altering Tables topic in chapter Using SQL to Manage Data of MySQL
Answer» Correct choice is (b) False To elaborate: Suppose a table is CREATED using the following STATEMENT: ‘CREATE TABLE my_tbl (…..) ENGINE = INNODB;’. The engine name ‘InnoDB’ USED is always case insensitive.

Discussion

123.	What is the name of the format file for a table named my_tbl?(a) my_tbl.fmt(b) my_tbl.frm(c) my_tbl.fmr(d) my_tbl.ftmThe question was posed to me in my homework.The above asked question is from Creating, Dropping, Indexing and Altering Tables in portion Using SQL to Manage Data of MySQL
Answer» Correct answer is (b) my_tbl.frm To elaborate: Every TIME a table is CREATED in MySQL, it creates a DISK file containing the format of the table. It has two components, namely, BASE name (here, ‘my_tbl’) and an extension (here, ‘frm’).

Discussion

124.	The default storage engine used is ____________(a) EXAMPLE(b) ARCHIVE(c) MyISAM(d) NDBThis question was posed to me by my school teacher while I was bunking the class.Query is from Creating, Dropping, Indexing and Altering Tables in portion Using SQL to Manage Data of MySQL
Answer» Right choice is (c) MyISAM Explanation: MySQL comes with multiple storage engines. The default storage ENGINE USED is ‘MyISAM’. ‘EXAMPLE’ is the STUB storage engine, NDB is the storage engine for MySQL CLUSTER.

Discussion

125.	Which storage engine is not available in MySQL 5.0?(a) InnoDB(b) ARCHIVE(c) Falcon(d) NDBThis question was posed to me during an interview.My enquiry is from Creating, Dropping, Indexing and Altering Tables in section Using SQL to Manage Data of MySQL
Answer» CORRECT option is (c) Falcon To elaborate: All of the storage engines given are available in MYSQL versions 5.0 and above, except ‘Falcon’. MySQL supports many storage engines or table HANDLERS that have a specific SET of properties.

Discussion

126.	Which statement is used to remove indexes on tables?(a) DROP INDEX(b) DELETE INDEX(c) REMOVE INDEX(d) FLUSH INDEXThe question was posed to me in unit test.My doubt is from Creating, Dropping, Indexing and Altering Tables in portion Using SQL to Manage Data of MySQL
Answer» Correct choice is (a) DROP INDEX The best I can EXPLAIN: MySQL provides statements to change the structure of tables. To add or remove the INDEXES on the EXISTING database tables, the ‘CREATE INDEX’ and ‘DROP INDEX’ tables are USED.

Discussion

127.	Which statement makes changes to the database’s global attributes?(a) CHANGE(b) ALTER(c) ALTERNATE(d) UPDATEThe question was posed to me in class test.The question is from Selecting, Creating, Dropping and Altering Databases topic in section Using SQL to Manage Data of MySQL
Answer» RIGHT choice is (b) ALTER The explanation: The ‘ALTER TABLE’ STATEMENT is used to MAKE changes to a database’s global attributes. This statement is followed by the NAME of the database, CHARACTER set and collation.

Discussion

128.	Which statement is used to see the definition for an existing database?(a) SHOW CREATE DATABASE(b) SHOW DATABASE(c) SHOW CREATE(d) SHOW CREATE DATABASE TABLEI got this question during an interview.Enquiry is from Selecting, Creating, Dropping and Altering Databases topic in chapter Using SQL to Manage Data of MySQL
Answer» CORRECT OPTION is (a) SHOW CREATE DATABASE For EXPLANATION: The statement ‘SHOW CREATE DATABASE’ is invoked to see the definition of an EXISTING database in the MySQL server. It is followed by the qualified name of the database.

Discussion

129.	MySQL stores the database character set and collation attributes in the file _________(a) dp.opt(b) db.opt(c) db.sv(d) db.zipThis question was posed to me in my homework.This intriguing question comes from Selecting, Creating, Dropping and Altering Databases in section Using SQL to Manage Data of MySQL
Answer» Right option is (b) db.opt For EXPLANATION I would say: The FILE named ‘db.opt’ is of a great significance to MYSQL, espectially the MySQL server. It stores the database attributes along with the db charset and collation attributes.

Discussion

130.	If COLLATE is given without CHARACTER SET, the first part of the collation name gives the character set.(a) True(b) FalseThe question was asked by my school principal while I was bunking the class.My enquiry is from Selecting, Creating, Dropping and Altering Databases topic in portion Using SQL to Manage Data of MySQL
Answer» Right choice is (a) True For explanation I would say: When a database is created, the ‘CHARACTER SET’ and ‘COLLATE’ values are SPECIFIED. When ‘CHARACTER SET’ is given WITHOUT ‘COLLATE’, the default COLLATION is used.

Discussion

131.	To create a database only if it doesn’t already exist, which clause is used?(a) IF EXISTS(b) IF NOT EXISTS(c) CREATE EXISTS(d) EXISTS IFThe question was asked during an interview for a job.Question is from Selecting, Creating, Dropping and Altering Databases in division Using SQL to Manage Data of MySQL
Answer» The CORRECT choice is (b) IF NOT EXISTS Best explanation: The ‘CREATE DATABASE’ STATEMENT supports MANY optional values. To create a database named ‘my_db’ only if it doesn’t already EXIST, we write ‘CREATE DATABASE IF NOT EXISTS my_db’.

Discussion

132.	The file created by the server to store the database attributes is __________(a) db.otp(b) dp.zip(c) db.opt(d) db.clsThis question was posed to me in an interview for job.I would like to ask this question from Selecting, Creating, Dropping and Altering Databases topic in portion Using SQL to Manage Data of MySQL
Answer» RIGHT choice is (c) db.opt Explanation: WHENEVER a database is created in MySQL, the MySQL server CREATES a directory with the same NAME as the database. It creates the file db.opt to store the ATTRIBUTES.

Discussion

133.	Which keyword is used to create a database?(a) CREATE(b) SET(c) SETUP(d) LINKI have been asked this question by my school principal while I was bunking the class.I want to ask this question from Selecting, Creating, Dropping and Altering Databases in chapter Using SQL to Manage Data of MySQL
Answer» The correct answer is (a) CREATE Explanation: The STATEMENT ‘CREATE DATABASE database_name;’ is USED to create a database with the NAME ‘database_name’. A database qualifier should be used to SPECIFY the full name of the database.

Discussion

134.	It is not required to have an access privilege for a database before selecting it with ‘USE’.(a) True(b) FalseThe question was posed to me in quiz.The question is from Selecting, Creating, Dropping and Altering Databases topic in section Using SQL to Manage Data of MySQL
Answer» The correct ANSWER is (b) False To explain I would SAY: In order to select a database as the default database for the MySQL SERVER USING the ‘USE’ statement, some access privilege for the database needs to be granted or attained.

Discussion

135.	Which keyword is the synonym for DATABASE?(a) TABLE(b) OBJECT(c) DB(d) SCHEMAI had been asked this question in examination.My enquiry is from Selecting, Creating, Dropping and Altering Databases topic in portion Using SQL to Manage Data of MySQL
Answer» Right option is (d) SCHEMA Easy explanation: In any STATEMENT where the word ‘DATABASE’ OCCURS, the keyword ‘SCHEMA’ can be used as a SYNONYM in PLACE of it. In the literal sense, SCHEMA refers to the structure of the database.

Discussion

136.	Which statement is used to select a default database?(a) USE(b) CREATE(c) DROP(d) SCHEMAThis question was addressed to me at a job interview.This key question is from Selecting, Creating, Dropping and Altering Databases in chapter Using SQL to Manage Data of MySQL
Answer» The CORRECT ANSWER is (a) USE To elaborate: MySQL has the facility to use VARIOUS statements specifically at the database level. For selecting a DEFAULT database, the keyword or clause used is the ‘USE’ statement.

Discussion

137.	What is generally used as a synonym for CHARACTER SET?(a) CSET(b) CHSET(c) CHARSET(d) CHCSETThe question was asked in an international level competition.This interesting question is from Character Set Support in chapter Using SQL to Manage Data of MySQL
Answer» CORRECT answer is (c) CHARSET Easiest explanation: ‘CHARACTER SET’ can be abbreviated into ‘CHARSET’ and can be USED in the same contexts and statements where ‘CHARACTER SET’ is used. ‘charset’ is the server-supported character set.

Discussion

138.	Post MySQL 6.0, utf8 was ___________(a) 3 bytes(b) 4 bytes(c) 5 bytes(d) 6 bytesThis question was posed to me during an online exam.The query is from Character Set Support in portion Using SQL to Manage Data of MySQL
Answer» The CORRECT OPTION is (b) 4 bytes The explanation is: Unicode support PRIOR to MySQL 6.0 was different from that post MySQL 6.0. The older utf8 was of three bytes. The newer utf8 is now of FOUR bytes. This is applicable to MySQL 6.0 and above.

Discussion

139.	Prior to MySQL 6.0, utf8 was ___________(a) 3 bytes(b) 4 bytes(c) 8 bytes(d) 9 bytesI have been asked this question in final exam.This question is from Character Set Support in division Using SQL to Manage Data of MySQL
Answer» Right answer is (a) 3 bytes For explanation: ‘UTF’ stands for ‘Unicode TRANSFORMATION Format’. Unicode SUPPORT prior to MySQL 6.0 was different from that post MySQL 6.0. The older UTF8 was of THREE bytes.

Discussion

140.	What does UTF stand for int utf8?(a) Universal Transformation Format(b) Unicode Transformation Format(c) Universal Transformation Formula(d) Unicode Transformation FormulaThe question was posed to me in an interview for job.I need to ask this question from Character Set Support topic in division Using SQL to Manage Data of MySQL
Answer» RIGHT option is (B) UNICODE Transformation Format Easiest explanation: In the utf8 character set in MySQL, the characters are represented in ONE, two or three bytes. ‘UTF’ stands for ‘Unicode Transformation Format’. Unicode support prior to MySQL 6.0 was DIFFERENT.

Discussion

141.	Which statement is used to show the server’s current character set and collation settings?(a) SHOW CONSTANTS(b) SHOW CONSTRAINTS(c) SHOW VARIABLES(d) DISP VARIABLESI got this question in a national level competition.This interesting question is from Character Set Support topic in portion Using SQL to Manage Data of MySQL
Answer» CORRECT option is (c) SHOW VARIABLES Easy EXPLANATION: The statement ‘SHOW VARIABLES LIKE ‘character\_set\_%” displays a table consisting of two COLUMNS, ‘Variable_name’ and ‘VALUE’. Replacing characer\_set\_% with collation\_% shows the collation variables.

Discussion

142.	Which MySQL statement is used to find out which character sets are available?(a) SHOW CHARACTER SET(b) SHOW COLLATION(c) SHOW CHARACTER SETS(d) SHOW COLLATIONSThis question was posed to me in homework.My enquiry is from Character Set Support topic in portion Using SQL to Manage Data of MySQL
Answer» Right option is (a) SHOW CHARACTER SET The BEST I can explain: It is SIMPLE to determine the character SETS and collations that are available in MySQL. ‘SHOW CHARACTER SET’ SHOWS the character sets while ‘SHOW COLLATION’ shows the collations.

Discussion

143.	Which clause can be used to sort string values according to a specific collation?(a) SORT(b) GROUP(c) FILTER(d) COLLATEThis question was addressed to me in class test.Origin of the question is Character Set Support in division Using SQL to Manage Data of MySQL
Answer» Correct answer is (d) COLLATE The best I can EXPLAIN: The ‘COLLATE’ operator can be used to sort the string values ACCORDING to a specific collation. For example, ‘SELECT COL FROM TBL ORDER BY col COLLATE latin1_swedish_ci’ sorts by swedish collation.

Discussion

144.	Unicode support is provided in MySQL.(a) True(b) FalseThis question was addressed to me in unit test.My question is taken from Character Set Support topic in division Using SQL to Manage Data of MySQL
Answer» The correct choice is (a) True For EXPLANATION: In MySQL, UNICODE character set support is provided by the utf8 and ucs2 character SETS. There are further ADDITIONAL character sets available as of MySQL version 6.0.4.

Discussion

145.	What is the maximum collations a character set can have?(a) 0(b) 1(c) 2(d) more than 1This question was posed to me in an interview for internship.I need to ask this question from Character Set Support topic in section Using SQL to Manage Data of MySQL
Answer» Right option is (d) more than 1 Easy EXPLANATION: The MYSQL server allows simultaneous use of MULTIPLE character sets. A given character set is allowed to have one or more collations. It can be chosen ACCORDING to the need of the DATABASE.

Discussion

146.	What is AI in terms of database collation?(a) Accent Insensitive(b) Augment Insensitive(c) Articulate Insensitive(d) Addition InsensitiveI got this question during an interview.The question is from Case Sensitivity in SQL Statements in portion Using SQL to Manage Data of MySQL
Answer» Correct choice is (a) Accent INSENSITIVE To explain: The collation in the database can also be specified in the join or comparison conditions. The VALUE ‘AI’ MEANS ‘Accent Insensitive’. ‘CS’ is case sensitive and ‘CI’ is case insensitive.

Discussion

147.	Which property determines whether a database object is a case sensitive?(a) COLLATION(b) ATOMICITY(c) COLLABORATION(d) NORMALIZATIONI got this question by my college director while I was bunking the class.I need to ask this question from Case Sensitivity in SQL Statements topic in division Using SQL to Manage Data of MySQL
Answer» The CORRECT answer is (a) COLLATION For explanation I WOULD say: The way to determine whether a database OBJECT or a database is case sensitive or not is to check the ‘COLLATION’ property. The result would be either CI for insensitive or CS for sensitive.

Discussion

148.	Which of the following is case sensitive in MySQL?(a) Event names(b) Logfile group names(c) Column names(d) IndexesThis question was posed to me in class test.My query is from Case Sensitivity in SQL Statements topic in portion Using SQL to Manage Data of MySQL
Answer» The correct option is (b) Logfile group names To explain I WOULD say: Column names and indexes are not case SENSITIVE on any platform and neither are column aliases. UNLIKE the standard SQL, the names of the log file groups are ALWAYS case sensitive.

Discussion

149.	Regardless of whether a database or table name is case sensitive on the system, it must be referred to using the same lettercase throughout a given query.(a) True(b) FalseI had been asked this question during an interview for a job.I would like to ask this question from Case Sensitivity in SQL Statements topic in division Using SQL to Manage Data of MySQL
Answer» RIGHT answer is (a) True For explanation I would say: A database or table name MUST be referred to USING the same lettercase throughout a given query. This is REGARDLESS of the fact whether it is CASE sensitive on the system or not.

Discussion

150.	Which case does InnoDB store database names in?(a) lower(b) upper(c) mixed(d) randomThe question was posed to me during an interview.I need to ask this question from Case Sensitivity in SQL Statements topic in portion Using SQL to Manage Data of MySQL
Answer» Right ANSWER is (a) lower The best I can explain: In InnoDB, all the database names as well as all the table names are stored in lowercase INTERNALLY. There is no random case assignment to the database ELEMENTS when the engine is SET as InnoDB.

Discussion

Explore topic-wise InterviewSolutions in .

The comma operator can also be used to join tables.(a) True(b) FalseI have been asked this question during a job interview.My question is based upon Performing Multiple topic in division Using SQL to Manage Data of MySQL

CROSS JOIN and JOIN are similar to __________(a) INNER JOIN(b) NATURAL JOIN(c) OUTER JOIN(d) CARTESIAN JOINI had been asked this question by my school principal while I was bunking the class.This key question is from Performing Multiple in portion Using SQL to Manage Data of MySQL

The clause that filters JOIN results is called _________(a) WHERE(b) SORT(c) GROUP(d) GROUP BYThis question was posed to me in a job interview.Asked question is from Performing Multiple topic in section Using SQL to Manage Data of MySQL

The join where all possible row combinations are produced is called _________(a) INNER JOIN(b) OUTER(c) NATURAL(d) CARTESIANThe question was asked in semester exam.This question is from Performing Multiple topic in section Using SQL to Manage Data of MySQL

In inner join, result is produced by matching rows in one table with rows in another table.(a) True(b) FalseThe question was asked in quiz.Query is from Performing Multiple in portion Using SQL to Manage Data of MySQL

The option in mysqlshow to show information about indexes in a table is _________(a) –no-data(b) –indexes(c) –keys(d) –flagI got this question in an interview for job.My doubt stems from Obtaining Database Metadata in section Using SQL to Manage Data of MySQL

The command which lists databases managed by the server is _____________(a) mysqld(b) mysqlshow(c) mysqllist(d) mysqldbI have been asked this question in homework.This interesting question is from Obtaining Database Metadata topic in portion Using SQL to Manage Data of MySQL

Which table stores information about the threads executing within the server?(a) PROCESS(b) PROCESSLIST(c) LIST(d) THREADSLISTThis question was posed to me during an online interview.The query is from Obtaining Database Metadata topic in chapter Using SQL to Manage Data of MySQL

INFORMATION_SCHEMA is more portable than SHOW statements.(a) True(b) FalseThe question was asked during an interview.Query is from Obtaining Database Metadata topic in section Using SQL to Manage Data of MySQL

Which disk data does FILES table in INFORMATION_SCHEMA store?(a) NDB(b) NBD(c) NBK(d) NCDI have been asked this question in an online interview.I would like to ask this question from Obtaining Database Metadata topic in section Using SQL to Manage Data of MySQL

INFORMATION_SCHEMA is based on the SQL standard.(a) True(b) FalseI had been asked this question in an international level competition.Query is from Obtaining Database Metadata in division Using SQL to Manage Data of MySQL

The general term for information about databases and the objects in MySQL is _________(a) datum(b) info(c) record(d) metadataThe question was asked in class test.I'd like to ask this question from Obtaining Database Metadata topic in section Using SQL to Manage Data of MySQL

The statement to change the table name is __________(a) CHANGE(b) CHANGENAME(c) CHANGENM(d) RENAMEI got this question in class test.This intriguing question comes from Creating, Dropping, Indexing and Altering Tables topic in portion Using SQL to Manage Data of MySQL

The default index type for MEMORY tables is __________(a) HASH(b) SPATIAL(c) FULLTEXT(d) UNIQUEI had been asked this question in a national level competition.My query is from Creating, Dropping, Indexing and Altering Tables topic in section Using SQL to Manage Data of MySQL

It is possible to drop multiple tables in the same statement.(a) True(b) FalseThe question was posed to me in exam.This intriguing question originated from Creating, Dropping, Indexing and Altering Tables in division Using SQL to Manage Data of MySQL

Which keyword is used to create a table as a temporary copy of itself?(a) TEMP(b) TEMPO(c) TEMPR(d) TEMPORARYThis question was posed to me at a job interview.This intriguing question comes from Creating, Dropping, Indexing and Altering Tables topic in division Using SQL to Manage Data of MySQL

In the CREATE TABLE statement, the engine name specified is case sensitive.(a) True(b) FalseThis question was addressed to me in unit test.My question is taken from Creating, Dropping, Indexing and Altering Tables topic in chapter Using SQL to Manage Data of MySQL

What is the name of the format file for a table named my_tbl?(a) my_tbl.fmt(b) my_tbl.frm(c) my_tbl.fmr(d) my_tbl.ftmThe question was posed to me in my homework.The above asked question is from Creating, Dropping, Indexing and Altering Tables in portion Using SQL to Manage Data of MySQL

The default storage engine used is ____________(a) EXAMPLE(b) ARCHIVE(c) MyISAM(d) NDBThis question was posed to me by my school teacher while I was bunking the class.Query is from Creating, Dropping, Indexing and Altering Tables in portion Using SQL to Manage Data of MySQL

Which storage engine is not available in MySQL 5.0?(a) InnoDB(b) ARCHIVE(c) Falcon(d) NDBThis question was posed to me during an interview.My enquiry is from Creating, Dropping, Indexing and Altering Tables in section Using SQL to Manage Data of MySQL

Which statement is used to remove indexes on tables?(a) DROP INDEX(b) DELETE INDEX(c) REMOVE INDEX(d) FLUSH INDEXThe question was posed to me in unit test.My doubt is from Creating, Dropping, Indexing and Altering Tables in portion Using SQL to Manage Data of MySQL

Which statement makes changes to the database’s global attributes?(a) CHANGE(b) ALTER(c) ALTERNATE(d) UPDATEThe question was posed to me in class test.The question is from Selecting, Creating, Dropping and Altering Databases topic in section Using SQL to Manage Data of MySQL

Which keyword is used to create a database?(a) CREATE(b) SET(c) SETUP(d) LINKI have been asked this question by my school principal while I was bunking the class.I want to ask this question from Selecting, Creating, Dropping and Altering Databases in chapter Using SQL to Manage Data of MySQL

It is not required to have an access privilege for a database before selecting it with ‘USE’.(a) True(b) FalseThe question was posed to me in quiz.The question is from Selecting, Creating, Dropping and Altering Databases topic in section Using SQL to Manage Data of MySQL

Which keyword is the synonym for DATABASE?(a) TABLE(b) OBJECT(c) DB(d) SCHEMAI had been asked this question in examination.My enquiry is from Selecting, Creating, Dropping and Altering Databases topic in portion Using SQL to Manage Data of MySQL

Which statement is used to select a default database?(a) USE(b) CREATE(c) DROP(d) SCHEMAThis question was addressed to me at a job interview.This key question is from Selecting, Creating, Dropping and Altering Databases in chapter Using SQL to Manage Data of MySQL

What is generally used as a synonym for CHARACTER SET?(a) CSET(b) CHSET(c) CHARSET(d) CHCSETThe question was asked in an international level competition.This interesting question is from Character Set Support in chapter Using SQL to Manage Data of MySQL

Post MySQL 6.0, utf8 was ___________(a) 3 bytes(b) 4 bytes(c) 5 bytes(d) 6 bytesThis question was posed to me during an online exam.The query is from Character Set Support in portion Using SQL to Manage Data of MySQL

Prior to MySQL 6.0, utf8 was ___________(a) 3 bytes(b) 4 bytes(c) 8 bytes(d) 9 bytesI have been asked this question in final exam.This question is from Character Set Support in division Using SQL to Manage Data of MySQL

Which MySQL statement is used to find out which character sets are available?(a) SHOW CHARACTER SET(b) SHOW COLLATION(c) SHOW CHARACTER SETS(d) SHOW COLLATIONSThis question was posed to me in homework.My enquiry is from Character Set Support topic in portion Using SQL to Manage Data of MySQL

Which clause can be used to sort string values according to a specific collation?(a) SORT(b) GROUP(c) FILTER(d) COLLATEThis question was addressed to me in class test.Origin of the question is Character Set Support in division Using SQL to Manage Data of MySQL

Unicode support is provided in MySQL.(a) True(b) FalseThis question was addressed to me in unit test.My question is taken from Character Set Support topic in division Using SQL to Manage Data of MySQL

What is the maximum collations a character set can have?(a) 0(b) 1(c) 2(d) more than 1This question was posed to me in an interview for internship.I need to ask this question from Character Set Support topic in section Using SQL to Manage Data of MySQL

What is AI in terms of database collation?(a) Accent Insensitive(b) Augment Insensitive(c) Articulate Insensitive(d) Addition InsensitiveI got this question during an interview.The question is from Case Sensitivity in SQL Statements in portion Using SQL to Manage Data of MySQL

Which of the following is case sensitive in MySQL?(a) Event names(b) Logfile group names(c) Column names(d) IndexesThis question was posed to me in class test.My query is from Case Sensitivity in SQL Statements topic in portion Using SQL to Manage Data of MySQL

Which case does InnoDB store database names in?(a) lower(b) upper(c) mixed(d) randomThe question was posed to me during an interview.I need to ask this question from Case Sensitivity in SQL Statements topic in portion Using SQL to Manage Data of MySQL