Already have an account? Get multiple benefits of using own account!
Login in your account..!
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
Data Definition Language
It organises the data in the form of columns and rows. But what does the data field column of table accumulate? How do you describe it using SQL?
The Data definition language (DDL) defines a set of commands used in the modification and creation of schema objects such as indexes, tables, views etc. These commands give the ability to create, drop and alter these objects. These commands are linked to the management and administrations of the databases. Before and after every DDL statement, the current transactions are implicitly committed, that is changes made by these commands are permanently stored in the databases. Let us talk about these commands in more detail:
CREATE TABLE Command
Column_name1 data type (column width) [constraints], Column_name2 data type (column width) [constraints], Column_name3 data type (column width) [constraints],
Where table name assigns the name of the table, column name describes the name of the field, data type specifies the data type for the field and column width distribute specified size to the field.
Have a look around the site, and at some of the sites they have featured. These are all examples of bad design, and also offer an explanation about why they fall into this category
To do the division operation R1 ÷ R2, R2 should be a correct subset of R1. In the following example R1 have attributes A and B and R2 have only attribute B so R2 is a correct subse
Events4Fun is an event management company in Europe with branches in South America as well. The company is well-known for its efficiency, good-quality services, and affordable char
How does the system cope up with a record crash when recovery is going on after the first crash? Ans: In a system the undo and redo operations are needed to be idempotent to c
what is attribute is attribute inheritance in dbms?
What is storage manager? A storage manager is a program module that gives the interface between the Low level data kept in a database and the application programs
Redo Logs: Any database must have minimum two redo logs. These are the rules for the database; the redo logs record all modifies to the system objects or user objects. If any type
Benefits of Sequential File Organisation It is quick and efficient when dealing with huge volumes of data that require being processed periodically (batch system). Dra
Explain weak and strong entity type ? Weak and Strong entity type: An entity set which does not have a primary key is referred to as a weak entity set. The existence of a wea
Why do you go for sorting your query results? SQL SELECT command to fetch data from MySQL table. Whenever you select rows, the MySQL server is free to return them in any order
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd