InterviewSolution
Saved Bookmarks
InterviewSolution
This section includes InterviewSolutions, each offering curated multiple-choice questions to sharpen your knowledge and support exam preparation. Choose a topic below to get started.
| 101. |
Deleted syllabus of IT class 10 2021 |
| Answer» | |
| 102. |
explain the purpose of offline blog editor |
| Answer» The purpose of an offline blog editor is to create blog and publish the content whenever internet connectivity is available. They publish the blog written automatically on the internet domain when you connect to a internet connection. | |
| 103. |
Functional English Session - 19,20 for class 10 solutions |
| Answer» | |
| 104. |
Functional English Session - 19,20 for class 20 |
| Answer» | |
| 105. |
What is the work of DDL co.mand |
|
Answer» The DDL commands in\xa0SQL\xa0are used to create database schema and to define the type and structure of the data that will be stored in a database...!! The DDL command work with the SQL query statement which are executedtp perform and show desired results. The\xa0DDL commands\xa0once queried and run cannot be rolled back and does commit implicitly. Tables are the database objects that store the data records. |
|
| 106. |
How do blank documents create in excel |
| Answer» | |
| 107. |
Write the points to be kept in mind to make an effective presentation for the audience |
| Answer» How can you make a good presentation even more effective?°Show your Passion and Connect with your Audience. ...°Focus on your Audience\'s Needs. ...°Keep it Simple: Concentrate on your Core Message. ...°Smile and Make Eye Contact with your Audience. ...°Start Strongly. ...°Remember the 10-20-30 Rule for °Slideshows. ...°Tell Stories. | |
| 108. |
What is macros |
| Answer» A macro in computer science is a rule or pattern that specifies how a certain input should be mapped to a replacement output. Applying a macro to an input is macro expansion. The input and output may be a sequence of lexical tokens or characters, or a syntax tree. | |
| 109. |
Homepage |
| Answer» | |
| 110. |
What is mail merge and write the advantages of mail merge |
|
Answer» Mail merge is a feature that is included in both Microsoft word and Microsoft excel .it allows to create so many documents at a time Mail merge is joining a data source such as an adress book, with a microsoft word |
|
| 111. |
What are the components of a communication cycle |
|
Answer» 1. Communicator 2.Encoding 3.Message 4. Medium 5. Transmission 6.Receiver 7. Decoding 8.Feedback The Components of communication cycle are 1. Communicator2.Encoding3.Message4. Medium5. Transmission6.Receiver7. Decoding8.Feedback Sender,Message,Receiver,Channel,Feedback |
|
| 112. |
Syllbus |
|
Answer» Or u can type edudel on Google and you will find syllabus there I have the soft copy of the syllabus |
|
| 113. |
Name any one accessibility features ?? ? |
|
Answer» Toggle keyd Toggle Keys |
|
| 114. |
What is full form DDL and DML ? and difference between |
|
Answer» Sr. No.\tKey\tDDL\tDML1\tStands for\tDDL stands for Data Definition Language.\tDML stands for Data Manipulation Language.2\tUsage\tDDL statements are used to create database, schema, constraints, users, tables etc.\tDML statement is used to insert, update or delete the records.3\tClassification\tDDL has no further classification.\tDML is further classified into procedural DML and non-procedural DML.4\tCommands\tCREATE, DROP, RENAME and ALTER. DDL\xa0stands\xa0for\xa0Data\xa0Definition\xa0Language.\xa0DMLstands\xa0for\xa0Data Manipulation Language.\xa0DDLstatements are used to create database, schema, constraints, users, tables etc.\xa0DML\xa0statement is used to insert, update or delete the records. DDL strands for data definition language and DML Stands for data manipulation. DDL is data definition language and DML is Data Manipulation Language. DML is a standard of command that is used to access or manipulate data in a database. DDL is a standard of command that is used to Create, Modify and delete data in database objects DDL is data definition language and DML is Data Manipulation Language.DDL is a standard of command that is used to Create, Modify and delete data in database objects.DML is a standard of command that is used to access or manipulate data in a database. Hope it helps u...? |
|
| 115. |
What is full form of SQL? |
|
Answer» Structure query language SQL : Structured Query Language SQL : Structured Query Language...... Structured Query Language Structured Query Language |
|
| 116. |
Question 1Define the following; 1title bar. |
|
Answer» A\xa0title bar\xa0is a small strip that extends across the top of a window. It displays the\xa0title\xa0of the window and typically includes the close, minimize, and maximize buttons. In macOS, these buttons are on the left side of the\xa0title bar, while in Windows, they are on the rightI hope you understood It is located at the top of the window and display the document name. the format of the name displayed on the title bar is document name - Microsoft Word |
|
| 117. |
Anyone have past IT papersPlzssss telll imp questions |
| Answer» Sofia I will suggest uhh to refer to the Google | |
| 118. |
What are the factors of communicative effective ? |
| Answer» factors of communication effective\tListening\tVerbal Communication\tNonverbal Communication\tEmotional Awareness\tWritten Communication\tCommunicating in Difficult Situations | |
| 119. |
What are factors of communicative effective |
| Answer» Listening, Non-Verbal Communication, Be Clear, Be Personable, Be Confident, Always Have An Open Mind | |
| 120. |
Write any two function of verbal communication |
|
Answer» We use verbal communication to define reality, organize, think, and shape attitudes. Verbal communication helps us define reality. We use verbal communication to define everything from ideas, emotions, experiences, thoughts, objects, and people (Blumer, 1969). We use\xa0verbal communication\xa0to define reality, organize, think, and shape attitudes. ...\xa0Verbal communication\xa0helps us define reality. We use\xa0verbal communication\xa0to define everything from ideas, emotions, experiences, thoughts, objects, and people |
|
| 121. |
What are the 7C\'S of method of effective communication |
| Answer» There are seven elements of communication which are popularly known as 7C\'s communication.1. Clear 2. Correct3. Complete4. Concrete5. Concise6. Consideration 7. Courteous | |
| 122. |
Ch1 database management please notes provide |
|
Answer» CBSE Class 11 Informatics PracticesRevision NotesUNIT-2Relational Database Management System class 11 Notes Informatics PracticesData:\xa0Basic/raw facts about something which is not organized, for example details of some students which is not organized.Data Item:\xa0Each piece of information about an entity, such as name of a person or address, age or name of a product or the price is a Data Item.Database:\xa0A well organised collection of data that ensures safety, security and integrity of data.DataBase Management System(DBMS):\xa0Comprehensive software that provides the essential services to create, manage and maintain the databases. In short, a DBMS provides the means to store the data in the database, to edit or delete the data stored, to search and analyze the data in the database. They also provide various safety and security mechanisms that ensures that in any case stored data will be safe and accessible.Relational DataBase Management System(RDBMS):\xa0A Database Management System that conforms at-least half of the 12 rules defined by Dr. E.F. Codd (1970) in his research document. In a relational data model, the data is organized into tables (i.e. Rows and Columns). These tables are called Relations. A row in a table represents a relationship among a set of values. Since table is a collection of relationships it is generally referred to using the mathematical term Relation.Database Systems:\xa0Systems comprising of Databases and Database Management Systems are simply referred as database systems.Advantages of Data Base System:1) Reduce data redundancy (duplication of data).2) Control data inconsistency to a large extent.3) Database facilitate sharing of data.4) Enforce standards.5) Centralized databases can ensure data security.Examples of Common Database Management Systems:\xa0MySQL ,INGRES, POSTGRES, ORACLE, DB2.Levels of Database Implementation:1. Internal Level (Physical Level):\xa0It describes how the data are actually stored on the storage media.2. Conceptual Level:\xa0It describes what data are actually stored in the database. It also describes the relationships existing among data.3. External Level (View Level):\xa0It is closest to the users and is concerned with the way in which the data are viewed by individual users.Data Independence:\xa0The ability to modify a scheme definition in one level without affecting a scheme definition in the next higher level.Two Level of Data Independence:1. Physical Data Independence:\xa0It refers to the ability to modify the scheme followed at the physical level without affecting the scheme followed at the conceptual level.2. Logical data Independence:\xa0It refers to the ability to modify the scheme followed at the conceptual level without affecting the scheme followed at the external level.Data Model:\xa0A way by which data structures and their relationships are analyzed.Different Data Models:1. Relational data model2. Network data model3. Hierarchical data modelRelational data model:\xa0In this model data is organized into tabular structures called relations. A database may contain many relations providing a better classification of data based on its nature and use. Multiple relations are then linked/ associated together on some common key data values (foreign key).Network Data Model:\xa0In this model data is represented by collections of records and relationships among data are represented by links. A record is collection of fields i.e. attributes, each of which contents only one data value.Hierarchical data model:\xa0In this model records are organized as trees, data is represented by collection of records connected to one another through links.Basics of Relational Model Relation:\xa0A tabular structure containing data. To be a relation it\xa0must satisfy following four conditions:■ Atomicity: At every row-column intersection (Cell) there must be an atomic value i.e. a value that can not be further subdivided.■ No duplicity: No two rows of relation will be identical i.e. in any two rows value in at least one column must be different.■ Ordering of rows is immaterial.■ Ordering of columns is immaterial.Tuple:\xa0A row in a relation is called a tuple.Attribute:\xa0A column in a relation is called an attribute.Domain:\xa0Domain of an attribute refers to the set of all the possible values for that attribute.Degree:\xa0Number of attributes in a relation is the degree of that relation.Cardinality:\xa0Number of tuples in a relation is the cardinality of that relation.Candidate Key:\xa0A set of one or more minimal attributes used to uniquely identify a tuple in the relation and which can act as Primary Key. A relation can have multiple candidate keys.Primary Key:\xa0A candidate key that is primarily chosen for unique identification of tuples in a Relation.Any subset of Primary key should not be Primary key.Alternate Key:\xa0Candidate keys that not chosen as primary key are the alternate keys.Example:\xa0In a\xa0LIBRARY TableCandidate keys\xa0can be Accession no, Book no.Primary key:\xa0If we select Book no as primary key for our purpose thenAlternate Key\xa0will be Accession No.Views:\xa0A view is a virtual table whose contents are taking from other tables depending upon a condition.Table:\xa0StudentRoll. No.NameMarks101Anu85102Riya70103Ankit78Definition of the VIEW:CREATE VIEW toppers ASSELECT * FROM StudentWHERE Marks > 75;Here name of the view is toppersBase table is studentstoppers(A virtual table based on Student table)Roll. No.NameMarks101Anu85102Ankit78INTRODUCTION TO MYSQLMySQL:\xa0It is an Open Source RDBMS Software that uses Structured Query Language. It is available free of cost. Key Features of MySQL:1. High Speed.2. Ease of Use.3. Available Free of Cost.4. Supports standards based SQL.5. Provides portability.6. High Security.7. Provides many data types.8. Handles large database.MySQL Data Types:\xa0Every column (or data item) should belong to a unique domain (known as data type). These data types help to describe the kind of information a particular column holds. MySQL supports the ANSI SQL data types. Some of the commonly used data types along with their characteristics are as follows:ClassData TypeDescriptionExampleTextCHAR(size)A fixed-length string between 1 and 255 characters in length right-padded with spaces to the specified length when stored. Values must be enclosed in single quotes or double quotes.‘Maths’‘TexT’VARCHAR(size)A variable-length string between 1 and 255 characters in length; for example VARCHAR(25). Values must be enclosed in single quotes or double quotes‘Computer’‘Me and u’NUMERICDECIMAL(p,s)It can represent number with or 17.3 without the fractional part. The size argument has two parts: precision and scale. Precision (p) indicates the number of significant digits and scale (s) maximum number of digits to the right of the decimal point20.150000.00INTIt is used for storing integer values345DateDATEIt represents the date including day, month and year between 1000-01-01 and 9999-12-312009-07-02The Structured Query Language(SQL)SQL (pronounced SEQUEL for Simple English Query Language) is Non-procedural universal data access language used to access and manipulate data stored in nearly all the data bases available currently. SQL standards are defined by ANSI (American National Standards Institute). SQL statements are used to retrieve and update data in a database. SQL works with database programs like MySQL, MS Access, DB2, Informix, MS SQL Server, Oracle, Sybase, etc. Most of the SQL database programs also have their own proprietary extensions in addition to the SQL standard.SQL CommandsSQL commands can be classified into the following:Data Definition Language (DDL):\xa0A database scheme is defined by set of definitions, which are expressed, by a special set of commands called Data Definition Language (DDL). They are used to create tables, databases, identify data items, provide unique names to the data items and to define the length and provide the range of values that each data item can assume. They are CREATE TABLE, ALTER TABLE and DROP TABLE commands.Data Manipulation Language (DML):\xa0The data manipulation language (DML) handles operations such as entering rows into a table, changing data, deleting rows, and extracting data from rows and tables. With DML, one does not change the table’s structure, but rather its contents. It contains commands like INSERT, UPDATE and DELETE.Transaction Control Language (TCL):\xa0A transaction is a one complete unit of work. A transaction is successfully completed if\xa0and only if all its constituent steps are successfully completed. To manage and control the transactions, the transaction control commands are used. e.g. COMMIT, ROLLBACK, SAVEPOINT.WORKING WITH SQLTo work on MySQL, you need to open or create the database first:To Create/Open Database:mysql> CREATE DATABASE |
|
| 123. |
Table play an important role in DBMS. Explain Why? |
| Answer» | |
| 124. |
Ncert book for information technology |
| Answer» I have soft copy | |
| 125. |
Notes of chapter 1 in information technology |
| Answer» Informatics Practices Data:\xa0Basic/raw facts about something which is not organized, for example details of some students which is not organized. Data Item:\xa0Each piece of information about an entity, such as name of a person or address, age or name of a product or the price is a Data Item. Database:\xa0A well organised collection of data that ensures safety, security and integrity of data. DataBase Management System(DBMS):\xa0Comprehensive software that provides the essential services to create, manage and maintain the databases. In short, a DBMS provides the means to store the data in the database, to edit or delete the data stored, to search and analyze the data in the database. They also provide various safety and security mechanisms that ensures that in any case stored data will be safe and accessible. Relational DataBase Management System(RDBMS):\xa0A Database Management System that conforms at-least half of the 12 rules defined by Dr. E.F. Codd (1970) in his research document. In a relational data model, the data is organized into tables (i.e. Rows and Columns). These tables are called Relations. A row in a table represents a relationship among a set of values. Since table is a collection of relationships it is generally referred to using the mathematical term Relation. Database Systems:\xa0Systems comprising of Databases and Database Management Systems are simply referred as database systems. Advantages of Data Base System: 1) Reduce data redundancy (duplication of data). 2) Control data inconsistency to a large extent. 3) Database facilitate sharing of data. 4) Enforce standards. 5) Centralized databases can ensure data security. Examples of Common Database Management Systems:\xa0MySQL ,INGRES, POSTGRES, ORACLE, DB2. Levels of Database Implementation: 1. Internal Level (Physical Level):\xa0It describes how the data are actually stored on the storage media. 2. Conceptual Level:\xa0It describes what data are actually stored in the database. It also describes the relationships existing among data. 3. External Level (View Level):\xa0It is closest to the users and is concerned with the way in which the data are viewed by individual users.  Data Independence:\xa0The ability to modify a scheme definition in one level without affecting a scheme definition in the next higher level. Two Level of Data Independence: 1. Physical Data Independence:\xa0It refers to the ability to modify the scheme followed at the physical level without affecting the scheme followed at the conceptual level. 2. Logical data Independence:\xa0It refers to the ability to modify the scheme followed at the conceptual level without affecting the scheme followed at the external level. Data Model:\xa0A way by which data structures and their relationships are analyzed. Different Data Models: 1. Relational data model 2. Network data model 3. Hierarchical data model Relational data model:\xa0In this model data is organized into tabular structures called relations. A database may contain many relations providing a better classification of data based on its nature and use. Multiple relations are then linked/ associated together on some common key data values (foreign key). Network Data Model:\xa0In this model data is represented by collections of records and relationships among data are represented by links. A record is collection of fields i.e. attributes, each of which contents only one data value. Hierarchical data model:\xa0In this model records are organized as trees, data is represented by collection of records connected to one another through links. Basics of Relational Model Relation:\xa0A tabular structure containing data. To be a relation it\xa0must satisfy following four conditions: ■ Atomicity: At every row-column intersection (Cell) there must be an atomic value i.e. a value that can not be further subdivided. ■ No duplicity: No two rows of relation will be identical i.e. in any two rows value in at least one column must be different. ■ Ordering of rows is immaterial. ■ Ordering of columns is immaterial. Tuple:\xa0A row in a relation is called a tuple. Attribute:\xa0A column in a relation is called an attribute. Domain:\xa0Domain of an attribute refers to the set of all the possible values for that attribute. Degree:\xa0Number of attributes in a relation is the degree of that relation. Cardinality:\xa0Number of tuples in a relation is the cardinality of that relation. Candidate Key:\xa0A set of one or more minimal attributes used to uniquely identify a tuple in the relation and which can act as Primary Key. A relation can have multiple candidate keys. Primary Key:\xa0A candidate key that is primarily chosen for unique identification of tuples in a Relation. Any subset of Primary key should not be Primary key. Alternate Key:\xa0Candidate keys that not chosen as primary key are the alternate keys. Example:\xa0In a\xa0LIBRARY Table Candidate keys\xa0can be Accession no, Book no. Primary key:\xa0If we select Book no as primary key for our purpose then Alternate Key\xa0will be Accession No. Views:\xa0A view is a virtual table whose contents are taking from other tables depending upon a condition. Table:\xa0Student Roll. No.NameMarks101Anu85102Riya70103Ankit78 Definition of the VIEW: CREATE VIEW toppers AS SELECT * FROM Student WHERE Marks > 75; Here name of the view is toppers Base table is students toppers(A virtual table based on Student table) Roll. No.NameMarks101Anu85102Ankit78 INTRODUCTION TO MYSQL MySQL:\xa0It is an Open Source RDBMS Software that uses Structured Query Language. It is available free of cost. Key Features of MySQL: 1. High Speed. 2. Ease of Use. 3. Available Free of Cost. 4. Supports standards based SQL. 5. Provides portability. 6. High Security. 7. Provides many data types. 8. Handles large database. MySQL Data Types:\xa0Every column (or data item) should belong to a unique domain (known as data type). These data types help to describe the kind of information a particular column holds. MySQL supports the ANSI SQL data types. Some of the commonly used data types along with their characteristics are as follows: ClassData TypeDescriptionExampleTextCHAR(size)A fixed-length string between 1 and 255 characters in length right-padded with spaces to the specified length when stored. Values must be enclosed in single quotes or double quotes.‘Maths’ ‘TexT’VARCHAR(size)A variable-length string between 1 and 255 characters in length; for example VARCHAR(25). Values must be enclosed in single quotes or double quotes‘Computer’ ‘Me and u’NUMERICDECIMAL(p,s)It can represent number with or 17.3 without the fractional part. The size argument has two parts: precision and scale. Precision (p) indicates the number of significant digits and scale (s) maximum number of digits to the right of the decimal point20.1 50000.00INTIt is used for storing integer values345DateDATEIt represents the date including day, month and year between 1000-01-01 and 9999-12-312009-07-02 The Structured Query Language(SQL) SQL (pronounced SEQUEL for Simple English Query Language) is Non-procedural universal data access language used to access and manipulate data stored in nearly all the data bases available currently. SQL standards are defined by ANSI (American National Standards Institute). SQL statements are used to retrieve and update data in a database. SQL works with database programs like MySQL, MS Access, DB2, Informix, MS SQL Server, Oracle, Sybase, etc. Most of the SQL database programs also have their own proprietary extensions in addition to the SQL standard. SQL Commands SQL commands can be classified into the following: Data Definition Language (DDL):\xa0A database scheme is defined by set of definitions, which are expressed, by a special set of commands called Data Definition Language (DDL). They are used to create tables, databases, identify data items, provide unique names to the data items and to define the length and provide the range of values that each data item can assume. They are CREATE TABLE, ALTER TABLE and DROP TABLE commands. Data Manipulation Language (DML):\xa0The data manipulation language (DML) handles operations such as entering rows into a table, changing data, deleting rows, and extracting data from rows and tables. With DML, one does not change the table’s structure, but rather its contents. It contains commands like INSERT, UPDATE and DELETE. Transaction Control Language (TCL):\xa0A transaction is a one complete unit of work. A transaction is successfully completed if\xa0and only if all its constituent steps are successfully completed. To manage and control the transactions, the transaction control commands are used. e.g. COMMIT, ROLLBACK, SAVEPOINT. WORKING WITH SQL To work on MySQL, you need to open or create the database first: To Create/Open Database: mysql> CREATE DATABASE\xa0; Now the database with the given name will be created. One must be connected to the database before using it, as below: mysql> use\xa0; Creating Tables Tables are defined with the CREATE TABLE command. When tables are created its columns are named, data types and sizes supplied for each column. At least one column must be specified. Syntax: CREATE TABLE\xa0(\xa0,\xa0,…….,\xa0); Example: mysql> CREATE TABLE Students ( RollNo DECIMAL(3), Name VARCHAR(25) ); Once the table is created we can insert the record in it, edit or delete existing records, and also we can search for desired record in a very comprehensive way using the SQL Select statement. Creating tables with SQL Constraints: ^ A Constraint is a condition or check applicable on a field or set of fields. ^ Data constraints are the rules that are defined when a table is created. ^ They can also be defined or modified after creating the tables. ^ When constraints are defined any data entering in the table is first checked to satisfy the condition specified in particular constraint if it is, only then table data can be updated. If data updation/ insertion is violating the defined constraints, database rejects the data (entire record is rejected). ^ When a constraint is applied to a single column, it is called a column level constraint but if a constraint is applied on a combination of columns it is called a table constraint. Following Constraints can be defined on a table in SQL: Constraints nameDescriptionPRIMARY KEYUsed to create a primary key.UNIQUEto create a unique key.NOT NULLto define that column will not accept null values.FOREIGN KEY/ REFERENCESto define referential integrity with another table.DEFAULTto define the columns default value.CHECKto define the custom rule. Not Null and Default constraints can be applied only at column level rest all constraints can be applied on both column level and table levels. Use of constraints: CREATE TABLE student (Srollno integer NOT NULL, …); CREATE TABLE student (Srollno integer UNIQUE, …); CREATE TABLE student (Srollno integer NOT NULL, Sclass integer DEFAULT 12, Sname varchar(30)); CREATE TABLE student (Srollno integer CHECK (Srollno>0), Sclass integer, Sname varchar(30)); CREATE TABLE student (Srollno integer NOT NULL PRIMARY KEY, Sclass integer, Sname varchar(30)); CREATE TABLE teacher (Tid integer NOT NULL, FOREIGN KEY (Studentid) REFERENCES student (Sid)); Inserting the record in existing table: The INSERT INTO command append a new record to an existing table and initializes it to desired values. Syntax: INSERT INTO table_name (column_name [,column_name]) VALUES (value [,value]); INSERT INTO Student (RollNo, Name) VALUES (12333,’Anu’); Inserting NULL Values: INSERT INTO Student (RollNo, Name, Class, Grade) VALUES (12333,’Anu’,11, NULL); Inserting Dates: INSERT INTO Student (RollNo, Name, Class, DOB) VALUES (12333,’Anu’,11, ‘1998-02-24′) Inserting Data from another Table: INSERT INTO Marks SELECT * FROM Student WHERE Class>10; Note:\xa0Column names can be omitted if the values are entered in the same order in which they appear in the table. Insert into will give you an error if you omit to enter a mandatory value (non-null). Deleting Existing records from the table: The DELETE command deletes one, many, or even all records in a table, depending on the conditions that you specify. Syntax: DELETE FROM tablename WHERE search_conditions; for example DELETE FROM Students WHERE RollNo>11255; Note:\xa0The delete command is VERY dangerous. If run without conditions, it will delete ALL records in a table. In addition, SQL has no undo function. For instance, DELETE FROM Students; Will delete all records from Students table. This is not likely to be what you want. Modifying the contents of records:\xa0The UPDATE command changes one, many, or even all records in a table, depending on the conditions that you specify Syntax: UPDATE tablename SET column_name = expression [,column_name = expression..] [WHERE search_conditions]; for example(assuming a customer table) UPDATE customer SET f_name = ‘Thomas’ WHERE l_name = ‘Smith’ and date_of_birth = ‘3/2/1985′; An expression can be either a constant value (e.g., ‘Thomas’) or an operation done on another column or columns (see the example below, assuming a loan table with column rate.). UPDATE TABLE loan SET rate = rate + 1.5; Because there is no condition (i.e., no WHERE) all records will be updated. All rates will be increased by 1.5. Selecting data from existing table: SQL SELECT statement is a comprehensive statement used to search/select records from one or more tables. All the analysis done on a database usually involves some form of select statement. >\xa0Choosing all fields (columns): Use an asterisk (*) to indicate all fields with the select statement: SELECT * FROM table_name; SELECT * FROM customer; >\xa0Choosing a selected list of fields (columns) SELECT column_name [,column_name] FROM table_name; SELECT f_name, l_name, date_of_birth FROM customer; NOTE:\xa0The order in which you list the columns affects their order in the resulting output. Items within [ ] are optional. >\xa0Temporarily renaming columns in query results SELECT column_heading AS column_name [,column_heading AS column_name] FROM table_name; Example: SELECT f_name as “Name” FROM customer; >\xa0Including calculated columns in the results SELECT date_due, rate, principal, rate * principal FROM loan; NOTE: If necessary, use parentheses to clarify order of precedence. >\xa0Eliminating duplicate query results with distinct If you use the keyword distinct after the keyword SELECT, you will only get unique rows. Example: SELECT rate, FROM loan; (above will display all rate values might be repeated) SELECT distinct rate FROM loan; (above will display only unique rate values, no repetition) >\xa0Selecting from all the rows: SELECT ALL rate, FROM loan; (above query will display all rate values) >\xa0Selecting rows: WHERE clause is used to specify the condition for searching. Only those records will be retrieved that satisfy condition given with where clause. SELECT SELECT_list FROM table_list WHERE search_conditions; Example: SELECT * FROM customer WHERE f_name = ‘Carl’; >\xa0Possible Search Conditions – Comparison operators (=,<,>,!=.<>,<=,>=) SELECT * FROM loan WHERE principal > 100000000; – Ranges (between and not between; inclusive) SELECT * FROM loan WHERE rate BETWEEN 7.5 AND 8.5; OR SELECT * FROM loan WHERE rate NOT BETWEEN 7.5 AND 8.5; – Lists (in and not in) SELECT * from Customer where city IN (‘Ahmedabad’, ‘Baroda’, ‘Delhi’, ’Mumbai’, ’Chennai’); OR SELECT * from Customer where city NOT IN (‘Ahmedabad’, ‘Baroda’, ‘Delhi’,’Mumbai’,’Chennai’); – Null values SELECT * from Customer where city is Null; OR SELECT * from Customer where city is Not Null; – Character matches (like and not like) SELECT f_name, l_name FROM customer WHERE l_name LIKE ‘Fos%’; SELECT f_name, l_name FROM customer WHERE l_name LIKE ‘_oster’; Note:\xa0“%” (matches any string of zero or more characters) and “_” (matches any one character). In addition to those, brackets can be used to include either ranges or sets of characters. Combinations of previous options using logical operators and, or, and not etc.: SELECT f_name, l_name FROM customer WHERE l_name LIKE ‘San%’ AND City NOT IN (‘Baroda’,‘Delhi’) >\xa0Some more examples: – ‘Am%’ matches any string starting with Am. – ‘%Singh%’ matches any string containing ‘Singh’ – ‘%a’ matches any string ending with ‘a’ – ‘ ’ matches any string that is exactly 3 characters long. – ‘ %’ matches any string that has at least 2 characters long. – ‘ g’ matches any string that is 4 characters along with 3 characters in the beginning but ‘g’ as the 4th\xa0character. >\xa0Viewing a tables structures Describe/ Desc statement is used to see the structure of a table: Desc\xa0; Describe\xa0; >\xa0Sorting records The output of a SELECT query can be sorted in ascending or descending order on one or more columns, the default is ascending. This is important to note that the data in table is not sorted, only the results that appear on the screen are sorted. Syntax: SELECT\xa0[,, ….] FROM [WHERE\xa0] [ORDER BY\xa0[,\xa0.]]; Example: (Sorting on single column) SELECT * FROM EMPL ORDER BY ENAME; Example: (Sorting on Multiple columns) SELECT * FROM EMPL ORDER BY ENAME, JOB; >\xa0Adding a column: The ALTER TABLE command is used to change definitions of existing tables. It can add columns, delete columns or change their size,rename the name of an existing table. Syntax: ALTER TABLEADD (\xa0); Example: ALTER TABLE Students ADD (age NUMBER (2) CHECK (age > 5)); >\xa0Modify a column: Syntax: ALTER TABLEMODIFY (column name newdatatype (newsize)); Example: ALTER TABLE Students MODIFY ( age NUMBER (1)); >\xa0Changing a column name: ALTER TABLECHANGE\xa0; Example: ALTER TABLE Students CHANGE age s_age NUMBER (2) >\xa0Removing table components – To remove primary key constraints ALTER TABLE Students DROP primary key; – To remove column from the table ALTER TABLE Students DROP COLUMN age; >\xa0Drop a table from database: DROP TABLE; Example: DROP TABLE Students; > Renaming a table: ALTER TABLE\xa0RENAME TO\xa0; Example: ALTER TABLE Students RENAME TO Students_Details; Operator Precedence: All the operators have precedence. Precedence is the order in which different operators are evaluated. Various operators in descending order of precedence (top to bottom) are listed below: 1!2(Unary minus)3^4*,/,DIV,%, MOD5-,+6=, <=, >, >=, =, !=, IS, LIKE, IN7BETWEEN8NOT9&&, AND10|| OR MySQL Functions Functions A function is a predefined command set that performs some operation and returns the single value. Numeric Functions >\xa0POWER(): Returns the argument raised to the specified power. POW () works the same way. Example:(i)POW(2,4):Result:16 (ii)POW(2,-2):Result:0.25 (iii)POW(-2,3):Result: -8 >\xa0ROUND(): ROUND(X) Rounds the argument to the zero decimal place, where as ROUND(X,d) rounds the argument to d decimal places. Example : (i)\xa0ROUND(-1.23); Result: -1 (ii)\xa0ROUND(-1.58); Result: -2 (iii)\xa0ROUND(1.58); Result: 2 (iv)\xa0ROUND(3.798, 1); Result: 3.8 (v)\xa0ROUND(1.298, 0); Result: 1 (vi)\xa0ROUND(23.298, -1); Result: 20 (vii)\xa0ROUND( 25.298,-1); result: 30 >\xa0TRUNCATE(): Truncates the argument to specified number of decimal places. Example: (i) TRUNCATE (7.29,1) Result: 7.2 (ii) TRUNCATE(27.29,-1) Result: 20 >\xa0SIGN(): Returns sign of a given number. Example: (i) SIGN (15) Result: 1 : (ii) SIGN (-15) Result : -1 : (iii) SIGN (0) Result : 0. >\xa0SQRT: Returns the square root of given number. Example: (i) SQRT (25) Result: 5 Character/String Functions >\xa0LENGTH(): Returns the length of a string in bytes/no.of characters in string. Example: LENGTH(‘INFORMATICS’); Result:11 >\xa0CHAR(): Returns the corresponding ASCII character for each integer passed. Example: CHAR(65) ; Result : A >\xa0CONCAT(): Returns concatenated string i.e. it adds strings. Example: CONCAT(‘Informatics’,’ ‘,‘Practices’); Result : Informatics Practices’ >\xa0INSTR(): Returns the index of the first occurrence of substring. Example: INSTR(‘Informatics’,’ mat’); Result : 6(since ‘m’ of ‘mat’ is at 6th place) >\xa0LOWER()/ LCASE(): Returns the argument after converting it in lowercase. Example: LOWER(‘INFORMATICS’); Result: informatics >\xa0UPPER()/ UCASE(): Returns the argument after converting it in uppercase. Example: UCASE(‘informatics’); Result: INFORMATICS >\xa0LEFT () : Returns the given number of characters by extracting them from the left side of the given string Example : LEFT(‘INFORMATICS PRACTICES’, 3); Result : INF >\xa0RIGHT(): Returns the given number of characters by extracting them from the right side of the given string Example : RIGHT(‘INFORMATICS PRACTICES’,3); Result: CES >\xa0MID(): Returns a substring starting from the specified position in a given string. Example: MID(‘INFORMATICS PRACTICES’,3,4); Result : FORM >\xa0SUBSTR(): Returns a substring from a given string. Example: SUBSTR(‘INFORMATICS’ , 3 , 4 ) ; Result : FORM SUBSTR(‘INFORMATICS’ , -3 , 2\xa0) ; Result : IC >\xa0LTRIM(): Removes leading spaces. Example : LTRIM(‘ INFORMATICS’); Result: ‘INFORMATICS’ >\xa0RTRIM(): Removes trailing spaces. Example : RTRIM(‘INFORMATICS ‘); Result: ‘INFORMATICS’ >\xa0TRIM(): Removes leading and trailing spaces. Example: TRIM(‘ INFORMATICS ‘); Result: ‘INFORMATICS’ Date/Time Functions >\xa0CURDATE(): Returns the current date Example: CURDATE(); Result: ‘2012-09-18’ >\xa0NOW(): Returns the current date and time Example: NOW(); Result : ‘2010-07-21 13:58:11’ >\xa0SYSDATE(): Return the time at which the function executes Example: SYSDATE(); Result: ‘2010-07-21 13:59:23’ >\xa0DATE(): Extracts the date part of a date or datetime expression Example: DATE(‘2003-12-31 01:02:03’); Result:: ‘2003-12-31’ >\xa0MONTH() Returns the month from the date passed Example: MONTH(‘2010-07-21’); Result : 7 >MONTHNAME() Returns the name of month from the date passed Example: MONTHNAME(‘2010-07-21’); Result : JULY >\xa0YEAR(): Returns the year. Example: YEAR(‘2010-07-21’); Result : 2010 >\xa0DAYNAME(): Returns the name of the weekday Example: DAYNAME(‘2010-07-21’); Result : WEDNESDAY >\xa0DAYOFMONTH(): Returns the day of the month (0-31) Example: DAYOFMONTH(‘2010-07-21’); Result: 21 >\xa0DAYOFWEEK(): Returns the weekday index of the argument Example: DAYOFWEEK(‘2010-07-21’); Result: 4 (Sunday is counted as 1) >\xa0DAYOFYEAR(): Return the day of the year(1-366) Example: DAYOFYEAR(‘2010-07-21’); Result: | |
| 126. |
~`|•√Π÷׶∆£€¥¢^°={},\\©®™℅[][email\xa0protected]#$%&-+()/*"\':;!?_,. |
| Answer» Can i know the names of these symbols | |
| 127. |
How can you apply a style to the selected text? |
| Answer» H | |
| 128. |
What is the passport |
|
Answer» A passport is a travel document, usually issued by a country\'s government to its citizens that verifies the identity and nationality of the holder for the purpose of international travel. A passport is a travel document usually issued by a country \'s goverment to its citizen that verifies the idenyity and nationality of the holder for the purpose of international travel: A passport is a travel document,usually issued by a country\'s government to its citizens that verifies the identity and nationalism of the holder for the purpose of international travel A passport is a travel document, usually issued by a country\'s government to its citizens that verifies the identity and nationality of the holder for the purpose of international travel A passport is a travel document, usually issued by a country\'s government to its citizens that verifies the identity and nationality of the holder for the purpose of international travel. |
|
| 129. |
Why you are not providing sample questions of information technology |
|
Answer» Arihant i Succeed sample paper book One book is there Yùtrrreer78rtry98yytrryyrrffeyjbftyoppugcswevbnmjjhfvbnigcdtui |
|
| 130. |
Difference between DTMS AND RDMS |
| Answer» RDMS Relational Database Management System | |
| 131. |
Write a program to create a macro named total |
| Answer» | |
| 132. |
What are the Myths about entrepreneurs that entrepreneurs believe in entrepreneurship? |
|
Answer» One is the that entrepreneur need a lot of money to start up a business One of the myth is that entrepreneurs are born with entrepreneur skills. |
|
| 133. |
Tell me deleted syllabus |
|
Answer» According to new syllabus. There are Two parts A and B. Part A contain employability skills and is of 10 marks out of 50. Part B contain Digital documentation, RDBMS, Web security and basics, and one more chapter. Hii |
|
| 134. |
I want the pdf of IT book |
| Answer» | |
| 135. |
Can you tell me syllabus |
| Answer» No | |
| 136. |
What is templates????? |
|
Answer» Templates are pre defined set of formats on which files can created quickly Templates or document templates refer to a sample fill-in-the-blank document that can help in saving time. Usually templates are customized documents that may have sample content, themes, etc. |
|
| 137. |
Full form d d l |
|
Answer» DDL refers to Data Definition Language. Ask to Google |
|
| 138. |
Sample of IT (402) of class 10 2020-2021 |
| Answer» If you are asking for sample paper, you can check out the latest sample papers by CBSE on it\'s official website | |
| 139. |
I want sample paper of computer 2021 code 402 now |
|
Answer» http://cbseacademic.nic.in/web_material/Curriculum21/SQP_MS_X/402_Information_Tech_SQP.pdf We need a sample paper |
|
| 140. |
What is meant by \'what if\' scenarios |
| Answer» Scenarios are tool to test "what if" questions. Using scenarios we can enter variable and constant in same cell. Scenarios option is available in tools menu. Each scenarios are named and edited separately Hope this is helpful for you ??Thank u ?? | |
| 141. |
What do you mean by mail merge? How do you perform the mail merge? |
| Answer» Mail merge | |
| 142. |
What are the disadvantage of non verbal communication |
| Answer» Do not understand exect meaning | |
| 143. |
It code 402 ka sample paper |
|
Answer» What\'s the syllabus of computer for final Cbseacademic.nic.in skill education Sample paper |
|
| 144. |
Is information technology marks are added in final result of CBSE? |
|
Answer» Yes Yes percentage not marks No Yes bro ? Yes |
|
| 145. |
What are advantages of styles |
|
Answer» Use for creating and good looking professional document with least effort. It makes work beautiful It used to look beautiful |
|
| 146. |
Which of the following features are found in the ease of access centre in windows |
|
Answer» Who Important question for board exam Important question for board exam .........is bringing together the mind, body and spirit |
|
| 147. |
What is froud |
|
Answer» Bdsk Jfgch |
|
| 148. |
Sample paper question |
| Answer» 15 spq | |
| 149. |
Pre board sample paper subject information technology |
| Answer» I don\'t know | |
| 150. |
what is punctuation ?mantion any three punctuation marks |
| Answer» Punctuation are the special characters that are used in sentenceEg. So sad!! What?? She said "Whoa". | |