To display the details of all those students who have IP as their optional subject. -Technology

To display the details of all those students who have IP as their optional subject. -Technology
by

1 Answer

Answer :

(i) select * from student where optional=‟IP‟;(ii) select name, stream, optional from student where name like 'A%';(iii) update student set average=average+3 where stream=‟Humanities‟ and optional='Maths';(iv) select name from student where average>75;
by

Related questions

When you define a field for a table, which of the following parameters do Access always consider optional? -Technology

Description : When you define a field for a table, which of the following parameters do Access always consider optional? -Technology

Last Answer : (d) Description field of the table is optional, as it depends on the databasedesigner that he/she wants to describe a field or not.

Mr. Sanjay wants to plot a bar graph for the given set of values of subject on x_axis and number of students who opted for that subject on -Technology

Description : Mr. Sanjay wants to plot a bar graph for the given set of values of subject on x_axis and number of students who opted for that subject on -Technology

Last Answer : (i) plt.bar(x,y)(ii) plt.show()

Write a query to display customer’s name along with their transaction details. -Technology

Description : Write a query to display customer’s name along with their transaction details. -Technology

Last Answer : Select cust_name, t.* from customer c, transaction t where c.Acc_No=t.Acc_No;

(i) To display names of stores along with Sales Amount of those stores that have ‘fashion’ anywhere -Technology

Description : (i) To display names of stores along with Sales Amount of those stores that have ‘fashion’ anywhere -Technology

Last Answer : mysql> Select Name,SalesAmt from Store order by noOfEmp;mysql> Select city, sum(SalesAmt) from store group by City;mysql> Select count(*),City from store group by City having count(*)>2; ... ;Min(DateOpen)2015-02-06mysql> Select Count(StoreId), NoOfEmp from Store group byNoOfemp having max(SalesAmt)

1. To display Names of Patients, TESTID and Test names for those Patients who were admitted -Technology

Description : 1. To display Names of Patients, TESTID and Test names for those Patients who were admitted -Technology

Last Answer : SQL commands for the given statements :(i) SELECT NAME, TESTID, TESTNAME FROM PATIENT, TESTWHERE PATIENT. TESTID = TEST. TESTID AND DTADMIT BETWEEN 01-DEC-2017' AND '15-DEC-2017' ;(ii) SELECT NAME, TESTNAME, COST ... NAME LIKE '% Sharma %' ;(iii) UPDATE TEST SET COST = COST +50 WHERE COST < 200 ;

Students should prefer those teachers who Options: A) dictate notes in the class. B) give important questions before examination. C) can clear their difficulties regarding subject-matter. D) are themselves disciplined.

Description : Students should prefer those teachers who Options: A) dictate notes in the class. B) give important questions before examination. C) can clear their difficulties regarding subject-matter. D) are themselves disciplined. 

Last Answer : C) can clear their difficulties regarding subject-matter. 

In the table “Student”, Priya wanted to increase the Marks (Column Name: Marks) of those students -Technology

Description : In the table “Student”, Priya wanted to increase the Marks (Column Name: Marks) of those students -Technology

Last Answer : Correct SQL statement :UPDATE Student SET Marks = Marks +5 WHERE Marks

An IP address is a string of ……….. numbers separated by periods. -Technology

Description : An IP address is a string of ……….. numbers separated by periods. -Technology

Last Answer : (b) An IP address consists of 4 numbers separated by periods.

IP addresses are converted into (a) a binary string (b) alphanumeric string -Technology

Description : IP addresses are converted into (a) a binary string (b) alphanumeric string -Technology

Last Answer : (c) DNS translates domain names into their IP addresses and vice-versa.

………… allows delivery of voice communications over IP networks. -Technology

Description : ………… allows delivery of voice communications over IP networks. -Technology

Last Answer : VoIP allows delivery of voice communications over IP networks.

IP address is given to every computer for its unique identification. -Technology

Description : IP address is given to every computer for its unique identification. -Technology

Last Answer : True An IP address serves two principal functions:1. Host or network interface identification2. Location addressing

FTP utilizes TCP/IP protocol suite. -Technology

Description : FTP utilizes TCP/IP protocol suite. -Technology

Last Answer : True FTP is the easiest way to transfer files between computers via an Internet and utilizes TCP (Transmission Control Protocol)/IP (Internet Protocol) systems to perform uploading and downloading tasks.

Expand the following terms : 1. GSM 2. IP -Technology

Description : Expand the following terms : 1. GSM 2. IP -Technology

Last Answer : Expanded form :(i) GSM – Global System for Mobile Communication(ii) IP- Internet Protoco

Write one example each of URL and IP address. -Technology

Description : Write one example each of URL and IP address. -Technology

Last Answer : Example of URL → http: // www. microsoft. com Example of IP address → 192.168.0.0

Touch screen is an electronic ……….. display that can detect the presence and location of a touch within the display area. -Technology

Description : Touch screen is an electronic ……….. display that can detect the presence and location of a touch within the display area. -Technology

Last Answer : Touch screen is an electronic visual display that can detect the presence and location of a touch within the display area.

Write the HTML code to display horizontal line of red color. -Technology

Description : Write the HTML code to display horizontal line of red color. -Technology

Last Answer :

How would you display text in the title bar of a browser? -Technology

Description : How would you display text in the title bar of a browser? -Technology

Last Answer : To display text in a title bar of a browser, use the tag inside the tag in the HTML document.e.g. HTML document

Write HTML code to display various bullet types. -Technology

Description : Write HTML code to display various bullet types. -Technology

Last Answer : LotusRoseSunHoonoutput

Write HTML code to display ordered lists. -Technology

Description : Write HTML code to display ordered lists. -Technology

Last Answer : Many Ordered ListNumbered listSunMoonLetters 1is t SunMoonLowercase letters starting from 3rd 1etter

Tags and text that do not display directly on the page afe placed in (a) body (b) table -Technology

Description : Tags and text that do not display directly on the page afe placed in (a) body (b) table -Technology

Last Answer : (c) Information in tag is not displayed directly in the Web page. It is used to identify the matter (tags) used in a Web page.

To display the text in italics, ………. tag is used and to display in type writer font, ……… tag is used. -Technology

Description : To display the text in italics, ………. tag is used and to display in type writer font, ……… tag is used. -Technology

Last Answer : To display the text in italics,tag is used and to display in typewriterfont, tag is used.

If you want to display uppercase alphabets instead of numbers, ………… ordered type should you use. -Technology

Description : If you want to display uppercase alphabets instead of numbers, ………… ordered type should you use. -Technology

Last Answer : If you want to display uppercase alphabets instead of numbers, Aordered type should you use.

background attribute is used to display image. -Technology

Description : background attribute is used to display image. -Technology

Last Answer : True It is an attribute of tag used to display the background image.

Write the HTML command to display the following in your Web page. -Technology

Description : Write the HTML command to display the following in your Web page. -Technology

Last Answer : The HTML command is – A2 + B2

Write the HTML code to display an image on the right side of the page. -Technology

Description : Write the HTML code to display an image on the right side of the page. -Technology

Last Answer :

Write the HTML code to display an inline image named pencil.jpg located at C:\ in the center of your Web page. -Technology

Description : Write the HTML code to display an inline image named pencil.jpg located at C:\ in the center of your Web page. -Technology

Last Answer :

Web browsers display images in the following format (a) XBM (b) JPEG -Technology

Description : Web browsers display images in the following format (a) XBM (b) JPEG -Technology

Last Answer : (d) All of these

To display (X+Y)2, correct HTML code is (a) <sub>(X+Y)2</sub> -Technology

Description : To display (X+Y)2, correct HTML code is (a) (X+Y)2 -Technology

Last Answer : (c) (X+Y) 2 code is correct because superscript have to be placed in between and tags.

Which attribute lets you control the display of select border sides of a table? -Technology

Description : Which attribute lets you control the display of select border sides of a table? -Technology

Last Answer : frame attribute displays the selected border sides of the table.

Write HTML code to display a table with border of 5px. -Technology

Description : Write HTML code to display a table with border of 5px. -Technology

Last Answer : l2 „

………….. is the background image of display screen on which windows, icons and other graphical items appear. -Technology

Description : ………….. is the background image of display screen on which windows, icons and other graphical items appear. -Technology

Last Answer : Desktopis the background image of display screen on which windows, icons and other graphical items appear.

The……………. attribute is used to display a specific portion of a table border. -Technology

Description : The……………. attribute is used to display a specific portion of a table border. -Technology

Last Answer : The frameattribute is used to display a specific portion of a table border.

In the rules attribute, the………… value helps to display a table border only between rows. -Technology

Description : In the rules attribute, the………… value helps to display a table border only between rows. -Technology

Last Answer : In the rules attribute, the rows value helps to display a table border only between rows.

The cols value in the rules attribute, allows you to display table border only between columns. -Technology

Description : The cols value in the rules attribute, allows you to display table border only between columns. -Technology

Last Answer : True The cols value in the rules attribute is drawn between columns only.

……….. option is used to display a document before printing. -Technology

Description : ……….. option is used to display a document before printing. -Technology

Last Answer : Print Previewoption is used to display a document before printing.

XML was not designed to (a) display Web pages -Technology

Description : XML was not designed to (a) display Web pages -Technology

Last Answer : (a) XML was designed to store and carry data, not to display Web pages.

I want to see the tracked changes in my document. How do I turn On the display of tracked changes? -Technology

Description : I want to see the tracked changes in my document. How do I turn On the display of tracked changes? -Technology

Last Answer : In MS-Word 2007, on the Review tab, use the little menus in the Tracking group. Final Showing Markup or Original Showing Markup will show what changes you have made. But check the selected items on the Show Markup menu to be sure that Word is showing you the right things.

……….. is used to describe data and ……….. is used to display data. -Technology

Description : ……….. is used to describe data and ……….. is used to display data. -Technology

Last Answer : XML is used to describe data and HTMLis used to display data.

What is the shortcut key to display the Microsoft PowerPoint shortcut menu? -Technology

Description : What is the shortcut key to display the Microsoft PowerPoint shortcut menu? -Technology

Last Answer : (c) Shift + F10 is the shortcut key to display the PowerPoint shortcut menu

If cell range A1 : A5 contain the numbers 20, 16, 5, 35 and 7 then = AVERAGE(A1 : A5, 50) will display. -Technology

Description : If cell range A1 : A5 contain the numbers 20, 16, 5, 35 and 7 then = AVERAGE(A1 : A5, 50) will display. -Technology

Last Answer : The correct answer is(a) 22.167

If you type =2 * (6_4) in cell Al, what value will be display? -Technology

Description : If you type =2 * (6_4) in cell Al, what value will be display? -Technology

Last Answer : (b) = 2*(6-4) = 2*(2) = 4

If you enter 15 + 30 in a cell, Excel will display …………….. -Technology

Description : If you enter 15 + 30 in a cell, Excel will display …………….. -Technology

Last Answer : If you enter 15 + 30 in a cell, Excel will display15 + 30.

Write the HTML code to display links of a web page in yellow colour. -Technology

Description : Write the HTML code to display links of a web page in yellow colour. -Technology

Last Answer :

Write HTML code to display the following table : -Technology

Description : Write HTML code to display the following table : -Technology

Last Answer : scheduleDuty Chart8 AM10AM12 AM KEVIN KHUSHBOO AMARJEET

In a Bank’s database, there are two tables ‘Customer’ and ‘Transaction’ as shown below. Write a query to display customer’s name who has -Technology

Description : In a Bank’s database, there are two tables ‘Customer’ and ‘Transaction’ as shown below. Write a query to display customer’s name who has -Technology

Last Answer : (i) Select cust_name from customer c,transaction t where c.Acc_No=t.Acc_No and Transaction_Type= 'Debit';(ii)Select cust_name, t.* from customer c, transaction t where c.Acc_No=t.Acc_No;(iii) ... total amount of all type of transactions, it will only display the total of credit transactions only.

Write a query to display customer’s name who has withdrawn the money. -Technology

Description : Write a query to display customer’s name who has withdrawn the money. -Technology

Last Answer : Select cust_name from customer c,transaction t where c.Acc_No=t.Acc_No and Transaction_Type= 'Debit';

Write a query to display customer’s name who have not done any transaction yet. -Technology

Description : Write a query to display customer’s name who have not done any transaction yet. -Technology

Last Answer : Select cust_name from customer c,transaction t where c.Acc_No!=t.Acc_No;

While working in Netbeans, Ms. Sonia has designed a login page where she wants to display -Technology

Description : While working in Netbeans, Ms. Sonia has designed a login page where she wants to display -Technology

Last Answer : If statement is more appropriate for this situation because here is given only two conditions which will be executed by if statement while switch statement is used where multiple branch selection statements are given.

Deepti works as a programmer in a travel company. She has developed the following code to display -Technology

Description : Deepti works as a programmer in a travel company. She has developed the following code to display -Technology

Last Answer : switch (choice){Case 1 : JTextFieldl. setText ('New Delhi to Goa') ;break ;Case 2 : jTextFieldl.setText ('New Delhi to Paris') ;break ;Case 3 : jTextFieldl.setText ('New Delhi to Bangkok') ;break ;default: jTextFieldl.setText ('P1. choose valid option') ;}

Given a Pandas series called Sequences, the command which will display the first 4 rows is .... (a) print(Sequences.head(4)) -Technology

Description : Given a Pandas series called Sequences, the command which will display the first 4 rows is .... (a) print(Sequences.head(4)) -Technology

Last Answer : (a) print(Sequences.head(4))