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. |
The context in which the privilege ‘CREATE TABLESPACE’ applies is ______________ |
| A. | Server administration |
| B. | Tables |
| C. | Stored routines |
| D. | Views |
| Answer» B. Tables | |
| 2. |
The option necessary to compile a C program havin math functions is ______________ |
| A. | -lm |
| B. | -ln |
| C. | -lp |
| D. | -lq |
| Answer» B. -ln | |
| 3. |
What has a higher priority? |
| A. | writes |
| B. | reads |
| C. | same priority |
| D. | machine dependent |
| Answer» B. reads | |
| 4. |
What is the option for specifying the executable name while compiling with gcc? |
| A. | -e |
| B. | -o |
| C. | -a |
| D. | -b |
| Answer» C. -a | |
| 5. |
The default scheduling property of MySQL is implemented by how many of these? |
| A. | 0 |
| B. | 1 |
| C. | 2 |
| D. | 3 |
| Answer» E. | |
| 6. |
Which of these exports table definitions and contents? |
| A. | mysqldump |
| B. | mysqladmin |
| C. | mysqlimport |
| D. | mysqlexport |
| Answer» B. mysqladmin | |
| 7. |
Which of the following does not return a value? |
| A. | 0 |
| B. | 1 |
| C. | 2 |
| D. | 3 |
| Answer» C. 2 | |
| 8. |
Which of the following use ‘NULL’ to indicate failure? |
| A. | 0 |
| B. | 1 |
| C. | 2 |
| D. | 3 |
| Answer» D. 3 | |
| 9. |
The library file that contains various portability macros and definitions is ______________ |
| A. | my_global.h |
| B. | my_sys.h |
| C. | mysql.h |
| D. | my_local.h |
| Answer» C. mysql.h | |
| 10. |
The header that should be included first is ______________ |
| A. | my_global.h |
| B. | my_sys.h |
| C. | mysql.h |
| D. | my_local.h |
| Answer» B. my_sys.h | |
| 11. |
Replication enables data from one MySQL database server to be copied to one or more MySQL database servers. |
| A. | True |
| B. | False |
| C. | May be True or False |
| D. | Can't say |
| Answer» B. False | |
| 12. |
SBR replication is ______________ |
| A. | Statement based |
| B. | Row based |
| C. | Column based |
| D. | Table based |
| Answer» B. Row based | |
| 13. |
To reload a delimited text data file use ______________ |
| A. | mysqldump |
| B. | mysqld |
| C. | mysqlimport |
| D. | mysqlnaive |
| Answer» D. mysqlnaive | |
| 14. |
The most restrictive among the following is ______________ |
| A. | mysql_query() |
| B. | mysql_real_query() |
| C. | same |
| D. | machine dependent |
| Answer» B. mysql_real_query() | |
| 15. |
An embedded application includes the server side and client side. |
| A. | True |
| B. | False |
| C. | May be True or False |
| D. | Can't say |
| Answer» B. False | |
| 16. |
What is the kind of delete when deletion of an employee from the table also deletes that employee from another table? |
| A. | transparent |
| B. | concrete |
| C. | elaborate |
| D. | cascaded |
| Answer» E. | |
| 17. |
Multiple statement execution is not enabled by default. |
| A. | True |
| B. | False |
| C. | May be True or False |
| D. | Can't say |
| Answer» B. False | |
| 18. |
What is the general statement-issuing routine? |
| A. | mysql_real_query() |
| B. | mysql_query_real() |
| C. | mysql_image_query() |
| D. | mysql_query_image() |
| Answer» B. mysql_query_real() | |
| 19. |
The grant table that stores users who can connect to the server and their global privileges are ______________ |
| A. | user |
| B. | db |
| C. | tables_priv |
| D. | procs_priv |
| Answer» B. db | |
| 20. |
The system variable controls the size of the table cache _________________ |
| A. | table_cache |
| B. | cache_table |
| C. | open_cache |
| D. | cache_open |
| Answer» B. cache_table | |
| 21. |
The date and time datatype that stores time value in ‘hh:mm:ss’ format is ___________ |
| A. | DATE |
| B. | TIME |
| C. | DATETIME |
| D. | TIMESTAMP |
| Answer» C. DATETIME | |
| 22. |
Mysql cannot be used to execute script files. |
| A. | True |
| B. | False |
| C. | May be True or False |
| D. | Can't say |
| Answer» C. May be True or False | |
| 23. |
For InnoDB tables in mysqldump an online backup that takes no locks on tables can be performed by ______________ |
| A. | –multiple-transaction |
| B. | –single-transaction |
| C. | –double-transaction |
| D. | –no-transaction |
| Answer» C. –double-transaction | |
| 24. |
The ‘A’ in the ACID property of transactions is _______________ |
| A. | Availability |
| B. | Accuracy |
| C. | Adjustability |
| D. | Atomicity |
| Answer» E. | |
| 25. |
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» B. Show me all columns | |
| 26. |
Which among the following can also be included with “SELECT” clause while writing query in Mysql? |
| A. | Literals |
| B. | Expressions |
| C. | User defined functions |
| D. | All of the mentioned |
| Answer» E. | |
| 27. |
Which clause is mandatory with clause “SELECT” in Mysql? |
| A. | FROM |
| B. | WHERE |
| C. | Both FROM and WHERE |
| D. | None of the mentioned |
| Answer» B. WHERE | |
| 28. |
Find the error in the following SQL statement? |
| A. | No Error |
| B. | No table mentioned |
| C. | Depends |
| D. | None of the mentioned |
| Answer» C. Depends | |
| 29. |
What will be the output of the following SQL statement? |
| A. | Show all columns but only those rows which belongs to person_id=1 |
| B. | Show all columns and rows |
| C. | Shows only columns person_id |
| D. | None of the mentioned |
| Answer» B. Show all columns and rows | |
| 30. |
What will be the output of of the following SQL statement? |
| A. | Show only columns (person_id, Fname, lname) and rows related to these columns |
| B. | Show only columns (person_id, Fname, lname) |
| C. | Show all rows |
| D. | Show all columns except (person_id, Fname, lname) |
| Answer» B. Show only columns (person_id, Fname, lname) | |
| 31. |
Can “SELECT” clause be used without the clause “FROM”? |
| A. | Yes |
| B. | No |
| C. | Depends |
| D. | None of the mentioned |
| Answer» C. Depends | |
| 32. |
What does ‘name’ represent in the following SQL code snippet? |
| A. | A table |
| B. | A row |
| C. | A column |
| D. | An object |
| Answer» D. An object | |
| 33. |
The MySQL server used in its client/server architecture is _______________ |
| A. | mysqla |
| B. | mysqlb |
| C. | mysqlc |
| D. | mysqld |
| Answer» E. | |
| 34. |
Which is the MySQL instance responsible for data processing? |
| A. | MySQL client |
| B. | MySQL server |
| C. | SQL |
| D. | Server daemon program |
| Answer» C. SQL | |
| 35. |
In MySQL databases, the structure representing the organizational views of the entire databases is ____________ |
| A. | Schema |
| B. | View |
| C. | Instance |
| D. | Table |
| Answer» B. View | |
| 36. |
Which type of database management system is MySQL?What is data in a MySQL database organized into? |
| A. | Object-orientedObjects |
| B. | HierarchicalTables |
| C. | RelationalNetworks |
| D. | NetworkFile systems |
| Answer» C. RelationalNetworks | |
| 37. |
What represents an ‘attribute’ in a relational database? |
| A. | TrueTable |
| B. | FalseRow |
| C. | May be True or FalseColumn |
| D. | Can't sayObject |
| Answer» D. Can't sayObject | |
| 38. |
What represents a ‘tuple’ in a relational database? |
| A. | Table |
| B. | Row |
| C. | Column |
| D. | Object |
| Answer» C. Column | |
| 39. |
Which program reads the statement from a binary log? |
| A. | mysql_config |
| B. | mysqlbinlog |
| C. | mysqldump |
| D. | mysqlimport |
| Answer» C. mysqldump | |
| 40. |
Which program emulates the client load for a MySQL server? |
| A. | mysqlslap |
| B. | mysqldump |
| C. | mysqladmin |
| D. | mysqlimport |
| Answer» B. mysqldump | |
| 41. |
The place where the server stores its databases and status files are the data directory. |
| A. | True |
| B. | False |
| C. | May be True or False |
| D. | Can't say |
| Answer» B. False | |
| 42. |
Which of the following is more efficient? |
| A. | LOAD DATA |
| B. | INSERT |
| C. | Same |
| D. | Indeterminate |
| Answer» B. INSERT | |
| 43. |
The function used to convert a string to an int is ______________ |
| A. | INET_ATON() |
| B. | INET_NTOA() |
| C. | INET_ITOS() |
| D. | INET_STOI() |
| Answer» B. INET_NTOA() | |
| 44. |
What is used to perform an analysis of key values by the server? |
| A. | ANALYZE KEYS |
| B. | ANALYZE TABLE |
| C. | PERFORM ANALYSIS |
| D. | PERFORM TABLE ANALYSIS |
| Answer» C. PERFORM ANALYSIS | |
| 45. |
Which of the following is true concerning triggers? |
| A. | You do not create them with SQL. |
| B. | They execute against only some applications that access a database. |
| C. | They have an event, condition, and action. |
| D. | They cannot cascade (cause another trigger to fire). |
| Answer» D. They cannot cascade (cause another trigger to fire). | |
| 46. |
The following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T ; |
| A. | Equi-join |
| B. | Natural join |
| C. | Outer join |
| D. | Cartesian join |
| Answer» E. | |
| 47. |
How many tables may be included with a join? |
| A. | One |
| B. | Two |
| C. | Three |
| D. | All of the above. |
| Answer» E. | |
| 48. |
Which of the following is a correlated subquery? |
| A. | Uses the result of an inner query to determine the processing of an outer query. |
| B. | Uses the result of an outer query to determine the processing of an inner query. |
| C. | Uses the result of an inner query to determine the processing of an inner query. |
| D. | Uses the result of an outer query to determine the processing of an outer query. |
| Answer» C. Uses the result of an inner query to determine the processing of an inner query. | |
| 49. |
Which of the following statements is true concerning subqueries? |
| A. | Involves the use of an inner and outer query. |
| B. | Cannot return the same result as a query that is not a subquery. |
| C. | Does not start with the word SELECT. |
| D. | All of the above. |
| Answer» B. Cannot return the same result as a query that is not a subquery. | |
| 50. |
A UNION query is which of the following? |
| A. | Combines the output from no more than two queries and must include the same number of columns. |
| B. | Combines the output from no more than two queries and does not include the same number of columns. |
| C. | Combines the output from multiple queries and must include the same number of columns. |
| D. | Combines the output from multiple queries and does not include the same number of columns. |
| Answer» D. Combines the output from multiple queries and does not include the same number of columns. | |