MySQL

Q1.How does character data can be stored?

Fixed length string

None of the mentioned

Variable length string

Either Fixed or Variable length string

Q2.What is the maximum length of clear columns?

None of the mentioned

65, 535 bytes

256 bytes

255 bytes

Q3.What declaration will you use to choose the character ser other than the default one?

Varchar(20);

Varchar(20) character set;

All of the above

Varchar(20) character set utf8;

Q4.Select the program that copies the database from one server to another?

Mysqlflushdb

Mysqlcopydb

Mysqldbflush

Mysqldbcopy

Q5.Select the right length about the varchar columns.

Upto 256 bytes

One of the mentioned

Upto 65, 567 bytes

Upto 65, 535 bytes

Q6.What should be the length of the column should be in the oracle database?

Varchar

Varchar2

None of the mentioned

Varchar 3

Q7.Which of the following has the maximum number of bytes?

Text type

Varchar

Both Varchar and Char

Char

Q8.Which of the text type contains the maximum bytes?

Long text

Medium text

Text

Tiny text

Q9.Which of the following command you will use to display the character set?

None of the mentioned

SHOW;

CHARACTER SET;

SHOW CHARACTER SET;

Q10.Which of the option does not use the same number of bytes and consumption of bytes to input data?

Both Varchar and Char

Varchar

Char

None of the mentioned

Your Score

- of - questions are answered correctly

MySQL Database Development

For Support

Office Hours

We are on

Company

Customer Service

Help

Your Score

- of - questions are answered correctly

Login to view answer sheet

FORGOT PASSWORD

SIGN UP

Email Verification

MySQL Database Development

For Support

Office Hours

We are on

Company

Customer Service

Help