Answer:
A query in a database is a request for information stored within a database management system (DBMS), which is the software program that maintains data.
SQL(Structured Query Language ( is a standard language for storing, manipulating, and retrieving data in database.
Five types of SQL queries are:
1) Data Definition Language (DDL).
used to define and modify the structure of a database.
2) Data Manipulation Language (DML).
used to manipulate (change) the data in the database.
3) Data Control Language(DCL).
used for access control and permission management for users in the database.
4) Transaction Control Language(TCL).
used for maintaining consistency of the database and for the management of transactions made by the DML commands.
5) Data Query Language (DQL).
used for performing queries on the data within schema objects.
Answer:
See explaination
Explanation:
CREATE TABLE CATEGORY
(
cid int NOT NULL,
description varchar2(1000),
PRIMARY KEY (cid)
);
CREATE TABLE PRODUCT
(
pid int NOT NULL,
description varchar2(1000),
cid int,
price int,
p_size varchar2(1),
CONSTRAINT chk_price CHECK (price>0),
CONSTRAINT chk_size CHECK (p_size in ('S','M','L')),
CONSTRAINT fk_cid FOREIGN KEY (cid) REFERENCES CATEGORY(cid)
);
Answer:
Check explanation.
Explanation:
So, i will be going supporting positive effect of how the reshaping of of the media has affected the film industry. Since brainly do not support me to include links to websites and videos I will only be sharing my opinions on the subject.
One of the ways the media is been reshaped is through the platform known as the Social Networking Sites. This platform has helped people to create an account with them, create content on their sites and share this content. With the development of this platform the film industry can put their content on this platform and show it to the world. On platforms like this, the films can be viewed and shared to many individuals.
These Platforms are been employed by film makers/industry to disseminate their content and also for the generation of revenue.
It is both true that <span>Technician A says that the excessive length of a heater hose is intended to protect the heater core from undue stress. Technician B says that excessive wear adds to the length of a heater hose, and a replacement heater hose should be roughly three to four inches shorter than its predecessor. So the asnwer is letter B.</span>
