How does Oracle guarantee data integrity of data changes?
Answer Posted / 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 |
Post New Answer View All Answers
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
What is the difference between dropping a database and taking a database offline? : sql server DBA
what are the differences of where and if in SAS?
How to start SQL Server in minimal configuration mode?
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
how can you connect from 10g user to 11g user??
what is the role of dip user in our database?
how can you enable flashback feature?
Which autogrowth database setting is good? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
internal architecture
Explain about your sql server dba experience? : sql server DBA
what is a crs resource?
What are the recovery models for a database? : sql server DBA