0
There are three parts of structure query language (sql) .
1.dml
2.ddl
3.dcl
1. In data manipulation language (dml) we can insert,update and delete a record.
2.in data definition language (ddl) we can change the structure of data like alter a table,create object ,drop and rename an object.
3.data control language (dcl) we can use security rights like grant ,revoke .
Add your answer:
Earn +20 pts
Is SQL DBMS or RDBMS?
dbms
What are dbms languages?
DBMS languages are specialized programming languages used to interact with databases. Common DBMS languages include SQL (Structured Query Language) for querying and manipulating data, and PL/SQL (Procedural Language/SQL) for developing procedures and functions within a database system. These languages are designed to facilitate communication with the database management system and perform various operations on the data stored in the database.
What is relation between sql and dbms?
SQL (Structured Query Language) is a programming language used to communicate with relational database management systems (RDBMS). DBMS (Database Management System) is a software system that allows users to create, maintain, and control databases. Essentially, SQL is the language used to interact with and perform operations on databases managed by DBMS.
Examples for dbms and rdbms?
My sql, Microsoft sql , Microsoft Access, dBase, Filemaker pro are the examples for dbms and oracle and sql server are the examples for rdbms
What is the language used by most of the DBMS for helping their users to access data?
SQL (Structured Query Language) is the language used by most DBMS (Database Management Systems) to help users access data. It allows users to perform tasks such as querying databases, manipulating data, and managing database structures. SQL is a standardized language that is widely used in the industry.
List some dbms and rdms software?
The name of few DBMS are FOXPRO, MS-ACCESS, SQL Server, My SQL, ORACLE, etc.
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.
What are the differences between sql and mysql?
SQL is short for Structured Query Language, and MySQL is a database management system, like SQL Server 2005, Oracle.An example would be other programming languages like BASIC and QBASIC where BASIC is the generic term for the BASIC programming language and QBASIC is Microsoft's version (quick BASIC) and TURBO BASIC was Borlands version.oracle supports the user defined datatypes,where as mysql not support all these types of datatypes, like user defined , and cursors like these stuff;;
What is data sub language?
A data Sublanguage is a computer language used to define or manipulate the structure of a relational database management system(DBMS) e.g QBE, SQL.
What is data sub-language?
A data Sublanguage is a computer language used to define or manipulate the structure of a relational database management system(DBMS) e.g QBE, SQL.
Can be executed sql statements without a dbms?
yes
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
