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.
| 151. |
What is the general term for information about databases and the objects in MySQL? |
| A. | datum |
| B. | info |
| C. | record |
| D. | metadata |
| Answer» E. | |
| 152. |
The statement used to change the table name is __________ |
| A. | RENAME |
| B. | CHANGE |
| C. | CHANGENAME |
| D. | CHANGENM |
| Answer» B. CHANGE | |
| 153. |
The function returning an array of row values is ______________ |
| A. | fetchrow_array() |
| B. | fetchrow_arrayref() |
| C. | fetch() |
| D. | fetchrow_hashref() |
| Answer» B. fetchrow_arrayref() | |
| 154. |
The key declares that an index in one table is related to that in another is called _____________ |
| A. | primary |
| B. | secondary |
| C. | foreign |
| D. | cross |
| Answer» D. cross | |
| 155. |
Illegal values converted to the appropriate ‘zero’ value for ______________ |
| A. | Numeric |
| B. | String |
| C. | ENUM |
| D. | TIME |
| Answer» E. | |
| 156. |
The default value in seconds in the system variable ‘long_query_time’ is ______________ |
| A. | 5 |
| B. | 10 |
| C. | 20 |
| D. | 60 |
| Answer» C. 20 | |
| 157. |
What are X’61626364′ and X’61626364′? |
| A. | abcd and 1633837924 |
| B. | abcd and 4297383361 |
| C. | dcba and 1633837924 |
| D. | dcba and 4297383361 |
| Answer» B. abcd and 4297383361 | |
| 158. |
The largest value to which the variable ‘max_allowed_packet’ can be set is ______________ |
| A. | 1GB |
| B. | 2GB |
| C. | 4GB |
| D. | 8GB |
| Answer» B. 2GB | |
| 159. |
The datatype that means a variable length non binary string is __________ |
| A. | VARCHAR |
| B. | BINARY |
| C. | VARBINARY |
| D. | BLOB |
| Answer» B. BINARY | |
| 160. |
What is the property of InnoDB that enforces foreign key relationships stay intact? |
| A. | atomicity |
| B. | durability |
| C. | consistency |
| D. | referential integrity |
| Answer» E. | |
| 161. |
The privilege that must be given to the database to create a stored function or procedure is ____________ |
| A. | CREATE ROUTINE |
| B. | CREATE METHOD |
| C. | CREATE FUNCTION |
| D. | CREATE PROCEDURE |
| Answer» B. CREATE METHOD | |
| 162. |
How would a stored function named PI() written in the database ‘sampdb’ be called? |
| A. | PI() |
| B. | sampdb.PI() |
| C. | MySQL.PI() |
| D. | db.PI() |
| Answer» C. MySQL.PI() | |
| 163. |
A FULLTEXT index can be created for multiple columns. |
| A. | True |
| B. | False |
| C. | May be True or False |
| D. | Can't say |
| Answer» B. False | |
| 164. |
The keyword used with UNION that retains duplicate rows is ___________ |
| A. | ALL |
| B. | NARROW |
| C. | STRICT |
| D. | DISTINCT |
| Answer» B. NARROW | |
| 165. |
What is x’ffff’ in decimal? |
| A. | 65534 |
| B. | 66535 |
| C. | 65536 |
| D. | 65537 |
| Answer» D. 65537 | |
| 166. |
What is the mantissa in -1.58E5? |
| A. | -1.58 |
| B. | 1.58 |
| C. | E |
| D. | 5 |
| Answer» B. 1.58 | |
| 167. |
The keyword used with UNION that retains duplicate rows is ______________ |
| A. | ALL |
| B. | NARROW |
| C. | STRICT |
| D. | DISTINCT |
| Answer» B. NARROW | |
| 168. |
The mode used to turn off the special meaning of backslash and treat it as an ordinary character is _____________ |
| A. | NO_ESCAPES_SLASH |
| B. | NO_ESCAPES_BACKSLASH |
| C. | NO_BACKSLASH_ESCAPES |
| D. | NO_BACKSLASH_ESCAPE |
| Answer» D. NO_BACKSLASH_ESCAPE | |
| 169. |
The ‘C’ in the ACID property of transactions is _______________ |
| A. | Compound |
| B. | Concrete |
| C. | Collision |
| D. | Consistency |
| Answer» E. | |
| 170. |
Which command is used to make a script file ‘run_me.sh’ executable? |
| A. | chmod +e run_me.sh |
| B. | chmod +a run_me.sh |
| C. | chmod +y run_me.sh |
| D. | chmod +x run_me.sh |
| Answer» E. | |
| 171. |
In which file are the statements entered in ‘mysql’ saved? |
| A. | .mysql_queries |
| B. | .queries |
| C. | .mysql_history |
| D. | .history |
| Answer» D. .history | |
| 172. |
What is InnoDB in the following MySQL code? |
| A. | database name |
| B. | table name |
| C. | reference engine |
| D. | storage engine |
| Answer» E. | |
| 173. |
What is the table name in the following SQL code? |
| A. | student |
| B. | VALUES |
| C. | Kyle |
| D. | M |
| Answer» B. VALUES | |
| 174. |
What is the special database that always exists after setting up MySQL on a computer? |
| A. | sampdb |
| B. | mysql |
| C. | information_schema |
| D. | readme_db |
| Answer» D. readme_db | |
| 175. |
The log enabled by –relay-log-index is _____________ |
| A. | relay log index |
| B. | relay log |
| C. | binary log |
| D. | error log |
| Answer» B. relay log | |
| 176. |
How can a view refer to multiple tables? |
| A. | UNION |
| B. | JOIN |
| C. | GROUP |
| D. | SELECT |
| Answer» C. GROUP | |
| 177. |
The LOCAL capability for LOAD DATA does not need to be enabled explicitly. |
| A. | True |
| B. | False |
| C. | May be True or False |
| D. | Can't say |
| Answer» B. False | |
| 178. |
The character that the MySQL client program recognizes as a statement delimiter is ______________ |
| A. | : |
| B. | . |
| C. | ; |
| D. | , |
| Answer» D. , | |
| 179. |
What is the statement used to select a default database? |
| A. | USE |
| B. | CREATE |
| C. | DROP |
| D. | SCHEMA |
| Answer» B. CREATE | |
| 180. |
What is the synonym for CHARACTER SET? |
| A. | CSET |
| B. | CHSET |
| C. | CHARSET |
| D. | CHCSET |
| Answer» D. CHCSET | |
| 181. |
It is required to have an access privilege for a database before selecting it with ‘USE’. |
| A. | True |
| B. | False |
| C. | May be True or False |
| D. | Can't say |
| Answer» B. False | |
| 182. |
The keyword used to create a database is __________ |
| A. | CREATE |
| B. | SET |
| C. | SETUP |
| D. | LINK |
| Answer» B. SET | |
| 183. |
The server listens on a network port for TCP/IP connections unless started with the option ______________ |
| A. | –networking |
| B. | –skip-networking |
| C. | –skip-networks |
| D. | –quit-networking |
| Answer» C. –skip-networks | |
| 184. |
Which file is created by the server to store the database attributes? |
| A. | db.otp |
| B. | dp.zip |
| C. | db.opt |
| D. | db.cls |
| Answer» D. db.cls | |
| 185. |
What is the default storage engine? |
| A. | EXAMPLE |
| B. | ARCHIVE |
| C. | MyISAM |
| D. | NDB |
| Answer» D. NDB | |
| 186. |
The storage engine in MySQL that provides foreign key support is ___________ |
| A. | TRANSACTION |
| B. | InnoDB |
| C. | MyISAM |
| D. | MEMORY |
| Answer» C. MyISAM | |
| 187. |
For what can the FULLTEXT indexes be created for? |
| A. | MyISAM |
| B. | InnoDB |
| C. | MEMORY |
| D. | TRANSITION |
| Answer» B. InnoDB | |
| 188. |
The option that executes all SQL statements in a SQL script irrespective of the number of errors is ______________ |
| A. | –ensure |
| B. | –force |
| C. | –violent |
| D. | –run |
| Answer» C. –violent | |
| 189. |
The name of the format file for a table named my_tbl is __________ |
| A. | my_tbl.fmt |
| B. | my_tbl.frm |
| C. | my_tbl.fmr |
| D. | my_tbl.ftm |
| Answer» C. my_tbl.fmr | |
| 190. |
In the CREATE TABLE statement, the engine name specified is case insensitive. |
| A. | True |
| B. | False |
| C. | May be True or False |
| D. | Can't say |
| Answer» B. False | |
| 191. |
The option which finds the startup options supported by the server through mysqld is ______________ |
| A. | –verbose |
| B. | –vertex |
| C. | –startup |
| D. | –shutdown |
| Answer» B. –vertex | |
| 192. |
Server startup can also be done by the ______________ |
| A. | option file |
| B. | log file |
| C. | error file |
| D. | system file |
| Answer» B. log file | |
| 193. |
The collations this statement lists are ______________ |
| A. | names beginning with utf8 |
| B. | names ending with utf8 |
| C. | names containing utf8% anywhere |
| D. | names ending in utf8% |
| Answer» B. names ending with utf8 | |
| 194. |
The error log file has a suffix ______________ |
| A. | .err |
| B. | .er |
| C. | .error |
| D. | .log |
| Answer» B. .er | |
| 195. |
The statement used to find out which character sets are available is ______________ |
| A. | SHOW CHARACTER SET |
| B. | SHOW COLLATION |
| C. | SHOW CHARACTER SETS |
| D. | SHOW COLLATIONS |
| Answer» B. SHOW COLLATION | |
| 196. |
The clause that can be used to sort string values according to a specific collation is ______________ |
| A. | SORT |
| B. | GROUP |
| C. | FILTER |
| D. | COLLATE |
| Answer» E. | |
| 197. |
What are CROSS JOIN and JOIN are similar to? |
| A. | INNER JOIN |
| B. | NATURAL JOIN |
| C. | OUTER JOIN |
| D. | CARTESIAN JOIN |
| Answer» B. NATURAL JOIN | |
| 198. |
What is the clause that filters JOIN results called? |
| A. | WHERE |
| B. | SORT |
| C. | GROUP |
| D. | GROUP BY |
| Answer» B. SORT | |
| 199. |
The number of languages that have interfaces to bind to the C API of MySQL among these is ______________ |
| A. | 0 |
| B. | 1 |
| C. | 2 |
| D. | 3 |
| Answer» E. | |
| 200. |
The language in which image processing is least simple is ______________ |
| A. | PHP |
| B. | Perl |
| C. | Python |
| D. | C |
| Answer» E. | |