1. What are the rules for RDBMS and who developed it?2. What is waterfall and spiral model?3. What are Primary key and foreign Key?4. What are commands in DDL, DML, DCL & TCL?5. What do you know about
Primary key is a constraint that uniquely identifies each row in a table. The key can be built on a single column or two or more columns together to identify a row uniquely. Such a column cannot contain a null value.Foreign key is a key that ...
What is the differences between DBMS & RDBMS? What is the differences between Oracle & MS Access?
An MDDB is generally used where large number of aggregations and summarizations are required along with a very fast retrieval of data.Here the data is stored in the form of multidiemnsional cube(however physically it is also implemented in the form of ...
What happens when the session stops half way while loading? How to join a flat file without matching keys in RDBMS?
XYZ Grapes, a vineyard, is developing an online ordering system to sell wine online. Because of local sales restrictions, the vineyard is working with local wine stored to deliver wine to the customers. The requirements for the system are: • Customers keep their choices in a "wine list". • Requests are fulfilled as the vintage become available. • Local wine shops track wines that have been ordered by customers in their area. • All order and product data is
Answer: A, D
mysql has provided all feateute of relational database like view sequence join index trigger etc ...
DBMS includes the theoretical part that how datas are stored in a table. It does not relate tables with another. While RDBMS is the procedural way that includes SQL syntaxes for relating tables with another and handling datas stored in tables. 1)rdbms ...
I have just started doing OOP design. My experience has been in RDBMS. Where we work with tables, relation between them defined using foreign keys. Can anyone pl. help in designing classes for a simple case here. There are two tables (states, districts). Districts contains stateId as foreign key. So state to district 1-many relation is there. Such things how do we design in oops. Thanx in advance
A database is an organized collection of information. It is structured so you can jump to the information by using a key, and find related infromation by navigating a path. A sequential (flat) file is not considered a database. ...
ODBC is an open standard for software providers to follow when creating an intermidate layer between the database and the application using the database. Having "open standards" usually means that different applications can write their code the same ...
View page << Previous 1 [2] 3 4 5 6 Next >>
Go Top
