Sql analyst sollicitatievragen

2K

Sollicitatievragen voor Sql Analyst gedeeld door sollicitanten

Meest gestelde sollicitatievragen

Sorteren: Relevantie|Populair|Datum
Shriram Value Services
Er werd een Software Engineer(SQL) gevraagd...17 maart 2017

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

4 antwoorden

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

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. Minder

Meer reacties weergeven
Berkshire Hathaway

If I knew what the cross apply operator was

4 antwoorden

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)" Minder

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. Minder

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. Minder

Meer reacties weergeven
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 antwoorden

--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; Minder

--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; Minder

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; Minder

PwC

What is the result if we do following Null + 90

3 antwoorden

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 antwoorden

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

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

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. Minder

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 antwoorden

I answered well.

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

Cerner

Security

2 antwoorden

The interview was in the morning or noon?

The interview was in the morning or noon? The whole process got completed on the same day including HR? Minder

Greenway Health

What's the difference between TRUNCATE and DELETE

2 antwoorden

Both delete the data but Delete is a DML command can roll back but Truncate is a DDL command and don’t roll back and faster than DML Minder

one gets logged, the other doesn't so you have your performance hit. Need elevated permissions i.e. dbo for TRUNCATE Minder

Global Payments

They dont give any trouble in interivew, very friendly managers and good staff. Generally they filter resume and when they are positive to hire you, they call you into interview, and then take final diceision after seeing your intreste and behaviour. Then they go for backgorund chek and references.

2 antwoorden

Once you call for interview, there is a chance that you will be hired

I hope so I have been waiting since my first interview. It has been already over 10 days. I’m so looking forward for my second interview. Been reading more about the company. For my second interview. It’s such a big history and the luxury system they do for customer service, they have build it around the whole plant. There is more and a lot to learn I’m so excited. Minder

Apex Systems

Asked about my experience installing new releases of software

2 antwoorden

Answered about how I installed new version of IFS. We went from IFS version 4 to IFS app 8 and it was an involved process with a database migration, setting up an Application Server with middleware, setting up security, etc. Minder

Answered about how I installed new version of IFS. We went from IFS version 4 to IFS app 8 and it was an involved process with a database migration, setting up an Application Server with middleware, setting up security, etc. I can do Minder

Weergave: 1 - 10 van 1.565 sollicitatievragen

Sollicitatievragen weergeven voor vergelijkbare functies

sql developerdata analystdatabase developerdatabase analyst