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
How do you recover database file using sql server?
A SQL recovery tool (see below) will help you repair corrupted .mdf files, tables, views, stored procedures, rules, defaults, user defined data types and triggers from Microsoft SQL server database & effectively recover large SQL Server database.
Recover sql server databases thanks to programmed method I would recommend you next utility
What do optimists tend to attribute their success to?
their own abilities; things beyond their control
What is the difference between derived attribute and normal attribute?
A normal attribute is an attribute present in a schema and which has to be entered while entering a tuple.
A derived Attribute is one which can be inferred(derived) from another normal attribute and it need not be a part of a schema.
For e.g.-> In a schema, Date-of-Birth is a normal attribute.While Age is a derived attribute which can be derived from the Date-of-Birth
What is advantage of paper based records?
Here are some examples:
- Written records are not destroyed when hard drives crash.
- You can access them without power
- Originals can be maintained
- Inexpensive compared to some forms of electronic data storage
5 Explain why the allocation of records to blocks affects database-system performance significantly?
To access a record, the entire block that containg the target record must be loaded into the main memory and it is time consuming. It involes seek time, rotational delay and block transfer time.
Alphabetic Data is in the form of Alphabets as well as space between two words. like Farhan ul Hasan , Karachi , Computer Studies etc.
How is a composite entity represented in an ERD and what is its function?
A Composite Entity is represented by a collection of Inter-related Entity types which togather represent a business Concept. An example of this concept is a Person's Health Record, Equipment Record, Equipment Maintenance Record.
What is the difference between single-valued attributes and simple attributes?
single valued attribute are one character in a record
What is an example of indexed sequential?
An example of indexed sequential access is a library catalog system. In this system, books are organized in a sequential manner by their titles or authors, but an index is maintained that allows users to quickly locate specific books based on keywords or categories. This hybrid approach combines the benefits of sequential access for browsing and indexed access for efficient searching.
What are pharmacy-benefits management firms?
Pharmacy-benefits management firms, or PBMs, are essentially intermediaries that negotiate discounts with pharmaceutical companies for large employers and managed-care insurers or health plans.
What is the difference between data model and schema in database?
As I understand it, a database schema is a physical entity, it describes the structure of exactly how the data is stored and is itself stored by DBMS for reference. Data model, on the other hand, is an abstract representation of database.
Part of AVG (anti virus software)
Hello Hans,
Please use latest version of AVG remover (build 1165), then remove all remained AVG folders* (if exist):
C:\Program files\AVG
C:\Documents and settings\All users\Application data\MFAData
C:\Documents and settings\All users\Application data\AVG8
C:\Documents and settings\All users\Application data\AVG9
C:\Documents and settings\All users\Application data\AVG10
Then check the AVG installation again. What is the current situation?
If the situation still persists, please gather (pack in an archive or zip file) latest AVG installation logs and "avgremover.log" from folder, where AVG remover has been run, upload the archive (zip file) to favorite online storage and provide us with link to uploaded file.
Thank you
* Some folders could be hidden by default Windows settings. To view hidden files and folders:
1. On the taskbar, click Start -> (Settings) -> Control Panel -> (Appearance and Personalization) -> Folder options.
2. Click the View tab.
3. Click ?Show hidden files and folders? (the name may vary depending on the operating system).
4. Click OK.
What is the difference between candidate key and primary key with example?
Any group of keys or columns (may be one or more than one) which can be used to uniquely refer to any row is together called as candidate key.
A primary key only one column name which can be used to uniquely refer any row.
there is no much difference b/w these two except the number of columns in consideration.
I am sure they do.
(although I have no direct knowledge of their data processing I cannot imagine that a company as large as Unilever would not have a great number of databases and so would need quite sophisticated database management systems to keep track of what they need to know!)
What are the characteristics of data in a data warehouse?
There are four key characteristics which separate the data warehouse from other major operational systems:
- Subject Orientation: Data organized by subject
- Integration: Consistency of defining parameters
- Non-volatility: Stable data storage medium
- Time-variance: Timeliness of data and access terms
What do extension and intentions of relations mean in dbms?
What is the main four phases of query processing in dbms?
Query processing can be divided into four main phases: decomposition, optimization, code generation, and execution.
What is the structure and organization of data in a database called?
Data hierarchy is the structure and organization of data, which involves fields, records, and files. (c) Bidgoly MIS2.
Network Database
What are the different types of database languages?
Two main types:
Relational Calculus based Language
Relational Algebra based Language.
These languages provide similar set of operations but with different syntax. Calculus based is more kind of procedural and near to English, while Algebra based uses a set of symbols for queries.
