Name of the candidate: Abdullayev Ulug’bek

Question 5
(a) Show how do you delete a table using SQL in a Database with an example.
(b) What is the SQL Command to create a new Table in a Database.
(a) The DROP TABLE statement is used to drop an existing table in a database.
DROP TABLE table_name
(b) The CREATE TABLE statement is used to create a new table in a database.
The following example creates a table called "Persons" that contains five columns: PersonID, LastName, FirstName, Address, and City:
CREATE TABLE Persons (
PersonID int,
LastName varchar(255),
Question 6
What are the different RDBMS Softwares used?

• 
  MS SQL.
  
• 
  Oracle Database.
  
• 
  Amazon Relational Database Service (RDS)
  
• 
  MySQL.
  
• 
  IBM Db2.
  
• 
  SAP HANA Cloud.
  
• 
  PostgreSQL.
  
• 
  Azure SQL Database
  
• 
  

1. SQL Server 2017 brings the control of SQL Server to Windows, Linux and Docker holders for the primary time ever, empowering designers to construct shrewdly applications utilizing their favored dialect and environment. Encounter industry-leading execution, rest guaranteed with imaginative security highlights, change your trade with AI built-in, and provide experiences wherever your clients are with versatile BI.
2. Makes a difference clients lower IT costs and provide the next quality of benefit by empowering union onto database clouds.
3. Amazon Social Database Benefit (Amazon RDS) makes it simple to set up, work, and scale a social database within the cloud. It gives cost-efficient and resizable capacity whereas overseeing time-consuming database organization errands such as equipment provisioning, database setup, fixing and reinforcements. It liberates you up to center on your apps so you'll be able deliver them the way better execution, accessibility, security, and compatibility they require. Amazon RDS is accessible on 6 recognizable database occasions: Amazon Aurora, MySQL, PostgreSQL, MariaDB, Prophet Database and SQL Server motors. This implies that the code, applications, and apparatuses you as of now utilize nowadays together with your existing databases can be utilized with Amazon RDS. Amazon RDS naturally patches the database program and backs up your database, putting away the reinforcements for a user-defined maintenance period and empowering point-in-time recuperation.
4. MySQL is an open source database solution.
5. Built to run the world’s mission-critical workloads. Planned by the world’s driving database specialists, IBM Db2 enables designers, undertaking modelers, and information engineers to run low-latency exchanges and real-time analytics prepared for the foremost requesting workloads. From microservices to AI workloads, Db2 is the tried, strong, and crossover database giving the extraordinary accessibility, built-in refined security, easy adaptability, and cleverly robotization for frameworks that run the world.
6. SAP HANA Cloud may be a single database as a benefit (DBaaS) establishment for present day applications and analytics over all undertaking information. Our cloud-based information establishment modernizes how trade choices are made with live information. Construct information arrangements with cloud-native adaptability, speed, and performance. With the SAP HANA Cloud database, you'll be able pick up trusted, business-ready data from a single arrangement whereas empowering security, protection, and anonymization with demonstrated endeavor unwavering quality. It can be conveyed either on preface, within the cloud, or in a cross breed combination for speedy time-to-value.
7. PostgreSQL is a powerful, open source object-relational database system.
8. Azure SQL Database is a relational database-as-a service using the Microsoft SQL Server Engine. SQL Database is a high-performance, reliable, and secure database you can use to build data-driven applications and websites in the programming language of your choice, without needing to manage infrastructure.