0
Database Programming
Databases are collections of tables that maintain and display information, often collaboratively; this information can be used for interaction with an application or gaining general knowledge. Questions about database engines and modifying or using them belong in this category.
8,803 Questions
database user
What does database administrator do?
a data administrator helps to install programs in a system it updates data and makes sure the data is secured
What are the distributed database access primitives?
dISTRIBUTED. DATABASE. ACCESS. PRIMITIVES. In the examples of the ... usemore powerful primitives
What are the difference between ddl and dml commands?
The basic difference between DDL and DML is the commands they provide . The dml (data manipulation language) provides statements to enter, update, delete and perform complex queries on these tables while the ddl(data description language) provides statement for the creation and deletion of tables, indexes, views etc.
What workplaces keep databases?
Various workplaces maintain databases, including businesses, educational institutions, healthcare organizations, and government agencies. Corporations often use databases for customer relationship management, inventory tracking, and financial records. Educational institutions store student information and academic records, while healthcare organizations maintain patient records and treatment histories. Government agencies use databases for managing public records, statistics, and services.
Why should a number be stored as text data type?
because if u do it as number then the 0 at the start would automatically be removed so u write in text otherwise the data would be wrong
How do you create dbms using c?
Creating a Database Management System (DBMS) using C involves designing a structure to store and manage data, typically in files. You would start by defining a data model and implementing functions for operations such as creating, reading, updating, and deleting records (CRUD). Use file I/O operations to persist data, and consider implementing indexing for efficient data retrieval. Additionally, you might include features like transaction management and user authentication for a more robust system.
What kind of motivations is required for data mining?
The Street lawyers or governments were given the chance to appreciate them
Why it is important to have a well structured filing system?
A well-structured filing system is crucial for efficient information management, enabling quick access to documents and data when needed. It reduces the risk of losing important files and minimizes the time spent searching for information, enhancing productivity. Additionally, a systematic approach helps maintain organization and clarity, making it easier to comply with legal and regulatory requirements. Overall, it promotes better decision-making and communication within an organization.
How do you contact meenan security systems management?
We have Meenan Security for a private residence. I would like to contact
upper mangement with my concerns regarding Meenan Security supporting
the Dutchess County area. Please help!
What are the characteristics of financial management information system?
A financial information management system is accurate, integrated with other systems and analytical. A good system will help management avoid problems by generating reports.
Which role monitors incoming invoice data from external systems such as Wide Area Work Flow WAWF?
Invoice Interface Processing Monitor
What is database management sysstem?
A database management system (DBMS) is a software package with computer programs that controls the creation, maintenance, and use of a database. It allows organizations to conveniently develop databases for various applications. Adatabase is an integrated collection of data records, files, and other objects. A DBMS allows different user application programs to concurrently access the same database. DBMSs may use a variety of database models, such as the relational model orobject model, to conveniently describe and support applications. It typically supports query languages, which are in fact high-level programming languages, dedicated database languages that considerably simplify writing database application programs. Database languages also simplify the database organization as well as retrieving and presenting information from it. A DBMS provides facilities for controlling data access, enforcing data integrity, managing concurrency control, and recovering the database after failures and restoring it from backup files, as well as maintaining database security.
Why DBMS is preferred rather than file processing system?
er diagram for hospital management
eitity set are
doctor
department
pesent
nurse
test
What are disadvantages of recreational database?
It's slacking off all the time rather than being an actual database.
Ans2:You sure you don't mean "Relational database"?Why relational database approach is better than earlier method?
Relational model helps in logical relation between two dimensional tables . It maintains data integrity and eliminates data redundancy. Earlier methods involved redundant set of data for maintaining relations between set of data.
What SQL keyword must be used to remove duplicate rows from the result?
The DISTINCT keyword can be used to return only distinct (different) values.
SQL SELECT DISTINCT SyntaxSELECT DISTINCT column_name(s)FROM table_name
When does a DBA use backwards recovery?
-Undo problem transactions
-Apply before images from log to undo their updates
A Document Type Definition (DTD) is a set of markup declarations that define a document type for an SGML-family markup language (SGML, XML, HTML).
A DTD uses a terse formal syntax that declares precisely which elements and references may appear where in the document of the particular type, and what the elements' contents and attributes are. A DTD can also declare entities which may be used in the instance document.
