हिंदी

Write any three DDL commands.

Advertisements

प्रश्न

Write any three DDL commands.

टिप्पणी लिखिए
Advertisements

उत्तर

  1. CREATE TABLE Command:
    You can create a table by using the CREATE TABLE command.
    CREATE TABLE Student
    (Admno integer,
    Name char(20), \
    Gender char(1),
    Age integer,
    Place char(10),
    );
  2. ALTER COMMAND:
    The ALTER command is used to alter the table structure like adding a column, renaming the existing column, changing the data type of any column or size of the column, or deleting the column from the table.
    Alter table Student add address char;
  3. DROP TABLE:
    The drop table command is used to remove a table from the database.
    DROP TABLE Student;
shaalaa.com
SQL Commands and Their Functions
  क्या इस प्रश्न या उत्तर में कोई त्रुटि है?
अध्याय 12: Structured Query Language (SQL) - Evaluation [पृष्ठ २३१]

APPEARS IN

सामाचीर कलवी Computer Science [English] Class 12 TN Board
अध्याय 12 Structured Query Language (SQL)
Evaluation | Q 3. | पृष्ठ २३१

संबंधित प्रश्न

The clause used to sort data in a database.


Write the difference between table constraint and column constraint?


What is a constraint?


Write the use of the Savepoint command with an example.


Write a SQL statement using the DISTINCT keyword.


Consider the following employee table. Write SQL commands for the question.

EMP CODE NAME DESIG PAY ALLO WANCE
S1001 Hariharan Supervisor 29000 12000
P1002 Shaji Operator 10000 5500
P1003 Prasad Operator 12000 6500
C1004 Manjima Clerk 8000 4500
M1005 Ratheesh Mechanic 20000 7000

To display the details of all employees in descending order of pay.


Consider the following employee table. Write SQL commands for the question.

EMP CODE NAME DESIG PAY ALLO WANCE
S1001 Hariharan Supervisor 29000 12000
P1002 Shaji Operator 10000 5500
P1003 Prasad Operator 12000 6500
C1004 Manjima Clerk 8000 4500
M1005 Ratheesh Mechanic 20000 7000

To display all employees whose allowance is between 5000 and 7000.


Consider the following employee table. Write SQL commands for the question.

EMP CODE NAME DESIG PAY ALLO WANCE
S1001 Hariharan Supervisor 29000 12000
P1002 Shaji Operator 10000 5500
P1003 Prasad Operator 12000 6500
C1004 Manjima Clerk 8000 4500
M1005 Ratheesh Mechanic 20000 7000

To remove the employees who are mechanics.


Construct the following SQL statement in the student table-

SELECT statement using ORDER BY clause.


Write a SQL statement to create a table for employees having any five fields and create a table constraint for the employee table.


Advertisements
Share
Notifications

Englishहिंदीमराठी


      Forgot password?
Use app×