1. CREATE DATABASE It is used to create a new database. Syntax: CREATE DATABASE database_name; Example: CREATE DATABASE school; 2. USE It is used to select a database before performing any operation. Syntax: USE database_name; Ex.- USE school; 3. CREATE TABLE It is used to create a new table inside a database….
Here are the examples of different types of DBMS. 1. Hierarchical DBMS (Tree Structure) Structure: Data stored in a tree-like structure (Parent → Child relationship). Each child has only one parent, but one parent can have many children. Example: Windows Registry IBM Information Management System (IMS) Organization structure example– Principal ├── Teacher │ ├── Student1…
MySQL Functions Functions are used to perform some specific task. Every functions has a particular pre-defined tasks. functions are categorized into two parts. 1. Single Row Functions These functions operates on a single row at a time. These functions are categorized into following parts- i. Math Functions ii. String Functions iii. Date and Time functions…
1-Define hub. Ans- A hub is a hardware device used to connect several computers together Hubs can be either active or passive Hubs usual. it can support 8, 12 or 24 RJ45 ports 2-Define modem. Ans- MOdulator – DEModulator (or Modem) is a device that connects telephone line to computer It converts digital signal to…
