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. 4)

  • 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 #16
What are four capabilities of the mysql client program?
  1. A
    Creating and dropping databases
  2. B
    Creating, dropping, and modifying tables and indexes
  3. C
    Shutting down the server by using the SHUTDOWN command
  4. D
    Creating and administering users
  5. E
    Displaying replication status information
  6. F
    Initiating a binary backup of the database by using the START BACKUP command

Correct Answer:
ABCDE

Question #17
Assume that you want to know which Mysql Server options were set to custom values.
Which two methods would you use to find out?
  1. A
    Check the configuration files in the order in which they are read by the Mysql Server and compare them with default values.
  2. B
    Check the command-line options provided for the Mysql Server and compare them with default values.
  3. C
    Check the output of SHOW GLOBAL VARIABLES and compare it with default values.
  4. D
    Query the INFORMATION_SCHEMA.GLOBAL_VARIABLES table and compare the result with default values.

Correct Answer:
CD

Question #18
You install a copy of Mysql 5.6.13 on a brand new Linux server by using RPM packages. The server starts successfully as verified by the following commands:
$ pidof mysqld
3132
$tail - n2 /var/lib.mysql/hostname.err
2013-08-18 08:18:38 3132 [Note] /usr/sbin/mysqld: ready for connections.
Version: 5.6.13-enterprise-commercial-advaced socket: /tmp/mysql.sock port;
3306 Mysql Enterprise Server Advanced Edition (Commercial)
You attempt to log in as the root user with the following command:
$mysql u root
ERROR 1045 (28000): Access denied for user root@localhost (using password: NO)
Which statement is true about this scenario?
  1. A
    The RPM installation script sets a default password of password for new installations.
  2. B
    The local root user must log in with a blank password initially: mysql –u root –p.
  3. C
    New security measures mean that the mysql_secure_installation script must be run first on all new installations.
  4. D
    The mysql_install_bd post-installation script used – random-password.

Correct Answer:
B

Question #19
A Mysql Server has been running an existing application successfully for six months.
The my.cnf is adjusted to contain the following additional configuration:
[mysqld]
Default-authentication-plugin=sha256_password
The Mysql Server is restarted without error.
What effect will the new configuration have in existing accounts?
  1. A
    They will have their passwords updated on start-up to sha256_password format.
  2. B
    They will have to change their password the next time they login to the server.
  3. C
    They are not affected by this configuration change.
  4. D
    They all connect via the secure sha256_password algorithm without any configuration change.

Correct Answer:
D
Reference:
http://dev.mysql.com/doc/refman/5.6/en/sha256-authentication-plugin.html

Question #20
In a design situation, there are multiple character sets that can properly encode your data.
Which three should influence your choice of character set?
  1. A
    Disk usage when storing data
  2. B
    Syntax when writing queries involving JOINS
  3. C
    Comparing the encoded data with similar columns on other tables
  4. D
    Memory usage when working with the data
  5. E
    Character set mapping index hash size

Correct Answer:
CDE

Previous Questions Next Questions

All Pages