0
Advantages and disadvantages of data manipulation language in sql?
Wiki User
∙ 14y ago
advantages of data manipulation language:
1.the DML statements can modify the data stored in a database.
2.user can specify what data is needed.
3.dml tends to have many different flavours and capabilities between database vendors.
4.it provides efficient human interaction with the system.
disadvantages of data manipulation language:
1.dml cannot be used to change the database structure.
2.tables or columns cannot be created or deleted using dml.
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
What are advantages and disadvantages of circular queue over ordinary queue?
Circular queues are very efficient and work well with low level codes. Ordinary queues are the standard type of queue but they do not maximize memory data well.
Disadvantages of logical data modelling?
1. Database may need completely redoing if a single field in one relational table has to be changed. 2. If an ERD is resolved incorrectly then it would have to be redone.
Difference between error control and flow control?
Flow Control:is one important design issue for the Data Link Layer that controls the flow of data between sender and receiver.In Communication, there is communication medium between sender and receiver. When Sender sends data to receiver than there can be problem in below case :1) Sender sends data at higher rate and receive is too sluggish to support that data rate.To solve the above problem, FLOW CONTROL is introduced in Data Link Layer. It also works on several higher layers. The main concept of Flow Control is to introduce EFFICIENCY in Computer Networks.Error Control:Network is responsible for transmission of data from one device to another device. The end to end transfer of data from a transmitting application to a receiving application involves many steps, each subject to error. With the error control process, we can be confident that the transmitted and received data are identical. Data can be corrupted during transmission. For reliable communication, error must be detected and corrected.Error control is the process of detecting and correcting both the bit level and packet level errors.Types of ErrorsSingle Bit ErrorThe term single bit error means that only one bit of the data unit was changed from 1 to 0 and 0 to 1.Burst ErrorIn term burst error means that two or more bits in the data unit were changed. Burst error is also called packet level error, where errors like packet loss, duplication, reordering. BY RAHUL SAGORE from IIPS, INDORE
Characteristics of oops?
OOP stands for object oriented programming. Some characteristics of it include emphasis on data rather than procedure, programs are divided into entities known as objects, and data Structures are designed such that they characterize objects.
What are the advantages and disadvantages of servlet?
Servlets are an integral part of any J2EE Web application. The key benefits of using Servlets in our web applications are: a. They are faster than CGI scripts because each CGI script produces an entirely new process that takes a lot of time to execute, whereas a servlet creates only a new thread. b. Servlet API is standard and available easily on the internet (like JSPs) c. Servlets have the advantages like ease of development & platform independence (like Java) d. They can access all the J2SE and J2EE APIs e. Can take the full advantage & capabilities of the Java programming langauge As you can see, there are numerous advantages of using the Servlet & JSP technologies. This is exactly why numerous organizations use them as a staple part of their J2EE application development work. The Disadvantage would be that Servlets are a little difficult to learn and use.
What are the elements of SQL?
Data manipulation language(DML) data Defenition language(DDL) data control Language(DCL) Transaction Control
Advantages and disadvantages of manual data processing?
disadvantages in data manual processing
What are the advantages and disadvantages of data collection methods in statistics?
There are both advantages and disadvantages of data collection methods in statistics. The main advantages are the metrics and correlation one can draw from statistics. The disadvantages stem from sampling errors.
What are the advantages and disadvantages of data compression?
hahaaha
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].
Three components of database management system?
1. A data definition language 2. A data manipulation language 3. A data dictionary
What methods are there of entering data into a Database?
Data in a database table can be inserted by the help of Data Manipulation Language, by writing query in language like Sql.
What is the full form of ddl and dml?
ddl: data definition languagedml: data manipulation language
What are the advantages and disadvantages of automated data capture?
They have no eyes
What are the advantages of SQL?
SQL allows for easy access and retrieval of large amounts of data, provides a standardized language for interacting with databases, and offers powerful tools for data manipulation and analysis. Additionally, SQL supports data integrity and security features to ensure reliable and secure data management.
The advantages and disadvantages of primary data?
Advantages and Disadvantages of primary data are: Advantages 1. Data is basic 2. Unbiased information 3. Original data 4. Data from the primary market/ population 5. Data direct from the population. Disadvantages. 1. Large volume of data. 2. Huge volume of population. 3. Time consuming 4. Direct and personal intervention has to be there. 5. Raw data.
Advantages and disadvantages of object oriented databases?
advantages of object oriented data base
