GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Placement Papers  >  Lucent  >  Computer Awareness
Go To First  |  Previous Question  |  Next Question 
 Computer Awareness  |  Question 5 of 30    Print  
Type duplicates of a row in a table customer with non-uniform key field customer no.

A. delete from customer where customer no. exists (select distinct customer no. from customer having count)
B. delete customer a where customer no. in (select customer b where customer no. equal to b customer no.) and a rowid > b rowid
C. delete customer a where customer no. in (select customer no. from customer a, customer B.
D. none of the above

C LANGUAGE


  
Total Answers and Comments: 0 Last Update: N/A   
  
 Sponsored Links

 

No answers are posted for this question yet.
Be the first to answer it!


 Related Questions

1). Piggy backing is a technique for a) Flow control b) sequence c) Acknowledgement d) retransmissionans: c piggy backing2). The layer in the OST model handles terminal emulationa) session b) application 

There is an employee table with key fields as employee no. Data in every n'th row are needed for a simple following queries will get required results. A. Select A employee no. from employee A, where exists from employee B, where A employee no. >= B employeee having (count(*) mod n)=0 B. select employee no. from employee A, employee B where A employee no. >= B employ no. grouping employee no. having (count(*) mod n=0) C. both a and b D. none of the above

Type duplicates of a row in a table customer with non-uniform key field customer no. A. delete from customer where customer no. exists (select distinct customer no. from customer having count) B. delete customer a where customer no. in (select customer b where customer no. equal to b customer no.) and a rowid > b rowid C. delete customer a where customer no. in (select customer no. from customer a, customer B. D. none of the above C LANGUAGE

Q is not equal to zero and k = (Q x n - s)/2 find n? A. (2 x k + s)/Q B. (2 x s x k)/Q C. (2 x k - s)/Q D. (2 x k + s x Q)/Q (E. (k + s)/Q

A right circular cylinder and a cone are there. Base radius of cone is equal to radius of cylinder. What is the ratio of height to slant side?

class B  


 Sponsored Links

 
Related Articles

ODP.NET - Populating a Dataset with a Single Data Table

ODP NET Populating a Dataset with a Single Data Table A dataset is simply a group of data tables These data tables can be identified with their own unique names within a dataset You can also add relations between data tables available in a dataset mosgoogle The following code gives you the details o
 

jQuery Table Row Finished Code

jQuery Table Row Finished Code The Finished Code Our second example page has demonstrated table row striping highlighting tooltips collapsing expanding and filtering Taken together the JavaScript code for this page is mosgoogle geshibot lang php" document ready function var highlighted
 

jQuery Expanding and Collapsing Table Rows

jQuery Expanding and Collapsing Table Rows The expanding and collapsing behavior added earlier also conflicts with our filters If a section is collapsed and a new filter is chosen then the matching items are displayed even if in the collapsed section Conversely if the table is filtered and a section
 

jQuery Table Row Filtering

jQuery Table Row Filtering Earlier we examined sorting and paging as techniques for helping users focus on relevant portions of a table s data We saw that both could be implemented either with server side technology or with JavaScript Filtering completes this arsenal of data arrangement strategies B
 

jQuery Collapsing and Expanding Table Rows

jQuery Collapsing and Expanding Table Rows When large sets of data are grouped in tables as each year s set of articles are in our News page collapsing or hiding a section s contents can be a convenient way to get a broad view of all of the table s data without having to scroll so much mosgoogle To
 

jQuery Table Manipulation

Learning jQuery Table Manipulation By Karl Swedberg Jonathan Chaffer Better Interaction Design and Web Development with Simple JavaScript Techniques Learning jQuery packtpub com jQuery book Table Manipulation Let em wear gaudy colors Or avoid display Devo Wiggly World" In the first si
 

What is the use of COUNT with DISTINCT option

COUNT is a group function returns result by summarizing multiple rows. All group by value function will have the usage of DISTINCT or ALL option and so is the COUNT which uses the DISTINCT option. DISTINCT option is used to enforce uniqueness and  if combined with COUNT is used to
 

Language Enhancements in SQL Server 2005

The T-SQL has been enhanced to include error handling, recursive query and to support the new database engine capabilities. Two new relational operators have been introduced—PIVOT and UNPIVOT for use in the FORM clause query. They perform manipulation on an input table valued expression an
 

SQL Table Commands

SQL Table Commands Overview As mentioned previously in this series of SQL articles, databases are primarily composed of tables. The “columns and rows” structure of the table allows data to be efficiently inserted, manipulated, updated, and deleted from the database. The three mos
 

SAP and Microsoft tools for Customer Service

World’s largest car dealer to use SAP and Microsoft tools for Customer Service Inchcape, the London-based largest car dealer in the world, is making itself much strong now by improving its customer services arising from major SAP and Microsoft implementations. The company has also vowed to
 

About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape