Online Access Free 1z1-883 Practice Test

Consider the following statement on a RANGE partitioned table:
ALTER TABLE orders DROP PARTITION p1, p3;
What is the outcome of executing the above statement?

• A.A syntax error will result as you cannot specify more than one partition in the same statement.
• B.All data in pi and p3 partitions are removed and the table definition is changed.
• C.All data in p1 and p3 partitions are removed, but the table definition remains unchanged.
• D.Only the first partition (p1) will be dropped as only one can be dropped at any time.

User A issues the command:
LOCK TABLES pets READ;
Which command can User B execute against the pets table?

• A.INSERT INTO pets...
• B.SELECT....FROM pets
• C.ALTER TABLE pets...
• D.UPDATE pets...

When designing an InnoDB table, identify an advantage of using the BIT datatype Instead of one of the integer datatypes.

• A.BIT (8) takes less space than eight TINYINT fields.
• B.Multiple BIT columns pack tightly into a row, using less space.
• C.The BIT columns can be manipulated with the bitwise operators &, |, ~, ^, <<, and >>. The other integer types cannot.
• D.BIT columns are written by InnoDB at the head of the row, meaning they are always the first to be retrieved.

What are three methods to reduce Mysql server exposure to remote connections?

• A.Setting specific GRANT privilege to limit remote authentication
• B.Setting - mysql_secure_configuration to enable paranoid mode
• C.Setting -- skip-networking when remote connections are not required
• D.Using the sql_mode=STRICT_SECURE after connections are established for encrypted communications
• E.Using SSL when transporting data over remote networks

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.Limiting logins to originate from the application server or the server's subnet
• C.Running the server with - skip-networking specified
• D.Starting the server with - bind- address=0.0.0.0 specified
• E.Disabling connections from named pipes or socket files (depending on the operating system of the server)
• F.Installing Mysql on the application server, and running the database and application on the same server