Before you start creating tables, you need a database, which is the container of tables. The database acts as a central point of administration for the tables in the database. The actual data is stored in the tables, which provide a structured organization for the data and maintain the integrity of that data.
To create tables, either you can create a new database or use an existing database. MySQL provides an empty database by the name test, which you can use to store your tables in. But it is recommended that you create new database before you…
For Best view of the content : click here
DROP TABLE Statement in SQL
SQL DROP TABLE statement is used to remove table in a database. When you use the SQL DROP TABLE statement to remove a table, the database engine deletes all objects associated to that table including data, table structure, indexes, constraints, triggers and maybe privileges.
The Drop Table command of SQL lets you drop a table from the database.
That is, to drop a table items, you need to write : The syntax for using a Drop Table command is :
DROP TABLE items ;
The Alter Table command is used to change definitions of existing tables. Usually, it can add columns to table. Sometimes it can delete columns (depending on privileges) or change their sizes.
In short we can say,
ALTER TABLE statement is used to add, delete, or modify columns in an existing table.
ALTER TABLE statement is also used to add and drop various constraints on an existing table.
To add a column in a table, use the following syntax:
ALTER TABLE table_name
ADD column_name datatype;
For instance, to add a new column tel_number of type integer in table Student.
It refers to a situation when people are willing to work at the existing wage rate, and are able to work, but are not getting work.
A worker is an individual who is engaged in some production activity.
workers are classified as :
Indicators are Substances which indicate the acidic or basic nature of the solution by the colur change.
The indicators obtained from natural sources are called Natural Indicatores.
Examples of some common natural indicators used widely to show acidic or basic character of substances.
Litmus solution is a purple dye, which is extracted from lichen, a plant belonging to the division Thallophyta, and is commonly used as an indicator.
An acid turns blue litmus paper red.
An base turns red litmus paper blue.
Tumeric is yellow in colur. Tumeric solution or paper turns reddish brown with basae…
Ans. In Python strings, each individual character is given a location number, called index and this process is called indexing.
Python allocates indices in two direction :
Ans. A sub-part or a slice of a string, say s, can be obtained using s[n:m] where n and m are integers. Python returns all the character at indices n, n+1, n+2…m-1 e.g.,
Ans. Keyword is a special word that has a special meaning and purpose. Keywords are reserved and are a few. For example, if, elif, else etc. are keywords.
Identifier is the user-defined name given to part of a program viz. variable, object, function etc. Identifiers are not reserved. These are defined by the user but they can have letters, digits and a symbol underscore. They must begin with either a letter or underscore. For instance, _chk, chess, trial etc. are identifiers in Python.
Ans. Literals mean constants i.e., the data…
Most computer programs work with files. This because files help in storing information permanently. Word processors create document files ; Database program create files of information ; Compilers read source files and generate executable files. So, we see, it is the files of that are mostly worded with, inside programs. A file in itself is a bunch of bytes stored on some storage device like hard-disk, thumb-drive etc. Every programming language offers some provision to use and create files through programs. …
Python if-else Statement
The if conditionals of Python come in multiple forms : plain if conditional, if-else conditional and if-elif conditionals.
An if statement tests a particular condition; if the condition evaluates to true, a course-of-action is followed i.e., a statement or set-of-statements is executed. If the condition is false, it does nothing :
python fundamentals class questions
ans. Keyword is a special word that has a special meaning and purpose. Keywords are reserved and are a few. For example, if, elif, else etc. are keywords.
Identifier is a user-defined name given to a part of a program viz. variable, object, function etc. Identifiers are not reserved. These are defined by the user but they can have letters, digits and a symbol underscore. They must begin with either a letter or underscore. For instance, _chk, chess, trial etc. are identifiers in Python.
ans. Literals mean constants i.e., the data…