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 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 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';
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 : (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)
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 : Which of the following is/are the Database server functions? i) Data management ii) Transaction management iii) Compile queries iv) Query optimization A) i, ii, and iv only B) i, ii and iii only C) ii, iii and iv only D) All i, ii, iii, and iv
Last Answer : A) i, ii, and iv only
Description : Write a C++ program to declare a class COLLEGE with members as college code. Derive a new class as STUDENT with members as studid. Accept and display details of student along with college for one object of student.
Last Answer : #include<iostream.h> #include<conio.h> class COLLEGE { protected: int collegecode; }; class STUDENT:public COLLEGE { int studid; public: void accept() { cout<<"Enter college ... STUDENT s; clrscr(); s.accept(); s.display(); getch(); }
Description : Sanchita is working for a nationalized bank and is in the process of creating a table to store the details of customers of the bank. -Technology
Last Answer : Primary key AccountNoCandidate key AccountNo and PAN NumberAlternate key PAN Number
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 : The difference between transactional selling and relationship selling is A. In transaction, selling buyers must pay cash B. In relationship selling, buyers and sellers must be related C. In ... to their customers e. In transaction selling, the transaction is the beginning of a relationship
Last Answer : D. In relationship selling, sellers work to provide value to their customers e. In transaction selling, the transaction is the beginning of a relationship
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.
Description : In a Bank’s database, there are two tables ‘Customer’ and ‘Transaction’ as shown below. -Technology
Last Answer : (i)Acc_No, Cust_Phone(ii)All the columns having capability to become Primary Key are known as Candidate Keys.(iii)Acc_No(iv)Trans_Id
Description : Ms. Sita trying to log into your Internet Banking account for online transaction activity. However, as strange as it may seem, -Technology
Last Answer : I. (i)Source code is available.(ii) Money need not to be paid for procuring the license for usage and further distribution.II. She could be under a DoS attack!She should deploy an ... into her network if not already done. This helps in restricting the bandwidth usage to authenticated users only.
Description : How do you tell the system that a transaction is beginning -Technology
Last Answer : When a transaction begins, Oracle Database assigns the transaction to an available undo data segment to record the undo entities for the new transaction. A transaction ID is not allocated until an ... ID is unique to a transaction and represents the undo segment number, slot and sequence number.
Description : Select Acc_No, sum(Amount) from Customer c, Transaction t where c.Acc_No=t.Acc_No group by c.Acc_No having Transaction_Type='Credit'; -Technology
Last Answer : 2301003 650002201002 20000
Description : You have changed parameters for AS Java of your SAP system based on AS ABAP+ Java. A restart of AS Java is requiredHow can you stop and start the Java stack without restarting the ABAP ... transaction, ICM Monitors (SMICM) D. Use transaction CCMS Control panel: Display Statuses and alerts (RZ03)
Last Answer : C. Use transaction, ICM Monitors (SMICM)
Description : When a transaction is processed online, how can the merchant verify the customer's identity? a. use secure sockets layers b. use secure electronic transactions c. use electronic data interchange d. use financial electronic data interchange
Last Answer : b. use secure electronic transactions
Description : Advantages of B2C commerce are (i) Business gets a wide reach to customers (ii) Payment for services easy (iii)Shop can be open 24 hours a day seven days a week (iv)Privacy of transaction always maintained a. i and ii b. ii and iii c. i and iii d. iii and iv
Last Answer : c. i and iii
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.