Home > Information Technology (IT) Support Executive > Quizzes > Database System Assistant Practice Test: Preparation of Database Project using MySQL
Database System Assistant Practice Test: Preparation of Database Project using MySQL
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 77% Most missed: “What does Control-_ do in MySQL input editor?”
Database System Assistant Practice Test: Preparation of Database Project using MySQL
Time left 00:00
22 Questions

1. The JDBI interface is available for __________
2. On UNIX, statements entered in ‘MySQL’ are saved in which file?
3. Which of these is used during MySQL setup?
4. What loads data files into tables?
5. Which language is the core for APIs and communication in MySQL?
6. Which of these is not used to connect to the MySQL server?
7. To execute the contents of a query file ‘exec.sql’ by feeding it to mysql, which command is used?
8. What exports table definitions and contents?
9. Which option executes all SQL statements in a SQL script irrespective of the number of errors?
10. What performs administrative operations?
11. What performs administrative operations?
12. Which of these is used during MySQL setup?
13. For how many of the following do interfaces exist for implementing direct native client-server protocol - Java, PHP, Ruby ?
14. Which program reads the statement from a binary log?
15. What does Control-_ do in MySQL input editor?
16. Which of these is not used to connect to the MySQL server?
17. Suppose run_me.sh is a script file. Which command is used to make it executable?
18. For which language is the PEAR module used?
19. For which language is the engine specific interface PDO defined?
20. Which of these is not used to connect to the MySQL server?
21. Which option executes all SQL statements in a SQL script irrespective of the number of errors?
22. Which program reads the statement from a binary log?