Free Oracle 1Z0-922 Exam Dumps Questions & Answers

Which SQL keyword is used to combine rows from two or more tables based on a related column between them?

• A.UNION
• B.CONCAT
• C.INTERSECT
• D.JOIN

Which command is used to restart the MySQL server on a Linux system?

• A.service mysqld restart
• B.systemctl restart mysql-server
• C.mysql restart
• D.systemctl restart mysqld

Which MySQL Enterprise tool provides real-time protection against SQL-based attacks such as SQL injection?

• A.MySQL Performance Schema
• B.MySQL Enterprise Authentication
• C.MySQL Enterprise Backup
• D.MySQL Enterprise Firewall

Which of the following does MySQL Enterprise Firewall provide?

• A.Automatic database failover
• B.High availability and load balancing
• C.Real-time database query blocking
• D.Database backup scheduling

Which of the following best describes the difference between logical and physical backups in MySQL?

• A.Logical backups export data as SQL statements, while physical backups copy the actual data files
• B.Logical backups are faster, but physical backups are more space-efficient Logical backups are
• C.required for MyISAM, while physical backups are required for InnoDB
• D.Logical backups copy the actual data files, while physical backups export data as SQL statements