answersLogoWhite

0

i dont know the answer

User Avatar

Wiki User

12y ago

What else can I help you with?

Continue Learning about Information Science

What is RISC in dbms?

RISC in DBMS stands for Reduced Instruction Set Computer. It refers to a type of processor architecture that focuses on the simplicity of instructions to improve performance. In database management systems, RISC processors can optimize query processing and data manipulation tasks efficiently.


What is subquery in dbms?

A subquery in DBMS is a query nested within another query. It is a way to retrieve data that depends on the result of another query. Subqueries can be used in a variety of ways, such as filtering, joining, or defining a derived table.


How the user requests for the required data is handled by DBMS explain with the help of example?

In a DBMS, the user requests for data by submitting queries written in a structured query language (SQL). These queries are then processed by the DBMS to locate and retrieve the requested data from the database tables. For example, a user can request all records of employees who work in a specific department by writing a SQL query that specifies the department's name and selects the relevant data fields. The DBMS then executes this query, retrieves the matching data from the database, and presents it to the user.


What are distributed-databases in dbms?

Distributed databases in a DBMS are databases that are stored on multiple computers across a network. They allow for data to be spread out and accessed simultaneously from different locations, which can improve performance and scalability. Distributed databases can enhance fault tolerance and reduce the risk of data loss.


Why fragmentation and date replication are useful in Distributed DBMS?

Most people use Relational databases to simplify work. All a Distributed DBMS is a Relational Database spread over a wider area than the workplace. Fragmentation and Date replication are complications and experience says that Distributed DBMS are built to make life simpler

Related Questions

Why global query optimization is difficult in distributed dbms?

1:parallel execution 2: Additional communication cost 3: Transparency and replication


What is RISC in dbms?

RISC in DBMS stands for Reduced Instruction Set Computer. It refers to a type of processor architecture that focuses on the simplicity of instructions to improve performance. In database management systems, RISC processors can optimize query processing and data manipulation tasks efficiently.


Query execution statistics in query processing in dbms?

create table vino(char name(6));


What is quel in dbms?

quel is a QUEry Language used in relational database


What is subquery in dbms?

A subquery in DBMS is a query nested within another query. It is a way to retrieve data that depends on the result of another query. Subqueries can be used in a variety of ways, such as filtering, joining, or defining a derived table.


What is a subsystem of a DBMS?

A subsystem of a Database Management System (DBMS) refers to a specialized component that performs a specific function within the overall architecture of the DBMS. Common subsystems include the Storage Management subsystem, which handles data storage and retrieval; the Query Processor, which interprets and executes database queries; and the Transaction Management subsystem, which ensures data integrity and consistency during concurrent operations. Each subsystem works together to provide the functionality and reliability expected from a 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.


How the user requests for the required data is handled by DBMS explain with the help of example?

In a DBMS, the user requests for data by submitting queries written in a structured query language (SQL). These queries are then processed by the DBMS to locate and retrieve the requested data from the database tables. For example, a user can request all records of employees who work in a specific department by writing a SQL query that specifies the department's name and selects the relevant data fields. The DBMS then executes this query, retrieves the matching data from the database, and presents it to the user.


Query processing in a distributed database environment?

its a BEAR


The execution of a user program which interacts with the distributed DBMS ia called?

Transaction


DBMS used in web-based application?

MYSQL - a freely distributed DBMS Microsoft SQL Server - the product of old-brand Microsoft Oracle - a strong and powerful DBMS, which is normally used by larger enterprises nowadays.


How to solve the query processing of distributed database management system?

o