MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 427 Mcqs, each offering curated multiple-choice questions to sharpen your Technical Programming knowledge and support exam preparation. Choose a topic below to get started.
| 101. |
The function returning reference to hash of row values is ______________ |
| A. | fetchrow_array() |
| B. | fetchrow_arrayref() |
| C. | fetch() |
| D. | fetchrow_hashref() |
| Answer» E. | |
| 102. |
What is the datatype for single precision floating point number? |
| A. | FLOAT |
| B. | DOUBLE |
| C. | INT |
| D. | BIGINT |
| Answer» B. DOUBLE | |
| 103. |
Hexadecimal numbers can be used in scientific notation. |
| A. | True |
| B. | False |
| C. | May be True or False |
| D. | Can't say |
| Answer» C. May be True or False | |
| 104. |
For how many of the following do interfaces exist for implementing direct native client-server protocol? |
| A. | 0 |
| B. | 1 |
| C. | 2 |
| D. | 3 |
| Answer» E. | |
| 105. |
The JDBI interface is available for _____________ |
| A. | C |
| B. | C++ |
| C. | Python |
| D. | Java |
| Answer» E. | |
| 106. |
How many of these languages have interfaces to bind to the C API of MySQL? |
| A. | 0 |
| B. | 1 |
| C. | 2 |
| D. | 3 |
| Answer» E. | |
| 107. |
To combine multiple retrievals, which keyword is used to write several SELECT statements between them? |
| A. | COMBINE |
| B. | CONCAT |
| C. | JOIN |
| D. | UNION |
| Answer» E. | |
| 108. |
The numbers that are prefixed with ‘0x’ are in base __________ |
| A. | 8 |
| B. | 16 |
| C. | 32 |
| D. | 64 |
| Answer» C. 32 | |
| 109. |
The number of values that can be returned from a given stored function is ______________ |
| A. | 0 |
| B. | 1 |
| C. | 2 |
| D. | 3 |
| Answer» C. 2 | |
| 110. |
The statement used to create a trigger is ______________ |
| A. | CREATE TRIGGER |
| B. | CREATE TRIGGERS |
| C. | PRODUCE TRIGGER |
| D. | PRODUCE TRIGGERS |
| Answer» B. CREATE TRIGGERS | |
| 111. |
The datatype best suited to store currency values is ______________ |
| A. | INT |
| B. | FLOAT |
| C. | DOUBLE |
| D. | DECIMAL |
| Answer» E. | |
| 112. |
The generic handle whose meaning depends on context is ______________ |
| A. | $dbh |
| B. | $sth |
| C. | $fh |
| D. | $h |
| Answer» E. | |
| 113. |
What is the escape sequence for carriage return? |
| A. | ‘\c’ |
| B. | ‘\r’ |
| C. | ‘\b’ |
| D. | ‘\z’ |
| Answer» C. ‘\b’ | |
| 114. |
The –protocol value ‘TCP’ runs on which operating systems? |
| A. | all |
| B. | unix only |
| C. | windows only |
| D. | none |
| Answer» B. unix only | |
| 115. |
The ‘SOCKET’ protocol is permitted on which operating systems? |
| A. | all |
| B. | unix only |
| C. | windows only |
| D. | none |
| Answer» C. windows only | |
| 116. |
Which of the following is used on Solaris? |
| A. | gcc |
| B. | clang |
| C. | Sun Studio |
| D. | FreeBSD |
| Answer» D. FreeBSD | |
| 117. |
What does the expression ’12 DIV 5′ evaluate to? |
| A. | 2.4 |
| B. | 2 |
| C. | error |
| D. | 0 |
| Answer» C. error | |
| 118. |
System variable in MySQL server that enables to configure the SQL mode is __________ |
| A. | sql_mode |
| B. | sql_config |
| C. | sql_server |
| D. | sql_enable |
| Answer» B. sql_config | |
| 119. |
The name of the option file in Unix is __________ |
| A. | .my.cnf |
| B. | .my.ini |
| C. | .my.opt |
| D. | .my.opc |
| Answer» B. .my.ini | |
| 120. |
Which of these is preferred when stored procedures are not being used? |
| A. | CLIENT_MULTI_STATEMENTS |
| B. | mysql_set_server_option() |
| C. | any of the two |
| D. | neither of the two |
| Answer» D. neither of the two | |
| 121. |
The number of attributes in the following SQL table is ______________ |
| A. | 1 |
| B. | 2 |
| C. | 3 |
| D. | 30 |
| Answer» C. 3 | |
| 122. |
How many of the following return rows? |
| A. | 0 |
| B. | 1 |
| C. | 2 |
| D. | 3 |
| Answer» E. | |
| 123. |
Which of these is more restrictive? |
| A. | mysql_query() |
| B. | mysql_real_query() |
| C. | same |
| D. | machine dependent |
| Answer» B. mysql_real_query() | |
| 124. |
How many of the following is considered as a special character by ‘mysql_real_escape_string()’? |
| A. | 0 |
| B. | 1 |
| C. | 2 |
| D. | 3 |
| Answer» E. | |
| 125. |
Which of these has a lower memory requirements? |
| A. | mysql_use_result() |
| B. | mysql_store_result() |
| C. | same |
| D. | machine dependent |
| Answer» B. mysql_store_result() | |
| 126. |
Input handling cannot be customized with MySQL. |
| A. | True |
| B. | False |
| C. | May be True or False |
| D. | Can't say |
| Answer» C. May be True or False | |
| 127. |
How many of the following take a connection handler as an argument? |
| A. | 0 |
| B. | 1 |
| C. | 2 |
| D. | 3 |
| Answer» D. 3 | |
| 128. |
By default, MySQL does not clip out of range numeric values to the nearest fit value. |
| A. | True |
| B. | False |
| C. | May be True or False |
| D. | Can't say |
| Answer» C. May be True or False | |
| 129. |
On failure, ‘mysql_query()’ returns _______________ |
| A. | 0 |
| B. | 1 |
| C. | -1 |
| D. | a non-zero value |
| Answer» E. | |
| 130. |
The exec_stmt_ssl is written in _______________ |
| A. | C++ |
| B. | C |
| C. | Python |
| D. | Perl |
| Answer» C. Python | |
| 131. |
How many of the following is (are) considered as a special character by ‘mysql_real_escape_string()’? |
| A. | 3 |
| B. | 1 |
| C. | 2 |
| D. | 0 |
| Answer» B. 1 | |
| 132. |
How many of the following does not return a value? |
| A. | 0 |
| B. | 1 |
| C. | 2 |
| D. | 3 |
| Answer» C. 2 | |
| 133. |
Which table in the ‘INFORMATION_SCHEMA’ stores information about storage engines and server plugins? |
| A. | ENGINES, PLUGINS |
| B. | FILES, PLUGINS |
| C. | PLUGINS, STATISTICS |
| D. | ENGINES, FILES |
| Answer» B. FILES, PLUGINS | |
| 134. |
How many of the following use NULL to indicate failure? |
| A. | 0 |
| B. | 1 |
| C. | 2 |
| D. | 3 |
| Answer» D. 3 | |
| 135. |
All API calls return a value. |
| A. | True |
| B. | False |
| C. | May be True or False |
| D. | Can't say |
| Answer» C. May be True or False | |
| 136. |
Which of the following returns a MySQL-specific numeric code? |
| A. | mysql_error() |
| B. | mysql_errno() |
| C. | mysql_sqlstate() |
| D. | mysql_close() |
| Answer» C. mysql_sqlstate() | |
| 137. |
The function load_defaults() reads the option files. |
| A. | True |
| B. | False |
| C. | May be True or False |
| D. | Can't say |
| Answer» B. False | |
| 138. |
What does mysql_real_connect() return if it fails? |
| A. | integer |
| B. | float |
| C. | structure |
| D. | |
| Answer» E. | |
| 139. |
The argument to the function mysql_error() is _______________ |
| A. | integer |
| B. | float |
| C. | structure |
| D. | pointer |
| Answer» E. | |
| 140. |
Which of the following returns an SQLSTATE code? |
| A. | mysql_error() |
| B. | mysql_errno() |
| C. | mysql_sqlstate() |
| D. | mysql_close() |
| Answer» D. mysql_close() | |
| 141. |
mysql_store_result() does not return a result set. |
| A. | True |
| B. | False |
| C. | May be True or False |
| D. | Can't say |
| Answer» C. May be True or False | |
| 142. |
Which of these returns a string containing an error message? |
| A. | mysql_error() |
| B. | mysql_errno() |
| C. | mysql_sqlstate() |
| D. | mysql_close() |
| Answer» B. mysql_errno() | |
| 143. |
The MySQL APIs are libraries to connect applications to database servers. |
| A. | True |
| B. | False |
| C. | May be True or False |
| D. | Can't say |
| Answer» B. False | |
| 144. |
What is the maximum number of indexes on MyISAM table? |
| A. | 0 |
| B. | 1 |
| C. | 2 |
| D. | more than 1 |
| Answer» E. | |
| 145. |
To how many of the following does the prepared-statement API apply to? |
| A. | 1 |
| B. | 2 |
| C. | 3 |
| D. | 4 |
| Answer» E. | |
| 146. |
The default case sensitivity of the database and table names depends on ___________ |
| A. | Server SQL mode |
| B. | Operating system of machine |
| C. | Does not depend on anything |
| D. | SQL server |
| Answer» C. Does not depend on anything | |
| 147. |
Which statement is valid if ‘`sampledb`’ is a database and ‘`tbl`’ is a table in it? |
| A. | SELECT * FROM `sampledb.member` |
| B. | SELECT * FROM `sampledb`.`member` |
| C. | SELECT * FROM `member`.`sampledb` |
| D. | SELECT * FROM `member.sampledb` |
| Answer» C. SELECT * FROM `member`.`sampledb` | |
| 148. |
Which character is illegal in naming an unquoted identifier in SQL? |
| A. | . |
| B. | _ |
| C. | $ |
| D. | 2 |
| Answer» B. _ | |
| 149. |
To see the table structure which command is issued? |
| A. | VIEW tbl_name; |
| B. | SELECT TABLE tbl_name; |
| C. | SELECT tbl_name; |
| D. | DESCRIBE tbl_name; |
| Answer» E. | |
| 150. |
fetchrow_hashref() returns reference to hash of row values keyed by ______________ |
| A. | row name |
| B. | column name |
| C. | table name |
| D. | database name |
| Answer» C. table name | |