InterviewSolution
Saved Bookmarks
InterviewSolution
This section includes InterviewSolutions, each offering curated multiple-choice questions to sharpen your knowledge and support exam preparation. Choose a topic below to get started.
| 401. |
What can be used interchangeably with MYSQL_VERSION_ID?(a) LIBMYSQL_VERSION(b) LIBMYSQL_VERSION_ID(c) MYSQL_VERSION_ID(d) MYSQL_ID |
|
Answer» Right choice is (b) LIBMYSQL_VERSION_ID Easy explanation: The ‘LIBMYSQL_VERSION’ and ‘LIBMYSQL_VERSION_ID’ macros have the same values as ‘MYSQL_SERVER_VERSION’ and ‘MYSQL_VERSION_ID’ and the two sets of macros can be used interchangeably. |
|
| 402. |
Which of the following can be used interchangeably with MYSQL_VERSION_ID?(a) LIBMYSQL_VERSION(b) LIBMYSQL_VERSION_ID(c) MYSQL_VERSION_ID(d) MYSQL_ID |
|
Answer» Correct choice is (b) LIBMYSQL_VERSION_ID The best explanation: The ‘LIBMYSQL_VERSION’ and ‘LIBMYSQL_VERSION_ID’ macros have the same values as ‘MYSQL_SERVER_VERSION’ and ‘MYSQL_VERSION_ID’ and the two sets of macros can be used interchangeably. |
|
| 403. |
What is the meaning of “SELECT” clause in Mysql?(a) Show me all Columns and rows(b) Show me all columns(c) Show me all rows(d) None of the mentioned |
|
Answer» Right option is (a) Show me all Columns and rows To explain I would say: None. |
|
| 404. |
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 mentioned |
|
Answer» Right choice is (a) Sorting your result set using column data Easiest explanation: None. |
|
| 405. |
“SELECT” clause cannot be used without which clause in Mysql?(a) FROM(b) WHERE(c) ORDER BY(d) All of the mentioned |
|
Answer» The correct option is (a) FROM Easy explanation: “FROM” clause is necessary to point out tables in the database. |
|
| 406. |
Which keyword is used for sorting the data in ascending order in Mysql?(a) DESC(b) ASC(c) ALTER(d) MODIFY |
|
Answer» The correct choice is (b) ASC To explain I would say: None. |
|
| 407. |
“COUNT” keyword belongs to which categories in Mysql?(a) Aggregate functions(b) Operators(c) Clauses(d) All of the mentioned |
|
Answer» The correct option is (a) Aggregate functions Explanation: None. |
|
| 408. |
Which keyword is used for sorting the data in descending order in Mysql?(a) DESC(b) ASC(c) ALTER(d) MODIFY |
|
Answer» Right option is (a) DESC Easiest explanation: None. |
|
| 409. |
Keyword “ASC” and “DESC” cannot be used without which clause in Mysql?(a) ORDER BY(b) GROUP BY(c) SELECT(d) HAVING |
|
Answer» Right option is (a) ORDER BY The best explanation: “ASC” or “DESC” are used to sort the result set in ascending or descending order therefore they cannot be used without “ORDER BY” clause. |
|
| 410. |
The operators used when a subquery returns multiple rows to be evaluated in comparison to the outer query are _____________(a) IN and NOT IN(b) EXISTS and NOT EXISTS(c) OUTER JOIN and INNER JOIN(d) LEFT JOIN and RIGHT JOIN |
|
Answer» Right option is (a) IN and NOT IN To explain I would say: When there is a need to evaluate multiple rows in comparison to the outer query, the ‘IN’ and ‘NOT IN’ operators are used. They are used for testing whether a comparison value is present in a set of values. |
|
| 411. |
Which statement is used to check how MySQL would execute a SELECT query?(a) TELL(b) SHOW(c) DISPLAY(d) EXPLAIN |
|
Answer» Correct choice is (d) EXPLAIN The explanation: In MySQL, by issuing an EXPLAIN statement MySQL displays some information about how it would execute a SELECT query without actually executing it. It is prefixed with the query. |
|
| 412. |
The operators that are used when a subquery returns multiple rows to be evaluated in comparison to the outer query are _____________(a) IN and NOT IN(b) EXISTS and NOT EXISTS(c) OUTER JOIN and INNER JOIN(d) LEFT JOIN and RIGHT JOIN |
|
Answer» Right answer is (a) IN and NOT IN The best explanation: When there is a need to evaluate multiple rows in comparison to the outer query, the ‘IN’ and ‘NOT IN’ operators are used. They are used for testing whether a comparison value is present in a set of values. |
|
| 413. |
“MODIFY” is used with which “Query clause”?(a) ALTER(b) FROM(c) WHERE(d) ORDER BY |
|
Answer» Correct option is (a) ALTER The best explanation: Modify is not a clause, it just used with clause Alter. |
|
| 414. |
To see the table structure, which of the following SQL commands is issued?(a) DESCRIBE tbl_name(b) VIEW tbl_name(c) SELECT TABLE tbl_name(d) SELECT tbl_name |
|
Answer» Right option is (a) DESCRIBE tbl_name To elaborate: The ‘DESCRIBE’ command is issued to see the structure of the table ‘tbl_name’. It shows the structure in the format: Field-Type-Null-Key-Default-Extra. The ‘VIEW’ and ‘SELECT’ commands are used to see the contents of the table. |
|
| 415. |
What is the join where all possible row combinations are produced?(a) INNER JOIN(b) OUTER(c) NATURAL(d) CARTESIAN |
|
Answer» Correct choice is (d) CARTESIAN Explanation: In ‘cartesian product’, each row of each table is combined with each row in every other table to produce all possible combinations. This produces a very large number of rows since the number is the product of rows. |
|
| 416. |
The clause that filters JOIN results is called _________(a) WHERE(b) SORT(c) GROUP(d) GROUP BY |
|
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). |
|
| 417. |
The log that contains a record of server startups and shutdowns and the messages about exceptional conditions is ______________(a) error log(b) general query(c) slow query log(d) binary log |
|
Answer» The correct choice is (a) error log For explanation: The error log contains a record of server startups and shutdowns and the messages about problems or exceptional conditions. If the server fails to start this log provides the help. |
|
| 418. |
Which Clause is used to select a particular table in Mysql?(a) WHERE(b) SELECT(c) FROM(d) ALTER |
|
Answer» The correct answer is (c) FROM To explain I would say: None. |
|
| 419. |
The log that identifies statements that may be in need of being rewritten for better performance is ______________(a) error log(b) general query(c) slow query log(d) binary log |
|
Answer» Correct choice is (c) slow query log Easiest explanation: The purpose of the slow-query log is to help the identification of statements that may be in need of being rewritten for better performance. This helps in query optimizations. |
|
| 420. |
What is the default value of column?(a) NULL(b) 0(c) -1(d) Undefined |
|
Answer» Correct choice is (a) NULL Easiest explanation: When table is defined in Mysql then each column related to table will contain NULL Value as default. |
|
| 421. |
Which Clause is used to select a particular row from the set of row in an existing table?(a) WHERE(b) FROM(c) ALTER(d) None of the mentioned |
|
Answer» Right answer is (a) WHERE Easiest explanation: None. |
|
| 422. |
Which clause is used to “Identifies table from which to draw table and how the table should be joined”?(a) FROM(b) SELECT(c) ORDER By(d) WHERE |
|
Answer» Right option is (a) FROM For explanation: None. |
|
| 423. |
Which of the following statements is/are correct?(a) True AND true =true(b) True AND false= false(c) False AND false= false(d) All of the mentioned |
|
Answer» The correct option is (d) All of the mentioned Easy explanation: None. |
|
| 424. |
Which statement is used to select columns and rows from the table?(a) SELECT(b) ALTER(c) MODIFY(d) FROM |
|
Answer» Right option is (a) SELECT For explanation: None. |
|
| 425. |
Which clause is used to “Filters out unwanted data”?(a) FROM(b) WHERE(c) SELECT(d) ORDER BY |
|
Answer» Correct answer is (b) WHERE The explanation is: None. |
|
| 426. |
Which clause is used to “filter out unwanted Groups”?(a) HAVING(b) FROM(c) WHERE(d) SELECT |
|
Answer» Correct choice is (a) HAVING Easiest explanation: None. |
|
| 427. |
Which clause is used to “group rows together by common columns values”?(a) SELECT(b) GROUP BY(c) FROM(d) WHERE |
|
Answer» The correct choice is (b) GROUP BY Explanation: None. |
|
| 428. |
Is “GROUP BY” clause is similar to “ORDER BY” clause?(a) Yes(b) No(c) Depends(d) None of the mentioned |
|
Answer» Correct option is (b) No For explanation I would say: “ORDER BY” clause is used for sorting while “GROUP BY” clause is used for aggregation of fields. |
|
| 429. |
Which clause is similar to “HAVING” clause in Mysql?(a) SELECT(b) WHERE(c) FROM(d) None of the mentioned |
|
Answer» Correct answer is (b) WHERE Explanation: “WHERE” is also used to filter the row values in Mysql. |
|
| 430. |
Which are the two languages used in Mysql?(a) DML/DDL(b) DDL/DCL(c) DML/DDM(d) None of the mentioned |
|
Answer» Right option is (a) DML/DDL To explain I would say: DDL (Data Definition Language) DML (Data Manipulation Language). |
|
| 431. |
The users responsible for query processing in database system are ___________(a) Native users(b) Application programmers(c) Sophisticated users(d) Specialized users |
|
Answer» Correct choice is (c) Sophisticated users To explain: Sophisticated users interact with the system without writing any application programs; they form the request in a database query language. |
|
| 432. |
What is the mantissa in -1.58E5?(a) -1.58(b) 1.58(c) E(d) 5 |
|
Answer» The correct option is (a) -1.58 The explanation is: In MySQL, the scientific notation for real numbers is possible. Some values are represented as floating point numbers in scientific notation consisting of a mantissa and exponent. |
|
| 433. |
Increasing the value of which system variable enables mysqld to keep more tables open simultaneously?(a) table_cache(b) max_connect(c) delayed_queue_size(d) max_allowed_packet |
|
Answer» Correct answer is (a) table_cache To explain: The ‘table_cache’ stores the size of the table cache. Increasing the value enables ‘mysqld’ to keep more tables open simultaneously by reducing the number of files open and close operations. |
|
| 434. |
Which system variable enables mysqld to keep more tables open simultaneously?(a) table_cache(b) max_connect(c) delayed_queue_size(d) max_allowed_packet |
|
Answer» Correct choice is (a) table_cache To explain I would say: The ‘table_cache’ stores the size of the table cache. Increasing the value enables ‘mysqld’ to keep more tables open simultaneously by reducing the number of files open and close operations. |
|
| 435. |
Which operator compares sounds?(a) MATCH SOUNDS(b) CHECK SOUNDS(c) SOUNDS LIKE(d) SOUNDS SIMILAR |
|
Answer» The correct answer is (c) SOUNDS LIKE To explain: The operator ‘SOUNDS LIKE’ is used to compare the sound. The ‘RLIKE’ is a synonym for ‘REGEXP’, which is a pattern matching using regular expressions. There are a lot of other operators for use. |
|
| 436. |
How can a view refer to multiple tables?(a) UNION(b) JOIN(c) GROUP(d) SELECT |
|
Answer» Right answer is (b) JOIN Best explanation: In MySQL, a ‘View’ can refer to multiple tables. This makes it a lot simpler to execute the queries involving joins. When a selection is made from the view, the join is executed producing the results. |
|
| 437. |
To maintain performance of tables having variable length rows, which statement is used?(a) MAINTAIN TABLE(b) BALANCE TABLE(c) ADJUST TABLE(d) OPTIMIZE TABLE |
|
Answer» The correct option is (d) OPTIMIZE TABLE Best explanation: In the variable length rows, there is more fragmentation of the table on which many deletes or updates are performed. OPTIMIZE TABLE is run periodically to maintain performance. |
|
| 438. |
What does RTF refer to?(a) Rich Text Format(b) Right Text Format(c) Rich Text Function(d) Right Text Function |
|
Answer» Correct answer is (a) Rich Text Format Best explanation: RTF (Rich Text Format) is a format developed by Microsoft that is understood by many word processors. MS-Word is one such program. Many others such as ‘OpenOffice’ understand it too. |
|
| 439. |
SBR replication is ______________(a) Statement based(b) Row based(c) Column based(d) Table based |
|
Answer» The correct answer is (a) Statement based For explanation: There are two main kinds of replication format: Statement Based Replication (SBR) replicates entire SQL statements and Row Based Replication (RBR) replicates only the changed rows. |
|
| 440. |
Which disk data does FILES table in INFORMATION_SCHEMA store?(a) NDB(b) NBD(c) NBK(d) NCD |
|
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. |
|
| 441. |
Which system variable determines the number of rows from INSERT DELAYED statements that can be queued per table?(a) fast_queue_size(b) general_queue_size(c) slow_queue_size(d) delayed_queue_size |
|
Answer» Right option is (d) delayed_queue_size The best I can explain: The system variable ‘delayed_queue_size’ determines the number of rows from INSERT DELAYED statements that can be queued per table (for the storage engines that support DELAYED inserts). |
|
| 442. |
Which option turns on the –extended-insert?(a) –opt(b) –opti(c) –op(d) –optimize |
|
Answer» The correct answer is (a) –opt For explanation: If the –opt option is enabled it turns on the –extended-insert option, which produces multiple row INSERT statements and some other options that allow the dump file to be processed more efficiently. |
|
| 443. |
The function returning reference to hash of row values is ______________(a) fetchrow_array()(b) fetchrow_arrayref()(c) fetch()(d) fetchrow_hashref() |
|
Answer» The correct answer is (d) fetchrow_hashref() To explain: The function ‘fetchrow_hashref()’ returns reference to hash of row values. ‘fetchrow_arrayref()’ returns a reference to an array of row values. ‘fetch()’ is the same as fetchrow_arrayref(). |
|
| 444. |
What is SBR replication?(a) Statement based(b) Row based(c) Column based(d) Table based |
|
Answer» Right answer is (a) Statement based To elaborate: There are two main kinds of replication format: Statement Based Replication (SBR) replicates entire SQL statements and Row Based Replication (RBR) replicates only the changed rows. |
|
| 445. |
The general statement-issuing routine is _______________(a) mysql_real_query()(b) mysql_query_real()(c) mysql_image_query()(d) mysql_query_image() |
|
Answer» The correct answer is (a) mysql_real_query() Best explanation: The general statement-issuing routine is mysql_real_query(). The statement is provided as a counted string (a string plus a length). The length of the statement string must be kept track of. |
|
| 446. |
mysql_fetch_row() returns _______________(a) integer(b) float(c) structure(d) pointer |
|
Answer» Correct choice is (d) pointer The explanation is: ‘mysql_fetch_row()’ returns a MYSQL_ROW value, a pointer to an array of values. If the return value is assigned to a variable named row each value within the row is accessed as row[i]. |
|
| 447. |
What is the exec_stmt_ssl written in?(a) C++(b) C(c) Python(d) Perl |
|
Answer» The correct choice is (b) C To explain I would say: In MySQL, the ‘sampdb’ distribution contains a source file named ‘exec_stmt_ssl.c’ from which the client program ‘exec_stmt_ssl’ can be built. There is a procedure to build this file. |
|
| 448. |
Which table in INFORMATION_SCHEMA stores information about storage engines and server plugins?(a) ENGINES, PLUGINS(b) FILES, PLUGINS(c) ENGINES, FILES(d) PLUGINS, STATISTICS |
|
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. |
|
| 449. |
The function returning an array of row values is ______________(a) fetchrow_array()(b) fetchrow_arrayref()(c) fetch()(d) fetchrow_hashref() |
|
Answer» The correct option is (a) fetchrow_array() To explain I would say: The function ‘fetchrow_array()’ returns an array of row values. ‘fetchrow_arrayref()’ returns a reference to an array of row values. ‘fetch()’ is the same as fetchrow_arrayref(). |
|
| 450. |
What is exec_stmt_ssl written in?(a) C++(b) C(c) Python(d) Perl |
|
Answer» The correct choice is (b) C Easy explanation: In MySQL, the ‘sampdb’ distribution contains a source file named ‘exec_stmt_ssl.c’ from which the client program ‘exec_stmt_ssl’ can be built. There is a procedure to build this file. |
|