2 Fisa de Raspuns TestRecrutare-CS BazeDate
4
Fisa de raspuns test de recrutare Consultant Baze de Date FISA DE RASPUNS - TEST RECRUTARE CS BD- Nume si prenume candidat: Predut Ciprian Data completarii testului :20.01.2015 Raspunsuri : 1. update dbo.tplata set dbo.tPlata.SumaTotala=subinterogare.toatl FROM dbo.tElementPlata as deactualizat INNER JOIN (select dbo.tElementPlata.PlataId,sum(dbo.tElementPlata.Suma)as total FROM dbo.tElementPlata INNER JOIN dbo.tPlata ON dbo.tElementPlata.PlataId = dbo.tPlata.PlataId group by dbo.tElementPlata.PlataId ) as subinterogare on subinterogare.PlataId=deactualizat.PlataId 2. a. alter table Persoana ADD Prenume nvarchar(128) b. select substring(ltrim(Nume),1,charindex(' ',Nume,1)-1) as z, substring(ltrim(Nume),charindex(' ',Nume,1)+1,Len(Nume)) as y from dbo.Persoana as a 3. a: Numar Litera Numar Semn 1
-
Upload
haiducu-albastru -
Category
Documents
-
view
11 -
download
4
description
Test IT
Transcript of 2 Fisa de Raspuns TestRecrutare-CS BazeDate
Fisa de raspuns test de recrutare Consultant Baze de Date
FISA DE RASPUNS
- TEST RECRUTARE CS BD-
Nume si prenume candidat: Predut CiprianData completarii testului :20.01.2015
Raspunsuri :
1. update dbo.tplata set dbo.tPlata.SumaTotala=subinterogare.toatl
FROM dbo.tElementPlata as deactualizat INNER JOIN
(select dbo.tElementPlata.PlataId,sum(dbo.tElementPlata.Suma)as total
FROM dbo.tElementPlata INNER JOIN
dbo.tPlata ON dbo.tElementPlata.PlataId = dbo.tPlata.PlataId
group by dbo.tElementPlata.PlataId
) as subinterogare
on subinterogare.PlataId=deactualizat.PlataId
2. a. alter table Persoana ADD Prenume nvarchar(128)
b. select substring(ltrim(Nume),1,charindex(' ',Nume,1)-1) as z, substring(ltrim(Nume),charindex('
',Nume,1)+1,Len(Nume)) as y from dbo.Persoana as a
3. a:
Numar Litera Numar Semn1 A NULL NULL
2 B 2 @
3 C 3 #
3 D 3 #
5 E 5 %
1
Fisa de raspuns test de recrutare Consultant Baze de Date
5 E 5 (
7 F NULL NULL
10 G 10 ^
NULL H NULL NULL
b. nu este diferenta
……………………………………………………………………………………………………………………………………………………………………………………………………...
4. a create table TabelSemneLitere (NumarS int, Litera nvarchar(1), NumarL int, Semn nvarchar(1))
……………………………………………………………………………………………………………………………………………………………………
b. insert into TabelSemneLitere Select * From tabelLitere tl LEFT join tabelSemne ts on tl.Numar = ts.Numar
………………….............................................................................................................................................................................
5. la create trebuie scris si tipul campului NumeStare si in loc de cursor as folosi while loop
6. Daca tabelu se numeste „tabelul” avem: select Persoana, STUFF((select ','+ Cunostinte from dbo.tabelul where
Persoana=a.Persoana FOR XML PATH('')),1,1,'') as CunostinteTotale from dbo.tabelul as a group by Persoana.
7. Create FUNCTION dbo.fFunctie(@numar int) RETURNS varchar(max)
BEGIN
DECLARE @puncte varchar(max)
declare @i int
set @puncte=' '
set @i=1
while (@i<=@numar)
Begin
2
Fisa de raspuns test de recrutare Consultant Baze de Date
set @puncte=@puncte+'.'
set @i=@i+1
End
RETURN @puncte
END.
8. select nume, sum(suma) SumaAAA from Finante2 where Banca='AAA'group by nume,Banca
9. Taoate valorile din „Coloana” diferite de valoarea NULL
Semnatura candidat:
Evaluator: ……………………………..
Calificativ: ………………………………
Observatii: …………………………………………………………………………………………………………………………………………………………………..
3
