databaseOnline version database knowledge by MINI YURELY CRUZ CORREA 1 In MySQL, the table with the users that exist in the system is called a a) information_schema.use b b) mysql.user c c) system.user d d) The previous answers are not correc 2 In MySQL, if we need to use foreign keys and transactions, we must use the engine a a) Blackhole b b) InnoDB c c) MyISAM d d) The previous answers are not correct 3 In MySQL, to obtain the current time (date and time), the function is used a a) CURDATE () b b) NOW () c c) TIME () d d) The previous answers are not correct 4 In the MySQL command-line client, terminating and executing a statement can be used a a) \ a b b) \ c c c) \ g d d) The previous answers are not correct 5 To shut down the MySQL server from the command line it is used a a) mysqld -u root shutdown b b) mysql -u root shutdown c c) mysqladmin -u root shutdown d d) The previous answers are not correct 6 In MySQL, how can you check the database selected by default? a a) select database (); b b) show databases; c c) use database; d ) The previous answers are not correct 7 What is the maximum length of the name of a database or table in MySQL? a a) 32 b b) 48 c c) 64 d d) The previous answers are not correct 8 To use MySQL on a computer, you need a a) A web server b b) Some type of client tool to access the database c c) A web browser d d) Perl, PHP or Java 9 In the MySQL console client, how do you cancel the execution of a command that is being entered and you do not want to execute it? a a) \ a b b) \ c c c) \ g d d) The previous answers are not correct 10 In the MySQL command-line client, terminating and executing a statement and having the results instead of columns displayed by rows is used a a) \c b b) \ d c c) \ G d d) The previous answers are not correc 11 In MySQL, to select the rows from 6 to 15 in a table, the clause is used a a) SELECT * FROM tbl LIMIT 6.15; b b) SELECT * FROM tbl LIMIT 6.10; c c) SELECT * FROM tbl LIMIT 5.10; d d) The previous answers are not correct 12 In the MySQL console client, what command is used to exit? a a) bye b b) close c c) quit d d) The previous answers are not correct 13 In MySQL, the table that contains the permissions of system users is called a a) information_schema.user_privileges b b) information_schema.user_permissions c c) mysql.user_privileges d d) mysql.user_permissions 14 In MySQL, the command is used to show the structure of a table a a) DESC b b) DESCRIBE c c) SHOW COLUMNS FROM d d) All the answers are correct 15 In MySQL, to select the database with which you want to work, the command is used a a) open b b) select c c) use d d) The previous answers are not correct
New game