Answer:
ALTER TABLE Products
ADD Products_price float(5,2) DEFAULT 9.99,
ADD Adding_time datetime;
Explanation:
So at first we need to use ALTER TABLE statement, when we use this statement we also need to provide the table name. In this case, i assume it is 'Products'.
Then, as per question, we need to add two columns.
The first one is 'product_price' and it contains decimal points. So, we need to use ADD statement and give a column name like 'Prodcuts_price' and its datatype 'float' because it contains decimal or floating points. so, for 3 digits on the left and 2 digits on the right, it makes a total of 5 digits. So, we need to declare it like this. (5,2) it means a total of 5 digits and 2 after the decimal point. after that, we need to set our Default value using the DEFALUT statement. so DEFAULT 9.99. it will set the default value to 9.99 for existing products.
And for our next column, we give its a name like 'Adding_time' then it's datatype 'datetime' because it will contain date and times.
Answer:
DHCP is the dynamic host configuration protocol that enable the server for assigning the IP address to the computer. It is basically used to provide automatic IP addresses within the network. It is basically used to configure the default gateway and provide the DNS server data in the device.
The optional parameter when configuring DHCP are:
- Sub-net mask
- Router
- Domain server
- Broadcast address
- Host name
Answer:
They make it easy to quickly see relationships between ideas.
Explanation:
A concept is an idea or a principle that could be used to understand an abstract notion. A conceptual note is one that makes the relationship between ideas easily discernible.
Without breaking much sweat or reading too deeply, the reader would find it easier to easily determine the relationship between ideas and how they relate to the subject matter. Conceptual notes can be taken on a laptop or paper.
