SQL MCQ Quiz Hub

1. What is the default path to Perl in Unix?
/usr/bin/perl
/usr/bin
/usr/perl
/usr/perl/bin

2. How is the output from PHP generated?
statically generated
dynamically generated
not generated
no output

3. What attempts auto recovery based on the contents of its serial log?
MyISAM
InnoDB
Falcon
TRANSACTION

4. Under which option are index changes not flushed until tables close?
–delay-write-key
–delay-key-write
–write-key-delay
–key-write-delay

5. Which option suppresses output unless there are errors in the table?
–silent
–wild
–suppress
–noout

6. What is the variable that is a handle to a database object?
$dbh
$sth
$fh
$h

7. The variable that returns code from operations that return true or false is ________
$rc
$rv
$rows
$ary

8. In PHP, how is the first element accessed if $a represents an array with numeric indices?
$a[1]
$a[0]
$a.1
$a.0

9. Which operator is used to access property of an object in PHP?
.
*
->
@

10. How is the binary log rotated?
FLUSH LOGS
ROTATE LOGS
FLUSH BINLOG
ROTATE BINLOG

11. How is a delimited-text data file reloaded?
mysqlexport
mysqlimport
mysqlexpand
mysqltransfer

12. Which program performs logical backups?
mysqlimport
mysqldump
myslqpit
mysqllogic

13. The option that suppresses output unless there are errors in the table is _____________
–silent
–wild
–suppress
–noout

14. What is the return value from operations returning a row count?
$rc
$rv
$rows
$ary

15. The mode of search in which the search string is parsed into words and the search looks for rows is ________
Boolean mode
Natural language
Query expansion
Cross mode

16. What is the hub of a MySQL installation?
mysqla
mysqlb
mysqlc
mysqld

17. Which program copies the databases from one server to another?
mysqldbcopy
mysqlcopydb
mysqlflushdb
mysqldbflush

18. To use ‘mysqldbcopy’ which privileges are required on the source server?
CREATE
INSERT
UPDATE
SELECT

19. The program that performs logical backups is _____
mysqlimport
mysqldump
myslqpit
mysqllogic

20. In ‘mysqldump’ which option is used to make all tables in the destination databases to use a different storage engine?
–next-storage-engine
–new-storage-engine
–clear-storage-engine
–get-storage-engine

21. Which function returns reference to hash of row values?
fetchrow_array()
fetchrow_arrayref()
fetch()
fetchrow_hashref()

22. The function ‘fetchrow_hashref()’ returns reference to hash of row values keyed by _____
row name
column name
table name
database name

23. Which function returns reference to array of row values?
fetchrow_array()
fetchrow_arrayref()
fetch()
fetchrow_hashref()

24. Which is the log in which data changes received from a replication master server are written?
error log
general query log
binary log
relay log

25. Which myisamchk variable represents the size of buffer used to hold index blocks?
key_buffer_size
read_buffer_size
sort_buffer_size
write_buffer_size

26. Which option is used in ‘mysqldump’ to make all tables in the destination databases to use a different storage engine?
–next-storage-engine
–new-storage-engine
_clear-storage-engine
_get-storage-engine

27. What is the output from PHP?
statically generated
dynamically generated
not generated
no output

28. What are PHP variables preceded by?
_
@
$
&

29. Which data type is best suited to store currency values?
INT
FLOAT
DOUBLE
DECIMAL

30. Which program converts binary log files to statements in text form?
mysqldump
mysqllog
mysqlbin
mysqlbinlog

31. The ‘mysqlbackup’ command to perform a restore operation is ______
copy-back-and-apply-log
apply-log-and-copy-back
copy-log-and-apply-back
apply-back-and-copy-log

32. The myisamchk variable that represents the size of buffer used to hold index blocks is ______
key_buffer_size
read_buffer_size
sort_buffer_size
write_buffer_size

33. Where does MySQL Enterprise Backup record details of each backup?
history_backup
backup_history
backlog_history
history_backlog

34. What is the log in which data changes received from a replication master server are written?
error log
general query log
binary log
relay log

35. The metadata log is ______
error log
ddl log
binary log
relay log

36. What is the default size of ‘max_binlog_cache_size’ system variable?
1 GB
2 GB
4GB
8GB

37. The slave stores the CHANGE MASTER parameters in the file _____
slave.info
slave.inf
master.info
master.inf

38. Which statement on the master expires binary log files?
SHOW SLAVE STATUS
PURGE MASTER
PURGE SLAVE
SHOW MASTER STATUS

39. Which statement suspends the replication related activity of the slave server?
RESUME SLAVE
START SLAVE
STOP SLAVE
GET SLAVE

40. MySQL Enterprise Backup records details of each backup in _____
history_backup
backup_history
backlog_history
history_backlog

41. In which context is the privilege ‘CREATE TABLESPACE’ applied?
Server administration
Tables
Stored routines
Views

42. In which directory are the DBI scripts located?
cgi-inc
cgi-bin
cgi-usr
cgi-perl

43. Which is the stored program associated with a schedule?
Trigger
Event
Stored function
Stored procedure

44. Which of these is not an exact numeric type?
SMALLINT
DECIMAL
NUMERIC
REAL

45. The statement that suspends the replication related activity of the slave server is _____
RESUME SLAVE
START SLAVE
STOP SLAVE
GET SLAVE

46. The minimum value stored by signed TINYINT is ______
-256
-128
0
128

47. MySQL uses security based on ACL. What does it stand for?
Access Control Language
Access Control Lists
Automatic Control Lists
Automatic Control Language

48. If $a represents an array with numeric indices in PHP, the first element accessed by ____
$a[1]
$a[0]
$a.1
$a.0

49. The operator used in PHP to access property of an object is _____
.
*
->
@

50. The maximum value that can be specified to the size of VARCHAR is ______
0
127
1023
65535