What is Database Administrator ( DBA) ?

What is Database Administrator ( DBA) ?
by

1 Answer

Answer :

Answer : In DBMS , the person or organization who has the overall responsibility of database management is called Database Administrator .
by

Related questions

I am doing a presentation on information technology (Network administrator) and I don't know what to do?

Description : I am doing a presentation on information technology (Network administrator) and I don't know what to do?

Last Answer : answer:Who are your audience? @jaytkay video on linked URL is no longer available

What is the role of database administrator? -Technology

Description : What is the role of database administrator? -Technology

Last Answer : DBA is a person who manages the database of an organisation.

Mr. Manav, a database administrator in “Global Educational and Training Institute” has created following table named “Training” -Technology

Description : Mr. Manav, a database administrator in “Global Educational and Training Institute” has created following table named “Training” -Technology

Last Answer : i. Select count(name) from training where name like ‘Ms.%’;ii. Select * from training where fee is NULL;iii. Select city, fee from training where topic = ‘Cyber Security’;iv. Alter table training add feedback varchar(20);

What steps should I take when considering database administrator training?

Description : What steps should I take when considering database administrator training?

Last Answer : For this training your need to do your research and find a technical school that fits your schedule, wether online or in class. Also check the prices they vary allot form school to school.

What's the average database administrator salary?

Description : What's the average database administrator salary?

Last Answer : The average database administrator's salary can range anywhere between; $30,000 and above. If you don't have a degree and a lot of experience you can start at the salary above.

What is the average salary for a database administrator?

Description : What is the average salary for a database administrator?

Last Answer : The average salary for a database administrator depends on the level of experience. The range would be lower for someone straight out of school versus someone who has been in the field for a long time.

What responsibilities does an Oracle Database Administrator have?

Description : What responsibilities does an Oracle Database Administrator have?

Last Answer : The responsibilities are quite important. Interacting with consumers and employees is a main responsibility. Database design and repair are also other main responsibilities.

Where can I train for a database administrator career?

Description : Where can I train for a database administrator career?

Last Answer : www.devry.edu This is one I found, and I know DeVery is a good technology school. But there are many other schools that will train you. Good Luck on your search!

What are the primary duties of a remote database administrator?

Description : What are the primary duties of a remote database administrator?

Last Answer : A database administrator's responsibilities can include the following tasks: future storage requirements for the database system. Creating primary database and the database tools and applications are executed on remote computers.

What exactly is a remote database administrator?

Description : What exactly is a remote database administrator?

Last Answer : Someone who's responsible for the design, implementation and maintenance of an organizations online database. They have to not only keep an eye out for any problems with the system but be ready to fix it if something's wrong.

The Perks of Being an IT Database Administrator ?

Description : The Perks of Being an IT Database Administrator ?

Last Answer : From Small to LargeIn the past, IT database administrators were only found at a few select companies. As the Information Age matured, small businesses, medium businesses, and the large businesses ... rely heavily on their database administrators to keep the company going and pay well for i

Some Duties of a Database Administrator?

Description : Some Duties of a Database Administrator?

Last Answer : As a company expands and business grows, they will have an increased need for support of their network and databases which store all of their information. Many businesses end up hiring professional database ... it so it can be altered and expanded as the needs of the business begins to change.

Oracle Database Administrator Job Tips?

Description : Oracle Database Administrator Job Tips?

Last Answer : Oracle is one of the leading producers of servers and business databases, used by thousands of businesses to run websites, manage inventory and supply chains, and keep customer records. These ... , as well as creating a well-crafted resume that highlights job experience, can significantly improv

What are the responsibilities of a Database Administrator ?

Description : What are the responsibilities of a Database Administrator ?

Last Answer : Installing and upgrading the Oracle Server and application tools. Allocating system storage and planning future storage requirements for the database system. Managing primary database structures ... tape Backing up and restoring the database. Contacting Oracle Corporation for technical support.

How does one manage Oracle database users? (for DBA

Description : How does one manage Oracle database users? (for DBA

Last Answer : Oracle user accounts can be locked, unlocked, forced to choose new passwords, etc. For example, all accounts except SYS and SYSTEM will be locked after creating an Oracle9iDB database using the DB ... locked users account ALTER USER scott PASSWORD EXPIRE; -- Force user to choose a new password

How does one manage Oracle database users? (for DBA

Description : How does one manage Oracle database users? (for DBA

Last Answer : Oracle user accounts can be locked, unlocked, forced to choose new passwords, etc. For example, all accounts except SYS and SYSTEM will be locked after creating an Oracle9iDB database using the ... from SYS.V$BH log buffer spaces Increase LOG_BUFFER parameter or move log files to faster disks

How does one backup a database using the export utility? (for DBA

Description : How does one backup a database using the export utility? (for DBA

Last Answer : Oracle exports are "logical" database backups (not physical) as they extract data and logical definitions from the database into a file. Other backup strategies normally back-up the physical data ... exports include more information about the database in the export file than user level exports.

What strategies are available for backing-up an Oracle database? (for DBA

Description : What strategies are available for backing-up an Oracle database? (for DBA

Last Answer : The following methods are valid for backing-up an Oracle database: Export/Import - Exports are "logical" database backups in that they extract logical definitions and data from the database to a file. ... , etc. If your database is in ARCGIVELOG mode, you also need to backup archived log files.

Why and when should I backup my database? (for DBA

Description : Why and when should I backup my database? (for DBA

Last Answer : Backup and recovery is one of the most important aspects of a DBAs job. If you lose your company's data, you could very well lose your job. Hardware and software can always be ... things that will get you. Most failed recoveries are a result of organizational errors and miscommunications.

How does one create a standby database? (for DBA)

Description : How does one create a standby database? (for DBA)

Last Answer : While your production database is running, take an (image copy) backup and restore it on duplicate hardware. Note that an export will not work!!! On your standby database, issue ... the standby database, stop the recovery process and activate it: ALTER DATABASE ACTIVATE STANDBY DATABASE;

Who created all these users in my database?/ Can I drop this user? (for DBA

Description : Who created all these users in my database?/ Can I drop this user? (for DBA

Last Answer : Oracle creates a number of default database users or schemas when a new database is created. Below are a few of them: SYS/CHANGE_ON_INSTALL or INTERNAL Oracle Data Dictionary/ Catalog Created ... there should be no problem altering these users to use a different default and temporary tablespace.

What is a Virtual Private Database? (for DBA

Description : What is a Virtual Private Database? (for DBA

Last Answer : Oracle 8i introduced the notion of a Virtual Private Database (VPD). A VPD offers Fine-Grained Access Control (FGAC) for secure separation of data. This ensures that users only have ... the DBMS_RLS (Row Level Security) package. Select from SYS.V$VPD_POLICY to see existing VPD configuration.

How can one dump internal database structures? (for DBA

Description : How can one dump internal database structures? (for DBA

Last Answer : The following (mostly undocumented) commands can be used to obtain information about internal database structures. o Dump control file contentsalter session set events 'immediate trace name CONTROLF level 10 ... ); print x alter session set events 'immediate trace name blockdump level 50360894' /

What database events can be set? (for DBA

Description : What database events can be set? (for DBA

Last Answer : The following events are frequently used by DBAs and Oracle Support to diagnose problems: " 10046 trace name context forever, level 4 Trace SQL statements and show bind variables in trace output. " 10046 ... . On Unix, you can type "oerr ora 10053" from the command prompt to get event details.

What is a database EVENT and how does one set it? (for DBA

Description : What is a database EVENT and how does one set it? (for DBA

Last Answer : Oracle trace events are useful for debugging the Oracle database server. The following two examples are simply to demonstrate syntax. Refer to later notes on this page for an explanation of what these ... changes to the INIT.ORA file will affect all sessions once the database has been restarted.

My database is down and I cannot restore. What now? (for DBA

Description : My database is down and I cannot restore. What now? (forDBA

Last Answer : Recovery without any backup is normally not supported, however, Oracle Consulting can sometimes extract data from an offline database using a utility called DUL (Disk UnLoad). This utility reads data in the ... as an absolute last resort and will most likely cost your company a lot of money!!!

My database was terminated while in BACKUP MODE, do I need to recover? (for DBA

Description : My database was terminated while in BACKUP MODE, do I need to recover? (for DBA

Last Answer : If a database was terminated while one of its tablespaces was in BACKUP MODE (ALTER TABLESPACE xyz BEGIN BACKUP;), it will tell you that media recovery is required when you try to restart the ... : ALTER DATABASE END BACKUP; The above commands need to be issued when the database is mounted.

What database aspects should be monitored? (for DBA

Description : What database aspects should be monitored? (for DBA

Last Answer : One should implement a monitoring system to constantly monitor the following aspects of a database. Writing custom scripts, implementing Oracle's Enterprise Manager, or buying a third-party monitoring product ... up? . Objects getting close to their max extents . User and process limits reached

How does one backup a database using RMAN? (for DBA

Description : How does one backup a database using RMAN? (for DBA

Last Answer : The biggest advantage of RMAN is that it only backup used space in the database. Rman doesn't put tablespaces in backup mode, saving on redo generation overhead. RMAN will re-read database ... directly to tape. Alternatively one can backup to disk and then manually copy the backups to tape.

How does one do on-line database backups? (for DBA

Description : How does one do on-line database backups? (for DBA

Last Answer : Each tablespace that needs to be backed-up must be switched into backup mode before copying the files out to secondary storage (tapes). Look at this simple example. ALTER TABLESPACE xyz ... files while in backup mode. This will lead to excessive database archiving and even database freezes.

How does one do off-line database backups? (for DBA

Description : How does one do off-line database backups? (for DBA

Last Answer : Shut down the database from sqlplus or server manager. Backup all files to secondary storage (eg. tapes). Ensure that you backup all data files, all control files and all log files. When ... at a convenient time, switch your database into ARCHIVELOG mode and perform hot (on-line) backups.

How does one see the uptime for a database? (for DBA

Description : How does one see the uptime for a database? (for DBA

Last Answer : Look at the following SQL query: SELECT to_char (startup_time,'DD-MON-YYYY HH24: MI: SS') "DB Startup Time" FROM sys.v_$instance; Marco Bergman provided the following alternative solution: SELECT ... from V$INSTANCE JUL, V$INSTANCE SEC where JUL.KEY like '%JULIAN%' and SEC.KEY like '%SECOND%';

Can one rename a database user (schema)? (for DBA)

Description : Can one rename a database user (schema)? (for DBA)

Last Answer : No, this is listed as Enhancement Request 158508. Workaround: Do a user-level export of user A create new user B Import system/manager fromuser=A touser=B Drop user A

What database block size should I use? (for DBA)

Description : What database block size should I use? (for DBA)

Last Answer : Oracle recommends that your database block size match, or be multiples of your operating system block size. One can use smaller block sizes, but the performance cost is significant. Your choice should ... 8K. This is because volume manager products use 8K blocks (and this is not configurable).

How does one create a new database? (for DBA)

Description : How does one create a new database? (for DBA)

Last Answer : One can create and modify Oracle databases using the Oracle "dbca" (Database Configuration Assistant) utility. The dbca utility is located in the $ORACLE_HOME/bin directory. The Oracle Universal ... ='/u02/oradata/'; ALTER SYSTEM SET DB_CREATE_ONLINE_LOG_DEST_2='/u03/oradata/'; CREATE DATABASE;

DBMS provides the facility of accessing data from a database through (A) DDL (B) DML (C) DBA (D) Schema

Description : DBMS provides the facility of accessing data from a database through (A) DDL (B) DML (C) DBA (D) Schema 

Last Answer : (B) DML

What is meant by database sorting ?

Description : What is meant by database sorting ?

Last Answer : sorting means sorting. data sorting means sorting data. A table can have many names . If the names are arranged in a table, it can be easily found out . Records can be sorted on any one or more fields. ... is done on a field, less time is required to search the record according to that field.

Why is the database changed ? Explain ?

Description : Why is the database changed ? Explain ?

Last Answer : Answer : The structure of the database is changed for the following reasons. 1. To change the name of the field in the table , 2. To change the data type of the field , 3. To change the size of the field , 4. To delete or delete the field , 5. Etc. to add new fields.

The index file in the database is updated automatically - explain. ?

Description : The index file in the database is updated automatically - explain. ?

Last Answer : The data is arranged in a special order so that the user can quickly find any data from the database. Indexing is the process of arranging the records in a database table in such a logical ... to the database file, the index files are automatically updated. This does not change the original file.

Why is sorting done in database ?

Description : Why is sorting done in database ?

Last Answer : Sorting can be done very easily using Microsoft Access program. First you have to select the field on which you want to sort the table. Then select Sort from the Record menu . Click on the latest Sort Ascending or Sort Desending . The field can be sorted by Ascending or Descending order

Why is SQL called a database tool ?

Description : Why is SQL called a database tool ?

Last Answer : RDBMS full name Relational Database Management System. RDBMS is a software-based management system used to create , control , establish , maintain , maintain , search, and search various data tables in a database .

How many headings are there in each column of a database ?

Description : How many headings are there in each column of a database ?

Last Answer : Each column in a database has a heading.

What is a database field ?

Description : What is a database field ?

Last Answer : Database field is the title of the column.

Which one is in a database ?

Description : Which one is in a database ?

Last Answer : A database contains row column records.

Why is database called information management system ?

Description : Why is database called information management system ?

Last Answer : Databases are called information management methods because the stored information can be managed.

What is a database called ?

Description : What is a database called ?

Last Answer : Database is called database.

What are the keyboard commands for saving database files ?

Description : What are the keyboard commands for saving database files ?

Last Answer : The keyboard command for saving database files is Ctrl + S

What is the name of the database ?

Description : What is the name of the database ?

Last Answer : The database is called another DBMS .

What command is used to remove a table or index from a SQL database ?

Description : What command is used to remove a table or index from a SQL database ?

Last Answer : DROP TABLE is used to remove a table or index from a SQL database .

What is a corporate database ?

Description : What is a corporate database ?

Last Answer : Answer : A multidimensional database management system is a multidimensional database management system created by specialized software for storing and using essential information. Example: The data ... , insurance companies , multinational companies , government agencies , NGOs and networking.