Improve MySQL Ability : Part-1

Improve MySQL Ability

Q. 1. ) Which statement gives you the version of MySQL?

A. SELECT VERSION();
B. SELECT();
C. SELECT VERSIONS();
D. SELECT VERS();

Q. 2. ) Select the MySQL variable to control size of HEAP table

A. max_heap_size
B. max_heap_tables_size
C. max_heap_table_size
D. max_heap_tables_sizes

Q. 3. ) select a correct REGEXP operator.

A. $ and &
B. ^ and %
C. % and &
D. None of these

Q. 4. ) select a correct option for use in Heap Table.

A. Indexes should be NOT NULL
B. index should be null
C. Option 1 and 2
D. none of these

Q. 5. ) What is the default port for MySQL Server?

A. 3305
B. 3306
C. 3307
D. 3308

Q. 6. ) Select option for in float Datatype use a byte.

A. 8
B. 16
C. 4
D. 18

Q. 7. ) Fullform of ACL in MYSQL.

A. Accent Controll Layout
B. Access Controll layout
C. Access Content List
D. Access Control List

             Previous------------------------------------------Next