MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 657 Mcqs, each offering curated multiple-choice questions to sharpen your Testing Subject knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
Which of the following MySQL statements 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` | |
| 2. |
Which table is used to run a UNION-type query on MyISAM tables? |
| A. | TRADITIONAL |
| B. | MERGE |
| C. | SERVELET |
| D. | UNITE |
| Answer» C. SERVELET | |
| 3. |
The “Mysql command line tool” formats are bounded by ______________ |
| A. | +-| |
| B. | +-* |
| C. | +-/ |
| D. | +-} |
| Answer» B. +-* | |
| 4. |
Suppose it is desired that UNION operation should return not more than 3 rows. Which keyword is used for this? |
| A. | LIMIT |
| B. | RESTRICT |
| C. | COUNT |
| D. | SORT |
| Answer» B. RESTRICT | |
| 5. |
The following SQL statement is invalid. |
| A. | True |
| B. | False |
| C. | May be True or False |
| D. | Can't say |
| Answer» C. May be True or False | |
| 6. |
What is ‘xyz’ in the following SQL statement? |
| A. | row name |
| B. | column name |
| C. | table name |
| D. | database name |
| Answer» C. table name | |
| 7. |
In which join all the rows from the left table appear in the output irrespective of the content of the other table? |
| A. | RIGHT JOIN |
| B. | LEFT JOIN |
| C. | INNER JOIN |
| D. | OUTER JOIN |
| Answer» C. INNER JOIN | |
| 8. |
The UNION ALL has a higher precedence than UNION DISTINCT. |
| A. | True |
| B. | False |
| C. | May be True or False |
| D. | Can't say |
| Answer» C. May be True or False | |
| 9. |
What does ‘C’ stand for in the ACID property of transactions? |
| A. | Compound |
| B. | Concrete |
| C. | Collision |
| D. | Consistency |
| Answer» E. | |
| 10. |
It is not 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» C. May be True or False | |
| 11. |
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 COLLATIONS |
| Answer» B. SHOW COLLATION | |
| 12. |
Which among the following is the correct syntax for showing all tables in the database? |
| A. | SHOWS TABLES |
| B. | SHOW TABLE |
| C. | SHOW |
| D. | SHOWS TABLES; |
| Answer» E. | |
| 13. |
Which command is used in Mysql command line tool to return to window command shell? |
| A. | exit; |
| B. | quit; |
| C. | both exit; and quit; |
| D. | only exit; |
| Answer» D. only exit; | |
| 14. |
What default value gets stored in columns of the table? |
| A. | |
| B. | 0 |
| C. | 1 |
| D. | -1 |
| Answer» B. 0 | |
| 15. |
Which command is used for showing current date and time in Mysql command line tool? |
| A. | select now() |
| B. | SELECT now(); |
| C. | SELECT now() |
| D. | None of the mentioned |
| Answer» C. SELECT now() | |
| 16. |
Which parameter determines the shortest words to index in FULLTEXT indexes? |
| A. | ft_min_word_len |
| B. | ft_min_len_word |
| C. | ft_word_min_len |
| D. | ft_word_len_word |
| Answer» B. ft_min_len_word | |
| 17. |
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. | False |
| C. | May be True or False |
| D. | Can't say |
| Answer» B. False | |
| 18. |
Which of the following characters is illegal in naming an unquoted identifier in SQL? |
| A. | _ |
| B. | $ |
| C. | 2 |
| D. | . |
| Answer» E. | |
| 19. |
It is possible to drop multiple tables in the same statement. |
| A. | True |
| B. | False |
| C. | May be True or False |
| D. | Can't say |
| Answer» B. False | |
| 20. |
Which clause in the SQL standard controls how NULL values in a composite foreign key are handled when comparing to a primary key. |
| A. | SET |
| B. | MATCH |
| C. | ON DELETE |
| D. | ON CASCADE |
| Answer» C. ON DELETE | |
| 21. |
Which data type character merges the “Check Constraint” into a data type definition? |
| A. | ENUM |
| B. | ENUM1 |
| C. | ENUM2 |
| D. | None of the mentioned |
| Answer» B. ENUM1 | |
| 22. |
Which keyword is used to delete all the rows from the table? |
| A. | TRUNCATE |
| B. | REMOVE |
| C. | DELETE ALL |
| D. | CLEAR |
| Answer» B. REMOVE | |
| 23. |
What is the role of “CONSTRAINS” in defining a table in Mysql? |
| A. | Declaring primary key |
| B. | Declaring Foreign Key |
| C. | Restrictions on columns |
| D. | All of the mentioned |
| Answer» E. | |
| 24. |
Views are not updatable. |
| A. | True |
| B. | False |
| C. | May be True or False |
| D. | Can't say |
| Answer» C. May be True or False | |
| 25. |
MySQL stores the database character set and collation attributes in the file _________ |
| A. | dp.opt |
| B. | db.opt |
| C. | db.sv |
| D. | db.zip |
| Answer» C. db.sv | |
| 26. |
UPDATE statement is a DML statement. What does DML stand for? |
| A. | Data Manipulation Language |
| B. | Data Manipulation Level |
| C. | Data Markup Language |
| D. | Data Markup Level |
| Answer» B. Data Manipulation Level | |
| 27. |
What is the durability property of transactions? |
| A. | statements form a logic unit |
| B. | database remains consistent |
| C. | one transaction does not affect the other |
| D. | transaction effects are recorded permanently |
| Answer» E. | |
| 28. |
A view can be deleted using the command __________ |
| A. | REMOVE |
| B. | DELETE |
| C. | CLEAR |
| D. | DROP |
| Answer» E. | |
| 29. |
Which Clause is used to select a particular table in Mysql? |
| A. | WHERE |
| B. | SELECT |
| C. | FROM |
| D. | ALTER |
| Answer» D. ALTER | |
| 30. |
Which feature is used for the automatic increment of the column? |
| A. | AUTO_INCREMENT |
| B. | AUTO |
| C. | INCREMENT |
| D. | All of the mentioned |
| Answer» B. AUTO | |
| 31. |
The facility that allows nesting one select statement into another is called __________ |
| A. | nesting |
| B. | binding |
| C. | subquerying |
| D. | encapsulating |
| Answer» D. encapsulating | |
| 32. |
Which of the following is case sensitive in MySQL? |
| A. | Event names |
| B. | Logfile group names |
| C. | Column names |
| D. | Indexes |
| Answer» C. Column names | |
| 33. |
Which clause is used to rename the existing table? |
| A. | RENAME |
| B. | MODIFY |
| C. | ALTER |
| D. | None of the mentioned |
| Answer» B. MODIFY | |
| 34. |
Which of the following functions are not performed by “ALTER” clause? |
| A. | Change the name of the table |
| B. | Change the name of the column |
| C. | Drop a column |
| D. | All of the mentioned |
| Answer» E. | |
| 35. |
In the following MySQL command how many rows will be deleted? |
| A. | 1 |
| B. | 0 |
| C. | No row |
| D. | None of the mentioned |
| Answer» B. 0 | |
| 36. |
In the following MySQL command how many rows will be updated? |
| A. | 0-9 |
| B. | 1-6 |
| C. | No row |
| D. | None of the mentioned |
| Answer» B. 1-6 | |
| 37. |
SELECT on a MERGE table is like _____________ |
| A. | UNION ALL |
| B. | UNION |
| C. | UNION DISTINCT |
| D. | JOIN |
| Answer» B. UNION | |
| 38. |
The option in mysqlshow to show information about indexes in a table is _________ |
| A. | –no-data |
| B. | –indexes |
| C. | –keys |
| D. | –flag |
| Answer» D. –flag | |
| 39. |
The default index type for MEMORY tables is __________ |
| A. | HASH |
| B. | SPATIAL |
| C. | FULLTEXT |
| D. | UNIQUE |
| Answer» B. SPATIAL | |
| 40. |
The command which lists databases managed by the server is _____________ |
| A. | mysqld |
| B. | mysqlshow |
| C. | mysqllist |
| D. | mysqldb |
| Answer» C. mysqllist | |
| 41. |
“INSERT” is same as “UPDATE”? |
| A. | NO |
| B. | YES |
| C. | May be |
| D. | None of the mentioned |
| Answer» B. YES | |
| 42. |
Which Clause is used to sort the stored data in alphabetical order? |
| A. | ORDER by CLAUSE |
| B. | MODIFY |
| C. | ALTER |
| D. | UPDATE |
| Answer» B. MODIFY | |
| 43. |
The statement to change the table name is __________ |
| A. | CHANGE |
| B. | CHANGENAME |
| C. | CHANGENM |
| D. | RENAME |
| Answer» E. | |
| 44. |
Which property determines whether a database object is a case sensitive? |
| A. | COLLATION |
| B. | ATOMICITY |
| C. | COLLABORATION |
| D. | NORMALIZATION |
| Answer» B. ATOMICITY | |
| 45. |
What is generally used as a synonym for CHARACTER SET? |
| A. | CSET |
| B. | CHSET |
| C. | CHARSET |
| D. | CHCSET |
| Answer» D. CHCSET | |
| 46. |
Which statement can be used to specify the sql_mode system variable at runtime? |
| A. | SPECIFY |
| B. | SET |
| C. | ASSIGN |
| D. | CHANGE |
| Answer» C. ASSIGN | |
| 47. |
When no modes are enabled, what does this SQL statement return? |
| A. | empty value |
| B. | zero |
| C. | a negative value |
| D. | a garbage value |
| Answer» B. zero | |