1Z0-883 | Down to date Oracle 1Z0-883 practice test


Q21. In a design situation, there are multiple character sets that can properly encode your data. Which three should influence your choice of character set? 

A. Disk usage when storing data 

B. Syntax when writing queries involving JOINS 

C. Comparing the encoded data with similar columns on other tables 

D. Memory usage when working with the data 

E. Character set mapping index hash size 

Answer: C,D,E 

Q22. When backing up a replication slave, which three should also be backed up in addition to data? 

A. The master.info and relay.info files 

B. The relay log files 

C. The relay index file 

D. Mysql.slave_master_info table 

E. Mysql.slave_relay_log_info table 

F. Mysql.slave_worker_info table 

Answer: A,B,E 

Reference: http://dev.mysql.com/doc/refman/5.0/en/replication-solutions-backups-rawdata.html 

Q23. The validate_password plugin is loaded and displays the following settings in global variables: 

Mysql> SHOW VARIABLES LIKE ‘validate_password%’; 

When attempting to set your password, you get the following error: 

Mysql> SET PASSWORD = PASSWORD (‘Hoverl@%’); 

ERROR 1819 (HY000): Your password does not satisfy the current policy requirements 

What is the cause of the error? 

A. The password is eight characters long, but needs to exceed validate_password_length to be valid. 

B. All of the MEDIUM password policy requirements have not been honored. 

C. The password matches a substring Hover as a dictionary word. 

D. The password does not match the validate_passoword_number_count requirement. 

E. There is no dictionary file defined, so password validation cannot work as expected. 

Answer:

Q24. User A issues the command: 

LOCK TABLES pets READ; 

Which command can User B execute against the pets table? 

A. UPDATE pets… 

B. SELECT….FROM pets 

C. INSERT INTO pets… 

D. ALTER TABLE pets… 

Answer:

Q25. A database exists as a read-intensive server that is operating with query_cachek_type = DEMAND. 

The database is refreshed periodically, but the resultset size of the queries does not fluctuate. 

Note the following details about this environment: 

A web application uses a limited set of queries. 

The Query Cache hit rate is high. 

All resultsets fit into the Query Cache. 

All queries are configured to use the Query Cache successfully. 

The response times for queries have recently started to increase. The cause for this has correctly been identified as the increase in the number of concurrent users accessing the web service. 

Based solely on the information provided, what is the most likely cause for this slowdown at the database level? 

A. The Query Cache is pruning queries due to an increased number of requests. 

B. Query_cache_min_res_unit has been exceeded, leading to an increased performance overhead due to additional memory block lookups. 

C. Mutex contention on the Query Cache is forcing the queries to take longer due to its single-threaded nature. 

D. The average resultset of a query is increasing due to an increase in the number of users requiring SQL statement execution. 

Answer:

Q26. Compare a typical Distributed Replicated Block Device (DRBD) with MySQL Standard Replication using master-slave replication. 

Which two statements are correct? 

A. Both technologies use the TCP/IP stack as their primary transmission medium. 

B. DRBD uses shared-disk technology. 

C. Both technologies guarantee an identical copy of data on the secondary node. 

D. Only MySQL can maintain a time-delayed copy of data on the secondary node. 

Answer:

Q27. You execute the following statement in a Microsoft Windows environment. There are no conflicts in the path name definitions. 

C: > mysqld – install Mysql56 – defaults – file = C : my –opts.cnf 

What is the expected outcome? 

A. Mysqld acts as an MSI installer and installs the Mysql 5.6 version, with the c: my-opts.cnf configuration file. 

B. Mysql is installed as the Windows service name Mysql56, and uses c: my-opts.cnf as the configuration file 

C. An error message is issued because – install is not a valid option for mysqld. 

D. A running Mysql 5.6 installation has its runtime configuration updated with the server variables set in c: my-opts.cnf. 

Answer:

Q28. The InnoDB engine has a feature known as clustered indexes. 

Which three statements are true about clustered indexes as used in InnoDB? 

A. A primary key must exist for creation of a clustered index. 

B. A primary key is used as a clustered index. 

C. A clustered index is a grouping of indexes from different tables into a global index for faster searching. 

D. If no indexes exist, a hidden clustered index is generated based on row IDs. 

E. A clustered index provides direct access to a page containing row data. 

F. The first unique index is always used as a clustered index and not a primary key. 

G. A clustered index allows fulltext searching within InnoDB, 

Answer: B,D,G 

Reference: http://dev.mysql.com/doc/refman/5.0/en/innodb-index-types.html 

Q29. You want to start monitoring statistics on the distribution of storage engines that are being used and the average sizes of tables in the various databases. 

Some details are as follows: . The Mysql instance has 400 databases. . Each database on an average consists of 25-50 tables. 

You use the query: 

SELECT TABLE_SCHEMA, 

‘ENGINE’, 

COUNT (*), 

SUM (data_length) total_size 

FROM INFORMATION_SCHEMA.TABLES 

WHERE TABLE_TYPE = ‘BASE TABLE’ 

GROUP BY TABLE_SCHEMA, ‘ENGINE’ 

Why is this query slow to execute? 

A. Counting and summarizing all table pages in the InnoDB shared tablespace is time consuming. 

B. Collecting information requires various disk-level operations and is time consuming. 

C. Aggregating details from various storage engine caches for the final output is time consuming. 

D. Collecting information requires large numbers of locks on various INFORMATION_SCHEMA tables. 

Answer:

Q30. Which statement is true about using Microsoft Windows Cluster as a platform for Mysql? 

A. It is provided by means of IP- level disk replication. 

B. It is shared-nothing architecture. 

C. It implements High Availability by using the .NET Connector’s load balancing capabilities. 

D. It relies on the shared disk architecture being visible to both servers. 

Answer: