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
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What is dcl? : sql server DBA
What are the commands used in dcl? : sql server DBA
How do you trace the traffic hitting a sql server? : sql server DBA
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
What is fill factor? : sql server DBA
Query processing is slow(eg select query)how will u solve that
What happens on checkpoint? : sql server DBA
How would you go about verifying the network name that the local_listener is currently using?
What purpose does the model database server? : sql server DBA
How would you extract DDL of a table without using a GUI tool?
What are the different ways you can create databases in sql server? : sql server DBA
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What are the commands you'd issue to show the explain plan for "select * from dual"?
What are the recovery models for a database? : sql server DBA