If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
968how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
1633Post New Facebook SQL Server Interview Questions
Anyone attended the manual testing interview with L&T infotech in recent past. please let me know the type of questions they can ask especially in PM round. Thanks
What is bad breath?
You have been hired as a contract project manager for Grapevine Vineyards. Grapevine wants you to design an Internet wine club for their customers. Customers must pre-register before being allowed to order wine over the Internet so that legal age can be established. You tested using data from Grapevine's existing database. This new module cannot be tested until the data from the existing system is loaded. This is an example of which of the following? A. Preferential logic B. Soft logic C. Discretionary dependency D. Hard logic
What are the different types of collections in java?
What are some ways to declare a class a managed jsf bean?
Explain how can a stopped job be started again?
What is meant by D-FF? What is the basic difference between Latches and Flip flops? What is a multiplexer? How can you convert an SR Flip-flop to a JK Flip-flop? How can you convert an JK Flip-flop to a D Flip-flop? What is Race-around problem? How can you rectify it? Which semiconductor device is used as a voltage regulator and why? What do you mean by an ideal voltage source? What do you mean by zener breakdown and avalanche breakdown? What are the different types of filters? What is the need of filtering ideal response of filters and actual response of filters? What is sampling theorem? What is impulse response? Explain the advantages and disadvantages of FIR filters compared to IIR counterparts. What is CMRR? Explain briefly. What do you mean by half-duplex and full-duplex communication? Explain briefly. Which range of signals are used for terrestrial transmission? What is the need for modulation? Which type of modulation is used in TV transmission? Why we use vestigial side band (VSB-C3F) transmission for picture? When transmitting digital signals is it necessary to transmit some harmonics in addition to fundamental frequency? For asynchronous transmission, is it necessary to supply some synchronizing pulses additionally or to supply or to supply start and stop bit? BPFSK is more efficient than BFSK in presence of noise. Why? What is meant by pre-emphasis and de-emphasis? What do you mean by 3 dB cutoff frequency? Why is it 3 dB, not 1 dB?
What does an uber-jar mean?
what is the difference you can make by doing your course in the country of your choice
Explain the difference between intra partition tdq and extra partition tdq?
In a log in page what will be test procedure, test scenario, test description & test steps?
What is activation of objects?
Is it possible to share similar linux user i’d & same virtual machine in android . If yes how?
How many rows and columns 2018 excel?
How to convert numeric values to integers in ms sql server?