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. |
What can be used to check for views that have been invalidated by DROP or ALTER operations? |
| A. | CREATE TABLE |
| B. | VERIFY TABLE |
| C. | DETAILS TABLE |
| D. | CHECK TABLE |
| Answer» E. | |
| 2. |
Which among the following is the correct syntax for modifying the definition of an existing table? |
| A. | ALTER TABLE person MODIFY person_id SMALLINT UNSIGNED AUTO_INCREMENT; |
| B. | ALTER TABLE person person_id SMALLINT UNSIGNED AUTO_INCREMENT; |
| C. | ALTER TABLE person MODIFY person_id ; |
| D. | ALTER TABLE person |
| Answer» B. ALTER TABLE person person_id SMALLINT UNSIGNED AUTO_INCREMENT; | |
| 3. |
Which command is used for taking “server side help” in Mysql command line tool? |
| A. | /h |
| B. | /c |
| C. | /e |
| D. | None of the mentioned |
| Answer» B. /c | |
| 4. |
Transactional processing requires lesser overhead due to CPU cycles and memory. |
| A. | True |
| B. | False |
| C. | May be True or False |
| D. | Can't say |
| Answer» C. May be True or False | |
| 5. |
What cannot be done on a view? |
| A. | display |
| B. | filter |
| C. | index |
| D. | drop |
| Answer» D. drop | |
| 6. |
What does ‘A’ stand for in the ACID property of transactions? |
| A. | Availability |
| B. | Accuracy |
| C. | Adjustability |
| D. | Atomicity |
| Answer» E. | |
| 7. |
Which keyword is used to specify the foreign key after the table is created? |
| A. | SETUP |
| B. | SET |
| C. | ALTER TABLE |
| D. | SPECIFY |
| Answer» D. SPECIFY | |
| 8. |
Mysql command line tool is used to show “how many rows are returned and how long SQL command took to execute”. |
| A. | True |
| B. | False |
| C. | Undetermined |
| D. | Depend |
| Answer» D. Depend | |
| 9. |
What is the default value of column? |
| A. | |
| B. | 0 |
| C. | -1 |
| D. | Undefined |
| Answer» B. 0 | |
| 10. |
Which of the following does not support a materialized view? |
| A. | MySQL |
| B. | Oracle |
| C. | PostgreSQL |
| D. | SybaseSQL |
| Answer» B. Oracle | |
| 11. |
What is xyz in the following SQL statement? |
| A. | column name |
| B. | table name |
| C. | row name |
| D. | database name |
| Answer» C. row name | |
| 12. |
What is the value of val2 in the following MySQL statement? |
| A. | previous val1 |
| B. | updated val1 |
| C. | unchanged |
| D. | val1 + 1 |
| Answer» C. unchanged | |
| 13. |
What is abc in the following SQL statement? |
| A. | column name |
| B. | table name |
| C. | row name |
| D. | database name |
| Answer» B. table name | |
| 14. |
What is x in the following MySQL statement? |
| A. | column name |
| B. | table name |
| C. | server name |
| D. | database name |
| Answer» C. server name | |
| 15. |
In the following SQL command “*” stands for? |
| A. | Retrieve all data from the table |
| B. | Retrieve data of primary key only |
| C. | Retrieve NULL data |
| D. | None of the mentioned |
| Answer» B. Retrieve data of primary key only | |
| 16. |
In the following SQL command “person” stands for? |
| A. | Table name |
| B. | Attribute |
| C. | Multivalued attribute |
| D. | None of the mentioned |
| Answer» B. Attribute | |
| 17. |
If attribute “fruit” stores data as “apple, mango, banana” in table person then what will be the output of the following SQL command? |
| A. | apple, mango, banana |
| B. | apple, banana, mango |
| C. | mango, apple, banana |
| D. | none of the mentioned |
| Answer» B. apple, banana, mango | |
| 18. |
Which among the following is the correct syntax for defining “ENUM” in Mysql? |
| A. | gender ENUM (‘M’, ‘F’), |
| B. | gender ENUM, |
| C. | gender ENUM ( ), |
| D. | none of the mentioned |
| Answer» B. gender ENUM, | |
| 19. |
In the following SQL command “person_id” can be ____________ |
| A. | Only Primary Key |
| B. | Primary Key or any other Attribute |
| C. | Only Attribute but not a primary Key |
| D. | None of the mentioned |
| Answer» C. Only Attribute but not a primary Key | |
| 20. |
In the following SQL query, what does “person” stands for? |
| A. | Composite attributes |
| B. | Multivalued attributes |
| C. | Table name |
| D. | None of the mentioned |
| Answer» D. None of the mentioned | |
| 21. |
Find out the logical error in the following MySQL code snippet? |
| A. | Lesser number of columns |
| B. | Incorrect definition |
| C. | Primary key is missing |
| D. | None of the mentioned |
| Answer» D. None of the mentioned | |
| 22. |
In the following SQL query, what does “person_id” stands for? |
| A. | Normal attribute of the table |
| B. | Super key |
| C. | Composite key |
| D. | Primary key |
| Answer» C. Composite key | |
| 23. |
Will the following SQL command produce any error ? |
| A. | Error |
| B. | No Error |
| C. | Depends |
| D. | None of the mentioned |
| Answer» C. Depends | |
| 24. |
Will the following SQL command produce any error? |
| A. | Error |
| B. | No Error |
| C. | Depends |
| D. | None of the mentioned |
| Answer» B. No Error | |
| 25. |
What is xyz in the following MySQL statement? |
| A. | column name |
| B. | table name |
| C. | search string |
| D. | database name |
| Answer» D. database name | |
| 26. |
In Boolean search, results are sorted by relevance. |
| A. | True |
| B. | False |
| C. | May be True or False |
| D. | Can't say |
| Answer» C. May be True or False | |
| 27. |
What is known as the set of SQL statements that either executes successfully or none of them have an effect? |
| A. | joins |
| B. | transactions |
| C. | filters |
| D. | deletions |
| Answer» C. filters | |
| 28. |
What is the meaning of “REFERENCES” in table definition? |
| A. | Primary key |
| B. | |
| C. | Foreign Key |
| D. | A ”foreign Key” belong to this particular table |
| Answer» E. | |
| 29. |
Qualifying the name of column with the table name is not necessary in single-table updates. |
| A. | True |
| B. | False |
| C. | May be True or False |
| D. | Can't say |
| Answer» B. False | |
| 30. |
What is AI in terms of database collation? |
| A. | Accent Insensitive |
| B. | Augment Insensitive |
| C. | Articulate Insensitive |
| D. | Addition Insensitive |
| Answer» B. Augment Insensitive | |
| 31. |
What is true about the following SQL statement? |
| A. | invalid |
| B. | display contents of table_1 |
| C. | improper case being used |
| D. | display only column names in table_1 |
| Answer» C. improper case being used | |
| 32. |
If no database has been selected, specifying a database qualifier is necessary. |
| A. | True |
| B. | False |
| C. | May be True or False |
| D. | Can't say |
| Answer» B. False | |
| 33. |
Which collations does this MySQL statement list? |
| 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 | |
| 34. |
Post MySQL 6.0, utf8 was ___________ |
| A. | 3 bytes |
| B. | 4 bytes |
| C. | 5 bytes |
| D. | 6 bytes |
| Answer» C. 5 bytes | |
| 35. |
Prior to MySQL 6.0, utf8 was ___________ |
| A. | 3 bytes |
| B. | 4 bytes |
| C. | 8 bytes |
| D. | 9 bytes |
| Answer» B. 4 bytes | |
| 36. |
Which statement is used to show the server’s current character set and collation settings? |
| A. | SHOW CONSTANTS |
| B. | SHOW CONSTRAINTS |
| C. | SHOW VARIABLES |
| D. | DISP VARIABLES |
| Answer» D. DISP VARIABLES | |
| 37. |
Which statement is used to see the definition for an existing database? |
| A. | SHOW CREATE DATABASE |
| B. | SHOW DATABASE |
| C. | SHOW CREATE |
| D. | SHOW CREATE DATABASE TABLE |
| Answer» B. SHOW DATABASE | |
| 38. |
To create a database only if it doesn’t already exist, which clause is used? |
| A. | IF EXISTS |
| B. | IF NOT EXISTS |
| C. | CREATE EXISTS |
| D. | EXISTS IF |
| Answer» C. CREATE EXISTS | |
| 39. |
Which statement makes changes to the database’s global attributes? |
| A. | CHANGE |
| B. | ALTER |
| C. | ALTERNATE |
| D. | UPDATE |
| Answer» C. ALTERNATE | |
| 40. |
The join in which all the rows from the right table appear in the output irrespective of the content of the other table is ___________ |
| A. | CARTESIAN JOIN |
| B. | CROSS JOIN |
| C. | INNER JOIN |
| D. | RIGHT JOIN |
| Answer» E. | |
| 41. |
Which subquery cannot be executed by itself as a separate statement? |
| A. | Correlated |
| B. | Uncorrelated |
| C. | EXISTS |
| D. | NOT EXISTS |
| Answer» B. Uncorrelated | |
| 42. |
Which keyword in the UPDATE statement is used to assign values to columns? |
| A. | ASSIGN |
| B. | SET |
| C. | MARK |
| D. | GET |
| Answer» C. MARK | |
| 43. |
Which among the following is the correct syntax for defining “Constraint Check” in Mysql? |
| A. | gender char(1) check( gender IN (‘M’, ‘F’)), |
| B. | gender char (1) check, |
| C. | gender char (1) check ( gender ), |
| D. | none of the mentioned |
| Answer» B. gender char (1) check, | |
| 44. |
How many storage engines among the following are transaction-safe? |
| A. | 1 |
| B. | 2 |
| C. | 3 |
| D. | 4 |
| Answer» C. 3 | |
| 45. |
An uncorrelated subquery does not contain any reference to the values from the outer query. |
| A. | True |
| B. | False |
| C. | May be True or False |
| D. | Can't say |
| Answer» B. False | |
| 46. |
Which command is used to show all tables that are stored in a database? |
| A. | SHOWS |
| B. | SHOW |
| C. | SHOWES |
| D. | None of the mentioned |
| Answer» E. | |
| 47. |
Transactional processing provides strong guarantees about the outcome of operations. |
| A. | True |
| B. | False |
| C. | May be True or False |
| D. | Can't say |
| Answer» B. False | |
| 48. |
Which among the following are the correct definitions for “NULL” in Mysql? |
| A. | Absence of value |
| B. | Unknown |
| C. | Empty set |
| D. | All of the mentioned |
| Answer» E. | |
| 49. |
The “Mysql command line tool” format the results in which of the following format? |
| A. | Rectangle |
| B. | Square |
| C. | Sphere |
| D. | None of the mentioned |
| Answer» B. Square | |
| 50. |
Which clause is used to sort a UNION result as a whole? |
| A. | LIMIT |
| B. | ORDER BY |
| C. | GROUP BY |
| D. | SORT |
| Answer» C. GROUP BY | |