Can you have a nested transaction?
Answer / abinash
yes we can have nested transaction.
A transaction is nothing a set of sql statement which either executes at a time or nothing will happen and we specify the transaction using Begin and End.
And also we can have multiple begin end (nested transaction) inside a transaction.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the system function to get the current user's user id?
Explain the general syntax for a SELECT statements covering all the options.
fact table and dimension table containg one to many relationship or many to one relastionship
What are the key features of dbms?
Explain what a database is?
What is database design and development?
What is a self join? Explain it with an example?
Where is dbms used?
agregator gives one to many records or many to one record
Explain the cube operator?
Who are end users in dbms?
What is the database development process?
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)