MariaDB MCQ (Quiz) : W3Schools, Tutorials Point

1 .

When the Initial release date of MariaDB?

A)

29 October 2009

B)

29 October 2008

C)

29 October 2007

D)

29 October 2006

Correct Answer : 29 October 2009

Explanation : MariaDB is a community-developed, commercially supported fork of the MySQL relational database management system (RDBMS), intended to remain free and open-source software under the GNU General Public License. Development is led by some of the original developers of MySQL, who forked it due to concerns over its acquisition by Oracle Corporation in 29 October 2009.

2 .

Who is developed MariaDB?

A)

David Axmark

B)

Allan Larsson

C)

Tim O'Reilly

D)

Michael "Monty" Widenius

Correct Answer : Michael "Monty" Widenius

Explanation :

The MariaDB project is the brainchild of Michael "Monty" Widenius, the founder of MySQL®, Monty Program Ab (now MariaDB Corporation), and a founding member of the MariaDB Foundation.

The core team consists of developers sponsored by the MariaDB Foundation, companies and individuals who are members of the Foundation, and people in the MariaDB community. MariaDB is a technocracy, and we want our core membership to reflect this.

The MariaDB Foundation's role is to be a steward of the MariaDB project. The Foundation also takes the responsibility of keeping the quality of the MariaDB project high. The MariaDB Foundation has assumed this stewardship from Monty Program Ab, which was the original driver until a foundation could be created..

Source : Mariadb

3 .

MariaDB is a fork of the MySQL?

A)

NoSQL database

B)

Relational database

C)

Personal database

D)

Centralised database

Correct Answer : Relational database

Explanation : MariaDB is a fork of the MySQL relational database management system.

4 .

Which of the following is not features of MariaDB?

A)

MariaDB offers Galera cluster technology.

B)

All of MariaDB is under GPL, LGPL, or BSD

C)

MariaDB uses a standard and popular querying language.

D)

None of the above

Correct Answer : None of the above

Explanation : All of the above is a feature of MariaDB.

5 .

What are the different types of clauses used in MariaDB?

A)

MariaDB Like Clause

B)

MariaDB Where Clause

C)

MariaDB Where Clause and MariaDB Like Clause

D)

None of the above

Correct Answer : MariaDB Where Clause and MariaDB Like Clause

Explanation : MariaDB Where Clause and MariaDB Like Clause are the different types of clauses used in MariaDB.

6 .

Which term refers to storing data twice in order to accelerate the system?

A)

Row

B)

Primary Key

C)

Redundancy

D)

Referential Integrity

Correct Answer : Redundancy

Explanation : Redundancy : This term refers to storing data twice in order to accelerate the system.

7 .

Which term refers to ensuring all foreign key values point to existing rows?

A)

Index

B)

Foreign Key

C)

Compound Key

D)

Referential Integrity

Correct Answer : Referential Integrity

Explanation : Referential Integrity : This term refers to ensuring all foreign key values point to existing rows.

8 .

What are the types of aggregate functions in MariaDB?

A)

MariaDB SUM Function

B)

MariaDB MIN Function

C)

MariaDB COUNT Function

D)

All of the above

Correct Answer : All of the above

Explanation : All of the above are the types of aggregate functions in MariaDB.

9 .

What are the types of JOIN in MariaDB?

A)

Left Join

B)

Inner Join

C)

Outer Join

D)

All of the above

Correct Answer : All of the above

Explanation : All of the above are the types of JOIN in MariaDB.

10 .

MariaDB does not support for PHP, one of the most popular web development languages.

A)

True

B)

False

C)

Can not say

D)

--

Correct Answer : False

Explanation : MariaDB offers support for PHP, one of the most popular web development languages.

11 .

How many parameter mysql_select_db command has?

A)

2

B)

3

C)

4

D)

5

Correct Answer : 2

Explanation : PHP provides the mysql_select_db function for database selection. The function uses two parameters, one optional, and returns a value of “true” on successful selection, or false on failure.

12 .

DOUBLE also known as?

A)

Real

B)

Double Precision

C)

Both (A) and (B)

D)

None of the above

Correct Answer : Both A and B

Explanation : DOUBLE (also REAL and DOUBLE PRECISION) : This data type represents normal-size, floating-point numbers of the value 0.

13 .

MariaDB does not runs on a number of operating systems and do not supports a wide variety of programming languages.

A)

True

B)

False

C)

Can not say

D)

--

Correct Answer : False

Explanation : MariaDB runs on a number of operating systems and supports a wide variety of programming languages.

14 .

Which data type represents a string object having only a single value from a list?

A)

ENUM

B)

SET

C)

TEXT

D)

VARBINARY

Correct Answer : ENUM

Explanation : ENUM : This data type represents a string object having only a single value from a list.

15 .

Which command is used Sets the current default database?

A)

db database_name

B)

maria database_name

C)

mariaDB database_name

D)

use database_name

Correct Answer : use database_name

Explanation : USE [database name] : Sets the current default database.

16 .

We can disconnect from MariaDB through?

A)

end

B)

pop

C)

break

D)

exit

Correct Answer : exit

Explanation : Disconnect from MariaDB through the exit command : mysql> exit

17 .

Which command is used to Provides table index information relating to the specified table?

A)

SHOW INDEX FROM TABLENAME

B)

SHOW INDEX FROM [table name]

C)

SHOW INDEX FROM TABLENAME [table name]

D)

SHOW INDEX TABLENAME [table name]

Correct Answer : SHOW INDEX FROM TABLENAME [table name]

Explanation : SHOW INDEX FROM TABLENAME [table name] : Provides table index information relating to the specified table.

18 .

Which parameter specifies that on a second call to mysql_connect() with identical arguments, rather than a new connection, the identifier of the current connection will be returned?

A)

user

B)

new_link

C)

server

D)

client flags

Correct Answer : new_link

Explanation : new_link : This optional parameter specifies that on a second call to mysql_connect() with identical arguments, rather than a new connection, the identifier of the current connection will be returned.

19 .

PHP provides the ___________ function for opening a database connection.

A)

mysql_connect()

B)

connect()

C)

maria_connect()

D)

mariadb_connect()

Correct Answer : mysql_connect()

Explanation :

PHP provides the mysql_connect() function for opening a database connection. It uses five optional parameters, and returns a MariaDB link identifier after a successful connection, or a false on unsuccessful connection.

connection mysql_connect(server,user,passwd,new_link,client_flag);

20 .

PHP provides the ___________ function for closing database connections.

A)

close()

B)

maria_close()

C)

mysql_close()

D)

mariadb_close()

Correct Answer : mysql_close()

Explanation :

It also provides the mysql_close() function for closing database connections, which uses a single parameter.

bool mysql_close ( resource $link_identifier );

21 .

Which data type represents integers in the signed range of -8388608 to 8388607, and the unsigned range of 0 to 16777215?

A)

INT

B)

BIGINT

C)

SMALLINT

D)

MEDIUMINT

Correct Answer : MEDIUMINT

Explanation : MEDIUMINT : This data type represents integers in the signed range of -8388608 to 8388607, and the unsigned range of 0 to 16777215.

22 .

MariaDB is a community-developed branch of the ________ database, which uses the Maria engine by default.

A)

MySQL

B)

OpenSolaris

C)

OpenOffice.org

D)

Solaris (operating system)

Correct Answer : OpenSolaris

23 .

MariaDB is a supported database in-

A)

App Planet

B)

Microsoft Azure

C)

Both (A) and (B)

D)

None of the above

Correct Answer : Microsoft Azure

24 .

Which year MariaDB 5.2 released?

A)

2013

B)

2014

C)

2015

D)

2016

Correct Answer : 2013

25 .

In_________Google tasked one of its engineers to work at the MariaDB Foundation

A)

2003

B)

2006

C)

2009

D)

2013

Correct Answer : 2013

26 .

MariaDB is a backward compatible, binary drop-in replacement of-

A)

TFSL

B)

GTFL

C)

MySQL

D)

None of the above

Correct Answer : MySQL

27 .

Maria DB is written in

A)

C

B)

C++

C)

Perl

D)

All of the above

Correct Answer : All of the above

28 .

How many types of aggregate functions in MariaDB?

A)

4

B)

5

C)

6

D)

7

Correct Answer : 5

Explanation : This section introduces you to the most commonly used MariaDB aggregate functions including avg(), count(), max(), min(), and sum().

MariaDB MCQs with Answers