25th
Jul
MYSQL MCQ

MYSQL MCQ

  • Admin
  • 25th Jul, 2020
  • 1099 Followers

MYSQL MCQ Quiz

1) MySQL is .................

  • A. A Programming language
  • B. A technique for writing reliable programs
  • C. A Relational Database Management System
  • D. None of Above

2) Which of the following package is used for Remote Method Invocation (RMI)?

  • A. java.rmi
  • B. java.applet
  • C. java.lang.rmi
  • D. java.lang.reflect

3) How much character are allowed to create database name?

  • A. 72
  • B. 64
  • C. 55
  • D. 40

4) To use mysql on your computer you will need ................

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

5) Which "text Type" Has The Maximum Number Of Bytes?

  • A. Text
  • B. Tiny Text
  • C. Long Text
  • D. Medium Text
Download Free : MYSQL MCQ PDF

6) Which Of These Commands Will Delete A Table Called XXX If You Have Appropriate Authority?

  • A. DROP XXX
  • B. DROP TABLE XXX
  • C. DROP XXX WHERE Confirm = "YES"
  • D. DELETE XXX WHERE Confirm = "YES"

7) Which data type is more suitable for storing “small notes” in Mysql?

  • A. Char
  • B. Varchar
  • C. Longtext
  • D. Mediumtext

8) Which of the following is used to delete an entire mysql database?

  • A. mysql_drop_db
  • B. mysql_drop_dbase
  • C. mysql_drop_entiredb
  • D. mysql_drop_database

9) Which of the following method is used to change the name of a thread?

  • A. public void getName()
  • B. public String getName()
  • C. public void setName(String name)
  • D. public String setName(String name)

10) Does MySQL support the complete SQL99 standard?

  • A. Yes
  • B. No

11) Commands passed to the mysql daemon are written in ..............

  • A. Swedish
  • B. English
  • C. SQL Language
  • D. None of Above

12) Which of the following is NOT available in MySQL?

  • A. LIKE
  • B. JOIN
  • C. FETCH
  • D. REVOKE

13) The main mysql program that does all the data handling is called

  • A. Httpd
  • B. Mysql
  • C. Mysqld
  • D. Mysql.exe

14) .............. is used to find and fix bugs in the java programs.

  • A. JVM
  • B. JDK
  • C. JRE
  • D. JDB

15) What does JMS stands for?

  • A. Java Monitor Service
  • B. Java Monitor Session
  • C. Java Message Service
  • D. Java Message Session

16) MYSQL comes with as standard with client libraries for

  • A. C Only
  • B. Java And C
  • C. Java Only
  • D. Perl, PHP And C

17) MySQL runs on which operating systems?

  • A. Unix And Linux Only
  • B. Linux And Mac OS-X Only
  • C. Unix, Linux, Windows And Others
  • D. None of Above

18) Which of the following is true about mysql?

  • A. Easy to use
  • B. Scalable
  • C. High Flexibility
  • D. All of the above

19) Which of these commands will delete a table called xyz

  • A. DROP XYZ
  • B. DROP TABLE XYZ
  • C. DELETE XYZ WHERE Confirm = "YES"
  • D. DROP XYZ WHERE Confirm = "YES"

20) Which of the following is a superclass of all exception classes?

  • A. Exception
  • B. Throwable
  • C. IOException
  • D. RuntimeException

21) You are required to buy a licence for mysql if ..............

  • A. you use it for longer than 30 days
  • B. You use it on a publicly accessible site
  • C. You incorporate it into a product that you sell
  • D. You are never required to buy a license

22) Which of these field types would be best to hold a .jpg image?

  • A. text
  • B. blob
  • C. nchar binary
  • D. char binary

23) What is the return type of the hashcode() method in the object class?

  • A. int
  • B. long
  • C. void
  • D. Object

24) The program called mysql is ................

  • A. The Database Engine
  • B. There Isn't A Program Just Called Mysql
  • C. A Client Program That Lets You Send SQL Commands To The Database Engine
  • D. None of Above

25) Which of these is not a valid name for a column?

  • A. To
  • B. Far
  • C. From
  • D. Near

26) Which of the following is available in mysql?

  • A. CREATE VIEW
  • B. CREATE TRIGGER
  • C. CREATE SCHEMA
  • D. CREATE DATABASE

27) Which of the following is not supported by mysql?

  • A. Table Joining
  • B. Stored Procedures
  • C. Temporary (Hash) Tables
  • D. Regular Expression Matching

28) Which of the following services are provided to EJB components by the EJB container?

  • A. Naming support
  • B. Transaction support
  • C. Persistence support
  • D. All of the above

29) Is Java Virtual Machine platform independent?

  • A. Yes
  • B. No

30) Which one is the correct declaration for choosing the character set other than default?

  • A. Varchar(20);
  • B. Varchar(20) Character Set;
  • C. Varchar(20) Character Set Utf8;
  • D. None of Above

31) Which of the following is a valid long literal?

  • A. 904423
  • B. L990023
  • C. ABH8097
  • D. 0xnf029L

32) An attempt to add null key to a TreeMap will result in .............

  • A. Error
  • B. Compile time Exception
  • C. Runtime - NullPointerException
  • D. None of These

33) Which of the following data type value is returned by all transcendental math functions?

  • A. int
  • B. float
  • C. long
  • D. double

34) “Numeric Data” is used to store ____________

  • A. Whole numbers
  • B. Natural numbers
  • C. Rational numbers
  • D. Both Whole and Natural numbers

35) In a like clause, you can ask for any 6 letter value by writing

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

36) Which among the following have the maximum bytes?

  • A. Char
  • B. Text Type
  • C. Varchar
  • D. Both Varchar And Char

37) What kind of replication is supported by the mysql server?

  • A. Multiple-master Replication
  • B. Single File Based Clustering
  • C. Master To Slave Replication
  • D. MySQL Doesn't Support Replication

38) The maximum length of the char columns is .................

  • A. 256 Bytes
  • B. 255 Bytes
  • C. 65, 535 Bytes
  • D. None of Above

39) The father of mysql is ...........

  • A. Bill Joy
  • B. Bill Gates
  • C. Stephanie Wall
  • D. Michael Widenius

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

  • A. Char
  • B. Varchar
  • C. Both Varchar And Char
  • D. None of Above

41) How many reserved keywords are currently defined in the Java language?

  • A. 49
  • B. 50
  • C. 47
  • D. 48

42) If you want to undo a grant you should use ............

  • A. UNDO
  • B. REVOKE
  • C. DELETE
  • D. UNGRANT

43) Which of the following is not a Java features?

  • A. Dynamic
  • B. Object-oriented
  • C. Use of pointers
  • D. Architecture Neutral

44) Which method of object class can clone an object?

  • A. copy()
  • B. Clone()
  • C. Objectclone()
  • D. Objectcopy()

Leave A Comment :

Valid name is required.

Valid name is required.

Valid email id is required.

Related MCQ/Quiz

01st
Dec
Laravel MCQ
01st
Dec
React JS MCQ
01st
Jan
AngularJs MCQ
01st
Jul
Node js MCQ
01st
Jul
Angular 2 MCQ
01st
Jul
JSON MCQ