Question

What is DBMS?
create a table emp nd insert values
​

Answer 1

A database is a collection of related data which represents some aspect of the real world. A database system is designed to be built and populated with data for a certain task.

Step-by-step explanation:

Basic Syntax for CREATE

CREATE TABLE table_name

(

column1 datatype(size),

column2 datatype(size),

column3 datatype(size),

.....

columnN datatype(size),

PRIMARY KEY( one or more columns )

);

Example

create table emp(

empno number(4,0),

ename varchar2(10),

job varchar2(9),

mgr number(4,0),

hiredate date,

sal number(7,2),

deptno number(2,0)

PRIMARY KEY (ID)

);

Field Type Null Key Default Extra

EMPNO number(4,0) N0 PRI

ENAME varchar2(10) YES – NULL

JOB varchar2(9) NO – NULL

MGR number(4,0) NO – NULL

HIRE DATE date NO – NULL

SAL number(7,2) NO – NULL

DEPTNO number(2,0) NO – NULL

Answer 2

`\huge \boxed{ \textbf{ {Answer : }}}`

• A database management system (DBMS) is system software for creating and managing databases.
• A DBMS makes it possible for end users to create, protect, read, update and delete data in a database.

━━━━━━━━━━━━━━━━━━━━━━━━

Example:-

Emp table :-

[ Create table ]

• mysql-›create table emp ( id int ( 10 ) , name char ( 10 ) , sal int ( 10 ));

`\:`

Output:-

`\:`

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

[ Insert value ]

• mysql-›insert into table emp ( id, name , sal ) values ( 101 , abc , 2500 ));
• mysql-›insert into table emp ( id, name , sal ) values ( 102 , xyz , 3500 ));
• mysql-›insert into table emp ( id, name , sal ) values ( 103 , pqr , 5000 ));

`\:`

Output:-

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

hope it helps ⸙