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.
| 1. |
‘x’ in the following MySQL statement is ____________ |
| A. | column name |
| B. | table name |
| C. | server name |
| D. | database name |
| Answer» C. server name | |
| 2. |
The function returning reference to array of row values is ______________ |
| A. | fetchrow_array() |
| B. | fetchrow_arrayref() |
| C. | fetch() |
| D. | fetchrow_hashref() |
| Answer» C. fetch() | |
| 3. |
The column attribute provides unique numbers for identification is ______________ |
| A. | AUTO_INCREMENT |
| B. | UNSIGNED |
| C. | IDENTIFY |
| D. | DESCRIBE |
| Answer» B. UNSIGNED | |
| 4. |
The AUTO_INCREMENT column attribute is best used with ______________ |
| A. | FLOAT |
| B. | INT |
| C. | CHARACTER |
| D. | DOUBLE |
| Answer» C. CHARACTER | |
| 5. |
Issuing ‘SELECT’ on a MERGE table is like _____________ |
| A. | UNION |
| B. | UNION ALL |
| C. | UNION DISTINCT |
| D. | JOIN |
| Answer» C. UNION DISTINCT | |
| 6. |
Which of these is not optional? |
| A. | select_list |
| B. | table_list |
| C. | row_constraint |
| D. | grouping_columns |
| Answer» B. table_list | |
| 7. |
How many digits is the DECIMAL used for expressions containing only exact values with fractional part? |
| A. | 32 |
| B. | 64 |
| C. | 65 |
| D. | 16 |
| Answer» D. 16 | |
| 8. |
What is the precision of BIGINT? |
| A. | 32 |
| B. | 64 |
| C. | 128 |
| D. | 16 |
| Answer» C. 128 | |
| 9. |
The search mode that uses natural language search as a subroutine is ____________ |
| A. | Natural language |
| B. | Boolean mode |
| C. | Query expansion |
| D. | Cross mode |
| Answer» D. Cross mode | |
| 10. |
The spatial datatype used to store a curve is _____________ |
| A. | GEOMETRY |
| B. | POINT |
| C. | LINESTRING |
| D. | POLYGON |
| Answer» D. POLYGON | |
| 11. |
Stored programs degrade database security. |
| A. | True |
| B. | False |
| C. | May be True or False |
| D. | Can't say |
| Answer» C. May be True or False | |
| 12. |
Execution on a time activated basis according to a schedule is done by _____________ |
| A. | Stored program |
| B. | Events |
| C. | Triggers |
| D. | Stored procedures |
| Answer» C. Triggers | |
| 13. |
The system variable ‘system_time_zone’ can be reset at runtime. |
| A. | True |
| B. | False |
| C. | May be True or False |
| D. | Can't say |
| Answer» C. May be True or False | |
| 14. |
The following MySQL statement is valid. |
| A. | True |
| B. | False |
| C. | May be True or False |
| D. | Can't say |
| Answer» B. False | |
| 15. |
abc in the following MySQL statement is ___________ |
| A. | column name |
| B. | table name |
| C. | row name |
| D. | database name |
| Answer» B. table name | |
| 16. |
abc in the following MySQL statement is ____________ |
| A. | row name |
| B. | column name |
| C. | view |
| D. | database |
| Answer» C. view | |
| 17. |
xyz in the following MySQL statement is __________ |
| A. | table |
| B. | column |
| C. | view |
| D. | database |
| Answer» D. database | |
| 18. |
Is there any error in the following MySQL statement? |
| A. | No |
| B. | Yes |
| C. | Depends |
| D. | None of the mentioned |
| Answer» B. Yes | |
| 19. |
Which clause is similar to “HAVING” clause in Mysql? |
| A. | SELECT |
| B. | WHERE |
| C. | FROM |
| D. | None of the mentioned |
| Answer» C. FROM | |
| 20. |
If in Table “account”, a column “cust_id” consists of {1,2,2,3,3,5,6,7,8,8} then what will be the output on executing the following MySQL statement? |
| A. | {1, 2, 2, 3, 3, 5, 6, 7, 8, 8} |
| B. | {1, 2, 3, 5, 6, 7, 8} |
| C. | { } |
| D. | None of the mentioned |
| Answer» C. { } | |
| 21. |
If in Table “employee”, a column “emp_id” consists of {1,2,2,3,3,5,6,7,8,8} then what will be the output on executing the following MySQL statement? |
| A. | {1,2,2,3,3,5,6,7,8,8} |
| B. | {1,2,3,5,6,7,8} |
| C. | { } |
| D. | None of the mentioned |
| Answer» C. { } | |
| 22. |
Is there any error in executing the following MySQL command? |
| A. | Yes |
| B. | No |
| C. | Depends on condition |
| D. | None of the mentioned |
| Answer» C. Depends on condition | |
| 23. |
What is the meaning of the “WHERE” clause in Mysql? |
| A. | Filtering out unwanted rows from result set |
| B. | Filtering out unwanted columns from result set |
| C. | Filtering out unwanted rows and columns from result set |
| D. | None of the mentioned |
| Answer» B. Filtering out unwanted columns from result set | |
| 24. |
Which Keyword is used to remove duplicate rows in the result set? |
| A. | DISTINCTS |
| B. | MODIFY |
| C. | DISTINCT |
| D. | All of the mentioned |
| Answer» B. MODIFY | |
| 25. |
How can we define the clause “FROM” in Mysql? |
| A. | It defines the tables used by a query |
| B. | It defines the linking of tables in Mysql |
| C. | It defines the tables used by a query & linking of tables in Mysql |
| D. | None of the mentioned |
| Answer» D. None of the mentioned | |
| 26. |
In the following MySQL query, “person_1” belongs to which category of table in MySQL? |
| A. | Permanent Tables |
| B. | Virtual tables |
| C. | Temporary tables |
| D. | None of the mentioned |
| Answer» C. Temporary tables | |
| 27. |
What is the meaning of “Temporary Tables” in Mysql? |
| A. | Rows returned by sub query |
| B. | Permanent tables |
| C. | Virtual tables |
| D. | All of the mentioned |
| Answer» B. Permanent tables | |
| 28. |
Find the missing clause from the following SQL statement? |
| A. | FROM |
| B. | WHERE |
| C. | SELECT |
| D. | None of the mentioned |
| Answer» B. WHERE | |
| 29. |
“SELECT” clause cannot be used without which clause in Mysql? |
| A. | FROM |
| B. | WHERE |
| C. | ORDER BY |
| D. | All of the mentioned |
| Answer» B. WHERE | |
| 30. |
“CREATE TABLE …” command is used to create which type of table in Mysql? |
| A. | Permanent Tables |
| B. | Virtual tables |
| C. | Temporary tables |
| D. | All of the mentioned |
| Answer» B. Virtual tables | |
| 31. |
“CREATE VIEW …” command is used to create which type of table in Mysql? |
| A. | Permanent Tables |
| B. | Virtual tables |
| C. | Temporary tables |
| D. | All of the mentioned |
| Answer» C. Temporary tables | |
| 32. |
If emp_id contain the following set {9, 7, 6, 4, 3, 1, 2}, what will be the output on execution of the following MySQL command? |
| A. | {9, 7, 6, 4, 3, 1, 2} |
| B. | {1, 2, 3, 4, 6, 7, 9} |
| C. | {2, 1, 3, 4, 6, 7, 9} |
| D. | None of the mentioned |
| Answer» C. {2, 1, 3, 4, 6, 7, 9} | |
| 33. |
Is there any error in the following MySQL command? |
| A. | Yes |
| B. | No error |
| C. | Depends |
| D. | None of the mentioned |
| Answer» C. Depends | |
| 34. |
Which command is used to create “Temporary tables” in MySQL? |
| A. | CREATE TABLE; |
| B. | CREATE VIEW |
| C. | Both CREATE TABLE; and CREATE VIEW |
| D. | None of the mentioned |
| Answer» E. | |
| 35. |
What will be the output of the following MySQL statement ? |
| A. | False |
| B. | Null |
| C. | Depend |
| D. | None of the mentioned |
| Answer» C. Depend | |
| 36. |
Which of the following statements is/are correct with respect to “VIEW”? |
| A. | “VIEW” is a query that stored in the data dictionary |
| B. | There is no data associated with “VIEW” |
| C. | “VIEW” creates virtual tables in Database |
| D. | All of the mentioned |
| Answer» E. | |
| 37. |
What is the meaning of “GROUP BY” clause in Mysql? |
| A. | Group data by column values |
| B. | Group data by row values |
| C. | Group data by column and row values |
| D. | None of the mentioned |
| Answer» B. Group data by row values | |
| 38. |
Find odd one out? |
| A. | GROUP BY |
| B. | DESC |
| C. | ASC |
| D. | ORDER BY |
| Answer» B. DESC | |
| 39. |
What is the need of “column Aliases” in “SELECT” clause? |
| A. | To assign a new label to the column in result set |
| B. | To overwrite the existing column name in result set |
| C. | To modify the column name while using literals, Expression, built_in functions with “SELECT clause |
| D. | All of the mentioned |
| Answer» E. | |
| 40. |
Which among the following is an optional Keyword? |
| A. | DISTINICTS |
| B. | ALL |
| C. | AS |
| D. | Both AS and ALL |
| Answer» E. | |
| 41. |
Is “GROUP BY” clause is similar to “ORDER BY” clause? |
| A. | Yes |
| B. | No |
| C. | Depends |
| D. | None of the mentioned |
| Answer» C. Depends | |
| 42. |
What is the use of “VIEW” in Mysql? |
| A. | To hide columns from the users |
| B. | To hide the complexity of the database |
| C. | To simplify complexity of database design |
| D. | All of the mentioned |
| Answer» E. | |
| 43. |
Which among the following belongs to an “aggregate function”? |
| A. | COUNT |
| B. | UPPER |
| C. | LOWER |
| D. | All of the mentioned |
| Answer» B. UPPER | |
| 44. |
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» B. Aggregation of fields | |
| 45. |
What is the meaning of “HAVING” clause in Mysql? |
| A. | To filter out the row values |
| B. | To filter out the column values |
| C. | To filter out the row and column values |
| D. | None of the mentioned |
| Answer» B. To filter out the column values | |
| 46. |
“COUNT” keyword belongs to which categories in Mysql? |
| A. | Aggregate functions |
| B. | Operators |
| C. | Clauses |
| D. | All of the mentioned |
| Answer» B. Operators | |
| 47. |
What is the significance of “ORDER BY” in the following MySQL statement? |
| A. | Data of emp_id will be sorted |
| B. | Data of emp_id will be sorted in descending order |
| C. | Data of emp_id will be sorted in ascending order |
| D. | All of the mentioned |
| Answer» B. Data of emp_id will be sorted in descending order | |
| 48. |
What is the significance of the statement “GROUP BY d.name” in the following MySQL statement? |
| A. | Aggregation of the field “name” of both table |
| B. | Aggregation of the field “name” of table “department” |
| C. | Sorting of the field “name” |
| D. | None of the mentioned |
| Answer» C. Sorting of the field “name” | |
| 49. |
What is the significance of the statement “HAVING COUNT (emp_id)>2” in the following MySQL statement? |
| A. | Filter out all rows whose total emp_id below 2 |
| B. | Selecting those rows whose total emp_id>2 |
| C. | Filter out all rows whose total emp_id below 2 & Selecting those rows whose total emp_id>2 |
| D. | None of the mentioned |
| Answer» D. None of the mentioned | |
| 50. |
Which of the following belongs to an “aggregate function”? |
| A. | COUNT |
| B. | SUM/AVG |
| C. | MIN/MAX |
| D. | All of the mentioned |
| Answer» E. | |