Please help me solve these questions, thank you. Subject: Database administration N a)SQL statements in Figure 1

Please help me solve these questions, thank you.

Subject:

Database administration
 
 

Transcribed Image Text:

N a)SQL statements in Figure 1 are used to gather optimizer statistics. How optimizer statistics can be used to help Database Administrators (DBAs) to maintain a database? Suggest THREE (3) ways. SQL> SELECT COUNT(*) FROM hr.employees; COUNT(*) 214 SQL> SELECT num_rows FROM dba_tables 2 WHERE owner='HR' AND table name='EMPLOYEES'; NUM ROWS 107 Figure 1: SQL statement b) What kind of statistics that can be collected by DBA? c) How a DBA reacts to alerts? Recommend FOUR (4) methods. 1 N a)SQL statements in Figure 1 are used to gather optimizer statistics. How optimizer statistics can be used to help Database Administrators (DBAs) to maintain a database? Suggest THREE (3) ways. SQL> SELECT COUNT(*) FROM hr.employees; COUNT(*) 214 SQL> SELECT num_rows FROM dba_tables 2 WHERE owner='HR' AND table name='EMPLOYEES'; NUM ROWS 107 Figure 1: SQL statement b) What kind of statistics that can be collected by DBA? c) How a DBA reacts to alerts? Recommend FOUR (4) methods. 1