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.
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;
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;
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);
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);
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) :
Description : Write SQL query to create a table Player with the following structure : -Technology
Last Answer : CREATE TABLE Player(};
Description : Write SQL Query commands based on the following table: -Technology
Last Answer : This answer was deleted by our moderators...
Description : Define query in the context of database. -Technology
Last Answer : A query is an inquiry into the database using the SELECT statement. These statements give you filtered data according to your conditions and specifications indicating the fields, records, and summaries which a user wants to fetch from a database.
Description : Data is stored in RDBMS in the form of (a) table (b) query -Technology
Last Answer : (a) Relational Database Management System stores data in the form of relation. As we know, relations are known as table.
Description : A query is used to retrieve data from the database based on one or more criteria. -Technology
Last Answer : False Because MS-Access 2007 supports the database object query.
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);
Description : Consider the following schemas: Branch = (Branch-name, Assets, Branch-city) Customer = (Customer-name, Bank-name, Customer-city) Borrow = (Branch-name, loan-number, customer account-number) Deposit = ... )) (C) πcustomer-name(σbalance> 10000(Borrow)) (D) σcustomer-name(σbalance> 10000(Borrow))
Last Answer : (A) πcustomer-name(σbalance> 10000(Deposit))
Description : Write the HTML code to display horizontal line of red color. -Technology
Last Answer :
Description : Write HTML code to display various bullet types. -Technology
Last Answer : LotusRoseSunHoonoutput
Description : Write HTML code to display ordered lists. -Technology
Last Answer : Many Ordered ListNumbered listSunMoonLetters 1is t SunMoonLowercase letters starting from 3rd 1etter
Description : Write the HTML command to display the following in your Web page. -Technology
Last Answer : The HTML command is – A2 + B2
Description : Write the HTML code to display an image on the right side of the 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
Description : Write HTML code to display a table with border of 5px. -Technology
Last Answer : l2 „
Description : Write the HTML code to display links of a web page in yellow colour. -Technology
Description : Write HTML code to display the following table : -Technology
Last Answer : scheduleDuty Chart8 AM10AM12 AM KEVIN KHUSHBOO AMARJEET
Description : Write the SQL command that will display the current time and date. -Technology
Last Answer : Select now();
Description : Consider the following Series object, S_amt Table 350 Chair 200 Sofa 800 Stool 150 i. Write the command which will display the name -Technology
Last Answer : i. print(S_amt[S_amt>250])ii. S_amt.name= 'Furniture'
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”
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);
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)
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.
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
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.
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.
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.
Description : background attribute is used to display image. -Technology
Last Answer : True It is an attribute of tag used to display the background image.
Description : Web browsers display images in the following format (a) XBM (b) JPEG -Technology
Last Answer : (d) All of these
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.
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.
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.
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.
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.
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.
Description : ……….. option is used to display a document before printing. -Technology
Last Answer : Print Previewoption is used to display a document before printing.
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.
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.
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.
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
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
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
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.
Description : To display the details of all those students who have IP as their optional subject. -Technology
Last 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;
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)