View Single Post
  #1  
Old 20th November 2011
Linuxmania Linuxmania is offline
Ceriwiser
 
Join Date: Nov 2011
Posts: 392
Rep Power: 14
Linuxmania mempunyai hidup yang Normal
Default TES TERTULIS ORACLE MASUK PERUSAHAAN BESAR[Yang Ngerti ORACLE MASUK]

Sebelumnya,Info Lowongan Ter Update,Anda2 yang akan Memasuki Dunia Kerja,Bisa Mencari Lowongan Pekerjaan Disini. Dalam & Luar Negeri Lengkap.






Quote:





Sedikit Berbagi Pengalaman

Dua Hari Lalu Saya cari2 Lowongan Pekerjaan di JOBSDB.COM Khususnya didaerah Jakarta Pusat.Pada Jobsdb.com Saya Dapat salah satu Perusahaan: PT. Austindo Nusantara Jaya Rent (ANJR) is an Outsourcing Service Provider for company's transportation needs.Pada saat itu ada penerimaan Di Bidang IT Staff Hardware Support.

Seperti Biasa dlm melamar pekerjaan saya Mempersiapkan CV Lamaran Pekerjaan saya,sedikit merubah Penampilan,karena akan Melewati Tahap Lisan (interview) & Tertulis. Luar biasa Susah Bangat Tes Tertulisnya,karena kita Harus bisa Menjawab soal2 tes dari beberapa jenis soal Tertulis sesuai Syarat Penerimaan.Salah satunya tentang ORACLE. Berikut Saya Share Soal2 TES TERTULIS ORACLE Standar INTERNATIONAL,Kali Aja diantara Anda2 yang Mendalami dunia IT,sudah tamat S1/ punya banyak pengetahuan khusus & Pengalaman di Bidang IT,Mencoba untuk mengadu Nasib di bidang IT STAFF Hardware support Atau Personalia Database Server dan bidang2 IT Lainnya di dalam suatu perusaahan Besar,disini saya berbagi soal2 ORACLE ber Standar International. Karena Oracle sekarang termasuk salah satu yang sangat penting Untuk dikuasai terutama untuk Masuk Perusahaan2 Besar Di Indonesia,contoh: Perusahaan Indosat,Bank Indonesia,XL etc.Apalagi husunya Perusaaahan2 daerah Pulau Jawa,bahkan Oracle sudah Go International.

Bayangkan saja Jika Anda Go International,Untuk Gaji sebagai Staff It di Negara tetangga seperti Singapore,apabila bisa menguasai dATABASE server,dan Mengerti Oracle,Gaji bisa berkisar 30 sampai dengan 40 juta/bulan. Memang sih biaya hidup disana cukup besar,Namun klw kita bandingkan dengan Gaji Staff IT di Indonesia berbeda Jauh.

catatan: Syarat GO international untuk Toefl aja 550.

Bisa Berbahasa Inggris dengan baik






Quote:





Jadi,Berikut Soal2 Tes Tertulis Oracle Standar INTERNATIONAL,Tapi tidak Beserta Jawabanya,karena sambil Melatih Kepintaran Anda2 yang Mengerti Oracle






Quote:





Memang Soalnya Berbahasa Inggris,Karena Ber standar International,begitu Juga pada saat Interview pada Umumnya Berbahasa Inggris.Semoga Bermamfaat






Spoiler for SOAL TES:





Quote:





DBA (DATABASE ADMINISTRATOR)



1. Oracle Architecture



Q. 1 : What is a Schema

1. A Physical Organization of Objects in the Database

2. A Logical Organization of Objects in the Database

3. A Scheme Of Indexing

4. None of the above



Q. 2 : An Oracle Instance is

1. Oracle Memory Structures 3. Oracle Background Processes

2. Oracle I/O Structures 4. All of the Above



Q. 3 : The SGA Consists of the Following Items

1. Buffer Cache 3. Redo Log Buffer

2. Shared Pool 4. All of the Above



Q. 4 : The area that stores the blocks recently used by SQL statements is called

1. Shared Pool

2. Buffer Cache

3. PGA

4. UGA



Q. 5 : Which of the following is not a Background Server Process in an Oracle Server

1. DB Writer

2. DB Reader

3. Log Writer

4. SMON



Q. 6 : Which of the following is a valid background server processes in Oracle

1. ARCHiver

2. LGWR ( Log Writer )

3. DBWR ( Dbwriter )

4. All of the above



Q. 7 : The process that writes the modified blocks to the data files is

1. DBWR 3. PMON

2. LGWR 4. SMON



Q. 8 : The process that records information about the changes made by all transactions that commit is

1. DBWR

2. SMON

3. CKPT

4. None of the above



Q. 9 : Oracle does not consider a transaction committed until

1. The Data is written back to the disk by DBWR

2. The LGWR successfully writes the changes to redo

3. PMON Process commits the process changes

4. SMON Process Writes the data



Q. 10 : The process that performs internal operations like Tablespace Coalescing is

1. PMON 3. DBWR

2. SMON 4. ARCH



Q. 11 : The process that manages the connectivity of user sessions is

1. PMON

2. SMON

3. SERV

4. NET8



Q. 12 : The ARCH process is enabled when the database runs in a

1. PARALLEL Mode

2. ARCHIVE LOG Mode

3. NOARCHIVELOG Mode

4. None of the above



Q. 13 : What performs the Check Point in the absence of a CKPT Process

1. DBWR

2. LGWR

3. PMON

4. SMON



Q. 14 : If an application requests data that is already in the memory, it is referred to as a

1. Cache Read

2. Cache Hit

3. Cache Miss

4. Cache Latch



Q. 15 : If the data requested is in the memory but had to be reloaded due to aging, it is referred to as

1. CACHE HIT

2. CACHE REFRESH

3. CACHE RELOAD

4. None of the above



Q. 16 : If the data requested is not in the servers memory, it is referred to as

1. CACHE DISK

2. CACHE MISS

3. CACHE READ

4. None of the above



Q. 17 : You can Dynamically resize the following Parameters in the SGA

1. Buffer Cache

2. Library Cache

3. Dictionary Cache

4. None of the above



Q. 18 : The memory area that stores the parsed representation of most recently executed Statements is

1. BUFFER CACHE8

2. LIBRARY CACHE

3. DICTIONARY CACHE

4. NONE OF THE ABOVE







Quote:





Jika Anda2 Bisa Menjawab Jawabannya,Kita Bisa Berbagi Disini.

Dan Membahasnya Bersama2.




















Reply With Quote