What is RAID and what are different types of RAID
configurations?
Answer / monal
RAID: For FUN it is called Redundant Array of INEXPENSIVE
Disks.
In Reality it is called Redundant Array of Independent Disks.
Following 3 are most popular and still in use in different ways.
1. RAID 0: Disk Striping
2. RAID 1: Disk Mirroring
3. RAID 5: Disk Striping with Parity Bit.
| Is This Answer Correct ? | 4 Yes | 0 No |
Can we take incremental backups in datapump?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
How would you go about increasing the buffer cache hit ratio?
hi, suppose i created one table after few days i did some insert,update how can i know when will i did ddl or dml operation is undergone on that table
what is the use of recording information about current session?
Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode? 4. Can you take Online Backups if the the database is running in NOARCHIVELOG mode?
why do we give pctfree and pctused in create table statement?
Give two methods you could use to determine what DDL changes have been made.
What are the different sql server versions you have worked on? : sql server DBA
What are the recovery models for a database? : sql server DBA
How can you gather statistics on a table?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)