database

  1. steve taylor

    Help Me/Question What Are The Advantages Of Using Stored Procedures?

    The main advantages of the stored procedures are listed below:- It provides greater security. Decreased network traffic. SQL command can be optimized so easy in use the SQL command. Code sharing which reduce the overall work. It have standardized processing . There are specialization among...
  2. steve taylor

    Help Me/Question What Is The Difference Between Differences Between Structured Data And Unstructured Data.

    Structured data :- Structure data which maintain a structure. Structure data are stored in tabular form in the data base. The most important structure data are character, number etc Unstructured data:- A data which can not be stored in the table, like multimedia data such as documents...
  3. steve taylor

    Help Me/Question What Is 1 Nf (normal Form)?

    The first normal form is the first and the simplest type of normalization that can be implemented in a database. The main rules of the first normal forms are :- 1.Remove duplicate columns from the same table. 2.Create separate table for each group of related data and each row have unique column...
  4. steve taylor

    Help Me/Question What Is Dml (data Manipulation Language)?

    Data manipulation language (DML) that enable users to access on manipulate (read , write, update) data as that is organised by appropriate data models. Procedure of the data manipulation language :- Data manipulation language (DML) requires a user to specify the what data are needed and how to...
  5. steve taylor

    Help Me/Question What Is Atomicity And Aggregation?

    Atomicity:- Atomicity means a transaction should complete its all the operations or perform non of the operation. If the transaction fail in between execution then it rollback to its previous state without any changes. Aggregation:- Aggregation is a process in which relation between two entity...
  6. steve taylor

    Help Me/Question What Are The Features Of Database Language?

    Feature of the database languages are as given below :- Database management system have specific configuration and management of storage engine. Computations to modifications of query results by computation like counting, summing, averaging, grouping, sorting and cross product constraint. It’s...
  7. steve taylor

    Help Me/Question What Is The Object Oriented Database?

    Relational database (RDBMS) used to store the conventional data like employee table in the form of table which contain row and columns . row are called as tuple and column are called as attribute. Where as Object Oriented data base used to store the data in the form of Objects. It is used to...
  8. steve taylor

    Help Me/Question What Is Transparency In Database ?

    Data base is the huge collection of Disk. It may be at one place and distributed over various geographical region. When we store any date in the database we do not know about its location where it is stored . It may be on the local disk and some where else.Transparency means hiding the...
  9. steve taylor

    Help Me/Question How To Find Super Key Of Given Relation?

    Super key :- Set of the attribute which determines all the attributes of the relation. In a relation more the only super key may be possible. How to find super key for given relation. Student (ABCDE) Function dependencies are :- AB determine C C determine DE How many super keys are possible...
  10. Doominic anderson

    Help Me/Question What Is Rollback And Commit?

    In SQL DDL,DML,DCL languages are used to manage the whole database,one more language is TCL. TCL stands for Transaction Control Language,these commands are used to manage the transactions in the database.These are mainly used to manage the changes which is made by DML statements. TCL commands...
  11. Doominic anderson

    Help Me/Question What Is Partial And Full Functional Dependencies?

    Functional dependency is one of the important property of DBMS. In a given relation some attributes sets are present,one attribute set is functional dependent on attribute set of another if each value of one set is EXACTLY ONE value of another set. Functional dependency is mainly two type Full...
  12. Doominic anderson

    Help Me/Question Describe The Constraints Of Table Level And Column Level?

    SQL constraints are rules forced to apply on database to limit of data that can inserted into the table.to maintain its accuracy and integrity of data inside the table. Constraints are divided into two types i.e. table level constraints and column level constraints. Which constraints belong to...
  13. Doominic anderson

    Help Me/Question What Is Nonsubversion Rule Given By E.f Codd?

    E.F.codd is a computer scientist who invented the relational model for database management.Based on relational model relational database was created. It is in the form of tables which contains its schema,attributes,records e.t.c. E.F.Codd has given 12 rules to check dbms's concepts against its...
  14. Doominic anderson

    Help Me/Question What Is Difference Between Grant And Revoke?

    DCL stand for data control language and it is used to control the privilege in database. For creating database,database table,columns,rows,insertion,updation,deletion e.t.c. we need privilege. DCL controls and manage all the actions done on the database. Two DCL commands are grant and revoke...
  15. Doominic anderson

    Help Me/Question Why Views Are Used In Dbms?

    DBMS is a collection of huge amount of data,while it is not introduced,traditional files are used to stored the data in a restricted manner,we cannot store more data and every time we have to create a new file to stored another type of data. DBMS has a huge collection of properties which enables...
  16. selvaa

    My Suggestion 6 Steps To Follow If You Get A Message “this Site May Be Hacked”

    6 Steps to follow if you get a message “This site may be hacked” For tackling hacked spam in search results Google has rolled out a set of algorithmic changes. There is a great increase in the number of hacked site and also a very high increase in the hacked site reconsideration request...
  17. steve taylor

    Help Me/Question What Is Sql Injection?

    There are some weakness are available in the every programming language. SQL have also a some weakness or we can say that illegal use of some command. SQL injection is the technique in which hacker inject SQL commands into an SQL statement to access the database content illegally. How to detect...
  18. steve taylor

    Help Me/Question What Is The Distributed Database And Its Advantages?

    Distributed means spread the data at the various places and make a connection between them to access them it is normally accomplished by networking. In the distributed database system data are stored at the various places and all the database are connected by the network to access them . What...
  19. steve taylor

    Help Me/Question Relational Database Versus Object Oriented Database.

    Relational database :- It is the convention database. It stored the data in the row and column form. Example :- Relational data base which store the record of engineering students. Object Oriented database:- It stores the data in the form of Objects . Example :- It is used to store data of...
  20. steve taylor

    Help Me/Question If Locking Is Not Implemented ,what Issue Can Occur?

    Locking are used to keeps the database in the consistent state. Means it prevent the data base from filling and retrieving the incorrect value by the process. Because database contain large amount of data and that data is accessed by the more then one customer at the same time . So there is a...
Top