Improve Your MySQL Ability : Part-4

Q. 22. ) How much storage space does DATETIME require?

A. 4 bytes
B. 2 bytes
C. 8 bytes
D. 1 bytes

Q. 23. ) Can I call a trigger directly from an application?

A. Yes
B. No

Q. 24. ) recorAn outer join requires each record in the two joined tables to have a matching record.

A. True
B. Falsee

Q. 25. ) –i-am-a-dummy flag is used Makes the MySQL engine refuse UPDATE and which other command?

A. WHERE
B. INSERT
C. DELETE
D. TRUNCATE

Q. 26. ) Which is the default order of sort in ORDER BY clause?

A. Ascending
B. Descending

Q. 27. ) Can DISTINCT command be used for more than one column?

A. No
B. Yes

Q. 28. ) On executing DELETE command, if you get an error "foreign key constraint"- what does it imply?

A. Foreign key not defined
B. Table is empty
A. Connectivity issue
B. Data is present in the other table

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

Improve Your MySQL Ability : Part-3

Improve Your MySQL Ability

Q. 15. ) Is Mysql query has LETTERCASE?

A. YES
B. NO

Q. 16. ) What is a candidate key?

A. Used to uniquely identify a row
B. Alias for primary key
C. Used to identify a column
D. Alias for foreign key

Q. 17. ) If an ENUM column is declared NOT NULL, its default value is the first element of the list of allowed values.

A. True
B. False, ENUM column cannot be null
C. False, its default value is the last element of the list of allowed values
D. False

Q. 18. ) Can I define multiple unique constraints on a table?

A. Yes
B. No

Q. 19. ) A view is nothing but a ________ table or a stored query

A. Dynamic
B. Real
C. Virtual
D. Static

Q. 20. ) BLOB data type can have default column value.

A. True
B. False

Q. 21. ) User() function returns the current users user name and ___________

A. password
B. host name
C. both a and b above
D. database name associated with the user

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

Improve Your MySQL Ability : Part-2

Improve Your MySQL Ability

Q. 8. ) which types are the nonstandard string types?

A. Text
B. Varchar
C. Smalltext
D. none Of these

Q. 9. ) How many columns can be used for creating Index?

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

Q. 10. ) What are the use for primary key?

A. Two primary key use in atable
B. only one primary key in a table
C. Not NulL
D. none

Q. 11. ) In Bellow options Which Drivers are use in MySQL?

A. Java Drivers
B. C Drivers
C. Option 1 and 2
D. PHP Drivers

Q. 12. ) Number of bytes in Double Datatype

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

Q. 13. ) In Bellow option Which fields are not allowed in Heap Tables.

A. char or varchar
B. Double or Float
C. BLOB or TEXT
D. INT

Q. 14. ) Which object are created using CREATE statement in MySQL?

A. Database
B. Class
C. Row
D. object

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

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