answersLogoWhite

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

Sql server error 1053?

may be this will help you - http://www.sqlservercentral.com/Forums/Topic271276-5-1.aspx#bm271295

Can you put Linux on a blank disc and install it on a different computer and not have it on the one that you put it on the disc from?

Here is what happened, my family had a computer. Then we moved out to Pennsylvania and got a new one, then for Christmas we got another one. So we have three computers, problem is one of them has a virus that prevents us from getting on the internet and the anti-virus needs to be updated to fix the problem using the internet. During the move we lost the windows xp opperating disk. So what im trying to do is get Linux, the freeware operating system onto a disk and moving it to the computer to install Linux so we can use it again. But, I don't want to install it Linux on the computer that I put it on the disk from. So I want to know, can I get Linux on a disk without instaling Linux on the computer that I put it on the disk from. Please if you know how tell me I'm desprate.

~rhilly11(the asker of the question)

How do you convert the 1db to dbm?

dBm is defined as power ratio in decibel (dB) referenced to one milliwatt (mW). It is an

abbreviation for dB with respect to 1 mW and the "m" in dBm stands for milliwatt.

dBm is different from dB. dBm represents absolute power, whereas in audio engineering the decibel is usually a voltage ratio of two values and is used then to represent gain or attenuation of an audio amplifier, or an audio damping pad.

What is 1NF?

First Normal Form (1NF) is a property of a relation in a relational database. To be in 1NF, each attribute in a table must be atomic, meaning it cannot be further subdivided. Additionally, each attribute must contain a single value, not a list or set of values.

What are the two types of fragmentation Illustrate them with block diagrams?

Ans) In computer storage, fragmentation is a phenomenon in which storage space is used inefficiently, reducing capacity and often performance. Fragmentation leads to storage space being "wasted", and the term also refers to the wasted space itself.

There are three different but related forms of fragmentation: external fragmentation, internal fragmentation, and data fragmentation, which can be present in isolation or conjunction. Fragmentation is often accepted in return for improvements in speed or simplicity.

Internal fragmentation: Due to the rules governing memory allocation, more computer memory is sometimes allocated than is needed. For example, memory can only be provided to programs in chunks divisible by 4, 8 or 16, and as a result if a program requests perhaps 23 bytes, it will actually get a chunk of 24. When this happens, the excess memory goes to waste. In this scenario, the unusable memory is contained within an allocated region, and is thus termed internal fragmentation. Slack space is a very important source of evidence in computer forensic investigation.

External fragmentation

External fragmentation arises when free memory is separated into small blocks and is interspersed by allocated memory. It is a weakness of certain storage allocation algorithms, when they fail to order memory used by programs efficiently. The result is that, although free storage is available, it is effectively unusable because it is divided into pieces that are too small individually to satisfy the demands of the application. The term "external" refers to the fact that the unusable storage is outside the allocated regions. External fragmentation also occurs in file systems as many files of different sizes are created, change size, and are deleted. The effect is even worse if a file which is divided into many small pieces is deleted, because this leaves similarly small regions of free spaces.

0x0000

0x1000

0x2000

0x3000

0x4000

0x5000

Comments

Start with all memory available for allocation.

A

B

C

Allocated three blocks A, B, and C, of size 0x1000.

A

C

Freed block B. Notice that the memory that B used cannot be included for an allocation larger than B's size.

Characteristics of data warehouse?

Hi,

1. Subject Oriented

2. Integrated

3. Nonvolatile

4. Time Variant

Check Binary tree isomorphism?

//not sure if it is correct

bool isomorphic(struct Node* root1,struct Node* root2)

{

if(root1 root2->value)

return ( isomorphic(root1->left,root2->left) && isomorphic(root1->right,root2->right)

isomorphic(root1->right,root2->left) && isomorphic(root1->left,root2->right)

);

else return false;

}

Why do police use databases?

to keep track of people past offences to see if they need to be keeped an eye on

What is an integrated management system?

An Integrated Management System (IMS) refers to a unified framework that combines multiple management systems within an organization into a single cohesive structure. These management systems could include various standards, guidelines, and processes that the organization follows to achieve its objectives, improve efficiency, ensure compliance, and enhance overall performance.

Organizations often deal with multiple management systems related to different aspects of their operations, such as quality management (ISO 9001), environmental management (ISO 14001), occupational health and safety (ISO 45001), information security (ISO 27001), and more. Each of these systems comes with its own set of requirements, processes, and documentation.

An IMS aims to streamline and simplify these systems by integrating their common elements, processes, and documentation. This integration offers several benefits:

Efficiency: By consolidating overlapping processes and resources, an IMS reduces redundancy and streamlines workflows, leading to increased efficiency.

Consistency: An IMS ensures that consistent practices are followed across different areas of the organization, reducing confusion and promoting standardized approaches.

Resource Optimization: With an integrated system, organizations can optimize resource utilization, including personnel, time, and technology.

Risk Management: An integrated approach can provide a more holistic view of risks and opportunities, helping organizations address potential issues more effectively.

Cost Savings: Eliminating duplication and redundancy can result in cost savings in terms of time, effort, and resources.

Sustainability and Compliance: An IMS can help organizations meet regulatory requirements and maintain compliance with multiple standards in a more streamlined manner.

Improved Communication: An integrated system fosters better communication and collaboration across different departments and functions.

Implementing an IMS requires careful planning, coordination, and communication across the organization. It involves assessing the existing management systems, identifying commonalities, establishing a framework for integration, and updating documentation and processes accordingly. The organization might need to undergo training and cultural adjustments to ensure successful adoption of the integrated approach.

It's important to note that while an IMS offers many benefits, it can also be complex to implement, especially in larger organizations with diverse operations. However, if executed effectively, an integrated management system can lead to improved overall performance, increased customer satisfaction, and a more efficient and effective organization.

How is an action query is different from select query?

Select queries do not change the data. They will show lists of data and various statistics and other requirements. Action queries do things like update records or delete records, which is changing the data. That is the difference.

Define a relation?

Relation means that someone has a familial connection. It can also mean that things are similar or connected to each other.

What is the difference between primitive and non primitive data structure?

A primitive data structure is generally a basic structure that is usually built into the language, such as an integer, an array or a linked-list.

A non-primitive data structure is built out of primitive data structures linked together in meaningful ways, such as a binary search tree, AVL Tree, Hashtable, etc.

How do you convert from dBm to dBi?

Well, the question your asking is basically impossible. It's like asking to convert a gallon of water into cans of pop. It is possible to convert the gallon of water into cans of water not soda. So you can convert dBm to watts, not dBi.

What are advantages of heap file organization?

1) insersection becomes easy in heap file organization.

2) deleation process also becomes easy in heap file organization.

3) searching or retrival of data becomes hard(it take more time).

What is a wildcard on a database?

When You can search for how many people say like coke on a database

What characteristics in a database fields may have such as data type field name field size and field format?

What characteristics could a database field have, such as data type, field name, field size and field format?

How you draw ts diagram?

To draw a T-S (Temperature-Entropy) diagram, start by labeling the axes: temperature (T) on the vertical axis and entropy (S) on the horizontal axis. Plot the phase boundaries for water, including solid, liquid, and vapor phases, and include critical points and lines such as the melting and boiling lines. Use curves to represent phase changes, like the isothermal and isentropic processes, and ensure that the diagram reflects the thermodynamic properties of the substance being analyzed. Finally, annotate key points and processes to provide clarity on the various thermodynamic states represented.

What is a CRM system?

Answer 1:

CRM system is software that refers to practices, strategies and technologies mainly for sales activities and also used to manage and analyze customer reactions. CRM systems are designed to compile information on different customers or point of contact between the customers and the company which include company's website, telephone, live chat, direct mails and social media. CRM aims in higher revenues, not cutting costs. CRM solution improves sales and marketing efforts and enables organizations to provide superior services to customers. #AashnaCloudtech

Answer 2:

CRM stands for Customer relationship management which is used to organize, automate, and synchronize business processes mainly for sales activities, but also for customer support, marketing, and technical support.

File access methods explain?

A serial access file has data stored on it in the order in which it was written. Each new record goes at the end of the file. To read a record from the file it is necessary to read through all the preceding records first.


A sequential access file has data stored on it in the order of the data in a key field.



A direct access file is one where any record can be accessed without having to access other records first. This is also known as random access.