Trinity - MySQL SERVER Interview Preparation Questions
Call
whatsapp
9447387064 | 9847003556
0471-2335855 | 8089080088 | 0471-2334855
9447387064 | 9847003556
0471-2335855 | 8089080088 | 0471-2334855
Cisco Training in Trivandrum, Trinity Technologies

No.1 Training Institute in Kerala

MySQL QUESTIONS : PART 1

Which declaration represents that “character data will consume the same number of bytes as declared and is right padded”?

Char

Varchar

Boolean

SHOW ANSWER

The maximum length of the char columns is

255 bytes

65, 535 bytes

256 bytes

SHOW ANSWER

 The maximum length of the varchar columns is

Upto 65, 535 bytes

Upto 256 bytes

Upto 65, 567 bytes

SHOW ANSWER

Which “text type” has the maximum number of bytes?

Tiny text

Text

Medium text

Long text

SHOW ANSWER

Which among the following have the maximum bytes?

Text type

Varchar

Char

SHOW ANSWER

In MySQL, identifier names can start with a digit.

True

False

SHOW ANSWER

 What is the maximum length for alias names in terms of characters?

64

128

256

SHOW ANSWER

What does a fully qualified table name consist of?

only the table name

only the database name

table name followed by database name

database name followed by table name

SHOW ANSWER

Input can be validated in MySQL programs.

True

False

SHOW ANSWER

Which type of database management system is MySQL?

Object-oriented

Hierarchical

Relational

Network

SHOW ANSWER

What is data in a MySQL database organized into?

Objects

 Tables

 Networks

File systems

SHOW ANSWER

MySQL is freely available and is open source

True

False

SHOW ANSWER

What represents an ‘attribute’ in a relational database?

Table

Row

Column

Object

SHOW ANSWER
BACK | NEXT
TRINITY SOFTWARE SOLUTIONS,IInd floor, Radheyam Towers, Gandhari Amman Kovil Road, Pulimood, Trivandrum - 1
0471-2334855 | 2335855 | 9447387064 | 9847003556 info@trinitytechnology.in