Dynamic Web Page Development (3350702) MCQs

MCQs of Establishing a Database Connection and Working With Database

Showing 11 to 20 out of 33 Questions
11.

Which among the following have the maximum bytes?

(નીચેનામાંથી શેમાં મેક્સિમમ બાઇટ્સ હોય છે?)

(a)

Varchar

(b)

Char

(c)

Text type

(d)

Both Varchar and Char

Answer:

Option (c)

12.

The maximum length of the char columns is __________.

(char columns ની મેક્સિમમ length __________છે.)

(a)

 255 bytes

(b)

65, 535 bytes

(c)

256 bytes

(d)

65, 536 bytes

Answer:

Option (a)

13.

The minimum value stored by signed TINYINT is ___________.

(signed TINYINT દ્વારા સ્ટોર minimum value ___________છે.)

(a)

-256

(b)

-128

(c)

0

(d)

128

Answer:

Option (b)

14.

The NULL value also means ___________.

(NULL વેલ્યુ નો અર્થ ___________ છે.)

(a)

value equal to zero

(b)

unknown value

(c)

negative values

(d)

large value

Answer:

Option (b)

15.

If an integer column is used for the values in range 1 to 99999, the best suitable datatype is __________.

(જો integer column 1 થી 99999 રેંજના વેલ્યુ માટે વપરાય છે, તો શ્રેષ્ઠ યોગ્ય ડેટાટાઇપ __________છે.)

(a)

MEDIUMINT SIGNED

(b)

MEDIUMINT UNSIGNED

(c)

SMALLINT SIGNED

(d)

SMALLINT UNSIGNED

Answer:

Option (b)

16.

Which Numeric Data type has the largest range?

(કયા ન્યુમેરિક ડેટા ટાઇપમાં સૌથી વધુ રેંજ છે?)

(a)

Mediumint

(b)

Smallint

(c)

Int

(d)

Tinyint

Answer:

Option (c)

17.

The maximum size in bytes of a row in MySQL is __________.

(MySQL માં એક rowના બાઇટ્સમાં maximum size __________ છે.)

(a)

65534

(b)

65535

(c)

65536

(d)

65537

Answer:

Option (b)

18.

What is the default format for “Date” data type?

("date" ડેટા ટાઇપ માટે default ફોર્મેટ શું છે?)

(a)

YYYY-MM-DD

(b)

MM-YYYY-DD

(c)

DD-MM-YYYY

(d)

yy-mm-dd

Answer:

Option (a)

19.

What is the default format for “Datetime” data type?

(“Datetime” ડેટા ટાઇપ માટે default ફોર્મેટ શું છે?)

(a)

YYYY-MM-DD HH:MM:SS

(b)

MM-YYYY-DD HH:MM:SS

(c)

DD-YYYY-MM MM:HH:SS

(d)

DD-YYYY-MM MM:SS:HH

Answer:

Option (a)

20.

What is the default format for “Year” data type?

(“Year” ડેટાટાઇપ માટેનું default ફોર્મેટ શું છે?)

(a)

YYYY

(b)

YYYY-DD-MM

(c)

MM-YYYY-DD

(d)

YYYY-DD-MM

Answer:

Option (a)

Showing 11 to 20 out of 33 Questions