NAMA :..........................................................
advertisement
PAK NANANG K RPL KELAS XI KOPETENSI NAMA :..................................................................... KELAS :............................./....................................... SECOR : AWAL ...................../SEKARANG................ TGL REMEDI:.................................................................... TGL PERIKSA:................................................................ NAMA INTRUKTUR : TDTANGAN:....................................................................... 1. Yang digunakan untuk menerangkan field name adalah .... A. type B. caption C. description D. properties E. field size 2. Yang termasuk aplikasi remote administrasi adalah .... A. MySQL B. PHP Nuke C. Vb script D. CSS E. SQL server 3. Cara menambah tabel baru di MySQL-front yaitu dengan .... A. conection B. drop database C. drop table D. create table E. create data base 4. Syntax yang digunakan untuk menghapus database dalam MySQL adalah .... A. create database name B. insert database name C. delete database name D. drop database name E. update database name 5. Halaman web yang dapat diakses dan berinteraksi sesuai dengan keinginan merupakan teknologi web yang berbasis.... A. konten B. struktural C. statis D. array E. dynamis 6. Syntax yang dapat digunakan untuk menghitung jumlah pengunjung pada buku tamu dari suatu WEB menggunakan .... A. sum B. shift register C. counter D. up Counter E. down counter 7. Yang mempengaruhi kecepatan dalam mengakses data pada transaksi on-line adalah.... A. decoder B. descripsi C. encoder D. encription E. bandwith 8. Penulisan tag HTML yang benar adalah .... A. <Tittle>............... <Tittle> B. <Head>.............<Head> C. <Html>................ <Head> D. <Body>............ <Body> E. <Html> ............. </Html> 9. Fungsi syntax / perintah Group By dalam MySQL adalah .... A. menampilkan data dengan kriteria tertentu B. menampilkan data dengan urutan tertentu C. menampilkan data yang diinginkan D. menambah data dan menampilkan kembali E. menambah data tanpa ketentuan 10. Di bawah ini adalah salah satu ciri website perdagangan elektronik atau E-Commerce yang baik, kecuali.... A. website yang dengan mudah dicari oleh mesin pencari internet B. website yang terus dikunjungi ( repeated traffic) C. website yang dapat mendorong pengunjung untuk merekomendasikan situs kita kepada orang lain D. website yang memberi fasilitas pada pengunjung untuk menawar harga E. website yang pengunjung merasa senang dan berlama-lama untuk melihat dan membaca 11. Auto increament berfungsi untuk.... A. mengisi angka yang selalu bertambah otomatis B. membatasi panjang masukan karakter C. mendeskripsikan data D. mengunci otomatis data E. mematikan angka PAK NANANG K RPL KELAS XI KOPETENSI 12. Cara membuat database baru di MySQL- front yaitu dengan .... A. create tabel B. conection C. drop database D. drop Tabel E. create database C. <table border="1"> <tr><td>baris 1, kolom 1</td> <td>baris 1, kolom 2</td> </tr><tr><td>baris 2, kolom 1</td> <td>baris 2, kolom 2</td></tr></table> 13. Type data INT dalam SQL berfungsi untuk.... A. menyatakan data berupa tanggal B. menyatakan data berupa waktu C. menyatakan data berupa karakter / string D. menyatakan data berupa angka E. menyatakan data berupa numeric D. <table border="1"> <tr> <td>Row 1, cell 1</td> <td>Row 1, cell 2</td> </tr> </table> 14. Web terdiri dari 4 (empat) hal yaitu ,kecuali? A. Hypertext B. Resource identifier C. Client-server D. Markup language E. Repeater E. </table> <p> < border=1> <tr> <td>Ini contoh tabel sederhana dengan border</td> </tr> </table> 15. Editor untuk membuat file HTML banyak tersedia, diantaranya,kecuali? A. Fronfage B. Notepad C. Drimwaver D. Crimson Editor E. Aphace 16. Ada beberapa macam key yang dapat diterapkan pada suatu tabel, terkecuali yaitu: A. Super key B. Candidate Key C. Primarikey D. Alternatif Key E. Prosedur Key 17. Penulisan untuk pepmbuatan tampilan tabel yang yang salah adalah ? A. </table> <p> <table border=1> <tr> <td>Ini contoh tabel sederhana dengan border</td> </tr> </table> B. <table border="1"> <tr> <td>baris 1, kolom 1</td> <td>baris 1, kolom 2</td> </tr></table> 18. Pada scriptor di bawh adalah contoh pembuatan ? <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Frameset//EN"> <html> <head> <title>Belajar menggunakan frame</title> </head> <frameset cols="20%, 80%"> <frame src="links.html" name="links"> <frame src="display.html" name="display"> <noframes> <body> <p> File ini menggunakan frame. Ikuti link <a href="noframes.html">tanpa frame</a> untuk menuju versi dari file ini tanpa frame </p> </body> </noframes> <frameset> <html> A. B. C. D. E. Profil Input data Tampilan data Conecsi Data Base Tampilan Menu Utama PAK NANANG K RPL KELAS XI KOPETENSI 19. Gambar Di bawah ini menu yand dapat menampilka Data adalah ? A. Browse B. Insert C.Structure D.Export E.Drop 20. Pada gambar di atas Untuk mengisi data pada MySQL dengan perintah click? A. Browse C. Structure B. Insert D.Export E.Drop 21. PHP mendukung data berikut di bawah ini, kecuali.... A. Integer B. Float C. Double D. String E. date 22. Salah satu bagian pemrograman web yang pemrograman webnya ditentukan pada sisi server adalah .... A. Web programming client B. Html programming C. Database programming D. Web server programming E. Database server 23. Yang termasuk aplikasi remote administrasi adalah .... A. MySQL B. PHP Nuke C. Vb script D. CSS E. SQL server 24. Yang digunakan untuk menerangkan field name adalah .... A. type B. caption C. description D. properties E. field size 25. Tabel berikut ini menunjukan SQL yang hasilnya jumlah data adalah .... A. select avg (jumlah) from t_dagangan where nmr_barang="NP200"; B. select count (jumlah) from t_dagangan C. select max (jumlah) from t_dagangan; D. select sum (jumlah) from t_dagangan where nmr_barang="NP200"; E. select sum (jumlah) from t_dagangan where tgl=20060304"; 26. Pada pembuatan blank database, langkah yang harus dilakukan setelah memilih blank database adalah mengisi .... A. create table B. update table C. create data D. create name E. input mask 27. Cara menambah tabel baru di MySQL-front yaitu dengan .... A. conection B. drop database C. drop table D. create table E. create data base 28. Syntax yang digunakan untuk menghapus database dalam MySQL adalah .... A. create database name B. insert database name C. delete database name D. drop database name E. update database name 29. Tuliskan SQL untuk menghitung jumlah customer yang terdapat di negara France dari tabel customer.... A. select (customer id) from customer where country "france" B. select count(customer id) from customer where country = "france " C. select customer id where country "france " D. select count (customer id)where= "france " E. select customer id where country = "france " 30. Halaman web yang dapat diakses dan berinteraksi sesuai dengan keinginan merupakan teknologi web yang berbasis.... A. konten B. struktural C. statis D. array E. dynamis PAK NANANG K RPL KELAS XI KOPETENSI 31. Syntax yang dapat digunakan untuk menghitung jumlah pengunjung pada buku tamu dari suatu WEB menggunakan .... A. sum B. shift register C. counter D. up Counter E. down counter 32. Dalam pemrograman database untuk ruang lingkup permintaan data atau pencarian dan penilaian data yang disajikan dengan perintah SELECT merupakan istilah J A. Database B. SQL C. Query data D. DML E. DDL 33. Atribut / field yang unik yang dapat membedakan entity / table satu dengan yang lainnya adalah J A. Foreig key B. Primary key C. Candidat key D. Alternative key E. Komposisis key 34. Type data INT dalam SQL berfungsi untuk.... A. menyatakan data berupa tanggal B. menyatakan data berupa waktu C. menyatakan data berupa karakter / string D. menyatakan data berupa angka E. menyatakan data berupa numeric 35. Didalam paket Exam atau Wamp Server agar Web yang kita buat bisa berjalan di perankan oleh plikasi: A. Aphace B. PHP C. MYSQL D. Internet Explor E. Notpad PAK NANANG K RPL KELAS XI KOPETENSI SPACKSIPIKASI KOMPUTER NO KOMPONEN Merek Satuan Mhz /Ghz/ x PS 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 .. Tgl Parap Penguji secore Parap Peserta ......................... Nanang Komarudin, S.Kom ................................................ PAK NANANG K RPL KELAS XI KOPETENSI JOBSET PRATEKUM Laporan Hasil Pratek Produktif Tgl: Praktekum Hari: Nama Peserta Nama Instruktur Paraf Paraf score JUDUL PRAKTEK 1. Nama Praktik :........................................................................................................ 2. Bahan Yang dibutuhkan : a. OS........................................... b. PC............................................... c. Penghubung LAN............................ d. ....................................................... e. ......................................................... f. IP Router:.......................................... g. IP DNS............................................. h. IP ISP:................................................ 3. Alat Pendukung a. Obeng (-)/(+) b. Tang c. Cleiner d. Avo Meter 4. Prosedur Langkah Kerja ................................................................................................................................................................... ................................................................................................................................................................... ......................................................................................................................... 5. K3LH ................................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................... ......................................................................................................... 6. Langkah Kerja.Praktek..Intaasi .............................................................................................. 7. ................................................................................................................................................................... ............................................................................................................................... 8. ................................................................................................................................................................... ............................................................................................................................. 9. ................................................................................................................................................... 10. ................................................................................................................................................... 11. ................................................................................................................................................... 12. ................................................................................................................................................... 13. ................................................................................................................................................... 14. ................................................................................................................................................... 15. ................................................................................................................................................... 16. ................................................................................................................................................... 17. ................................................................................................................................................... 18. ................................................................................................................................................... 19. ................................................................................................................................................... PAK NANANG K RPL KELAS XI KOPETENSI 20. 21. 22. 23. ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... PAK NANANG K RPL KELAS XI KOPETENSI PAK NANANG K RPL KELAS XI KOPETENSI FLOWCHAT PAK NANANG K RPL KELAS XI KOPETENSI KESIMPULAN LAPORAN PRAKTEK PAK NANANG K RPL KELAS XI KOPETENSI NAMA :..................................................................... KELAS :............................./....................................... SECOR : AWAL ...................../SEKARANG................ TGL REMEDI:.................................................................... TGL PERIKSA:................................................................ NAMA INTRUKTUR : TDTANGAN:....................................................................... 1. Yang digunakan untuk menerangkan field name adalah .... A. type B. caption C. description D. properties E. field size 2. Yang termasuk aplikasi remote administrasi adalah .... A. MySQL B. PHP Nuke C. Vb script D. CSS E. SQL server 3. Cara menambah tabel baru di MySQL-front yaitu dengan .... A. conection B. drop database C. drop table D. create table E. create data base 4. Syntax yang digunakan untuk menghapus database dalam MySQL adalah .... A. create database name B. insert database name C. delete database name D. drop database name E. update database name 5. Halaman web yang dapat diakses dan berinteraksi sesuai dengan keinginan merupakan teknologi web yang berbasis.... A. konten B. struktural C. statis D. array E. dynamis 6. Syntax yang dapat digunakan untuk menghitung jumlah pengunjung pada buku tamu dari suatu WEB menggunakan .... A. sum B. shift register C. counter D. up Counter E. down counter 7. Yang mempengaruhi kecepatan dalam mengakses data pada transaksi on-line adalah.... A. decoder B. descripsi C. encoder D. encription E. bandwith 8. Penulisan tag HTML yang benar adalah .... A. <Tittle>............... <Tittle> B. <Head>.............<Head> C. <Html>................ <Head> D. <Body>............ <Body> E. <Html> ............. </Html> 9. Fungsi syntax / perintah Group By dalam MySQL adalah .... A. menampilkan data dengan kriteria tertentu B. menampilkan data dengan urutan tertentu C. menampilkan data yang diinginkan D. menambah data dan menampilkan kembali E. menambah data tanpa ketentuan 10. Di bawah ini adalah salah satu ciri website perdagangan elektronik atau E-Commerce yang baik, kecuali.... A. website yang dengan mudah dicari oleh mesin pencari internet B. website yang terus dikunjungi ( repeated traffic) C. website yang dapat mendorong pengunjung untuk merekomendasikan situs kita kepada orang lain D. website yang memberi fasilitas pada pengunjung untuk menawar harga E. website yang pengunjung merasa senang dan berlama-lama untuk melihat dan membaca 11. Auto increament berfungsi untuk.... A. mengisi angka yang selalu bertambah otomatis B. membatasi panjang masukan karakter C. mendeskripsikan data D. mengunci otomatis data E. mematikan angka PAK NANANG K RPL KELAS XI KOPETENSI 12. Cara membuat database baru di MySQL- front yaitu dengan .... A. create tabel B. conection C. drop database D. drop Tabel E. create database C. <table border="1"> <tr><td>baris 1, kolom 1</td> <td>baris 1, kolom 2</td> </tr><tr><td>baris 2, kolom 1</td> <td>baris 2, kolom 2</td></tr></table> 13. Type data INT dalam SQL berfungsi untuk.... A. menyatakan data berupa tanggal B. menyatakan data berupa waktu C. menyatakan data berupa karakter / string D. menyatakan data berupa angka E. menyatakan data berupa numeric D. <table border="1"> <tr> <td>Row 1, cell 1</td> <td>Row 1, cell 2</td> </tr> </table> 14. Web terdiri dari 4 (empat) hal yaitu ,kecuali? A. Hypertext B. Resource identifier C. Client-server D. Markup language E. Repeater E. </table> <p> < border=1> <tr> <td>Ini contoh tabel sederhana dengan border</td> </tr> </table> 15. Editor untuk membuat file HTML banyak tersedia, diantaranya,kecuali? A. Fronfage B. Notepad C. Drimwaver D. Crimson Editor E. Aphace 16. Ada beberapa macam key yang dapat diterapkan pada suatu tabel, terkecuali yaitu: A. Super key B. Candidate Key C. Primarikey D. Alternatif Key E. Prosedur Key 17. Penulisan untuk pepmbuatan tampilan tabel yang yang salah adalah ? A. </table> <p> <table border=1> <tr> <td>Ini contoh tabel sederhana dengan border</td> </tr> </table> B. <table border="1"> <tr> <td>baris 1, kolom 1</td> <td>baris 1, kolom 2</td> </tr></table> 18. Pada scriptor di bawh adalah contoh pembuatan ? <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Frameset//EN"> <html> <head> <title>Belajar menggunakan frame</title> </head> <frameset cols="20%, 80%"> <frame src="links.html" name="links"> <frame src="display.html" name="display"> <noframes> <body> <p> File ini menggunakan frame. Ikuti link <a href="noframes.html">tanpa frame</a> untuk menuju versi dari file ini tanpa frame </p> </body> </noframes> <frameset> <html> A. B. C. D. E. Profil Input data Tampilan data Conecsi Data Base Tampilan Menu Utama PAK NANANG K RPL KELAS XI KOPETENSI 19. Gambar Di bawah ini menu yand dapat menampilka Data adalah ? A. Browse B. Insert C.Structure D.Export E.Drop 20. Pada gambar di atas Untuk mengisi data pada MySQL dengan perintah click? A. Browse C. Structure B. Insert D.Export E.Drop 21. PHP mendukung data berikut di bawah ini, kecuali.... A. Integer B. Float C. Double D. String E. date 22. Salah satu bagian pemrograman web yang pemrograman webnya ditentukan pada sisi server adalah .... A. Web programming client B. Html programming C. Database programming D. Web server programming E. Database server 23. Yang termasuk aplikasi remote administrasi adalah .... A. MySQL B. PHP Nuke C. Vb script D. CSS E. SQL server 24. Yang digunakan untuk menerangkan field name adalah .... A. type B. caption C. description D. properties E. field size 25. Tabel berikut ini menunjukan SQL yang hasilnya jumlah data adalah .... A. select avg (jumlah) from t_dagangan where nmr_barang="NP200"; B. select count (jumlah) from t_dagangan C. select max (jumlah) from t_dagangan; D. select sum (jumlah) from t_dagangan where nmr_barang="NP200"; E. select sum (jumlah) from t_dagangan where tgl=20060304"; 26. Pada pembuatan blank database, langkah yang harus dilakukan setelah memilih blank database adalah mengisi .... A. create table B. update table C. create data D. create name E. input mask 27. Cara menambah tabel baru di MySQL-front yaitu dengan .... A. conection B. drop database C. drop table D. create table E. create data base 28. Syntax yang digunakan untuk menghapus database dalam MySQL adalah .... A. create database name B. insert database name C. delete database name D. drop database name E. update database name 29. Tuliskan SQL untuk menghitung jumlah customer yang terdapat di negara France dari tabel customer.... A. select (customer id) from customer where country "france" B. select count(customer id) from customer where country = "france " C. select customer id where country "france " D. select count (customer id)where= "france " E. select customer id where country = "france " 30. Halaman web yang dapat diakses dan berinteraksi sesuai dengan keinginan merupakan teknologi web yang berbasis.... A. konten B. struktural C. statis D. array E. dynamis PAK NANANG K RPL KELAS XI KOPETENSI 31. Syntax yang dapat digunakan untuk menghitung jumlah pengunjung pada buku tamu dari suatu WEB menggunakan .... A. sum B. shift register C. counter D. up Counter E. down counter 32. Dalam pemrograman database untuk ruang lingkup permintaan data atau pencarian dan penilaian data yang disajikan dengan perintah SELECT merupakan istilah J A. Database B. SQL C. Query data D. DML E. DDL 33. Atribut / field yang unik yang dapat membedakan entity / table satu dengan yang lainnya adalah J A. Foreig key B. Primary key C. Candidat key D. Alternative key E. Komposisis key 34. Type data INT dalam SQL berfungsi untuk.... A. menyatakan data berupa tanggal B. menyatakan data berupa waktu C. menyatakan data berupa karakter / string D. menyatakan data berupa angka E. menyatakan data berupa numeric 35. Didalam paket Exam atau Wamp Server agar Web yang kita buat bisa berjalan di perankan oleh plikasi: A. Aphace B. PHP C. MYSQL D. Internet Explor E. Notpad KOMPONEN PAK NANANG K RPL KELAS XI KOPETENSI NO 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 .. Tgl Parap Penguji Nanang Komarudin, S.Kom Parap Peserta Satuan Mhz /Ghz/ x PS SPACKSIPIKASI KOMPUTER Merek secore ......................... ................................................ score Praktekum PAK NANANG K RPL KELAS XI KOPETENSI Tgl: Hari: JUDUL PRAKTEK JOBSET PRATEKUM Nama Peserta Paraf Nama Instruktur Laporan Hasil Pratek Produktif Paraf 1. Nama Praktik :........................................................................................................ 2. Bahan Yang dibutuhkan : a. OS........................................... b. PC............................................... c. Penghubung LAN............................ d. ....................................................... e. ......................................................... f. :.......................................... g. ............................................. h. :................................................ 3. Alat Pendukung a. ........................................................... b. ............................................................ c. ............................................................. d. ............................................................... e. .............................................................. f. ............................................................ g. 4. Prosedur Langkah Kerja ................................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................... 5. K3LH ................................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................... ......................................................................................................... 6. Langkah Kerja.Praktek..Intaasi .............................................................................................. 7. ................................................................................................................................................................... ............................................................................................................................... 8. ................................................................................................................................................................... ............................................................................................................................. 9. ................................................................................................................................................... 10. ................................................................................................................................................... 11. ................................................................................................................................................... PAK NANANG K RPL KELAS XI KOPETENSI 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. 22. 23. 24. 25. 26. 27. 28. 29. 30. 31. 32. 33. 34. 35. 36. ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................. ................................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................. ................................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................. ................................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................. ................................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................. ................................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................. ................................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................. ................................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................. ................................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................. ................................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................. ................................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................. ................................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................. ................................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................. ................................................................................................................................................................... ................................................................................................................................................................... PAK NANANG K RPL KELAS XI KOPETENSI 37. 38. 39. 40. 41. 42. 43. 44. 45. 46. 47. 48. 49. 50. 51. 52. ................................................................................................................................................................... ................................................................................................................................................................. ................................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................. ................................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................. ................................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................. ................................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................. ................................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................. ................................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................. ................................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................. ................................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................. ................................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................. ................................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................. ................................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................. ................................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................. ................................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................. ................................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................. ................................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................. ................................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................... ................................................................................................................................................................. PAK NANANG K RPL KELAS XI KOPETENSI FLOWCHAT PAK NANANG K RPL KELAS XI KOPETENSI KESIMPULAN LAPORAN PRAKTEK