DBA is your role read now these top questions

The following list of five questions helpful to understand Database admin roles. Why you need to understand about DBA?

If you are DBA, then you must know these questions…

DBA Interview Questions

  1. What are the main issues to be considered when creating a database?

    1. The following are sum of the list an administrator must focus
      1. Physical structure of database
      2. Logical structure
      3. Communication issues
      4. Location of RDBMS
      5. Location of files
      6. User access control
  2. What are the critical issues to be addressed when configuring the security?

    1. The following are important functions to be considered
      1. Access to the system is controlled.

      2. Authorized users must be able to access (insert, modify, retrieve, or delete)

      3. Authorized users must be restricted to the data and resources that they are duly authorized to access

      4. Unauthorized users must not access. This is also responsibility of DBA

  3. What are the main issues to be addressed while management of RDBMS?

    1. Main list DBA functions to be considered
      1. Reorganizing existing database tables and indexes

      2. Deleting unnecessary indexes or moving other objects

      3. Making alterations to the database itself

      4. Making alterations to database components 

      5. Creating additional database objects (tablespaces, datafiles, tables, users, indexes, procedures, etc.)

      6. Training users

      7. Backup and recovery of database objects

      8. Database performance tuning

  4. Why are backups important? Discuss how backup and recovery are handled?

    1. The primary goal of DBA is backup and recovery
      1. Protecting database during loss
      2. Recovery if something happens
      3. The reasons to data loss are – User error, Logical error and Process failure
  5. Why is performance tuning of a database important? 

    1. The below are awesome reasons
      1. Poor database design
      2. Growth of database size
      3. Change in requirements

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.