MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 49 Mcqs, each offering curated multiple-choice questions to sharpen your Structured Query Language (SQL) knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
In which directory are the DBI scripts located? |
| A. | cgi-inc |
| B. | cgi-bin |
| C. | cgi-usr |
| D. | cgi-perl |
| Answer» C. cgi-usr | |
| 2. |
Which is the log in which data changes received from a replication master server are written? |
| A. | error log |
| B. | general query log |
| C. | binary log |
| D. | relay log |
| Answer» E. | |
| 3. |
Multiple MySQL servers can be easily run on the same machine. |
| A. | True |
| B. | False |
| C. | May be True or False |
| D. | Can't say |
| Answer» C. May be True or False | |
| 4. |
The program that performs logical backups is _____________ |
| A. | mysqlimport |
| B. | mysqldump |
| C. | myslqpit |
| D. | mysqllogic |
| Answer» C. myslqpit | |
| 5. |
In ‘mysqldump’ which option is used to make all tables in the destination databases to use a different storage engine? |
| A. | –next-storage-engine |
| B. | –new-storage-engine |
| C. | –clear-storage-engine |
| D. | –get-storage-engine |
| Answer» C. –clear-storage-engine | |
| 6. |
PHP scripts are located in the web client document tree. |
| A. | True |
| B. | False |
| C. | May be True or False |
| D. | Can't say |
| Answer» C. May be True or False | |
| 7. |
In which context is the privilege ‘CREATE TABLESPACE’ applied? |
| A. | Server administration |
| B. | Tables |
| C. | Stored routines |
| D. | Views |
| Answer» B. Tables | |
| 8. |
Which program copies the databases from one server to another? |
| A. | mysqldbcopy |
| B. | mysqlcopydb |
| C. | mysqlflushdb |
| D. | mysqldbflush |
| Answer» B. mysqlcopydb | |
| 9. |
REPAIR TABLE works with how many of the following? |
| A. | 0 |
| B. | 1 |
| C. | 2 |
| D. | 3 |
| Answer» E. | |
| 10. |
To use ‘mysqldbcopy’ which privileges are required on the source server? |
| A. | CREATE |
| B. | INSERT |
| C. | UPDATE |
| D. | SELECT |
| Answer» E. | |
| 11. |
What are PHP variables preceded by? |
| A. | _ |
| B. | @ |
| C. | $ |
| D. | & |
| Answer» D. & | |
| 12. |
In PHP, how is the first element accessed if $a represents an array with numeric indices? |
| A. | $a[1] |
| B. | $a[0] |
| C. | $a.1 |
| D. | $a.0 |
| Answer» C. $a.1 | |
| 13. |
How is the output from PHP generated? |
| A. | statically generated |
| B. | dynamically generated |
| C. | not generated |
| D. | no output |
| Answer» C. not generated | |
| 14. |
CHECK TABLE works with how many of the following? |
| A. | 0 |
| B. | 1 |
| C. | 2 |
| D. | 3 |
| Answer» E. | |
| 15. |
The place where the server stores its databases and status files are called the data directory. |
| A. | True |
| B. | False |
| C. | May be True or False |
| D. | Can't say |
| Answer» B. False | |
| 16. |
The MySQL server is poorly configurable. |
| A. | True |
| B. | False |
| C. | May be True or False |
| D. | Can't say |
| Answer» C. May be True or False | |
| 17. |
The higher priority is ______________ |
| A. | writes |
| B. | reads |
| C. | same priority |
| D. | machine dependent |
| Answer» B. reads | |
| 18. |
Which data type is best suited to store currency values? |
| A. | INT |
| B. | FLOAT |
| C. | DOUBLE |
| D. | DECIMAL |
| Answer» E. | |
| 19. |
Which option is used in ‘mysqldump’ to make all tables in the destination databases to use a different storage engine? |
| A. | –next-storage-engine |
| B. | –new-storage-engine |
| C. | –clear-storage-engine |
| D. | –get-storage-engine |
| Answer» C. –clear-storage-engine | |
| 20. |
What is the default size of ‘max_binlog_cache_size’ system variable? |
| A. | 1 GB |
| B. | 2 GB |
| C. | 4 GB |
| D. | 8 GB |
| Answer» D. 8 GB | |
| 21. |
The metadata log is _______________ |
| A. | error log |
| B. | ddl log |
| C. | binary log |
| D. | relay log |
| Answer» C. binary log | |
| 22. |
How many of these can replace ‘level’ in ‘–myisam-recover = level’? |
| A. | 0 |
| B. | 1 |
| C. | 2 |
| D. | 3 |
| Answer» E. | |
| 23. |
The place where the server stores its databases and status files are the database directory. |
| A. | True |
| B. | False |
| C. | May be True or False |
| D. | Can't say |
| Answer» C. May be True or False | |
| 24. |
Which operator is used to access property of an object in PHP? |
| A. | . |
| B. | * |
| C. | -> |
| D. | @ |
| Answer» D. @ | |
| 25. |
Arrays can have associative indices in PHP. |
| A. | True |
| B. | False |
| C. | May be True or False |
| D. | Can't say |
| Answer» B. False | |
| 26. |
Which function returns reference to array of row values? |
| A. | fetchrow_array() |
| B. | fetchrow_arrayref() |
| C. | fetch() |
| D. | fetchrow_hashref() |
| Answer» C. fetch() | |
| 27. |
Which program converts binary log files to statements in text form? |
| A. | mysqldump |
| B. | mysqllog |
| C. | mysqlbin |
| D. | mysqlbinlog |
| Answer» E. | |
| 28. |
The ‘mysqlbackup’ command to perform a restore operation is _____________ |
| A. | copy-back-and-apply-log |
| B. | apply-log-and-copy-back |
| C. | copy-log-and-apply-back |
| D. | apply-back-and-copy-log |
| Answer» B. apply-log-and-copy-back | |
| 29. |
What is the default path to Perl in Unix? |
| A. | /usr/bin/perl |
| B. | /usr/bin |
| C. | /usr/perl |
| D. | /usr/perl/bin |
| Answer» B. /usr/bin | |
| 30. |
Which is the stored program associated with a schedule? |
| A. | Trigger |
| B. | Event |
| C. | Stored function |
| D. | Stored procedure |
| Answer» C. Stored function | |
| 31. |
The function ‘fetchrow_hashref()’ returns reference to hash of row values keyed by ______________ |
| A. | row name |
| B. | column name |
| C. | table name |
| D. | database name |
| Answer» C. table name | |
| 32. |
Which function returns reference to hash of row values? |
| A. | fetchrow_array() |
| B. | fetchrow_arrayref() |
| C. | fetch() |
| D. | fetchrow_hashref() |
| Answer» E. | |
| 33. |
How many of the following languages can interface to bind to the C API of MySQL? |
| A. | 0 |
| B. | 1 |
| C. | 2 |
| D. | 3 |
| Answer» E. | |
| 34. |
What is the Perl DBI? |
| A. | database inheritance |
| B. | database integrity |
| C. | database interface |
| D. | database isolation |
| Answer» D. database isolation | |
| 35. |
For which table does ‘REPAIR TABLE’ not work? |
| A. | MyISAM |
| B. | ARCHIVE |
| C. | CSV |
| D. | InnoDB |
| Answer» E. | |
| 36. |
To perform consistency checks on a MyISAM table the statement is _____________ |
| A. | CHECK TABLE |
| B. | REPAIR TABLE |
| C. | ANALYZE TABLE |
| D. | OPTIMIZE TABLE |
| Answer» B. REPAIR TABLE | |
| 37. |
The line which is written at the top of the script to write a Perl script using CGI.pm is ______________ |
| A. | use this CGI |
| B. | put CGI |
| C. | use CGI |
| D. | include CGI |
| Answer» D. include CGI | |
| 38. |
Which of the following columns is not returned by ‘OPTIMIZE TABLE’? |
| A. | Table |
| B. | Op |
| C. | Msg_type |
| D. | Msg_txt |
| Answer» E. | |
| 39. |
The column not returned by ‘OPTIMIZE TABLE’ is _____________ |
| A. | Table |
| B. | Msg_txt |
| C. | Op |
| D. | Msg_type |
| Answer» C. Op | |
| 40. |
The statement that performs key distribution analysis and stores the distribution for the named tables is _____________ |
| A. | CHECK TABLE |
| B. | ANALYZE TABLE |
| C. | CHECKSUM TABLE |
| D. | OPTIMIZE TABLE |
| Answer» C. CHECKSUM TABLE | |
| 41. |
WHAT_TYPES_OF_DATABASE_MAINTENANCE_SHOULD_BE_EXECUTED_??$ |
| A. | Update SQL Server’s usage |
| B. | Validate the database objects and system catalogs are free of corruption |
| C. | Determine the fragmentation for tables and indexes |
| D. | All of the mentioned |
| Answer» E. | |
| 42. |
Create_a_Database_Maintenance_Plan_that_creates_a__________backup_within_SQL_Server.$ |
| A. | Partial |
| B. | Snapshot |
| C. | Full |
| D. | None of the mentioned |
| Answer» D. None of the mentioned | |
| 43. |
Purpose of DBCC DBREINDEX command is to ? |
| A. | Rebuilds one or more indexes for a table in the specified database |
| B. | Rebuilds only one index for a table in the specified database |
| C. | Displays fragmentation information for the data and indexes of the specified table |
| D. | All of the mentioned |
| Answer» B. Rebuilds only one index for a table in the specified database | |
| 44. |
______________ runs UPDATE STATISTICS against all user-defined tables in the current database. |
| A. | sp_updatestats |
| B. | DBCC CHECKDB |
| C. | DBCC CATALOG |
| D. | DBCC INDEXDEFRAG |
| Answer» B. DBCC CHECKDB | |
| 45. |
Which of the following command defragments clustered and secondary indexes of the specified table ? |
| A. | DBCC SHOWCONTIG |
| B. | DBCC CHECKDB |
| C. | DBCC CATALOG |
| D. | DBCC INDEXDEFRAG |
| Answer» E. | |
| 46. |
Which of the following is used to Validate the database objects ? |
| A. | DBCC SHOWCONTIG |
| B. | DBCC CHECKDB |
| C. | DBCC CATALOG |
| D. | None of the mentioned |
| Answer» C. DBCC CATALOG | |
| 47. |
Which of the following is used to determine the fragmentation for tables and indexes ? |
| A. | DBCC SHOWCONTIG |
| B. | DBCC CHECKDB |
| C. | DBCC CHECKCATALOG |
| D. | None of the mentioned |
| Answer» B. DBCC CHECKDB | |
| 48. |
Point out the correct statement related to database maintenance : |
| A. | Performing SQL Server Maintenance with Maintenance Window |
| B. | Performing SQL Server Maintenance with No Maintenance Window |
| C. | Performing SQL Server Maintenance with Scrip Maintenance Window |
| D. | None of the mentioned |
| Answer» C. Performing SQL Server Maintenance with Scrip Maintenance Window | |
| 49. |
The SQL Server Maintenance Solution comprises scripts for running __________ maintenance on all editions of Microsoft SQL Server. |
| A. | backups |
| B. | integrity checks |
| C. | index |
| D. | all of the mentioned |
| Answer» E. | |