Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home Oracle 1z0-883

Oracle 1z0-883 Exam Practice Questions (P. 5)

  • Full Access (100 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
Question #21
What are three actions performed by the mysql_secure_installation tool?
  1. A
    It prompts you to set the root user account password.
  2. B
    It checks whether file permissions are appropriate within datadir.
  3. C
    It asks to remove the test database, which is generated at installation time.
  4. D
    It can delete any anonymous accounts.
  5. E
    It verifies that all users are configuration with the longer password hash.

Correct Answer:
ACD
Reference:
http://prefetch.net/blog/index.php/2006/06/18/securing-mysql-installations-with-mysql_secure_installation/

Question #22
Consider the query:
Mysql> SET @run = 15;
Mysql> EXPLAIN SELECT objective, stage, COUNT (stage)

FROM iteminformation -
WHERE run=@run AND objective=7.1

GROUP BY objective,stage -
ORDER BY stage;

The iteminformation table has the following indexes;
Mysql> SHOW INDEXES FROM iteminformation:

This query is run several times in an application with different values in the WHERE clause in a growing data set.
What is the primary improvement that can be made for this scenario?
  1. A
    Execute the run_2 index because it has caused a conflict in the choice of key for this query.
  2. B
    Drop the run_2 index because it has caused a conflict in the choice of key for this query.
  3. C
    Do not pass a user variable in the WHERE clause because it limits the ability of the optimizer to use indexes.
  4. D
    Add an index on the objective column so that is can be used in both the WHERE and GROUP BY operations.
  5. E
    Add a composite index on (run,objective,stage) to allow the query to fully utilize an index.

Correct Answer:
B

Question #23
Consider typical High Availability (HA) solutions that do not use shared storage.
Which three HA solutions do not use shared storage?
  1. A
    Mysql Replication
  2. B
    Distributed Replicated Block Device (DRBD) and Mysql
  3. C
    Windows Cluster and Mysql
  4. D
    Solaris Cluster and Mysql
  5. E
    Mysql NDB Cluster

Correct Answer:
ABE

Question #24
Which three statements are characteristic of the MEMORY storage engine?
  1. A
    Each table is represented on disk as an.frm file.
  2. B
    Each table has a corresponding.MYI and .MYD file.
  3. C
    It can support foreign keys.
  4. D
    It cannot contain text or BLOB columns.
  5. E
    Table contents are not saved if the server is restarted.
  6. F
    It can support transactions

Correct Answer:
ADE

Question #25
Consider the Mysql Enterprise Audit plugin.
The following event detail is found in the audit log:
<AUDIT_RECORD
TIMESTAMP="2013-04-09t01:54:17"
NAME="Connect"
CONNECTION_ID="3"
STATUS="1045"
USER="kate"
PROXY_USER=""
HOST="localhost"
IP=""
DB=""/>
Which two points can be concluded from the given event?
  1. A
    A connection was blocked by a firewall or a similar security mechanism.
  2. B
    A connection was attempted via socket rather than TCP.
  3. C
    A connection failed because the proxy user privileges did not match the login user.
  4. D
    A connection as the user kate was successful.
  5. E
    A connection failed due to authentication being unsuccessful.

Correct Answer:
BE
B: <IP>
A string representing the client IP address. This element appears only if the <NAME> value is Connect, Change user, or Query.
Example:
<IP>127.0.0.1</IP>
E: ERROR 1045 (28000): Access denied for user

Previous Questions Next Questions

All Pages