MySQL mcq questions and answers | MySQL MCQs Page-9 section-9

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

81.
What are PHP variables preceded by?

A. _

B. @

C. $

D. &

Answer & Solution Discuss in Board Save for Later

82.
When the security context enables carefully written stored programs to be set up that provide controlled access to tables for users, it is called . . . . . . . .

A. good

B. bad

C. illegal

D. fare

Answer & Solution Discuss in Board Save for Later

83.
INT3 maps to MySQL type . . . . . . . .

A. TINYINT

B. SMALLINT

C. MEDIUMINT

D. BIGINT

Answer & Solution Discuss in Board Save for Later

84.
Which "text type" has the maximum number of bytes?

A. Tiny text

B. Text

C. Medium text

D. Long text

Answer & Solution Discuss in Board Save for Later

85.

What does 'name' represent in the following SQL code snippet?

CREATE TABLE student
(
    name CHAR(30),
    roll_num INT,
    address CHAR(30),
    phone CHAR(12)
);

A. A table

B. A row

C. A column

D. An object

Answer & Solution Discuss in Board Save for Later

86.
Which of these is used during MySQL setup?

A. mysqld_multi

B. mysql.server

C. mysqld_safe

D. comp_err

Answer & Solution Discuss in Board Save for Later

87.
Which clause is used to display information that matches a given pattern?

A. WHERE

B. IS

C. SAME

D. LIKE

Answer & Solution Discuss in Board Save for Later

88.

Find the error in the following SQL statement?

SELECT *;

A. No Error

B. No table mentioned

C. Depends

D. None of the mentioned

Answer & Solution Discuss in Board Save for Later

89.
Is duplicate entry of other attributes are allowed in SQL?

A. Yes

B. No

C. Depends

D. None of the mentioned

Answer & Solution Discuss in Board Save for Later

90.
What is defined to execute when the table is modified only?

A. Stored functions

B. Stored procedures

C. Triggers

D. Events

Answer & Solution Discuss in Board Save for Later

1 2 3 4 5 6 7 8 9 10

81.
What are PHP variables preceded by?

Answer & Solution

82.
When the security context enables carefully written stored programs to be set up that provide controlled access to tables for users, it is called . . . . . . . .

Answer & Solution

83.
INT3 maps to MySQL type . . . . . . . .

Answer & Solution

84.
Which "text type" has the maximum number of bytes?

Answer & Solution

85.
What does 'name' represent in the following SQL code snippet?

`CREATE TABLE student ( name CHAR(30), roll_num INT, address CHAR(30), phone CHAR(12) );`

Answer & Solution

86.
Which of these is used during MySQL setup?

Answer & Solution

87.
Which clause is used to display information that matches a given pattern?

Answer & Solution

88.
Find the error in the following SQL statement?

`SELECT *;`

Answer & Solution

89.
Is duplicate entry of other attributes are allowed in SQL?

Answer & Solution

90.
What is defined to execute when the table is modified only?

Answer & Solution

Read More Section(MySQL Miscellaneous)

MySQL mcq questions and answers | MySQL MCQs

81. What are PHP variables preceded by?

Answer & Solution

82. When the security context enables carefully written stored programs to be set up that provide controlled access to tables for users, it is called . . . . . . . .

Answer & Solution

83. INT3 maps to MySQL type . . . . . . . .

Answer & Solution

84. Which "text type" has the maximum number of bytes?

Answer & Solution

85. What does 'name' represent in the following SQL code snippet? CREATE TABLE student ( name CHAR(30), roll_num INT, address CHAR(30), phone CHAR(12) );

Answer & Solution

86. Which of these is used during MySQL setup?

Answer & Solution

87. Which clause is used to display information that matches a given pattern?

Answer & Solution

88. Find the error in the following SQL statement? SELECT *;

Answer & Solution

89. Is duplicate entry of other attributes are allowed in SQL?

Answer & Solution

90. What is defined to execute when the table is modified only?

Answer & Solution

Read More Section(MySQL Miscellaneous)

81.
What are PHP variables preceded by?

82.
When the security context enables carefully written stored programs to be set up that provide controlled access to tables for users, it is called . . . . . . . .

83.
INT3 maps to MySQL type . . . . . . . .

84.
Which "text type" has the maximum number of bytes?

85.
What does 'name' represent in the following SQL code snippet?

`CREATE TABLE student ( name CHAR(30), roll_num INT, address CHAR(30), phone CHAR(12) );`

86.
Which of these is used during MySQL setup?

87.
Which clause is used to display information that matches a given pattern?

88.
Find the error in the following SQL statement?

`SELECT *;`

89.
Is duplicate entry of other attributes are allowed in SQL?

90.
What is defined to execute when the table is modified only?