New Activity
Ico create Educaplay New Activity
All the activities
Play Quiz
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