|
DataBase Administrator (DBA) Interview Questions and Answers
Part:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
(Continued from previous part...)
44. How do you add a data file to a tablespace?
ALTER TABLESPACE ADD DATAFILE <datafile_name> SIZE <size>
45. How do you resize a data file?
ALTER DATABASE DATAFILE <datafile_name> RESIZE <new_size>;
46. What view would you use to look at the size of a data file?
DBA_DATA_FILES
47. What view would you use to determine free space in a tablespace?
DBA_FREE_SPACE
48. How would you determine who has added a row to a table?
Turn on fine grain auditing for the table.
49. How can you rebuild an index?
ALTER INDEX <index_name> REBUILD;.
50. Explain what partitioning is and what its benefit is.
Partitioning is a method of taking large tables and indexes and splitting them into smaller, more manageable pieces.
51. You have just compiled a PL/SQL package but got errors, how would you view the errors?
SHOW ERRORS
52. How can you gather statistics on a table?
The ANALYZE command.
53. How can you enable a trace for a session?
Use the DBMS_SESSION.SET_SQL_TRACE or
Use ALTER SESSION SET SQL_TRACE = TRUE;
(Continued on next part...)
Part:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
| 