Topic : Architecture

What are the duties of an Oracle DBA?


Answer :

Duties of a DBA might include
Software and hardware installation
Configuration of new hardware and software
Security; performance tuning
Backup and recovery
Routine maintenance
Troubleshooting
Failure recovery.

Show Answer Discuss

What Oracle object is used for read consistency?


Answer :

The rollback segments are used for read consistency.

Show Answer Discuss

Define cluster?


Answer :

A cluster is a set of tables physically stored together as one table that shares a common column.
If data in two or more tables is frequently retrieved together based on data in the common column; using a clustered table can be quite efficient.
Tables can be accessed separately even though they are part of a clustered table.

Show Answer Discuss

What is the main difference between oracle;sql and sql server?


Answer :

Oracle is based on RDBMS(Relational Database Management System).
SQL is Structured Query Language is a standard command set used to communicate with the relational database management system.
SQL Server is another tool for RDBMS provided by MicroSoft.

Show Answer Discuss

Which type of relationship associates one row in a given table with one or no rows in another table?


Answer :

A one?to?one relationship associates one row in a given table with one or no rows in another table.

Show Answer Discuss