Curious about Actual Oracle Database (1Z0-908) Exam Questions?

Here are sample Oracle MySQL 8.0 Database Administrator (1Z0-908) Exam questions from real exam. You can get more Oracle Database (1Z0-908) Exam premium practice questions at TestInsights.

Page: 1 /
Total 140 questions

Want more questions? Get Premium Access.

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

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

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.

0 / 1500

Question 2

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

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

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

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

0 / 1500

Question 3

You want to dump all databases with names that start with "db".

Which command will achieve this?

Amysqlpump --include-tables=db.% --result-file=all_db_backup.sql

Bmysqlpump > all_db_backup.sql

Cmysqlpump --include-databases=db --result-file=all_db_backup.sql

Dmysqlpump --include-databases=db% --result-file=all_db_backup.sql

Correct : C

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

Amysqlpump --include-tables=db.% --result-file=all_db_backup.sql

Bmysqlpump > all_db_backup.sql

Cmysqlpump --include-databases=db --result-file=all_db_backup.sql

Dmysqlpump --include-databases=db% --result-file=all_db_backup.sql

0 / 1500

Question 4

Which two statements are true about the binary log encryption feature? (Choose two.)

AIt encrypts any connecting slaves connection thread.

BIt can be set at run time.

CIt requires a keyring plugin.

DWhen enabled it encrypts existing binary logs.

EIt can be activated per session.

Correct : A, E

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

AIt encrypts any connecting slaves connection thread.

BIt can be set at run time.

CIt requires a keyring plugin.

DWhen enabled it encrypts existing binary logs.

EIt can be activated per session.

0 / 1500

Question 5

Which statement is true about InnoDB persistent index statistics?

AUpdating index statistics is an I/O expensive operation.

BIndex statistics are calculated from pages buffered in the buffer pool for tables with InnoDB storage engine.

CSetting innodb_stats_auto_recalc=ON causes statistics to be updated automatically when a new index is created.

DExecution plans based on transient index statistics improve precision when innodb_stats_persistent_sample_pages is increased.

EIncreasing innodb_stats_persistent_sample_pages determines higher pages scanning speed, at the cost of increased memory usage.

Correct : A

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

AUpdating index statistics is an I/O expensive operation.

BIndex statistics are calculated from pages buffered in the buffer pool for tables with InnoDB storage engine.

CSetting innodb_stats_auto_recalc=ON causes statistics to be updated automatically when a new index is created.

DExecution plans based on transient index statistics improve precision when innodb_stats_persistent_sample_pages is increased.

EIncreasing innodb_stats_persistent_sample_pages determines higher pages scanning speed, at the cost of increased memory usage.

0 / 1500

Page: 1 / 28
Total 140 questions

Unlock Full
1Z0-908 Exam Features

In Just $49 You can Access

All Official Question Types
Interactive Web-Based Practice Test Software
No Installation or 3rd Party Software Required
Customize your practice sessions (Free Demo)
24/7 Customer Support

Get Full Access Now

Marked Questions
1Z0-908 Exam

1Z0-908 Exam Question 1
1Z0-908 Exam Question 2
1Z0-908 Exam Question 3
1Z0-908 Exam Question 4
1Z0-908 Exam Question 5

Download PDF File Demo

Try Web-Based Exam Practice Software Demo

Commenting

In order to participate in the comments you need to be logged-in.
You can sign-up or login