Free Oracle 1Z0-908 Exam Questions

Become Oracle Certified with updated 1Z0-908 exam questions and correct answers

Page: 1 / 79

Total 392 Questions | Updated On: Nov 14, 2024

Add To Cart

Question 1

Your MySQL server was upgraded from an earlier major version.

The sales database contains three tables, one of which is the transactions table, which has 4 million rows.

You are running low on disk space on the datadir partition and begin to investigate.

Examine these commands and output:

Other-Image-5400dea42-15fa-4b95-aaab-09ec510a61e4

Which two statements are true? (Choose two.)

A : Executing SET GLOBAL innodb_row_format=COMPRESSED and then ALTER TABLE transactionswill free up disk space.

B : ecuting ALTER TABLE transactions will enable you to free up disk space.

C : uncating the sales and leads table will free up disk space.

D : uncating the transactions table will free up the most disk space.

E : transactions table was created with innodb_file_per_table=OFF.

Answer: A

Question 2

You have forgotten the root user account password. You decide to reset the password and execute:

2020-03-14-14-37-11-4ec4153145d3e66368ed58ed6f5922f5

Which additional argument makes this operation safer?

A : --old-passwords, to start MySQL to use the old password format while running without the grant tables.

B : --reset-grant-tables, to start the server with only the mysql database accessible.

C : --read-only, to set all data to read-only except for super users

D : --skip-networking, to prohibit access from remote locations

Answer: D

Question 3

Which two are valid uses for binary logs on a MySQL instance? (Choose two.)

A : cording the order in which queries are issued

B : dit of all queries

C : int-in-time recovery

D : plication

E : gging the duration and locks for all queries

Answer: A,C

Question 4

Examine this MySQL client command to connect to a remote database:

mysql -h remote.example.org -u root -p --protocol=TCP --ssl-mode=

Which two --ssl-mode values will ensure that an X.509-compliant certificate will be used to establish the

SSL/TLS connection to MySQL?

A : QUIRED

B : RIFY_CA

C : RIFY_IDENTITY

D : EFERRED

E : ABLED

Answer: A

Question 5

Which three methods will show the storage engine for the Country table? (Choose three.)

A : OW CREATE TABLE Country;

B : OW ENGINE Country STATUS;

C : OW TABLE STATUS LIKE ‘Country’;

D : LECT ENGINE FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME= ‘Country’;

E : LECT ENGINE FROM INFORMATION_SCHEMA.ENGINES WHERE TABLE_NAME= ‘Country’;

Answer: A,C,D

Page: 1 / 79

Total 392 Questions | Updated On: Nov 14, 2024

Add To Cart