What is relational database ? Give me an example !
Answers were Sorted based on User's Feedback
Answer / ankit parikh
A relational database is a database that conforms to the
relational model, and refers to a database's data and schema
| Is This Answer Correct ? | 16 Yes | 4 No |
Answer / sunil kumar sharma
A relational database consists of well defined relations
consisting of attributes and their values. These relations
are called tables and the attributes are the columns and
their values.
A database may consist of various tables having
relationships among them.These ralationships facilitates
ease in querying and responses against the backend database
tables.
| Is This Answer Correct ? | 6 Yes | 2 No |
Answer / chaithan
Relational database is one which is designed according to
the relational model. For example, quantity,price,no. nof
orders can be grouped in relation with the product name or
customer name. This type of relational grouping is more
efficient as it makes data analysis easier and more
efficient. The queries can be run easily on such databases.
Examples of RDBMS are MS Access, ORACLE etc..
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / devraj
A relational database is a database in which the DB objects
have relation like table can have relation with help of PK
and FK concept.
For example you can name as ORACLE itself.
| Is This Answer Correct ? | 1 Yes | 2 No |
What is an extensible database?
Where is the data stored in a database?
Define checkpoint.
Why do we need foreign key?
1)what is the difference between view and materilized view? 2)what is the difference between delete and truncate? 3)what is the difference between migration and upgration? 4)what is the difference between RMAN HOT BACKUP and normal hot backup?
What is n tier architecture in dbms?
What are the limitations of rdbms?
What do you understand by data independence? What are its two types?
what are the advantages of GUI systems ?
Explain the concept of acid properties in dbms?
What is an entity-relationship model?
8. Sort, Lookup What kind of technique (partition) is used? 9. How can you handle exceptions in job sequencer? 10. How do you apply custom conditions an exceptions (How do you trigger exceptions in job sequence?) 11. I have a job with 3 possibilities? Finish with ok…..Abort…….Warning} How do you handle these in Job sequencer 12. How do you connect both OK and Warning can we? 13. How to find which process is running currently? 14. How do you find the disk usage in UNIX? 15. How do you combine 2 sequential files having same metadata of same file names? 16. How do you implement SCD in Ds? 17. Explain the situation where you have applied? 18. How do you apply new changes to? 19. Difference between change capture and Change apply? 20. Explain Compare Stage? 21. What is Surrogate key? 22. How to solve the problem of null values?
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)