Interested to Buy Any Domain ? << Click Here >> for more details...
How does Oracle guarantee data integrity of data changes?
- 1 Answers
- 4363 Views
- SoftSol, I also Faced
- E-Mail Answers
Answer / rajat sharma
Data integrity is provided by various constrains
(UNIQUE,CHECk etc.) provided to us by SQL. By these
constrains the user cannot even make a mistake in inserting
the data.
| Is This Answer Correct ? | 0 Yes | 0 No |
An automatic job running via DBMS_JOB has failed. Knowing only that "it's failed", how do you approach troubleshooting this issue?
If we issue alter database begin backup. What happens to database?
Explain the difference between a hot backup and a cold backup and the benefits associated with each?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
what is the difference between hot backup n rman backup?
What are the operating modes in which database mirroring runs? : sql server DBA
What are the different types of indexes available in sql server? : sql server DBA
Compare and contrast TRUNCATE and DELETE for a table.
What is the difference between online backup & offline backup?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
What are the commands you'd issue to show the explain plan for "select * from dual"?
-
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)
