MySQL mcq questions and answers | MySQL MCQs Page-6 section-2

Section 1 Section 2 Section 3 Section 4 Section 5 Section 6 Section 7 Section 8 Section 9 Section 10 Section 11 Section 12

51.
fetchrow_hashref() returns reference to hash of row values keyed by . . . . . . . .

A. row name

B. column name

C. table name

D. database name

Answer & Solution Discuss in Board Save for Later

52.
In which file are the statements entered in 'mysql' saved?

A. .mysql_queries

B. .queries

C. .mysql_history

D. .history

Answer & Solution Discuss in Board Save for Later

53.

Suppose tbl_1 is a table consisting of 8 rows and tbl_2 is a table consisting of 6 rows, the number of combinations through which the search is performed is . . . . . . .

SELECT tbl_1.i1, tbl_2.i2
	FROM tbl_1 INNER JOIN tbl_2
	WHERE tbl_1.i1 = tbl_2.i2;

A. 14

B. 2

C. 1

D. 48

Answer & Solution Discuss in Board Save for Later

54.
Which table lists the accounts and the databases for which the privileges are provided?

A. user

B. db

C. tables_priv

D. procs_priv

Answer & Solution Discuss in Board Save for Later

55.
What is the shebang line?

A. #!

B. !#

C. #$

D. $#

Answer & Solution Discuss in Board Save for Later

56.
What can be used interchangeably with MYSQL_VERSION_ID?

A. LIBMYSQL_VERSION

B. LIBMYSQL_VERSION_ID

C. MYSQL_VERSION_ID

D. MYSQL_ID

Answer & Solution Discuss in Board Save for Later

57.

The number of tables among the following for which HIGH_PRIORITY have an effect are . . . . . . . .

MyISAM, MEMORY, MERGE

A. 0

B. 1

C. 2

D. 3

Answer & Solution Discuss in Board Save for Later

58.
The MySQL clients are linked with . . . . . . . .

A. -lmysqlclient

B. -cmysqlclient

C. -dmysqlclient

D. -vmysqlclient

Answer & Solution Discuss in Board Save for Later

59.
CGI stands for . . . . . . . .

A. Computer Gateway Interface

B. Common Gateway Interface

C. Computer Generated Interface

D. Common Generated Interface

Answer & Solution Discuss in Board Save for Later

60.
There can be more than one column per table with the AUTO_INCREMENT attribute.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

1 2 3 4 5 6 7 8 9 10

51.
fetchrow_hashref() returns reference to hash of row values keyed by . . . . . . . .

Answer & Solution

52.
In which file are the statements entered in 'mysql' saved?

Answer & Solution

53.
Suppose tbl_1 is a table consisting of 8 rows and tbl_2 is a table consisting of 6 rows, the number of combinations through which the search is performed is . . . . . . .

`SELECT tbl_1.i1, tbl_2.i2 FROM tbl_1 INNER JOIN tbl_2 WHERE tbl_1.i1 = tbl_2.i2;`

Answer & Solution

54.
Which table lists the accounts and the databases for which the privileges are provided?

Answer & Solution

55.
What is the shebang line?

Answer & Solution

56.
What can be used interchangeably with MYSQL_VERSION_ID?

Answer & Solution

57.
The number of tables among the following for which HIGH_PRIORITY have an effect are . . . . . . . .

`MyISAM, MEMORY, MERGE`

Answer & Solution

58.
The MySQL clients are linked with . . . . . . . .

Answer & Solution

59.
CGI stands for . . . . . . . .

Answer & Solution

60.
There can be more than one column per table with the AUTO_INCREMENT attribute.

Answer & Solution

Read More Section(MySQL Miscellaneous)

MySQL mcq questions and answers | MySQL MCQs

51. fetchrow_hashref() returns reference to hash of row values keyed by . . . . . . . .

Answer & Solution

52. In which file are the statements entered in 'mysql' saved?

Answer & Solution

53. Suppose tbl_1 is a table consisting of 8 rows and tbl_2 is a table consisting of 6 rows, the number of combinations through which the search is performed is . . . . . . . SELECT tbl_1.i1, tbl_2.i2 FROM tbl_1 INNER JOIN tbl_2 WHERE tbl_1.i1 = tbl_2.i2;

Answer & Solution

54. Which table lists the accounts and the databases for which the privileges are provided?

Answer & Solution

55. What is the shebang line?

Answer & Solution

56. What can be used interchangeably with MYSQL_VERSION_ID?

Answer & Solution

57. The number of tables among the following for which HIGH_PRIORITY have an effect are . . . . . . . . MyISAM, MEMORY, MERGE

Answer & Solution

58. The MySQL clients are linked with . . . . . . . .

Answer & Solution

59. CGI stands for . . . . . . . .

Answer & Solution

60. There can be more than one column per table with the AUTO_INCREMENT attribute.

Answer & Solution

Read More Section(MySQL Miscellaneous)

51.
fetchrow_hashref() returns reference to hash of row values keyed by . . . . . . . .

52.
In which file are the statements entered in 'mysql' saved?

53.
Suppose tbl_1 is a table consisting of 8 rows and tbl_2 is a table consisting of 6 rows, the number of combinations through which the search is performed is . . . . . . .

`SELECT tbl_1.i1, tbl_2.i2 FROM tbl_1 INNER JOIN tbl_2 WHERE tbl_1.i1 = tbl_2.i2;`

54.
Which table lists the accounts and the databases for which the privileges are provided?

55.
What is the shebang line?

56.
What can be used interchangeably with MYSQL_VERSION_ID?

57.
The number of tables among the following for which HIGH_PRIORITY have an effect are . . . . . . . .

`MyISAM, MEMORY, MERGE`

58.
The MySQL clients are linked with . . . . . . . .

59.
CGI stands for . . . . . . . .

60.
There can be more than one column per table with the AUTO_INCREMENT attribute.