0
What else can I help you with?
How do you explain a database?
A database is a server, or storage spot were information is stored. The stored information can range from user information to settings. http://en.wikipedia.org/wiki/Database
Which type of data is used to explain a relationship?
A foreign key constraint is used to represent a relationship in a RDBMS (relational database management system).
Explain how atomicity durability is implemented in DBMS using shadow copy scheme?
The recovery-management component of a database system can support atomicity and durability by a variety of schemes. We first consider a simple, but extremely inefficient, scheme called the shadow copy scheme. This scheme, which is based on making copies of the database, called shadow copies, assumes that only one transaction is active at a time. The scheme also assumes that the database is simply a file on disk. A pointer called db-pointer is maintained on disk; it points to the current copy of the database. In the shadow-copy scheme, a transaction that wants to update the database first creates a complete copy of the database. All updates are done on the new database copy, leaving the original copy, the shadow copy, untouched. If at any point the transaction has to be aborted, the system merely deletes the new copy. The old copy of the database has not been affected. If the transaction completes, it is committed as follows. First, the operating system is asked to make sure that all pages of the new copy of the database have been written out to disk. (Unix systems use the flush command for this purpose.) After the operating system has written all the pages to disk, the database system updates the pointer db-pointer to point to the new copy of the database; the new copy then becomes the current copy of the database. The old copy of the database is then deleted.
Define DDL and DML?
SQL These are the main categories are DDL(Data Definition Language) DML ( Data Manipulation Language) DQL( Data Query Language) DCL( Data control Language) Data administration commands Transactional control command. ddl includes insert ,delete ,update values it include select statements, it include insert statement, it includes drop statements
Explain the different types of constants n variables in C?
explain loop structrunes
Database?
form_title=Database Design form_header=Transform your company by incorporating a new database design. What program will the database be used with?=_ Please explain what you will be using the database for?="" Do you have a database that you're already using?= () Yes () No
Explain architecture of Distributed Database systems Also explain the reasons for building distributed database systems?
1 Explain architecture of Distributed Database systems? Also, explain the reasons for building distributed database systems?
What are the characteristics of database?
chandranana explain the characteristic of database?
What is relational database Explain the purpose of creating database?
A relational database is a type of database that stores and organizes data in tables with a predefined structure. The purpose of creating a database is to efficiently store, manage, and retrieve data for various applications or systems. Databases help to ensure data integrity, enable data sharing, provide a structured way to store information, and support data analysis and reporting.
Explain three disadvantages of centralized database and distributed database?
what are the disadvantages of centralized database system
Explain how a database makes paying for a product online possible?
explain how database makes paying for products on the internet possible?
How would one explain what an SQL server is?
SQL server, or a Structured Query Languange server, is Microsoft's relational database management system. As a server it provided different needs, like data warehousing and web-enabled databases.
Explain how designers use different construction features to help the user access information on websites?
Explain how designers use different construction features to help the user access information on websites
Database Design?
form_title=Database Design form_header=Transform your company by incorporating a new database design. What program will the database be used with?=_ Please explain what you will be using the database for?="" Do you have a database that you're already using?= () Yes () No
Explain what manual and electronic and databases are?
one is made by an onion and the other by a garlic
Functions of database manager in Database management system. explain the functions with example.?
functions of DBA in DBMS
What are the three design goals for relational databases and explain why each is desirable.?
Data integrity: Ensuring that data stored in the database is accurate and consistent by enforcing constraints, such as unique keys and foreign keys, to prevent invalid data. Scalability: Allowing the database to efficiently handle growing amounts of data and user load by optimizing data storage, indexing, and query performance. Maintainability: Simplifying the process of database maintenance, updates, and modifications by using normalization, clear data modeling, and documenting database structures.
