{"id":2201,"date":"2023-05-08T11:43:53","date_gmt":"2023-05-08T08:43:53","guid":{"rendered":"https:\/\/www.aydiner.gen.tr\/?p=2201"},"modified":"2023-05-16T16:23:32","modified_gmt":"2023-05-16T13:23:32","slug":"veritabani-organizasyonu-calisma-sorulari-cevaplari","status":"publish","type":"post","link":"https:\/\/www.aydiner.gen.tr\/index.php\/2023\/05\/08\/veritabani-organizasyonu-calisma-sorulari-cevaplari\/","title":{"rendered":"Veritaban\u0131 Organizasyonu \u00c7al\u0131\u015fma Sorular\u0131-Cevaplar\u0131"},"content":{"rendered":"

1- Veritaban\u0131 Tasar\u0131m\u0131 ve\u00a0<\/u><\/strong>2- Veritaban\u0131 Haz\u0131rlama<\/u><\/strong><\/p>\n

1. ( )\u00a0<\/strong>Bir ki\u015fiye veya \u00fcr\u00fcne ait detayl\u0131 verilerin bir d\u00fczen \u00e7er\u00e7evesinde sakland\u0131\u011f\u0131 ortamlar \u201cVeri\u201d olarak adland\u0131r\u0131l\u0131r.<\/p>\n

2. ( )\u00a0<\/strong>Birincil anahtar k\u0131s\u0131tlay\u0131c\u0131da, bir s\u00fctuna ayn\u0131 olan de\u011ferler girilebilir.<\/p>\n

3. (\u00a0<\/strong>) Default k\u0131s\u0131tlamas\u0131, veri giri\u015fi s\u0131ras\u0131nda bir alan\u0131n alabilece\u011fi varsay\u0131lan bir de\u011fer atamak i\u00e7in kullan\u0131l\u0131r.<\/p>\n

4.\u00a0<\/strong>A\u015fa\u011f\u0131dakilerden hangisi bir \u201calan ad\u0131\u201d de\u011fildir?
\nA)\u00a0<\/strong>\u0130l_kodu\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0B)\u00a0<\/strong>Ders_ad\u0131\u00a0\u00a0\u00a0\u00a0\u00a0C)\u00a0<\/strong>Ders_kodu\u00a0\u00a0\u00a0\u00a0\u00a0D)\u00a0<\/strong>Ahmet<\/p>\n

5.\u00a0<\/strong>Bir tablodaki bir s\u00fctuna ait verilerin ba\u015fka bir tablonun s\u00fctunundan getirilmesini sa\u011flayan anahtar a\u015fa\u011f\u0131dakilerden hangisidir?
\nA)\u00a0<\/strong>Birincil Anahtar\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0B)\u00a0<\/strong>Yabanc\u0131 Anahtar\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0C)\u00a0<\/strong>S\u00fctunlar\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0D)\u00a0<\/strong>Unique k\u0131s\u0131tlamas\u0131<\/p>\n

6.\u00a0<\/strong>A\u015fa\u011f\u0131dakilerden hangisi \u201cbirincil anahtar\u201d alan\u0131 i\u00e7in uygun de\u011fildir?
\nA)\u00a0<\/strong>Do\u011fum tarihi\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0B)\u00a0<\/strong>T.C. kimlik numaras\u0131\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0C)\u00a0<\/strong>M\u00fc\u015fteri numaras\u0131\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0D)\u00a0<\/strong>Bir otomatik say\u0131 alan\u0131<\/p>\n

7.\u00a0<\/strong>Veri giri\u015flerinin belirtilen kriterlere g\u00f6re yap\u0131lmas\u0131n\u0131 sa\u011flayan k\u0131s\u0131tlay\u0131c\u0131 a\u015fa\u011f\u0131dakilerden hangisidir?
\nA)\u00a0<\/strong>Not Null k\u0131s\u0131tlamas\u0131\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0B)\u00a0<\/strong>Default K\u0131s\u0131tlamas\u0131\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0C)\u00a0<\/strong>Unique k\u0131s\u0131tlamas\u0131\u00a0\u00a0\u00a0D)\u00a0<\/strong>Check k\u0131s\u0131tlamas\u0131<\/p>\n

8.\u00a0<\/strong>( ) Normalle\u015ftirme, taslak veri taban\u0131 \u00fczerinde birtak\u0131m i\u015flemler yap\u0131larak tasla\u011f\u0131 son haline yakla\u015ft\u0131rma y\u00f6ntemidir.<\/p>\n

9.\u00a0<\/strong>( ) Veri taban\u0131 tablolar\u0131nda bir alana birden fazla veri giri\u015fi olabilir.<\/p>\n

10.\u00a0<\/strong>( ) Tablolarda bir bilginin birden fazla tekrarlanmas\u0131 bellekte fazla yer kaplamaz.<\/p>\n

11.\u00a0<\/strong>( ) Herhangi bir tablonun tekrarl\u0131 bilgiler i\u00e7erdi\u011fi duruma 2NF denir.<\/p>\n

12.\u00a0<\/strong>( ) Tablodaki benzersiz de\u011ferler i\u00e7eren her bir s\u00fctun ya da s\u00fctunlar grubu aday anahtar olarak adland\u0131r\u0131l\u0131r.<\/p>\n

13.\u00a0<\/strong>( ) Bir veritaban\u0131nda verilerin saklanm\u0131\u015f oldu\u011fu nesneler tablo olarak adland\u0131r\u0131l\u0131r.<\/p>\n

14.\u00a0<\/strong>( ) \u0130li\u015fkisel veri taban\u0131nda tablolarda birbirleri ile tamamen ayn\u0131 olan iki kay\u0131t kullan\u0131labilir<\/p>\n

15.\u00a0<\/strong>( ) Birincil anahtarlar birbiri ile ayn\u0131 olan de\u011ferler i\u00e7erebilir.<\/p>\n

16.\u00a0<\/strong>( ) Tablolarda ayn\u0131 tipte bilgiyi i\u00e7erecek alanlar\u0131n bulunmas\u0131 mutlak veri fazlal\u0131\u011f\u0131 sorunudur.<\/p>\n

17.\u00a0<\/strong>( ) Birinci normal formda haz\u0131rlanm\u0131\u015f bir tabloda ekleme, silme ve g\u00fcncelleme s\u0131ras\u0131nda sorunlar olabilir.<\/p>\n

18.\u00a0<\/strong>( ) Birinci normal formdan ikinci normal forma ge\u00e7i\u015fte k\u0131smi ba\u011f\u0131ml\u0131l\u0131klar\u0131n ortadan kald\u0131r\u0131lmas\u0131 gerekmektedir.<\/p>\n

19.\u00a0<\/strong>Tablolarda sat\u0131r ve s\u00fctunlar\u0131n kesi\u015fti\u011fi noktaya\u2026\u2026\u2026..\u2026 ad\u0131 verilir.<\/p>\n

20.\u00a0<\/strong>Veri taban\u0131nda depolanacak verileri k\u0131s\u0131tlayan ko\u015fullar\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026.olarak adland\u0131r\u0131l\u0131r.<\/p>\n

21.\u00a0<\/strong>( ) Veri Taban\u0131 yaz\u0131l\u0131m\u0131 bir i\u015fletim sistemidir.<\/p>\n

22.\u00a0<\/strong>( ) Veritaban\u0131nda bulunan verileri d\u0131\u015f ortamlara aktarabiliriz.<\/p>\n

23.\u00a0<\/strong>( ) Veritaban\u0131 nesneleri birbirleri ile ba\u011f\u0131ms\u0131zd\u0131r.<\/p>\n

24.\u00a0<\/strong>( ) Her veri taban\u0131 en az bir tablodan olu\u015fmak zorundad\u0131r.<\/p>\n

25.\u00a0<\/strong>( ) Formlar, verilerin ekranda, farkl\u0131 programlarda veya ka\u011f\u0131t \u00fczerinde tablolar h\u00e2linde sunulmas\u0131n\u0131 sa\u011flayan ara\u00e7lard\u0131r .<\/p>\n

26.\u00a0<\/strong>( ) Herhangi bir tabloya yeni s\u00fctunlar ekleyebilir veya istenilmeyen bir s\u00fctun silinebilir.<\/p>\n

27.\u00a0<\/strong>( ) Tablo tasar\u0131m g\u00f6r\u00fcn\u00fcm\u00fcnde iken bir alan\u0131 silmek i\u00e7in D\u0131\u015f Veri sekmesindeki Ara\u00e7lar grubunda yer alan Sat\u0131r Sil d\u00fc\u011fmesine t\u0131klan\u0131r.<\/p>\n

28.\u00a0<\/strong>( ) Tablolardaki alan adlar\u0131 en fazla 32 karakter olabilir.<\/p>\n

29.\u00a0<\/strong>( ) Tablolardaki alan adlar\u0131nda bo\u015fluk b\u0131rak\u0131labilir.<\/p>\n

30.\u00a0<\/strong>( ) otomatik say\u0131 veri t\u00fcr\u00fc, ard\u0131\u015f\u0131k veya rastgele olup benzersizdir.<\/p>\n

31.\u00a0<\/strong>( ) Metin veri t\u00fcr\u00fcnde alan boyutu belirlenirken \u00f6zellikler penceresinde yer alan varsay\u0131lan de\u011fer 60\u2019d\u0131r.<\/p>\n

32.\u00a0<\/strong>( ) Ge\u00e7erlilik metni, yanl\u0131\u015f veri giri\u015flerinde kar\u015f\u0131n\u0131za \u00e7\u0131kmas\u0131n\u0131 istedi\u011finiz bir uyar\u0131 metni olu\u015fturmak i\u00e7in kullan\u0131l\u0131r.<\/p>\n

33.\u00a0<\/strong>( ) Birincil anahtarlar hi\u00e7bir zaman NULL veya birbiri ile ayni olan de\u011ferleri i\u00e7ermezler<\/p>\n

34.\u00a0<\/strong>Veri taban\u0131n\u0131n temelini olu\u015fturan ve bilgilerin tutuldu\u011fu nesne a\u015fa\u011f\u0131dakilerden hangisidir?
\nA)\u00a0<\/strong>Formlar \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0B)\u00a0<\/strong>Tablolar\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0C)\u00a0<\/strong>Sorgular \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0D)\u00a0<\/strong>Raporlar<\/p>\n

35.\u00a0<\/strong>A\u015fa\u011f\u0131dakilerden hangisi tablolarda kullan\u0131lan veri t\u00fcrlerinden de\u011fildir?
\nA)\u00a0<\/strong>Metin\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0B)\u00a0<\/strong>Say\u0131\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0C)\u00a0<\/strong>Ek \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0D)\u00a0<\/strong>Bi\u00e7im<\/p>\n

36.\u00a0<\/strong>\u00dczerinde aritmetik i\u015flemler yap\u0131labilen ve i\u00e7inde parasal bilgi bulunmayan veri t\u00fcr\u00fc a\u015fa\u011f\u0131dakilerden hangisidir?
\nA)\u00a0<\/strong>Say\u0131 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0B)\u00a0<\/strong>Otomatik Say\u0131 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0C)\u00a0<\/strong>Para Birimi \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0D)\u00a0<\/strong>Not<\/p>\n

37.\u00a0<\/strong>Bir alana nas\u0131l veri girilece\u011finin denetlenmesi gerekti\u011fi durumlarda kullan\u0131lan veri tipi alan \u00f6zelli\u011fi a\u015fa\u011f\u0131dakilerden hangisidir?
\nA)\u00a0<\/strong>Bi\u00e7im\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0B)\u00a0<\/strong>Giri\u015f Maskesi \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0C)\u00a0<\/strong>Resim Yaz\u0131s\u0131 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0D)\u00a0<\/strong>Varsay\u0131lan De\u011fer<\/p>\n

38.\u00a0<\/strong>Ard\u0131nda bulun t\u00fcm karakterlerin k\u00fc\u00e7\u00fck harfle g\u00f6r\u00fcnt\u00fclenmesini sa\u011flayan karakter a\u015fa\u011f\u0131dakilerden hangisidir?
\nA)\u00a0<\/strong>? \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0B)\u00a0<\/strong>L \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0C)\u00a0<\/strong>> \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0D)\u00a0<\/strong><<\/p>\n

39.\u00a0<\/strong>Bir alana veri giri\u015fini zorunlu h\u00e2le getirmek i\u00e7in a\u015fa\u011f\u0131daki alan \u00f6zelliklerinden hangisi kullan\u0131l\u0131r?<\/p>\n

A)\u00a0<\/strong>Gerekli \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0B)\u00a0<\/strong>Ge\u00e7erlilik Metni\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0C)\u00a0<\/strong>Giri\u015f Maskesi \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0D)\u00a0<\/strong>Varsay\u0131lan De\u011fer 38<\/p>\n

40.\u00a0<\/strong>60\u2019dan b\u00fcy\u00fck ve 60\u2019 a e\u015fit kay\u0131tlar\u0131 g\u00f6steren \u00f6l\u00e7\u00fct hangisidir?<\/p>\n

A)\u00a0<\/strong>=>60\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0B)\u00a0<\/strong>=<60 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0C)\u00a0<\/strong>>=60 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0D)\u00a0<\/strong><=60<\/p>\n

41.\u00a0<\/strong>Veritaban\u0131nda Tablolar grubu hangi sekmede yer al\u0131r?
\nA)\u00a0<\/strong>Giri\u015f \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0B)\u00a0<\/strong>Olu\u015ftur\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0C)\u00a0<\/strong>D\u0131\u015f Veri \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0D)\u00a0<\/strong>Veri Taban\u0131 ara\u00e7lar\u0131<\/p>\n

42.\u00a0<\/strong>Not veri t\u00fcr\u00fcn\u00fcn kullan\u0131m amac\u0131 a\u015fa\u011f\u0131dakilerden hangisidir?
\nA)\u00a0<\/strong>\u0130ki de\u011ferli durumlardan bir tanesini se\u00e7mek i\u00e7in
\nB)\u00a0<\/strong>255 karakteri ge\u00e7meyen metinler eklemek i\u00e7in
\nC)\u00a0<\/strong>Ole nesnesi eklemek i\u00e7in
\nD)\u00a0<\/strong>Birden fazla sat\u0131rdan olu\u015fan uzun metin eklemek i\u00e7in<\/p>\n

43.\u00a0<\/strong>T\u0131kland\u0131\u011f\u0131 zaman kullan\u0131c\u0131y\u0131 belirtilen adrese y\u00f6nlendirmek i\u00e7in kullan\u0131lan veri t\u00fcr\u00fc a\u015fa\u011f\u0131dakilerden hangisidir?
\nA)\u00a0<\/strong>Ek\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0B)\u00a0<\/strong>K\u00f6pr\u00fc \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0C)\u00a0<\/strong>Metin \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0D)\u00a0<\/strong>Evet\/Hay\u0131r<\/p>\n

CEVAPLAR:\u00a0<\/strong>1- Yanl\u0131\u015f\u00a0\u00a0\u00a0 2- Yanl\u0131\u015f\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3-Do\u011fru\u00a0\u00a0\u00a0\u00a0 4-D\u00a0\u00a0\u00a0\u00a0 5-B\u00a0\u00a0\u00a0\u00a0 6-A\u00a0\u00a0\u00a0\u00a0 7-D\u00a0\u00a0\u00a0\u00a0 8- Do\u011fru\u00a0\u00a0\u00a0\u00a0 9- Yanl\u0131\u015f\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a010- Yanl\u0131\u015f\u00a0 11- Yanl\u0131\u015f\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a012-Do\u011fru\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a013-Do\u011fru\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a014- Yanl\u0131\u015f\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a015- Yanl\u0131\u015f\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a016- Do\u011fru\u00a0\u00a0\u00a0\u00a0 17- Do\u011fru\u00a0\u00a0\u00a0\u00a0 18- Do\u011fru\u00a0\u00a0\u00a0\u00a0 19-H\u00fccre \u00a0\u00a0\u00a0\u00a0\u00a020-B\u00fct\u00fcnl\u00fck k\u0131s\u0131tlamalar\u0131\u00a0\u00a0\u00a0\u00a0 21- Yanl\u0131\u015f\u00a0\u00a0\u00a0\u00a0 22- Do\u011fru\u00a0\u00a0\u00a0\u00a0 23- Yanl\u0131\u015f\u00a0\u00a0 24- Do\u011fru\u00a0\u00a0\u00a0 25- Yanl\u0131\u015f\u00a0\u00a0\u00a0\u00a0 26- Do\u011fru\u00a0\u00a0\u00a0\u00a0 27- Yanl\u0131\u015f\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a028- Yanl\u0131\u015f\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a029- Do\u011fru\u00a0\u00a0\u00a0 30-Do\u011fru\u00a0\u00a0\u00a0\u00a0 31- Yanl\u0131\u015f\u00a0\u00a0\u00a0\u00a0 32- Do\u011fru\u00a0\u00a0\u00a0\u00a0 33- Do\u011fru\u00a0\u00a0\u00a0\u00a0 34-B\u00a0\u00a0\u00a0\u00a0 35-D\u00a0\u00a0\u00a0\u00a0 36-A\u00a0\u00a0\u00a0\u00a0 37-B\u00a0\u00a0\u00a0\u00a0 38-D\u00a0\u00a0\u00a0\u00a0 39-A\u00a0\u00a0\u00a0\u00a0 40- C\u00a0\u00a0\u00a0 41-B\u00a0\u00a0\u00a0\u00a0 42- D\u00a0\u00a0\u00a0 43-B\u00a0\u00a0\u00a0\u00a0<\/strong><\/p>\n

 <\/p>\n

<\/div>\n

3- Veritaban\u0131nda Sorgular ve 4- Veritaban\u0131 Y\u00f6netimsel Fonksiyonlar\u0131<\/u><\/strong><\/p>\n

1. ( ) Tablolar\u0131n sat\u0131rlar\u0131n\u0131n herhangi bir s\u00fctuna g\u00f6re s\u0131ralanmas\u0131n\u0131n istendi\u011fi durumlarda SELECT deyimi ORDER BY ile birlikte kullan\u0131l\u0131r.<\/p>\n

2. ( ) MID() fonksiyonu bir karakter fonksiyonudur ve k\u00fc\u00e7\u00fck harfleri b\u00fcy\u00fck harfe d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in kullan\u0131l\u0131r.<\/p>\n

3. ( ) COUNT() fonksiyonu bir tablodaki kay\u0131tlar\u0131n say\u0131lmas\u0131 amac\u0131yla kullan\u0131lan fonksiyondur.<\/p>\n

4. Sorgu kullanarak tablo olu\u015fturmak i\u00e7in kullan\u0131lan SQL deyimi a\u015fa\u011f\u0131dakilerden hangisidir?
\nA) CREATE TABLE B) INSERT TABLE C) DELETE TABLE D) DROP TABLE<\/p>\n

5. ADD COLUMN deyiminin g\u00f6revi a\u015fa\u011f\u0131dakilerden hangisidir?
\nA) Tabloya sat\u0131r eklemek i\u00e7in kullan\u0131l\u0131r. B) Tabloya yeni bir ad vermek i\u00e7in kullan\u0131l\u0131r.
\nC) Tabloyu silmek i\u00e7in kullan\u0131l\u0131r. D) Tabloya s\u00fctun eklemek i\u00e7in kullan\u0131l\u0131r.<\/p>\n

6. \u00d6\u011eRENC\u0130LER tablosunda yer alan ADI ve B\u00d6L\u00dcM\u00dc alanlar\u0131n\u0131 se\u00e7mek i\u00e7in kullan\u0131lan SQL kodu a\u015fa\u011f\u0131dakilerden hangisidir?
\nA) SELECT ADI, B\u00d6L\u00dcM\u00dc FROM \u00d6\u011eRENC\u0130
\nB) INSERT ADI, B\u00d6L\u00dcM\u00dc FROM \u00d6\u011eRENC\u0130LER
\nC) SELECT AD, SOYAD, B\u00d6L\u00dcM\u00dc FROM \u00d6\u011eRENC\u0130LER
\nD) SELECT ADI, B\u00d6L\u00dcM\u00dc FROM \u00d6\u011eRENC\u0130LER<\/p>\n

7. B\u00fcy\u00fck harfleri k\u00fc\u00e7\u00fck harfe d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in kullan\u0131lan fonksiyon a\u015fa\u011f\u0131dakilerden hangisidir?
\nA) UCASE() B) LCASE C) MOD( ) D) CINT()<\/p>\n

8. Herhangi bir s\u00fctunun i\u00e7erdi\u011fi say\u0131sal de\u011ferlerin aritmetik ortalamas\u0131n\u0131 hesaplamak amac\u0131yla kullan\u0131lan fonksiyon a\u015fa\u011f\u0131dakilerden hangisidir?
\nA) SUM() B) STDEV() C) AVG() D) MAX()<\/p>\n

9. SELECT DateAdd(\u201cyyyy\u201d,2,#11\/22\/2010#); komut sat\u0131r\u0131 hangi sonucu \u00fcretir?
\nA) 2010 y\u0131l\u0131na 2 y\u0131l ekler. B) 11\/22\/2010 tarihine 2 g\u00fcn ekler.
\nC) 11\/22\/2010 tarihine 2 hafta ekler. D) Hi\u00e7biri<\/p>\n

10. ( ) Birinci tablodaki t\u00fcm sat\u0131rlar\u0131n ikinci tablodaki t\u00fcm sat\u0131rlarla birle\u015fmedi\u011fi durumlarda e\u015fiti olan birle\u015ftirme t\u00fcr\u00fc kullan\u0131l\u0131r.<\/p>\n

11. ( ) Tablolar birle\u015ftirilirken e\u015fiti olmayan birle\u015ftirme yapmak i\u00e7in INNER JOIN deyimi kullan\u0131l\u0131r.<\/p>\n

12. ( ) Tablo birle\u015ftirme s\u0131ras\u0131nda e\u015fle\u015fmeyen sat\u0131rlar\u0131n da birle\u015ftirilip sonuca dahil edilmesi istenilen durumlarda \u201cE\u015fiti olmayan birle\u015ftirme\u201d kullan\u0131l\u0131r.<\/p>\n

13. ( ) Sa\u011f d\u0131\u015f birle\u015ftirme olu\u015fturmak i\u00e7in RIGHT JOIN kullan\u0131l\u0131r.<\/p>\n

14. ( ) Alt sorgu i\u00e7erisinde ORDER BY s\u00f6zc\u00fc\u011f\u00fc kullan\u0131lamaz.<\/p>\n

15. ( ) All i\u015fleci alt sorgudaki kay\u0131tlar\u0131n de\u011ferine e\u015fit olmayan ana sorgu kay\u0131tlar\u0131n\u0131 almak i\u00e7in kullan\u0131l\u0131r.<\/p>\n

16. ( ) Alt sorgudan elde edilen sonu\u00e7ta tek sat\u0131rl\u0131k bir sonu\u00e7 elde ediliyorsa bu i\u015fleme \u00e7oklu sat\u0131r sorgular\u0131 denir.<\/p>\n

17. ( ) Bir tabloya sat\u0131r eklemek i\u00e7in INSERT INTO deyimi kullan\u0131l\u0131r.<\/p>\n

18. ( ) Values ifadesi ile ekleme yap\u0131lacak olan tablo ismi belirtilir.<\/p>\n

19. ( ) Insert Into i\u00e7inde fonksiyonlar kullan\u0131lamaz.<\/p>\n

20. ( ) Tablolarda g\u00fcncelleme i\u015flemini ger\u00e7ekle\u015ftirmek i\u00e7in Delete komutu kullan\u0131l\u0131r.<\/p>\n

21. ( ) Update komutu ile kullan\u0131lan SET ifadesi g\u00fcncellenecek alanlar ve bu alanlar\u0131n alacaklar\u0131 yeni de\u011ferleri belirlemek i\u00e7in kullan\u0131l\u0131r.<\/p>\n

22. ( ) Belirtilen tablodaki alanlar\u0131n de\u011ferlerini belirtilen \u00f6l\u00e7\u00fctlere g\u00f6re de\u011fi\u015ftirecek bir g\u00fcncelleme sorgusu olu\u015fturmak i\u00e7in UPDATE deyimi kullan\u0131l\u0131r.<\/p>\n

23. ( ) Veri taban\u0131nda verilere eri\u015febilmek i\u00e7in SELECT deyimi kullan\u0131lmaktad\u0131r.<\/p>\n

24. Tablolar\u0131n sat\u0131rlar\u0131n\u0131n herhangi bir s\u00fctuna g\u00f6re s\u0131ralanmas\u0131n\u0131n istendi\u011fi durumlarda SELECT deyimi \u2026\u2026\u2026 ile birlikte kullan\u0131l\u0131r.<\/p>\n

25. Bir dizenin i\u00e7erdi\u011fi say\u0131sal de\u011ferleri bi\u00e7imlendirilerek say\u0131sal veri t\u00fcr\u00fcne d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in \u2026\u2026.fonksiyonu kullan\u0131l\u0131r.<\/p>\n

26. Bilgisayardaki ge\u00e7erli sistem tarih ve saatini bildirmek i\u00e7in a\u015fa\u011f\u0131dakilerden hangisi kullan\u0131l\u0131r?
\nA) SELECT Now() B) SELECT Day() C) SELECT Tarih() D) SELECT Zaman()<\/p>\n

27. S\u00fctunlar\u0131n i\u00e7erdi\u011fi say\u0131sal de\u011ferleri toplamak amac\u0131yla kullan\u0131lan fonksiyon a\u015fa\u011f\u0131dakilerden hangisidir?
\nA) AVG() B) STDEV() C) SUM() D) VARP()<\/p>\n

28. Birden fazla s\u00fctun i\u00e7inde gruplama yapmak i\u00e7in a\u015fa\u011f\u0131dakilerden hangisi kullan\u0131l\u0131r?
\nA) ORDER BY B) GROUP BY C) SELECT BY D) FROM BY<\/p>\n

29. Tablolar\u0131n birle\u015ftirilmesi s\u0131ras\u0131nda e\u015fiti olan birle\u015ftirme yap\u0131l\u0131rken kullan\u0131lan deyim a\u015fa\u011f\u0131dakilerden hangisidir?
\nA) INNER JOIN B) LEFT JOIN C) RIGHT JOIN D) INSERT JOIN<\/p>\n

30. Alt sorgudaki kay\u0131tlar\u0131n de\u011ferine e\u015fit olmayan ana sorgu kay\u0131tlar\u0131n\u0131 almak i\u00e7in kullan\u0131lan i\u015fle\u00e7 a\u015fa\u011f\u0131dakilerden hangisidir?
\nA) SOME B) ANY C) ALL D) IN<\/p>\n

31. Bir tabloda bulunan kay\u0131tlar\u0131n istenildi\u011fi zaman silinebilmesi i\u00e7in kullan\u0131lan komut a\u015fa\u011f\u0131dakilerden hangisidir?
\nA) UPDATE B) INSERT C) DELETE D) WHERE<\/p>\n

32.( ) Veri taban\u0131nda bir veya birden fazla grup olu\u015fturmak i\u00e7in CREATE GROUP deyimi kullan\u0131l\u0131r.<\/p>\n

33.( ) Veri taban\u0131nda kullan\u0131c\u0131 olu\u015fturulurken tan\u0131mlanm\u0131\u015f olan parola, daha sonra de\u011fi\u015ftirilemez.<\/p>\n

34.( ) Kullan\u0131c\u0131lara veya belirli bir gruba yetki vermek i\u00e7in ALTER deyimi kullan\u0131l\u0131r.<\/p>\n

35.( ) Kullan\u0131c\u0131ya verilmi\u015f olan yetkileri iptal etmek i\u00e7in REVOKE deyimi kullan\u0131l\u0131r.<\/p>\n

36.( ) Veri taban\u0131nda tan\u0131mlanm\u0131\u015f olan bir kullan\u0131c\u0131 istenildi\u011fi zaman silinebilir.<\/p>\n

37.( ) G\u00f6r\u00fcn\u00fcmler kullan\u0131larak bir tablonun istenilen k\u0131s\u0131mlar\u0131n\u0131 g\u00f6r\u00fcnt\u00fcleyebilirsiniz.<\/p>\n

38.( ) Bir g\u00f6r\u00fcn\u00fcm olu\u015fturmak i\u00e7in SELECT VIEW deyimi kullan\u0131l\u0131r.<\/p>\n

39.( ) Olu\u015fturulmu\u015f olan bir g\u00f6r\u00fcn\u00fcm daha sonra silinemez.<\/p>\n

40. Veri taban\u0131nda kullan\u0131c\u0131 olu\u015fturmak i\u00e7in a\u015fa\u011f\u0131dakilerden hangisi kullan\u0131l\u0131r?
\nA) CREATE GROUP B) CREATE USER C) DROP USER D) ALTER USER<\/p>\n

41. Mevcut bir gruba daha \u00f6nceden tan\u0131mlanm\u0131\u015f olan kullan\u0131c\u0131 veya kullan\u0131c\u0131lar eklemek i\u00e7in a\u015fa\u011f\u0131dakilerden hangisi kullan\u0131l\u0131r?
\nA) ADD USER B) ADD GROUP C) CREATE USER D) CREATE GROUP<\/p>\n

42. Kullan\u0131c\u0131lara GRANT deyimi ile verilen ayr\u0131cal\u0131klar\u0131n istenildi\u011fi zaman geri al\u0131nabilmesi i\u00e7in a\u015fa\u011f\u0131dakilerden hangisi kullan\u0131l\u0131r?
\nA) CREATE B) SELECT C) DELETE D) REVOKE<\/p>\n

43. CREATE VIEW deyimi hangi ama\u00e7 i\u00e7in kullan\u0131l\u0131r?
\nA) Kullan\u0131c\u0131 olu\u015fturmak i\u00e7in B) G\u00f6r\u00fcnt\u00fc olu\u015fturmak i\u00e7in
\nC) G\u00f6r\u00fcnt\u00fc silmek i\u00e7in D) Kullan\u0131c\u0131 silmek i\u00e7in<\/p>\n

44. Olu\u015fturulan bir g\u00f6r\u00fcn\u00fcm\u00fc silmek i\u00e7in a\u015fa\u011f\u0131dakilerden hangisi kullan\u0131l\u0131r?
\nA) DELETE VIEW B) CREATE VIEW
\nC) DROP VIEW D) SELECT VIEW<\/p>\n

CEVAPLAR:<\/strong>\u00a01-Do\u011fru 2-Yanl\u0131\u015f 3-Do\u011fru 4-A 5-D 6-D 7-B 8-C 9-A 10-Yanl\u0131\u015f 11-Yanl\u0131\u015f 12-Do\u011fru 13-Do\u011fru 14-Do\u011fru 15-Yanl\u0131\u015f 16-Yanl\u0131\u015f 17-Do\u011fru 18-Yanl\u0131\u015f 19-Yanl\u0131\u015f 20-Yanl\u0131\u015f 21-Do\u011fru 22-Do\u011fru 23-Do\u011fru 24-Ordey By 25-Cint 26-A 27-C 28-B 29-A 30-D 31-C 32-D 33-Y 34-Y 35-D 36-D 37-D 38-Y 39-Y 40-B 41-A 42-D 43-B 44-C<\/p>\n","protected":false},"excerpt":{"rendered":"

1- Veritaban\u0131 Tasar\u0131m\u0131 ve\u00a02- Veritaban\u0131 Haz\u0131rlama 1. ( )\u00a0Bir ki\u015fiye veya \u00fcr\u00fcne ait detayl\u0131 verilerin bir d\u00fczen \u00e7er\u00e7evesinde sakland\u0131\u011f\u0131 ortamlar […]<\/p>\n","protected":false},"author":1,"featured_media":2212,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[180],"tags":[188],"class_list":["post-2201","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql","tag-veritabani-organizasyonu-calisma-sorulari-cevaplari"],"_links":{"self":[{"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/posts\/2201","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/comments?post=2201"}],"version-history":[{"count":1,"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/posts\/2201\/revisions"}],"predecessor-version":[{"id":2203,"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/posts\/2201\/revisions\/2203"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/media\/2212"}],"wp:attachment":[{"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/media?parent=2201"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/categories?post=2201"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/tags?post=2201"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}