Sql Interview Question and Answers:
73. What are the type of Synonyms?
There are two types of Synonyms are :
Private
Public
74. What is an Integrity Constrains?
An integrity constraint is a declarative way to define a business rule for a column of a table.
75. What is Table?
A table is the basic unit of data storage in an ORACLE database. The tables of a database hold all of the user accessible data. Table data is stored in rows and columns.
76. What is a synonym?
A synonym is an alias for a table, view, sequence or program unit.
77. What is Rollback Segment?
A Database contains one or more Rollback Segments to temporarily store "undo" information.
78. What does COMMIT do?
A Commit makes permanent the changes resulting from all SQL statements in the transaction. The changes made by the SQL statements of a transaction become visible to other user sessions transactions that start only after transaction is committed.
73. What are the type of Synonyms?
There are two types of Synonyms are :
Private
Public
74. What is an Integrity Constrains?
An integrity constraint is a declarative way to define a business rule for a column of a table.
75. What is Table?
A table is the basic unit of data storage in an ORACLE database. The tables of a database hold all of the user accessible data. Table data is stored in rows and columns.
76. What is a synonym?
A synonym is an alias for a table, view, sequence or program unit.
77. What is Rollback Segment?
A Database contains one or more Rollback Segments to temporarily store "undo" information.
78. What does COMMIT do?
A Commit makes permanent the changes resulting from all SQL statements in the transaction. The changes made by the SQL statements of a transaction become visible to other user sessions transactions that start only after transaction is committed.
No comments:
Post a Comment