What is basic SELECT statement?

-
Image
SELECT Statement A SELECT statement retrieves data from the database. With SELECT statement PROJECTION, SELECTION and JOIN can be performed on database tables. As data in relational database is stored in TABLES. TABLE has ROW and COLUMN structure. With SELECT statement all rows and all columns can be retrieved, this is known as PROJECTION. But, if rows and columns are retrieved on the basis of some condition, it is known as SELECTION. And suppose if some information is needed and that is stored in two or more different tables but are related, use JOINS to retrieve it from two or more tables. In SQL, basic SELECT statements are as follows: SELECT  * FROM  [ table_name ] ; SELECT   [ column1 ] ,  [ column2 ] ,  [ column3 ] ,   .....   FROM   [ table_name ] ; SELECT and FROM are known as clauses.  SELECT clause allows to specify columns to be selected from the database table.  FROM clause allows to specify table name that has those column to be s
16 comments

Differentiate between DDL and DML

-

DDL 

DDL stands for Data Definition Language. DDL comprises of statements that are used to define the database structure or database schema.

 Following are DDL statements:

 CREATE - Statement used for creating database objects like TABLE, VIEW etc.

 ALTER - Statement used for modifying database structure.

 DROP - Statement used for deleting database objects.

 TRUNCATE - Statement for removing all records from a table and free the allocated space.

 RENAME - Statement for renaming database object.

DML

DML stands for Data Manipulation Language. DML comprises of statements for managing data within the database.

 Following are DML statements:

 SELECT - Statement used to retrieve data from the TABLE.

 INSERT - Statement used to insert/push data in the TABLE.

 UPDATE - Statement used to update the existing data in the TABLE.

 DELETE - Statement used to delete data from the TABLE. 


Comments

Post a Comment

Popular posts from this blog

Define the terms: domain, tuple, attribute and relation

-
Image
General Definitions Relation: A relation in a relational database is described as a table. Table is organized into rows and columns. Attribute: A column header of a table is known as attribute of a relation. Tuple: A row in a table represents the record of a relation and known as a tuple of a relation. Domain : A set of possible values for a given attribute is known as domain of a relation. A domain is atomic, that means values are indivisible. For example, set of values for attribute FirstName of an EMPLOYEE relation are atomic.
Read more

With the help of block diagram explain the architecture of a DBMS.

-
Image
Database System Architecture [ REF: Fundamentals of Database Systems, Elmasri, Navathe, 6e ] Following block diagram explains the simplified DBMS architecture. Architecture is divided into two major blocks. First block represents the different types of end users and their respective interfaces for interacting with the database system. Second block  shows the internal components responsible for the storage management of data and processing of transactions. DBA Staff:  Database administrative staff, defines database structure. DDL Statements and Privileged Commands:   DBA staff use DDL (Data Definition Language) statements and Privileged Commands (Access control statements allocated as per assigned roles) to define database structure and make changes in definitions as per the requirements on timely basis. DDL Compiler:   It compiles DDL statements and record database definitions in system catalog or data dictionary.  Data Dictionary/Storage Catalog: Data
Read more

What are the different types of database users?

-
Following are the types of database users: 1) Application Programmer:    A technical person who writes database application programs. They are also known as Software Developer or Software Engineer. They write programs by using computer programming languages and development tools. Languages: Java, COBOL, PASAL, PL/SQL etc are used. Development tools: Eclipse, JDeveloper, SQL Developer etc are used. Application programs that interact with database are developed as per the user requirements and include functionalities of creating, reading, updating and deleting data from the database. These are commonly known as CRUD operations.   2) Naive Users: Naive users use application programs written by application programmer for interacting with  the database. These users don't have much knowledge about database but thy use predefined applications to access required data from the database.  Clerk working at the LIC office to maintain customer policy data is a naive u
Read more