1. How many types of aggregate functions in MariaDB?
A) 3
B) 5
C) 7
D) 9
Correct Answer: 5
Explanation : There are 5 types of aggregate functions in MariaDB. Which are: MIN, MAX, COUNT, SUM, and AVG.
2. Maria DB is founded in the year of 2009.
A) True
B) False
Correct Answer: True
3. Maria DB is a Open Source Project and New replacement of MySql.
A) True
B) False
Correct Answer: True
4. Maria DB is written in
A) C++
B) C
C) Perl
D) All of the above
Correct Answer: All of the above
Explanation : Maria DB is written in C, C++ and perl.
5. DOUBLE also known as?
A) Real
B) Double Precision
C) Both A and B
D) Nor A and Nor B
Correct Answer: Both A and B
6. What are the different types of clauses used in MariaDB?
A) MariaDB Like Clause
B) MariaDB Where Clause
C) Both A and B
D) None of the above
Correct Answer: Both A and B
7. What are the types of JOIN in MariaDB?
A) Inner Join and Outer Join
B) Left Join and Right Join
C) Both a and b
D) None of the above
Correct Answer: Both a and b
Explanation : Inner Join, Outer Join, Right Join and Left Join are the types of JOIN in MariaDB.
8. MariaDB is a community-developed branch of the OpenSolaris database, which uses the Maria engine by default.
A) True
B) False
Correct Answer: True
9. In MariaDB, the SELECT statement can be used with_________ statement.
A) Union
B) Deadlock
C) Isolation
D) Schema
Correct Answer: Union
Explanation : In MariaDB, the SELECT is used to retrieve rows selected from one or more tables, and can include UNION statements and subqueries.
10. Course(course_id,sec_id,semester)Here the course_id,sec_id and semester are __________ and course is a _________
A) Relations, Attribute
B) Attributes, Relation
C) Tuple, Relation
D) Tuple, Attributes
Correct Answer: Attributes, Relation
11. Maria DB is founded in the year of
A) 2007
B) 2009
C) 2011
D) 2013
Correct Answer: 2009
12. A table must have _____ ?
A) Primary key
B) Composite key
C) Secondary key
D) Sort key
Correct Answer: Primary key
Explanation : A table must have Primary key.
13. Not applicable condition can be represented in relation entry as
A) NA
B) 0
C) NULL
D) Blank Space
Correct Answer: NULL
Explanation : Not applicable condition can be represented in relation entry as NULL .
14. SELECT * FROM employee What type of statement is this?
A) DDL
B) DML
C) View
D) Integrity Constraint
Correct Answer: DML
Explanation : DML stands for data manipulation language.