We're so confident of our products that we provide no hassle product exchange.
Oracle MySQL 2021 Implementation Essentials Sample Questions:
1. Which two statements are true about MySQL Enterprise Firewall?
A) MySQL Enterprise Firewall is available only in MySQL Enterprise versions 5.7.10.and later.
B) Server-side plug-ins named MYSQL_FIREWALL_USERS and MYSQL_FIREWALL-WHITELIST implement INFORMATION_SCHEMA tables that provide views into the firewall data cache.
C) On Windows systems, MySQL Enterprise Firewall is controlled and managed by using the Windows Internet Connection Firewall control panel.
D) The firewall functionality is dependent upon SHA-256 and ANSI-specific functions built in to the mysql.firewall table. These functions cannot be deleted, even by the root user.
E) MySQL Enterprise Firewall shows only notifications blocked connections, which originated outside of your network's primary domain.
F) System tables named firewall_users and firewall_whitelist in the mysql database provide persistent storage of firewall data.
2. How would you restrict a user Joe from accessing all MySQL database objects?
A) UPDATE mysql.user SET Password=PASSWORD(,Invalid,) WHERE User=,joe';
B) CREATE USER ,joe'@,0.0.0.0, SET Password=PASSWORD(,% ! %,)
C) Insert Joe,s name into the mysql.user_restriction cable, and issue the FLUSH PRIVILEGES command.
D) REVOKE ALL PRIVILEGES, GRANT OPTION FROM ,joe,@,%,;
E) CREATE USER , joe,@1' %' DENY ALL PRIVILEGES
3. Which component of MySQL Enterprise Monitor provides trend analysis and capacity planning for MySQL databases?
Response:
A) MySQL Advisors
B) Query Analyzer
C) MySQL Dashboard
D) MySQL Query Analyzer
4. What SQL keyword must be specified when creating a foreign key constraint?
A) an index on the foreign key
B) unique PRIMARY key values for both child and parent tables
C) a TRIGGER on the child table for cascading delete statements
D) the SET_FOREGIN variable in the my .cnf file
E) a REFERENCES in the child table to the parent table
5. Consider this SQL statement which is using the innoDB storage engine and with global AUTOCOMMIT = 1:
What is the result after issuing the rollback command?
A) Only the t1 table is created.
B) Only the t2 table is created.
C) Both the tables, t1 and t2, are created.
D) Both the tables, t1 and t2, are not created because there is an explicit ROLLBACK.
Solutions:
| Question # 1 Answer: B,F | Question # 2 Answer: C | Question # 3 Answer: D | Question # 4 Answer: C | Question # 5 Answer: C |
By Enid
