Free Exam/Cram Practice Materials

Latest Uploads Free Practice Materials

Latest Comments

Mangesh - Jul 13, 2020
why no scheduled instances.

Olivio Manzaneda - Jul 13, 2020
Dataguard backup is possible with Active Data Guard, as the database is open in Read Only mode. Doc ID 1419923.1
For minimal cost, Active Data Guard is not a valid option while GoldenGate is free to

mrson92 - Jul 12, 2020
Using SHA-256 Pluggable Authentication
To set up an account that uses the sha256_password plugin for SHA-256 password hashing, use the following statement, where password is the desired account

mrson92 - Jul 12, 2020
14.6.3.4 Undo Tablespaces
Undo tablespaces contain undo logs, which are collections of undo log records that contain information about how to undo the latest change by a transaction to a clustered

mrson92 - Jul 12, 2020
Controls how often the MySQL server synchronizes the binary log to disk.

sync_binlog=0: Disables synchronization of the binary log to disk by the MySQL server. Instead, the MySQL server relies on the

mrson92 - Jul 12, 2020
A -> query excution
B --> parser
C --> optimizer
D --> optimizer
E --> Authorization
E --> Optimizer
F --> Parser

optimizer : createan optimal

mrson92 - Jul 12, 2020
answer is C,D.E

mrson92 - Jul 12, 2020
Because of this, you must have the DROP privilege for a table before you can execute ALTER TABLE ... DROP PARTITION on that table.

If you wish to drop all data from all partitions while preserving

mrson92 - Jul 12, 2020
This variable controls server-side LOCAL capability for LOAD DATA statements. Depending on the local_infile setting, the server refuses or permits local data loading by clients that have LOCAL enabled

mrson92 - Jul 12, 2020
To make inadvertent use of the mysql_clear_password plugin less likely, MySQL clients must explicitly enable it. This can be done in several ways:

Set the LIBMYSQL_ENABLE_CLEARTEXT_PLUGIN environment

mrson92 - Jul 12, 2020
Property Value
Command-Line Format --key-buffer-size=#
System Variable key_buffer_size
Scope Global
Dynamic Yes
SET_VAR Hint Applies No
Type Integer
Default Value 8388608
Minimum Value 8
Maximum Value

mrson92 - Jul 12, 2020
Property Value
Command-Line Format --key-buffer-size=#
System Variable key_buffer_size
Scope Global
Dynamic Yes
SET_VAR Hint Applies No
Type Integer
Default Value 8388608
Minimum Value 8
Maximum Value