Fragen im Vorstellungsgespräch: Sql developer

947

Fragen aus Vorstellungsgesprächen für „ Sql Developer“, von Bewerbern geteilt

Top-Fragen in Vorstellungsgesprächen

Sortieren: Relevanz|Beliebtheit|Datum
Shriram Value Services
Software Engineer(SQL) wurde gefragt...17. März 2017

SQL - Trigger, Stored Procedure, SQL Basics, truncate & delete HR - Joins, Multirow functions

4 Antworten

Trigger is a kind of special stored procedure which will execute automatically when a when an event occures in database server. Weniger

Stored procedure is a prepared SQL code which is saved for reusing.

Truncate is similar to the delete command but it removes entire table. Delete is the command Which is used to remove some data by using where clause. Weniger

Anzeigen Mehr Antworten
Berkshire Hathaway

If I knew what the cross apply operator was

4 Antworten

If they want the word its join, a description could be "the Cartesian product of multiplying the tables" and an example would be "like merging two matrices except every column may be of incongruent variables creating a result with polynomial rows, (which is likely no longer normalized to the form level of the database)" Weniger

An Apply operator is a join type that the query engine evaluates in sequential order because the right-hand table object can reference data in the left-hand table object. The Cross Apply operator is the Apply operator that acts like an Inner Join, eliminating any records in the left-hand table object that have a null match in the right-hand table object. Weniger

An Apply operator is a join type that the DB engine evaluates in sequential order because the right-hand table object can reference data in the left-hand table object. The Cross Apply operator is the Apply operator that acts like an Inner Join, eliminating any records in the left-hand table object that have a null match in the right-hand table object. Weniger

Anzeigen Mehr Antworten
ISN Software

Given 2 dates, return a result set that outputs a number for each week between the two. (They will ask the numbered week to be the sequential week and also the calendar week. Prepare for given start date to be start mid-week.)

3 Antworten

--Given 2 dates, return a result set that outputs a number for each week between the two. (They will ask the numbered week to be the sequential week and also the calendar week. Prepare for given start date to be start mid-week.) declare @temp date, @d date = '2020-01-01', @dd date = '2020-03-01', @i int = 0 declare @t table (w int, d date); declare @w int, @wp int = 0 set @temp = @d; while @temp @wp begin insert into @t values (@w, @temp) set @wp = @w end end select * from @t; Weniger

--Given 2 dates, return a result set that outputs a number for each week between the two. (They will ask the numbered week to be the sequential week and also the calendar week. Prepare for given start date to be start mid-week.) declare @temp date, @d date = '2020-01-01', @dd date = '2020-03-01', @i int = 0 declare @t table (w int, d date); declare @w int, @wp int = 0 set @temp = @d; while @temp @wp begin insert into @t values (@w, @temp) set @wp = @w end end select * from @t; Weniger

DECLARE @Start_Dt DATE = '2020-01-07', @End_Dt DATE = GETDATE(), @SequencialWeek_No INT = 1, @OldWeek_No INT = 0, @Week_No INT = 0; DROP TABLE IF EXISTS #Temp; CREATE TABLE #Temp ( Date DATE, Week_No INT, SequencialWeek_No INT ); WHILE @Start_Dt <= @End_Dt BEGIN SET @OldWeek_No = @Week_No; SET @Week_No = DATEPART(wk, @Start_Dt); SET @SequencialWeek_No = CASE WHEN @Start_Dt = '2020-01-07' THEN 1 WHEN @OldWeek_No = @Week_No THEN @SequencialWeek_No ELSE @SequencialWeek_No + 1 END; INSERT INTO #Temp ( Date, Week_No, SequencialWeek_No ) SELECT @Start_Dt, @Week_No, @SequencialWeek_No; SET @Start_Dt = DATEADD(DAY, 1, @Start_Dt); END; SELECT * FROM #Temp ORDER BY Date; Weniger

PwC

What is the result if we do following Null + 90

3 Antworten

Always remember null + anything will be null. Also applicable for - ,* ,/

Null

Null .anything+ null is null

Home Credit International

Not unexpectedly, the manager was particularly interested in my experience in gathering requirements and creating designs.

3 Antworten

What kind of design excersice did you have to present? something related to data modelling? I'm just curious Weniger

It was a high-level design for a loan application, including the architecture and data model for the application. Weniger

Because I had 12 years as team lead on a top priority application, I had good stories to relate about my experience gathering requirements and creating designs. Weniger

Page Industries

1. Aptitude, reasoning, English, C, C++ 2. Project 3. WAP for bubble sort. 4. WAQ for having clause 5. Multiple inheritance 6. OOPs concept

2 Antworten

I answered well.

I want to know about is their any fixed criteria in apptitude?

Oracle

how to transform a string into comma separated values

2 Antworten

use split()

Listtag(string,delimeter)

PwC

How to retrieve unique rows from database without using Distinct or Unique keyword

2 Antworten

One of the method is select a ROWID among duplicate columns

One method is to use GROUP BY the column(s) you want as distinct.

PwC

how to retrieve first five rows from database.

2 Antworten

select top 5* from table;

SELECT *FROM table_name ORDER BY column_name_id LIMIT 5;

Yardi Systems

Delete duplicate records from a table

2 Antworten

Do they ask to write a program or only sql queries?

referr google

1 - 10 von 947 angezeigt Fragen im Vorstellungsgespräch