Computer Terminology
Computer Programming
Database Programming

What are the DBMS tools for structured query language?

Top Answer
User Avatar
Wiki User
Answered 2008-07-29 02:38:25


* Unless you your contributions will be anonymous. However, your computer's internet address will be recorded so that contributors can trace * To add a personal comment on the answer or ask about the question, use the instead.

User Avatar

Your Answer


Still Have Questions?

Related Questions

What is the language used by most of the DBMS for helping their users to access data?

query language

What is quel in dbms?

quel is a QUEry Language used in relational database

What is the most commonly used database application?

Among popular database applications SQL (structured Query Language), IBM's DB2, and Oracle... I believe the most widely used DBMS to be Microsoft Access

What is database management system?

As the name suggests, a DBMS is software that creates and maintains a database (typically a relational database these days) as well as the data it contains. Besides the core software that oftens utilizes SQL (Structured Query Language) as its access method, many of the larger DBMS now in use also have extensions to create user forms, reports, query wizards, scripting and the like.

What are the differences between sql and mysql?

SQL (structured query Language) is standard language that is used in Mysql, Oracle, and Sql server. only difference between SQL server, Oracle, and Mysql. Sql server is micosoft product & a data Base Management System(DBMS) Oracle is also a DBMS by Oracle. mysql is open source and free by SUN also DBMS. All above used SQL in their Queries............ enjoy.........

What is query processor in distributed dbms?

i dont know the answer

Describe Procedural query language and non procedural query language in DBMS?

A query language is a language in which a user requests information from the database. These languages are usually on a level higher than that of a standardprogramming language. Query languages can be categorized as either procedural or non procedural.In a procedural language, the user instructs the system toperform a sequence of operations on the database to compute the desired result.In a non procedural language, the user describes the desired information withoutgiving a specific procedure for obtaining that information.

Is java DBMS?

no, Java is not dbms.. Java is a programming language Dbms is database

Query execution statistics in query processing in dbms?

create table vino(char name(6));

What is relation between sql and dbms?

As we all know that SQL stand for sequence query language. it is a unique language use for control or manipulate data in DB. And DBMS is a software. So they both are noting without each other. There is a relationship of compiler and language in between them.(written bySYED FATEHYAB AHMEDfrom biit)

What are the similarities between oracle dbms and access dbms?

Oracle and Access are both RDBMS's (Relational Database Management Systems). Consequently they both use tables which have 'keys' to retrieve rows, and use 'foreign keys' to other tables to 'relate' those rows together. Oracle and Access also both use SQL (Structured Query Language) to allow you to use the database (for example: "select * from customer_table where customer_number = '12345'"), although you can use tools which provide a more graphical environment to produce the underlying SQL. The real difference between the two is that Oracle is an industrial strength RDBMS.

How DBMS works in computers?

DBMS actually manages the storage, without DBMS you have to explicitly store the table definition and its contents in a file and retrieve it. This is a headache if there are many tables, this process is simplified by the software called DBMS, using this you can query the tables. query is nothing but calling the functions of the program called DBMS, if you want even you can create your own DBMS in c , java etc and have your queries defined in the form of functions.

How does a database work?

There are two kinds of databases. RDBMS and DBMS. Anything which stores data in rows and columns can be called as a database. Even a text file can be a database if it contains data in this format. XML files also can be treated as database. We can query a database using SQL (Structured Query Language) to extract information from a database. This data can be manipulated in different ways to generate reports or use in your software.

How does one use a relational database?

Nearly all relational databases currently in use utilize SQL (Structured Query Language) to both create and maintain the database structure itself as well as the data within it. The SQL code can either be created directly or, for the less technically inclined user, indirectly through forms and query wizards contained within many database management systems (DBMS).

How do you insert a new row in dbms?

Database rows are held in a structure called table (there are several types of tables). Each table is comprised from columns, defined by name and data types. One has to use the Structured Query Language (SQL), in order to perform data changes, using DML (Data Manipulation Language), such as INSERT (adding), UPDATE (changing) and DELETE (removing) data.

What are the differences between a sql server dba and a sql dba?

The term SQL alone implies Structured Query Language as per the ANSI standard. Every Database Management System (DBMS) has its own "software" that makes it work. That being said, the term "SQL DBA" alone does not make any sense without mentioning the vendor specific DBMS you are managing. So, an SQL Server DBA is an administrator of Microsoft's SQL Server.

DBMS facilities required for Recovery and back up?

1.The data definition facility or data definition language (DDL). 2.The data manipulation facility or data manipulation language (DML). 3.The data query facility or data query language [DQL]. 4.The data control facility or data control language [DCL]. 5.The transaction control facility or data control language [TCL].

Difference between file processing and dbms?

DBMS overcomes all the disadvantage of traditional FPS. The main difference between FPS and DBMS is that FPS do not support data sharing, data security and non redundancy.

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.

Who manufactures SQL servers and what is this DBMS' current version number?

An SQL server is any server that implements the Structured Query Language. SQL is the standard of the American National Standards Institute (ANSI) and the International Organization for Standardization (IOS). It was developed by IBM in the 1970s. It appears the latest revision was made in 2014. No one company manufactures SQL servers.

What is difference between C plus plus and FOXPRO?

C++ is a generic, general purpose, object-oriented, structured programming language used to produce native machine code programs. FoxPro is a procedural language and Database Management System (DBMS).

Is Dbms a language or system?

Database Management Systems (Abbr as DBMS) is a system which manages your database. In general, it is a set of software programs to create, store and maintain your data in a database. These software programs are provided by more than single vendor. For example: Oracle SQL IBM DB2 and MS Mysql

What are dbms languages?

DBMS is Database management system . The DBMS language are those that are used to store and maintain the data in the database. Example PL/SQL.

What are the end user tools of dbms?

fudu site hai

Why use a DBMS?

-Large amounts of data-Data is very structured-persistent data-valuable data