Latest Oracle 1z0-883 Actual Free Exam Questions & Community Discussion, Page 4

Question #31

Full Atomicity, Consistency, Isolation, Durability (ACID) compliance is a necessity for a new application, which heavily reads and writes data.
This requires the following config file options:
Sync_binlog=1 Innodb_flush_log_at_trx_commit=1
Innodb_doublewrite=1
However, this configuration is expected to introduce disk I/O overhead.
What three changes will reduce disk I/O overheads?

A. Placement of InnoDB log files and datadir on separate physical disks

B. Use of soft links for database directories on the same physical disk

C. Use of delay_key_write=ON for batch index update

D. Use of separate directories on the same physical disk for log files and data files

E. Allocation of RAM to the buffer pool such that more of the data can fit in RAM

Discussion 0

Correct Answer: A,C,E Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #32

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

A. Using SSL when transporting data over remote networks

B. Setting -- skip-networking when remote connections are not required

C. Setting - mysql_secure_configuration to enable paranoid mode

D. Setting specific GRANT privilege to limit remote authentication

E. Using the sql_mode=STRICT_SECURE after connections are established for encrypted communications

Discussion 0

Correct Answer: B,D,E Vote an answer

Question #33

Which statement is true about the log-output variable?

A. It enables and starts the General Query Log.

B. It is a static variable and can be set only at MySQL server startup.

C. It sets the target location for the binary logs generated by the MySQL sever.

D. It specifies output destinations for the slow and General Query logs.

Discussion 0

Correct Answer: D Vote an answer

Question #34

Consider typical High Availability (HA) solutions that do not use shared storage.
Which three HA solutions do not use shared storage?

A. Mysql Replication

B. Solaris Cluster and Mysql

C. Windows Cluster and Mysql

D. Distributed Replicated Block Device (DRBD) and Mysql

E. Mysql NDB Cluster

Discussion 0

Correct Answer: A,D,E Vote an answer

Question #35

Review the definition of the phone_list view.
CHEATE OR REPLACE
ALGORITHM=MERGE
DEFINER= 'root'@localhost'
SQL SECURITY DEFINER
VIEW 'phone_list' AS
SELECT
e . id as id
'e . first_name AS 'first_name'
'e . last_name AS 'last_name'
'coalesce ( ph1.phone_no, '--') AS 'office_no'
'coalesce (ph2 .phone_no, '--') AS 'cell_no'
FROM employees e
LEFT JOIN employee_phone ph1
ON ph1.emp_id = e.id AND ph1.type = 'office'
LEFT JOIN employee_phone ph2
ON ph2 .emp_id = e.id AND ph2 .type = 'mobile'
The tables employees and employee_phone are InnoDB tables; all columns are used in this view.
The contents of the phone_list view are as follows:
Mysql> select * from phone_list;

1 row in set (0.00 sec)
Which method can you use to change the cell_no value to '555-8888' for John Doe?

A. INSERT INTO employee_phone (emp_id, phone_no, type) VALUES (1, '555-8888','mobile');

B. UPDATE phone_list SET cell_name '555-8888' WHERE first_name= 'John' and last_name= 'Doe';

C. UPDATE employee_phone SET phone_no= '555-8888' where emp_id=1;

D. DELETE FROM phone_list WHERE first_name= 'John' and last_name= 'Doe'; INSERT INTO phone_list (first_name, last_name, office_no, cell_no) VALUES ('John' , 'Doe' , 'x1234' , '555-8888);

Discussion 0

Correct Answer: A Vote an answer

Question #36

Which hardware storage option, when set up with redundant disks, offers the least stability, availability, and reliability for Mysql data?

A. RAID 5

B. SAN (Storage Area Network)

C. NFS (Networked File System)

D. iSCSI

Discussion 0

Correct Answer: B Vote an answer

Question #37

What are four capabilities of the mysql client program?

A. Displaying replication status information

B. Initiating a binary backup of the database by using the START BACKUP command

C. Creating, dropping, and modifying tables and indexes

D. Shutting down the server by using the SHUTDOWN command

E. Creating and administering users

F. Creating and dropping databases

Discussion 0

Correct Answer: A,C,D,E,F Vote an answer

Question #38

Consider the following table:
CREATE TABLE 'game' (
'id' int (10) unsigned NOT NULL AUTO_INCREMENT,
'keyword' varchar (45) DEFAULT NULL,
'date' datetime NOT NULL,
PRIMARY KEY ('id' , 'date'),
UNIQUE KEY 'keyword_idx' ('keyword' , 'date')
) ENGINE=InnoDB DEFAULT CHARSET=latin1
PARTITION BY RANGE (TO_DAYS (date) ) (
PARTITION g201301 VALUES LESS THAN (TO_DAYS ('2013-01-01 00:00:00') ),
PARTITION g201302 VALUES LESS THAN (TO_DAYS ('2013-02-01 00:00:00') ),
PARTITION g201303 VALUES LESS THAN (TO_DAYS ('2013-03-01 00:00:00') ),
PARTITION g201304 VALUES LESS THAN (TO_DAYS ('2013-04-01 00:00:00') ),
PARTITION gMORES VALUES LESS THAN (MAXVALUE) );
Which method should used to add a new g201305 partition to the table?

A. ALTER TABLE games
COALESCE PARTITION (gMORES)
INTO
g01305 VALUES LESS THAN (TO_DAYS ('2013-05-01 00:00:00') ),
gMORES VALUES LESS THAN (MAXVALUE) );

B. ALTER TABLE games
ADD PARTITION g201350 VALUES LESS THAN (TO_DAYS ('2013-05-01 00:00:00') );

C. ALTER TABLE games
SPLIT PARTITION (gMORES)
INTO
g201305 VALUES LESS THAN (TO_DAYS ('2013-05-01 00:00:00') ),
gMORES VALUES LESS THAN (MAXVALUE) );

D. ALTHER TABLE games
DROP PATITION gMORES,
ADD PARTITION
g201305 VALUES LESS THAN (TO_DAYS ('2013-05-01 00:00:00') ),
gMORES VALUES LESS THAN (MAXVALUE) );

E. ALTER TABLE games
REORGANIZE PARTITION (gMORES)
INTO
g01305 VALUES LESS THAN (TO_DAYS ('2013-05-01 00:00:00') ),
gMORES VALUES LESS THAN (MAXVALUE) );

Discussion 0

Correct Answer: B Vote an answer

Question #39

Which two statements are true about InnoDB auto-increment locking?

A. The auto-increment lock can be a table-level lock.

B. InnoDB never uses table-level locks.

C. InnoDB does not use locks to enforce auto-increment uniqueness.

D. Some settings for innodb_autoinc_lock_mode can help reduce locking.

E. InnoDB always protects auto-increment updates with a table-level lock.

Discussion 0

Correct Answer: A,E Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #40

Mysqldump was used to create a single schema backup;
Shell> mysqldump -u root -p sakila > sakila2013.sql
Which two commands will restore the sakila database without interfering with other running database?

A. Shell> mysql -u root -p -e 'use sakila; source sakila2013.sql'

B. Shell> mysql -u root -p sakila <sakila2013.sql

C. Shell> mysqlimport -u root -p sakila sakila2013.sql

D. Mysql> USE sakila; LOAD DATA INFILE 'sakila2013.sql';

E. Shell> mysql -u root -p -silent < sakila2013.sql

Discussion 0

Correct Answer: A,B Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Oracle 1z0-883 Actual Free Exam Questions & Community Discussion

Download Free Oracle 1z0-883 Demo