e11] - Read-Only - Word References Mailings Review View Help 28 - in my SQL with innoDB how are the primary and secondary indexes created? a) primary indexes are automatically created for each primary...

Extracted text: e11] - Read-Only - Word References Mailings Review View Help 28 - in my SQL with innoDB how are the primary and secondary indexes created? a) primary indexes are automatically created for each primary key. Secondary indexes are created manually for the foreign keys. b) primary indexes are manually created for each primary keys. All the secondary indexes are created automatically. c) primary indexes are automatically created for primary key secondary indexes are created automatically for the foreign keys. d) Primary indexes are manually created for each primary key secondary index are men created manually for each foreign key. structure while those without a 29 - in MYSQL with innoBD with the primary key however primary key have a structure. a) Неар, sorted. b) Sorted, heap. c) Sorted, hash. d) Cluster, heap 30 - what approach in a database administrator used to assess the effectiveness of indexes while investigating slow queries? a) Run EXPLAIN on queries b) Change the primary key. c) Inspect query logs. d) Partition large tables F10 ※一 F11 Prtsc F7 F12 & 5 9 Y U + I|