Oracle 1Z0-908 Online Practice Questions and Exam Preparation

Oracle 1Z0-908 Online Questions & Answers

• Question 121:

  Which two statements are true about the mysqld-auto.cnf file? (Choose two.)

  A. This file is for storing MySQL Server configuration options in ISON format.
  B. This file is for logging purposes only and is never processed.
  C. It is read and processed at the beginning of startup configuration.
  D. It is read and processed at the end of startup configuration.
  E. It is always updated with changes to system variables.
  F. This file is for storing MySQL server_uuid values only.
  D. It is read and processed at the end of startup configuration.
  E. It is always updated with changes to system variables.

• Question 122:

  Examine this SQL statement:

  mysql> GRANT r_read@localhost TO mark WITH ADMIN OPTION;

  Which two are true? (Choose two.)

  A. Mark can grant the privileges assigned to the r_read@localhost role to another user.
  B. ADMIN OPTION causes the role to be activated by default.
  C. Mark can grant the r_read@localhost role to another user.
  D. Mark can revoke the r_read@localhost role from another role.
  E. ADMIN OPTION allows Mark to drop the role.
  F. Mark must connect from localhost to activate the r_read@localhost role.
  C. Mark can grant the r_read@localhost role to another user.
  D. Mark can revoke the r_read@localhost role from another role.

  ---

  Explanation/Reference:

  https://dev.mysql.com/doc/refman/8.0/en/grant.html

• Question 123:

  Your MySQL installation is running low on space due to binary logs. You need to reduce your log space usage urgently.

  Which two sets of actions when completed will accomplish this? (Choose two.)

  A. Use SET GLOBAL binlog_expire_logs_seconds= and restart the server.
  B. Set binlog_expire_logs_seconds in my.cnf.
  C. Set binlog_expire_logs_seconds = 0 in my.cnf and restart the server.
  D. Use SET PERSIST binlog_expire_logs_seconds=.
  E. Use PURGE BINARY LOGS to .
  F. Use SET GLOBAL binlog_expire_logs_seconds= and run the FLUSH BINARY LOGS command.
  A. Use SET GLOBAL binlog_expire_logs_seconds= and restart the server.
  D. Use SET PERSIST binlog_expire_logs_seconds=.

  ---

  Explanation/Reference:

  Reference: https://severalnines.com/database-blog/my-mysql-database-out-disk-space

• Question 124:

  You want to check the values of the sort_buffer_size session variables of all existing connections. Which performance_schema table can you query?

  A. user_variables_by_thread
  B. global_variables
  C. variables_by_thread
  D. session_variables
  D. session_variables

  ---

  Explanation/Reference:

  Reference: https://dev.mysql.com/worklog/task/?id=6629

• Question 125:

  Examine this command, which executes successfully:

  

  Which two statements are true? (Choose two.)

  A. A single-file backup is created.
  B. The backup operation will finish only when backup-and-apply-log is executed.
  C. The --backup-dir option holds temporary output, status, and metadata files.
  D. The backup operation will finish only when apply-log is executed.
  E. A raw backup is created.
  C. The --backup-dir option holds temporary output, status, and metadata files.
  D. The backup operation will finish only when apply-log is executed.

• Question 126:

  What does the binlog dump thread do?

  A. It monitors and schedules the rotation/deletion of the binary logs.
  B. It reads the relay log and executes the events contained in them.
  C. It acquires a lock on the binary log for reading each event to be sent to the slave.
  D. It connects to the master and asks it to send updates recorded in its binary logs.
  D. It connects to the master and asks it to send updates recorded in its binary logs.

  ---

  Explanation/Reference:

  Reference: https://blogs.oracle.com/mysql/what-causes-replication-lag- v2#:~:text=The%20Binlog%20Dump%20Thread.,contents%20of%20its%20binary%20log.andtext=The%20slaves%20creates%20th is%20SQL,log% 20and%20apply% 20its%20contents.

• Question 127:

  Examine this query:

  

  What information does this query provide?

  A. total memory used across all connections associated with the user on connection number 10
  B. total memory used by the first 10 connections
  C. total memory used by thread number 10
  D. total memory used across all connections associated with the user on thread number 10
  E. total memory used by connection number 10
  F. total memory used by the first 10 threads
  E. total memory used by connection number 10

• Question 128:

  Your MySQL server is running on the Microsoft Windows platform.

  Which three local connection protocols are available to you? (Choose three.)

  A. named pipes
  B. shared memory
  C. SOCKET
  D. X Protocol
  E. UDP
  F. TCP/IP
  A. named pipes
  B. shared memory
  F. TCP/IP

  ---

  Explanation/Reference:

  Reference: https://docs.oracle.com/cd/E17952_01/mysql-8.0-en/mysql-installer- workflow.html

• Question 129:

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

  Which command will achieve this?

  A. mysqlpump --include-tables=db.% --result-file=all_db_backup.sql
  B. mysqlpump > all_db_backup.sql
  C. mysqlpump --include-databases=db --result-file=all_db_backup.sql
  D. mysqlpump --include-databases=db% --result-file=all_db_backup.sql
  C. mysqlpump --include-databases=db --result-file=all_db_backup.sql

• Question 130:

  MySQL programs look for option files in standard locations.

  Which method will show the option files and the order in which they are read?

  A. shell> mysqladmin --debug
  B. shell> mysql --print-defaults
  C. shell> mysqld --help --verbose
  D. mysql> SHOW GLOBAL VARIABLES;
  A. shell> mysqladmin --debug