Explain the three Level Architecture of the Database System
No Answer is Posted For this Question
Be the First to Post Answer
You loss one datafile and DB is running in ARCHIVELOG mode. You have full database backup of 1 week old and partial backup of this datafile which is just 1 day old. From which backup should you restore this file?
What is data sublanguage?
Define join and enlist its types.
Can we attach the same List of Values to different fields in Design time ?
From where the Transactions per rollback segment is derived ?
Why are recursive relationships are bad? How do you resolve them?
How do you rename a database?
Define transaction and transaction isolation levels?
What is foreign key in database?
What is a trigger?
How to reorder the table columns (fields)?
Explain by listing some major advantages of dbms.
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)