SQL Interviewfragen und Antworten
Test your skills through the online practice test: SQL Quiz Online Practice Test
Frage 111. What is ROWID?
ROWID is a pseudo column attached to each row of a table. It is 18 characters long, blockno, rownumber are the components of ROWID.
Ist das hilfreich?
Kommentar hinzufugen
Kommentare ansehen
Frage 112. What is the fastest way of accessing a row in a table?
Using ROWID.
CONSTRAINTS
Ist das hilfreich?
Kommentar hinzufugen
Kommentare ansehen
Frage 113. What is an integrity constraint?
Integrity constraint is a rule that restricts values to a column in a table.
Ist das hilfreich?
Kommentar hinzufugen
Kommentare ansehen
Frage 114. What is referential integrity constraint?
Maintaining data integrity through a set of rules that restrict the values of one or more columns of the tables based on the values of primary key or unique key of the referenced table.
Ist das hilfreich?
Kommentar hinzufugen
Kommentare ansehen
Frage 115. What is the usage of SAVEPOINTS?
SAVEPOINTS are used to subdivide a transaction into smaller parts. It enables rolling back part of a transaction. Maximum of five save points are allowed.
Ist das hilfreich?
Kommentar hinzufugen
Kommentare ansehen
Am hilfreichsten laut Nutzern: