Free Oracle 1z1-908 Exam Dumps Questions & Answers

A MySQL server is monitored using MySQL Enterprise Monitor's agentless installation.
Which three features are available with this installation method? (Choose three.)

• A.MySQL Query Analysis data
• B.network-related information and network characteristics
• C.MySQL Replication monitoring
• D.CPU utilization
• E.disk usage and disk characteristics including disk advisors warnings
• F.security-related advisor warnings
• G.operating system memory utilization

Which two storage engines provide a view of the data consistent with the storage system at any moment?
(Choose two.)

• A.NDB
• B.MyISAM
• C.MEMORY
• D.InnoDB
• E.ARCHIVE

On examination, your MySQL installation datadir has become recursively world read/write/executable.
What are two major concerns of running an installation with incorrect file privileges? (Choose two.)

• A.MySQL binaries could be damaged, deleted, or altered.
• B.Users could overwrite configuration files.
• C.SQL injections could be used to insert bad data into the database.
• D.Data files could be deleted.
• E.Extra startup time would be required for the MySQL server to reset the privileges.

How can mysql_multi be configured to allow MySQL instances to use the same port number?

• A.The instances use different user accounts unique to each instance.
• B.The instances have appropriate net masks set.
• C.The instances listen on different IP addresses.
• D.The instances use different socket names.

Which two are contained in the InnoDB system tablespace (ibdata1) by default? (Chose two.)

• A.change buffer
• B.user privileges
• C.primary indexes
• D.doublewrite buffer
• E.InnoDB Data Dictionary
• F.table data