How to Safely Store your Data in the Cloud make money online
How to Safely Store your Data in the Cloud What exactly is the cloud? It is basically the collection of computers on the internet that companies are using to offer their services. One cloud service that is being offered is a revolutionary storage method for your data. From music files to pictures...
Multiplexing techniques
12. Describe the Multiplexing techniques for digital signal transmission. Multiplexing is a technology to transfer digital or analog data in daily use devices like telephone and television. Here, we discuss the various multiplexing technologies used for data transmission. Multiplexing is a method of combining multiple analog massage signals...
Explain any three aggregate functions with examples
Explain any three aggregate functions with examples. Aggregate Functions are keywords in SQL used to manipulate values within columns for output purposes. A function is a command always used in conjunction with a column name or expression. There are several types of functions in SQL. An aggregate function is...
Explain embedded SQL
Explain embedded SQL. Embedded SQL is a method of inserting inline SQL statements or queries into the code of a programming language, which is known as a host language. Because the host language cannot parse SQL, the inserted SQL is parsed by an embedded SQL preprocessor. Embedded...
Explain Database architecture
Explain Database architecture There are following three levels or layers of DBMS architecture: • External Level •Conceptual Level • Internal Level Objective of the Three Level Architecture The objective of the three level architecture is to separate each user's view of the database from...
Explain ACID properties.
Explain ACID properties Explain ACID properties. ACID (Atomicity, Consistency, Isolation, Durability) is a set of properties that guarantee that database transactions are processed reliably. In the context of databases, a single logical operation on the data is called a transaction. For example, a transfer of funds from one...
Explain normalization in Database
Explain normalization. Explain normalization. In creating a database, normalization is the process of organizing it into tables in such a way that the results of using the database are always unambiguous and as intended. Normalization may have the effect of duplicating data within the database and...
Define XML and explain the structure of XML
Define XML and explain the structure of XML. Define XML and explain the structure of XML. XML stands for extensible markup language. XML was developed around 1996 and is a subset of SGML. It's documents conform to SGML. XML was made less complicated than SGML...
Explain Network and Relational data models
7. Explain Network and Relational data models. Explain Network and Relational data models The network model is a database model conceived as a flexible way of representing objects and their relationships. Its distinguishing feature is that the schema, viewed as a graph in which object types are nodes...
Define deadlock with example
6. Define deadlock with example. Define deadlock with example In a database, a deadlock is a situation that occurs when two or more different database sessions have some data locked, and each database session requests a lock on the data that another, different, session has already locked. Because the...
Define RDBMS with example
4. Define RDBMS with example. Define RDBMS with example RDBMS is the abbreviated form of Relational Data Base Management System. A relational database management system (RDBMS) is a database management system (DBMS) that is based on the relational model as invented by E. F. Codd, of IBM's San...
Explain about triggers
5. Explain about triggers. Explain about triggers A database trigger is stored code that is executed immediately after a predefined event. It is used to ensure the coordinated performance of related actions. Although implementation varies, all major relational databases support triggers. A database trigger is procedural code...
Define instances and schemas
3. Define instances and schemas. Define instances and schemas In DBMS, Instance is the information stored in the Database at a particular moment. Schema is the overall Design of the Database. In programming, we declare a variable which corresponds to "Schema". But its values changes as and when required...
Explain Database users
Explain Database users. Database Users Database administrators – DBA is responsible for authorizing access to the database, for coordinating and monitoring its use, and acquiring software and hardware resources as needed. Database designers – identify data to be stored in the database and choosing appropriate...
Explain the three levels in data abstraction
Explain the three levels in data abstraction. Explain the three levels in data abstraction. Three levels of data abstraction are: 1. Physical level : How the data is stored physically and where it is stored in database. 2. Logical level: What information or data is stored in...