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


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


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


14. We can disconnect from MariaDB through?

A. pop
B. break
C. end
D. exit

View Answer


15. PHP provides the ___________ function for closing database connections.

A. close()
B. mariadb_close()
C. mysql_close()
D. maria_close()

View Answer


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


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


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


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


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





Discussion


* You must be logged in to add comment.