MYSQL MCQ Quiz

2. How Much Character Are Allowed To Create Database Name?

• 64
• 40
• 70
• 75

3. To Use 'mysqldbcopy' Which Privileges Are Required On The Source Server?

• CREATE
• INSERT
• SELECT
• UPDATE

4. The Function 'fetchrow_hashref()' Returns Reference To Hash Of Row Values Keyed By ______________

• Row Name
• Column Name
• Table Name
• Database Name

5. Which Function Returns Reference To Array Of Row Values?

• Fetch()
• Fetchrow_array()
• Fetchrow_hashref()
• Fetchrow_arrayref()

6. Which Is The Log In Which Data Changes Received From A Replication Master Server Are Written?

• Error Log
• Binary Log
• General Query Log
• Relay Log

7. Character Data Can Be Stored As

• Either Fixed Or Variable Length String
• Fixed Length String
• Variable Length String
• None Of The Mentioned

8. Which Declaration Doesn't Use The Same Number Of Bytes And Consumption Of Bytes Depends On The Input Data?

• Varchar
• Char
• Both Varchar And Char
• None Of The Mentioned

9. The Maximum Length Of The Char Columns Is

• 65, 535 Bytes
• 256 Bytes
• 255 Bytes
• None Of The Mentioned

10. The Maximum Length Of The Varchar Columns Is

• Upto 65, 535 Bytes
• Upto 256 Bytes
• Upto 65, 567 Bytes
• None Of The Mentioned

11. Mysql Support Different Character Sets, Which Command Is Used To Display All Character Sets?

• SHOW;
• SHOW CHARACTER SET;
• CHARACTER SET;
• None Of The Mentioned

12. Which One Is The Correct Declaration For Choosing The Character Set Other Than Default?

• Varchar(20);
• Varchar(20) Character Set Utf8;
• Varchar(20) Character Set;
• None Of The Mentioned

13. Which "text Type" Has The Maximum Number Of Bytes?

• Long Text
• Medium Text
• Tiny Text
• Text

14. Which Among The Following Have The Maximum Bytes?

• Varchar
• Char
• Both Varchar And Char
• Text Type

15. The "father" Of MySQL Is ______.

• Bill Joy
• Michael Widenius
• Bill Gates
• Stephanie Wall

16. To Use MySQL On Your Computer, You'll Need

• Perl, PHP Or Java
• A Browser
• Some Sort Of Client Program To Access The Databases
• FTP And Telnet

17. The Main MySQL Program That Does All The Data Handling Is Called

• Mysql
• Mysql.exe
• Httpd
• Mysqld

18. MySQL Comes With As Standard With Client Libraries For:

• C Only
• Java Only
• Java And C
• Perl, PHP And C

19. What Kind Of Replication Is Supported By The MySQL Server?

• Multiple-master Replication
• Single File Based Clustering
• Master To Slave Replication
• MySQL Doesn't Support Replication

20. Commands Passed To The MySQL Daemon Are Written In

• English
• Swedish
• Your Choice From Perl, PHP, Java Or Some Other Languages
• The Structured Query Language

21. Which Of These Commands Will Delete A Table Called XXX If You Have Appropriate Authority:

• DROP TABLE XXX
• DELETE XXX WHERE Confirm = "YES"
• DROP XXX
• DROP XXX WHERE Confirm = "YES"

22. MySQL Runs On Which Operating Systems?

• Unix And Linux Only
• Unix, Linux, Windows And Others
• Linux And Mac OS-X Only
• Any Operating System At All

23. Which Of The Following Is NOT Supported By MySQL

• Temporary (Hash) Tables
• Table Joining
• Regular Expression Matching
• Stored Procedures

24. One Of The Early Proponents Of Relational Database Who Laid Down Many Of The Principles We Use To This Day Was:

• Xigang Koi
• Edgar Codd
• William Crawford
• Mahatma Coate

25. Which Of These Is A Valid Call To A Function (watch The Spaces Carefully!)

• CONCAT( A , B )
• CONCAT ( A , B )
• CONCAT( "A" , "B" )
• CONCAT ( "A" , "B" )

26. If You Want To Undo A GRANT, You Should Use

• REVOKE
• UNDO
• UNGRANT
• DELETE

27. How Many Distinct, Different Values Can You Hold In An Enum Field?

• 255
• 7
• 65535
• 2 (True And False)

28. Which Of The Following Is NOT Available In MySQL:

• REVOKE
• FETCH
• LIKE
• JOIN

29. The Program Called Mysql Is

• There Isn't A Program Just Called Mysql
• A Wrapper Through Which Java Clients Must Connect To The Databases
• The Database Engine
• A Client Program That Lets You Send SQL Commands To The Database Engine

30. In A LIKE Clause, You Can Ask For Any 6 Letter Value By Writing:

• LIKE .{6}
• LIKE ______ (that's Six Underscore Characters)
• LIKE ^.{6}$
• LIKE ??????

31. Which Of The Following Is Available In MySQL:

• CREATE VIEW
• CREATE SCHEMA
• CREATE TRIGGER
• CREATE DATABASE

32. Which Of These Is Not A Valid Name For A Column

• To
• From
• Far
• Near

33. Which Statement Is Used To Insert A New Data In A Database?

• INSERT NEW
• Add New
• INSERT INTO
• UPDATE

34. The SQL Keyword BETWEEN Is Used?

• To Limit The Columns Displayed
• As A Wildcard
• For Ranges
• None Of The Above

35. Which Of The Following Is An Aggregate Function In MySQL?

• LIKE
• Union
• Group By
• MAX

36. Which Command Is Used To Remove All Rows From A Table?

• Delete
• Truncate
• Remove
• Both A & B

37. What Is MySQL View?

• Virtual
• Static
• Real
• Temporary Table