Oracle-MySQL 5 Database Administrator Certified Professional Exam, Part II Set 3

Question - 15 Maximum mark : - 28

Home
All Exams
Oracle-MySQL 5 Database Administrator Certified Professional Exam, Part II Online Mock Tests
Oracle-MySQL 5 Database Administrator Certified Professional Exam, Part II Set 3

What will be the effect of executing the following statement? REVOKE ALL PRIVILEGES FROM 'web'@'localhost'

The account 'web'@'localhost' will have all privileges removed, and the account deleted from the server. ✘ The account 'web'@'localhost' will no longer be usable for login, but since there is no ONclause, privileges are retained for re-enabling the account at a later time. ✘ The account 'web'@'localhost' will lose all privileges except for USAGE ✘ Nothing. A REVOKE statment without an ON clause is invalid ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

The account 'ulf'@'localhost' has previously been created with the statement GRANT ALL PRIVILEGES ON *.* TO 'ulf'@'localhost' IDENTIFIED BY 'w01f' This account should no longer be used, so you issue the following command: REVOKE ALL PRIVILEGES ON *.* FROM 'ulf'@'localhost' After executing this statement, you inspect the server and find that no clients are connected using that account. However, the next day you notice that the account 'ulf'@'localhost' is indeed connected to the server. Why is it still possible for the account 'ulf'@'localhost' to connect to the server?

Specifying GRANT ALL PRIVILEGES ON *.* effectively created an administrator account, which cannot be disabled through the REVOKE statement ✘ The REVOKE statement used does not remove the USAGE privilege from the account,allowing new connections with that account. ✘ The REVOKE command was not followed by a FLUSH PRIVILEGES command, so theaccount was never actually disabled ✘ The ON *.* clause should not be specified when disabling an account ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Which of the following best describes how the relay log works?

It records the times when the slave connects to the master. ✘ When a slave receives a change from the master, it is recorded in the relay log first andprocessed later. ✘ When a slave receives a change from the master, it is processed first and then recorded inthe relay log. ✘

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

With replication, what on the master is used to send commands to the slave?

The relay log. ✘ The binary log. ✘ The SQL Thread. ✘

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

To prevent users from seeing the password used for FEDERATED tables, you should...

Not grant them privileges to execute SHOW CREATE TABLE for this table. Not grant them privileges to execute SHOW CONNECTION for this table. Not grant them privileges to execute SHOW TABLE STATUS for this table. Not grant them privileges to execute SHOW CONNECTION STRING for this table.

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

The optimizer uses the primary key column ID to read the index values, then uses the index on Population to filter the results. The optimizer will always choose to use a unique index first, then use a secondary index if available. ✘ The optimizer uses the index on the Population column to search and filter the WHEREclause. A temporary table is used to perform a filesort on the results, and then only 5 records are returned to the client. ✘ The optimizer uses the index on the Population column to search, filter and sort thePopulation column, then returns 5 records to the client. The optimizer does not need to read the data rows, and can return values from the index only, because the index contains just integer values that form a leftmost prefix for the key. ✘ The optimizer uses the index on the Population column to search, filter and sort thePopulation column, and returns 5 records to the client. The optimizer does not need to read the data rows, and can return values from the index only because only those columns where specified in the SELECT statement. ✔ The optimizer will never read data from disk, since MySQL caches both data and index in thekey buffer. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Which of the following best describe how access control occurs in MySQL?

On login, the username, hostname and password are checked to allow access. On every query execution, username, hostname and current object access permissions are checked. ✘ On login, the username, hostname and password are checked to allow access. On everyquery execution, username, hostname, password and current object access permissions are checked. ✘ On login, the username, hostname and password are checked to allow access and the objectaccess permissions at login time are used for all subsequent operations for the lifetime of the connection. ✘

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

The password for the existing user 'kofi'@'agric.comp1.com' must be changed to "Sakila". Which of the following will do that?

SET PASSWORD FOR 'kofi'@'agric.comp1.com' = 'Sakila' ✘ SET PASSWORD 'Sakila' FOR 'kofi'@'agric.comp1.com' ✘ SET PASSWORD FOR 'kofi'@'agric.comp1.com' = PASSWORD('Sakila') ✘ SET PASSWORD('Sakila') FOR 'kofi'@'agric.comp1.com' ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

As an administrator, you attempt to create the account 'joe'@'example.com' with the following statement: GRANT SELECT, UPDATE, DELETE ON world.* TO 'joe'@'example.com' Which of the following best describe the effects of issuing this statement?

The account is not created, as you must always specify a password for new users ✘ Depending on active SQL modes, you may be prevented from creating the account becauseno password is specified. Otherwise, an account with no password is created. ✘ An account with no password is created, regardless of SQL modes. The password will notneed to be set at a later time. ✘ Since no password is specified, the account is created with an empty password that must bechanged by the user on first login ✔ There is not enough information provided to determine the outcome of executing thatstatement. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

10.

Which of the following steps are used to create database symbolic links on Windows?

Stop the server. Restart the server. Create a file in the data directory with the database name with an extension of .sym thatcontains the full path to the new location. Update your my.ini with the path to the new location. Move the database directory from the data directory to a new location.

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Prev Next

Congratulations

you have successfully completed the test

Back to Question View Result

Detail Form

We will send your result on your email id and phone no. please fill detail

Name

Email ID Note: Report will be send to the above Email ID

Phone No

Oracle-MySQL 5 Database Administrator Certified Professional Exam, Part II Set 3

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner