Q. The storage in bytes required for VARCHAR(4) type ‘abcd’ is _____________

View solution

Q. Which mode does not remove trailing spaces when CHAR values are retrieved?

View solution

Q. What is the minimum value stored by signed TINYINT?

View solution

Q. For InnoDB tables in mysqldump an online backup that takes no locks on tables can be performed by which option?

View solution

Q. What is used to reload a delimited text data file?

View solution

Q. Replication does not enable data from one MySQL database server to be copied to one or more MySQL database servers.

View solution

Q. What is SBR replication?

View solution

Q. Which is the library file that contains various portability macros and definitions?

View solution

Q. Which is the header that should be included first?

View solution

Q. Which of these has special automatic update behavior?

View solution

Q. To disallow zero month or day parts in dates, the option used is _____________

View solution

Q. The mode that does not remove trailing spaces when CHAR values are retrieved is _____________

View solution

Q. MySQL automatically converts a date or time value to a number if the value is used in a numeric context.

View solution

Q. The functions in Perl DBI called?

View solution

Q. The variable used as a handle to an open file is ______________

View solution

Q. Which variable is a handle to a database object?

View solution

Q. Which classes does spatial data types in MySQL correspond to?

View solution

Q. Which type can store a collection of objects of any type?

View solution

Q. SPATIAL indexes cannot be created on NOT NULL spatial columns.

View solution

Q. MySQL does not automatically convert a date or time value to a number if the value is used in a numeric context.

View solution