MariaDB Questions and Answers
11. Which term refers to storing data twice in order to accelerate the system?
A. Redundancy
B. Row
C. Primary Key
D. Referential Integrity
View Answer
Ans : A
Explanation: Redundancy : This term refers to storing data twice in order to accelerate the system.
12. Which term refers to ensuring all foreign key values point to existing rows?
A. Compound Key
B. Referential Integrity
C. Foreign Key
D. Index
View Answer
Ans : B
Explanation: Referential Integrity : This term refers to ensuring all foreign key values point to existing rows.
13. Which command is used Sets the current default database?
A. db database_name
B. maria database_name
C. use database_name
D. mariaDB database_name
View Answer
Ans : C
Explanation: USE [database name] : Sets the current default database.
14. We can disconnect from MariaDB through?
A. pop
B. break
C. end
D. exit
View Answer
Ans : D
Explanation: Disconnect from MariaDB through the exit command : mysql> exit
15. PHP provides the ___________ function for closing database connections.
A. close()
B. mariadb_close()
C. mysql_close()
D. maria_close()
View Answer
Ans : C
Explanation: It also provides the mysql_close() function for closing database connections, which uses a single parameter.
bool mysql_close ( resource $link_identifier );
16. Which data type represents integers in the signed range of -8388608 to 8388607, and the unsigned range of 0 to 16777215?
A. SMALLINT
B. MEDIUMINT
C. INT
D. BIGINT
View Answer
Ans : B
Explanation: MEDIUMINT : This data type represents integers in the signed range of -8388608 to 8388607, and the unsigned range of 0 to 16777215.
17. Which data type represents a string object having only a single value from a list?
A. ENUM
B. SET
C. TEXT
D. VARBINARY
View Answer
Ans : A
Explanation: ENUM : This data type represents a string object having only a single value from a list.
18. 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 be true or false
D. Can not say
View Answer
Ans : B
Explanation: MariaDB runs on a number of operating systems and supports a wide variety of programming languages.
19. What are the types of JOIN in MariaDB?
A. Inner Join
B. Outer Join
C. Left Join
D. All of the above
View Answer
Ans : D
Explanation: All of the above are the types of JOIN in MariaDB.
20. What are the types of aggregate functions in MariaDB?
A. MariaDB COUNT Function
B. MariaDB SUM Function
C. MariaDB MIN Function
D. All of the above
View Answer
Ans : D
Explanation: All of the above are the types of aggregate functions in MariaDB.
Discussion