What is the purpose of SQL? -Technology

What is the purpose of SQL? -Technology
by

1 Answer

Answer :

SQL is structured query language. It is a standard language of all the RDBMS.
by

Related questions

What is the purpose of SQL? -Technology

Description : What is the purpose of SQL? -Technology

Last Answer : SQL is structured query language. It is a standard language of all the RDBMS.

Help him in writing SQL query for the following purpose: (i) To count how many female candidates will be attending the training. -Technology

Description : Help him in writing SQL query for the following purpose: (i) To count how many female candidates will be attending the training. -Technology

Last Answer : (i)Select count(name) from training where name like ‘Ms.%’;(ii) Select * from training where fee is NULL;(iii) Select city, fee from training where topic = ‘Cyber Security’;(iv) Alter table training add feedback varchar(20);

Ms. Pari, a beginner in SQL is not able to understand the meaning of “Cancelling a Transaction”. Help her in understanding the same. -Technology

Description : Ms. Pari, a beginner in SQL is not able to understand the meaning of “Cancelling a Transaction”. Help her in understanding the same. -Technology

Last Answer : Cancelling a transaction means rolls the transaction to the beginning. It aborts any changes made during the transaction and the state of database is returned to what it was before the transaction began to execute.Rollback command is used for the same.

Write SQL query to create a table “BOOKS” with the following structure: Table: BOOKS -Technology

Description : Write SQL query to create a table “BOOKS” with the following structure: Table: BOOKS -Technology

Last Answer : Create table Books(BOOK_ID Integer (2) Primary Key,BOOK_NAME Varchar (20),CATEGORY Varchar (20),ISSUE_DATE Date);

Write SQL query to create a table “Registration” with the following structure: -Technology

Description : Write SQL query to create a table “Registration” with the following structure: -Technology

Last Answer : Create table Registration(Reg_Id Integer(2) Primary Key,Name varchar(20),Course varchar(10),Join_Dt date);

With reference to the above given tables, write commands in SQL for (i) and (ii) and output for (iii) below: -Technology

Description : With reference to the above given tables, write commands in SQL for (i) and (ii) and output for (iii) below: -Technology

Last Answer : (i) select TName, Passenger from Train T, Reservation R where T.TrainId=R.TrainId;(ii) select T.* from Train T, Reservation R where T.TrainId!=R.TrainId;(iii)TrainIdTNameSourceDestination3424Lucknow MailLucknowNew Delhi5400Century ExpressNew DelhiKanpur

What is the use of COMMIT in sql ? -Technology

Description : What is the use of COMMIT in sql ? -Technology

Last Answer : Commit is used to save all the DML transactions, and once saved they cannot be rolled back.

Name SQL Single Row functions (for each of the following) that 1. returns a number. -Technology

Description : Name SQL Single Row functions (for each of the following) that 1. returns a number. -Technology

Last Answer : (i) ASCII () function returns a number.(ii) LCASE () function returns lowercase letters .(iii) DAYNAME () function returns names of days.(iv) DAYOFWEEK () function returns weekday number

Consider the following table Furniture. Write SQL commands for the statements (i) to (viii) and write output for SQL queries (ix) and (x). -Technology

Description : Consider the following table Furniture. Write SQL commands for the statements (i) to (viii) and write output for SQL queries (ix) and (x). -Technology

Last Answer : SQL commands for the given statements (i) to (viii) ;1. SELECT FCODE, NAME. PRICE FROM Furniture WHERE PRICE < 5000;2. SELECT NAME. PRICE FROM Furniture3.4. WHERE NAME LIKE %table% ;5. SELECT DISTINCT WCODE ... ;15.16. Output for SQL queries (ix) and (x)(ix)SUM(PRICE)6500(x)COUNT(DISTINCT PRICE)5

Write SQL query to create a table Inventory with the following structure : -Technology

Description : Write SQL query to create a table Inventory with the following structure : -Technology

Last Answer : CREATE TABLE Inventory(Material Id Integer Primary Key,Material Varchar (50) NOT NULL,Category Char,DatePurchase Date) :

To select tuples with some salary, Siddharth has written the following erroneous SQL statement : -Technology

Description : To select tuples with some salary, Siddharth has written the following erroneous SQL statement : -Technology

Last Answer : The correct code is :SELECT ID, Salary FROM empsalaryWHERE Salary = 56000 ;

Write SQL query to create a table Player with the following structure : -Technology

Description : Write SQL query to create a table Player with the following structure : -Technology

Last Answer : CREATE TABLE Player(};

Write SQL Query commands based on the following table: -Technology

Description : Write SQL Query commands based on the following table: -Technology

Last Answer : This answer was deleted by our moderators...

Write the output of the following SQL command. select round (49.88); (a)49.88 (b)49.8 (c)49.0 (d)50 -Technology

Description : Write the output of the following SQL command. select round (49.88); (a)49.88 (b)49.8 (c)49.0 (d)50 -Technology

Last Answer : The correct answer is : (a) 50

The ....... command can be used to makes changes in the rows of a table in SQL. -Technology

Description : The ....... command can be used to makes changes in the rows of a table in SQL. -Technology

Last Answer : The update command can be used to makes changes in the rows of a table in SQL.

Write the SQL command that will display the current time and date. -Technology

Description : Write the SQL command that will display the current time and date. -Technology

Last Answer : Select now();

Consider the decimal number x with value 8459.2654. Write commands in SQL to: i. round it off to a whole number -Technology

Description : Consider the decimal number x with value 8459.2654. Write commands in SQL to: i. round it off to a whole number -Technology

Last Answer : i. select round(8459.2654);ii.select round(8459.2654,-2);

Consider the following SQL string: “Preoccupied” Write commands to display: (a)“occupied” (b)“cup” -Technology

Description : Consider the following SQL string: “Preoccupied” Write commands to display: (a)“occupied” (b)“cup” -Technology

Last Answer : commands to display:(a)“occupied” (b)“cup”

Considering the same string “Preoccupied” Write SQL commands to display: (a) the position of the substring ‘cup’ in the string “Preoccupied” -Technology

Description : Considering the same string “Preoccupied” Write SQL commands to display: (a) the position of the substring ‘cup’ in the string “Preoccupied” -Technology

Last Answer : (a)select instr 'Preoccupied' , ‘ 'cup'));(b)select left 'Preoccupied',4);

Write the SQL functions which will perform the following operations: (i) To display the name of the month of the current date . -Technology

Description : Write the SQL functions which will perform the following operations: (i) To display the name of the month of the current date . -Technology

Last Answer : (i) monthname(date(now()))(ii) trim(“ Panaroma “)(iii) dayname(date(dob))(iv) instr(name, fname)(v) mod(n1,n2)

Write the purpose of search engine. -Technology

Description : Write the purpose of search engine. -Technology

Last Answer : The main purpose of search engine is to help people to find more information in any topic, which user wants.

What is general purpose application software? Give some examples of general purpose application. -Technology

Description : What is general purpose application software? Give some examples of general purpose application. -Technology

Last Answer : General purpose application softwares are those softwares, which are used for any general function. They allow people to do simple computer tasks. It is sometimes referred to as GPS. e.g. graphics, multimedia, presentation software, desktop publishing software etc.

Write the purpose of DBMS. -Technology

Description : Write the purpose of DBMS. -Technology

Last Answer : DBMS is used to store logically related information at a centralized location. It facilitates data sharing among all the applications requiring it.

Explain any five specific purpose application softwares. -Technology

Description : Explain any five specific purpose application softwares. -Technology

Last Answer : 1. Hotel Management SystemIt refers to the management techniques used in the hotel sector. It includes hotel administration, accounts, billing marketing, housekeeping, front office or front desk, e.g. ... delivered to acustomer or set of customers.e.g. Billing Manager, BillingTracker, kBilling etc..

What is the purpose of Default Value field property? -Technology

Description : What is the purpose of Default Value field property? -Technology

Last Answer : If there is a situation when you want to enter the same value for all records. Then, to avoid typing the same thing many times, you can set as a Default Value property.

computer network. A computer network is a group of (i) ………. that are (ii) ……… to each other for the purpose o -Technology

Description : computer network. A computer network is a group of (i) ………. that are (ii) ……… to each other for the purpose o -Technology

Last Answer : (i) computers(ii) connected(iii) communication(iv) network(v) share

Which field properties are used in Office Access 2007? Give the purpose of each field property. -Technology

Description : Which field properties are used in Office Access 2007? Give the purpose of each field property. -Technology

Last Answer : Field PropertiesAfter you create a field and set its data types, you can also set additional field properties. Setting field properties can give the database extra flexibility and functionality.Some ... control.Text, Memo, Number,Date/Time, Currency,AutoNumber, Yes/No, OLEObject, Hyperlink.

What is the purpose of the description column in table Design View? -Technology

Description : What is the purpose of the description column in table Design View? -Technology

Last Answer : (a) A Design View of the table provides three columns as Field Name, Data Type, and Description. The description column provides the facility to write the description about Field Name.

What is the purpose of using the tags <H1>…<H6>? -Technology

Description : What is the purpose of using the tags …? -Technology

Last Answer : provides six levels of headings. is the largest heading level while is the smallest heading level. These headings help us in obtaining a uniform look and feel for the document.

What is the purpose of HTML? -Technology

Description : What is the purpose of HTML? -Technology

Last Answer : HTML (HyperText Markup Language) is used to create Web pages and tells the browser how to display them. It designs the basic layout and formatting of Web pages.HTML is made up of elements or tags and attributes, which work together to identify document parts and tell the browser how to display them.

What is the purpose of using HTML tags and attributes for Web designing? -Technology

Description : What is the purpose of using HTML tags and attributes for Web designing? -Technology

Last Answer : HTML (HyperText Markup Language) is used to create Web pages. It designs the basic layout and formatting of Web pages by using tags and attributes.The tag’s name tells the tag’s purpose and the attributes that follow the tag name give the additional information of the Web browser.

What is the purpose of using type attribute used in lists? -Technology

Description : What is the purpose of using type attribute used in lists? -Technology

Last Answer : The type attribute specifies the type of numbers or bullets depending on whether the list item is inside an ordered list or unordered list.

What is the purpose of using start attribute used in lists? -Technology

Description : What is the purpose of using start attribute used in lists? -Technology

Last Answer : This attribute is used to change the beginning value of an ordered list. Normally, the ordered list begins with 1. It lets you further customize an HTMLordered list by setting a new starting digit for the ordered list element.Syntaxe.g.Ordered List with type attribute

The data which is accurate, specific and organised for a purpose is known as (a) Data (b) Multimedia -Technology

Description : The data which is accurate, specific and organised for a purpose is known as (a) Data (b) Multimedia -Technology

Last Answer : (d) Data after processing becomes information and it is accurate, specific and organised for a purpose.

What is the purpose of using the attribute href in <a> tag? -Technology

Description : What is the purpose of using the attribute href in tag? -Technology

Last Answer : The href stands for Hypertext Reference. The href attribute is used with tag to specify the link to some other HTML page or Website.e.g. click here to go to learncbse.It will display like:click here to go to learncbse.

What is the purpose of mailto function? -Technology

Description : What is the purpose of mailto function? -Technology

Last Answer : The mailto function is used to send E-mail messages to multiple recipients. For this, we only need to type the E-mail address of the recipients in the same link separated by commas.

For what purpose, left clicking is often used? -Technology

Description : For what purpose, left clicking is often used? -Technology

Last Answer : Left clicking is most often used to select or open a file/folder.

State the possible purpose of adding the Comments feature in MS_Word application. -Technology

Description : State the possible purpose of adding the Comments feature in MS_Word application. -Technology

Last Answer : For making notes while reading the document without pen and paper, Comments feature is very useful.

Write down the purpose and features of Show Markup option available in Review tab of Word 2007 document. -Technology

Description : Write down the purpose and features of Show Markup option available in Review tab of Word 2007 document. -Technology

Last Answer : Accepting or rejecting changes work much like the Spell Check feature. By cycling through the changes made to a document, the author can accept or reject any or all changes.For accepting or rejecting ... and (iii) until all changes/comments have been reviewed.5. When finished, save your document.

Explain the purpose of AutoFormat feature of Word 2007. How it can be used in a Word document? -Technology

Description : Explain the purpose of AutoFormat feature of Word 2007. How it can be used in a Word document? -Technology

Last Answer : Auto-formatting feature of Word processing tool allows the automatic formatting of certain kinds of text while' typing. By selecting certain formatting options, theMicrosoft Office 2007 system programs can automatically ... .7. Click Add button.8. Click OK button.9. Close the Symbol dialog box.

Animation is a feature, which you can use in your presentation. What is the purpose of this feature? -Technology

Description : Animation is a feature, which you can use in your presentation. What is the purpose of this feature? -Technology

Last Answer : Animations are the visual effects applied to individual items on a slide such as graphics, titles or bullet points, rather than to the slide itself.

Kirti wants to add sound to slide transition. Which feature of Animations tab is useful for this purpose? -Technology

Description : Kirti wants to add sound to slide transition. Which feature of Animations tab is useful for this purpose? -Technology

Last Answer : On the Animations tab in the Transition to This Slide group, click the arrow next to ‘Transition Sound’ to add sound to slide transition.

The programmers who break into secure systems for malicious purpose are -Technology

Description : The programmers who break into secure systems for malicious purpose are -Technology

Last Answer : (a) Crackers are the programmers that break into secure systems for malicious purpose.

Backup is duplication of data for restoring purpose at a later time. -Technology

Description : Backup is duplication of data for restoring purpose at a later time. -Technology

Last Answer : True Backup is a process to copy the data and restore it, whenever required.

For what purpose pie charts are useful? -Technology

Description : For what purpose pie charts are useful? -Technology

Last Answer : Pie charts are useful for the following purposes:1. They convey approximate propositional relationship at a point in time.2. They compare part of a whole at a given point in time.3. Exploded portion of a pie chart emphasizes a small proportion of parts.

Write down the name and purpose of various components of a chart. -Technology

Description : Write down the name and purpose of various components of a chart. -Technology

Last Answer : Various components or parts of the chart are as follows:1. X-axis Refers to a horizontal axis, which is also known as category axis.2. Y-axis Refers to a vertical axis also known as ... Data label Provides additional information about a value in the chart, that is coming from a worksheet cell.

What is the main purpose of library classification? -Technology

Description : What is the main purpose of library classification? -Technology

Last Answer : The main purpose of Library classification is to facilitate the use of reading material. It confirms the exact location of a document in the library.

What is the purpose of <IMG> tag ? Mention it’s any two attributes along with their purpose. -Technology

Description : What is the purpose of tag ? Mention it’s any two attributes along with their purpose. -Technology

Last Answer : tag is used to insert images in any webpage.Its two main attributes are as follows:SRC : It specifies the URL of the image.ALT : It specifies an alternate text for an image.

Discuss the purpose of HTTP briefly. -Technology

Description : Discuss the purpose of HTTP briefly. -Technology

Last Answer : Full form of HTTP is Hypertext Transfer Protocol. It is the foundation of data communication for the World Wide Web.

What is the purpose of a web browser? Give the name of any two popular web browsers. -Technology

Description : What is the purpose of a web browser? Give the name of any two popular web browsers. -Technology

Last Answer : A web browser is an application program used for exploring the information resources available on the World Wide Web to retrieve the required information. Two popular web browsers are Google Chrome and Mozilla Firefox.