Free Oracle 1z0-883 Exam Dumps Questions & Answers

A Mysql instance is running on a dedicated server. Developers access the server from the same network subnet. Users access the database through an application that is running on a separate server in a DMZ.
Which two will optimize the security of this setup?

• A.  Enabling and using SSL for connections to the Mysql database
• B.  Installing Mysql on the application server, and running the database and application on the same server
• C.  Running the server with - skip-networking specified
• D.  Disabling connections from named pipes or socket files (depending on the operating system of the server)
• E.  Starting the server with - bind- address=0.0.0.0 specified
• F.  Limiting logins to originate from the application server or the server's subnet

What is true regarding InnoDB locking?

• A.  InnoDB uses row and table-level locks, but row locks are not escalates,
• B.  InnoDB uses row-level or table-level locks depending on the number of rows affected.
• C.  InnoDB locks only those rows that are updated.
• D.  InnoDB row locks may be escalated to page or table-level locks.
• E.  InnoDB only uses row locks, not page or table-level locks,

Which two are true regarding MySQL binary and text backups?

• A.  Text backups are human-readable while binary backups are not.
• B.  Binary backups are not portable across different operating systems.
• C.  Binary backups are usually slower than text backups.
• D.  Binary backups are usually faster than text backups.

An employee cannot access the company database. You check the connection variables:
Mysql> SHOW GLOBAL VARIABLES LIKE '%connect%';

8 rows in set (0.00 sec)
A look at the user privileges shows:
GRANT... TO 'bob'@'%, example.com' WITH MAX_USER_CONNECTIONS 0; GRANT... TO 'key'@'%, example.com' WITH MAX_USER_CONNECTIONS 1; GRANT... TO 'joe'@'%, example.com' WITH MAX_USER_CONNECTIONS 50; What is a valid explanation for why one of the users is unable to connect to the database?

• A.  All users are blocked because max_user_connections is accumulated over the host account information.
• B.  Connect_timeout is too small to allow a connection to occur.
• C.  Bob has max_user_connections set to zero, which blocks all his connections
• D.  Kay is already connected elsewhere and attempting to log in again.
• E.  Joe has exceeded the max_user_connections global limit.

What are four capabilities of the mysql client program?

• A.  Displaying replication status information
• B.  Creating and dropping databases
• C.  Initiating a binary backup of the database by using the START BACKUP command
• D.  Creating, dropping, and modifying tables and indexes
• E.  Shutting down the server by using the SHUTDOWN command
• F.  Creating and administering users