Free Actual Oracle 1Z0-908 Exam Questions & Answers

Question 1

You are considering using file-system snapshots to back up MySQL.

Which three statements are true? (Choose three.)

AThey take roughly twice as long as logical backups.

BThey allow direct copying of table rows with operating system copy commands.

CThey work best for transaction storage engines that can perform their own recovery when restored.

DThe backup window is almost zero from the perspective of the application.

EThey do not back up views, stored procedures, or configuration files.

FThere is a slight performance cost while the snapshot is active.

GThey do not use additional disk space.

Correct : C, E, G

Question 2

Examine this snippet from the binary log file named binlog.000036:

1Z0-908 Exam Question 2 Exhibit 1

The rental table was accidentally dropped, and you must recover the table.

You have restored the last backup, which corresponds to the start of the binlog.000036 binary log.

Which command will complete the recovery?

Amysqlbinlog --stop-position=500324 binlog.000036 | mysql

Bmysqlbinlog --stop-datetime='2019-ll-20 14:55:18' binlog.000036 | mysql

Cmysqlbinlog --stop-position=5004S3 binlog.000036 | mysql

Dmysqlbinlog --stop-datetime='2019-ll-20 14:55:16' binlog.000036 | mysql

Correct : D

Oracle 1Z0-908 Exam Questions - Navigate Your Path to Success