Belajar Cara Setir Mobil Tanpa Perlu Kursus

Panduan Cara Setir Mobil Tanpa Perlu Kursus

Artikel saya ini sengaja saya susun untuk mengingat pengalaman saya belajar setir mobil beberapa tahun yang lalu, saya menulis ini juga untuk menyemangati diri agar segera bisa memiliki "Mobil Keluarga Terbaik Di Indonesia". Dalam menuliskan ini saya banyak juga mengambil referensi dari blog http://bima.ipb.ac.id/~anita/kursus_stir_mobil.htm

Ok, langsung saja kita mulai pelajaran setir mobil sendiri tanpa kursus:


1. Posisi:
- Urutan pedal : Kopling (selalu kaki kiri yang menginjaknya), Rem dan Gas (pakai kaki kanan secara bergantian)
- Siapkan mobil dan surat-suratnya

2. Menghidupkan mobil dalam keadaan kopling di gigi nol

1) Pasang tali / sabuk pengaman
2) Putar kunci untuk menghidupkan mesin
3) Hidupkan AC
4) Turunkan Rem Tangan
5) Injak kopling habis, pindahkan gigi ke gigi 1
6) Angkat kopling pelan2
7) sambil Injak gas sedikit demi sedikit sampai terasa mobil bergerak

3. Memundurkan mobil
1) Injak kopling habis, pindahkan gigi ke gigi R
2) Angkat kopling pelan2. Rasakan sampai mobil terasa bergerak mundur. Atur bergerak mundurnya mobil dengan cara menginjak dan mengangkat kopling sekuku sampai dengan � kopling (jangan lebih dan jangan mengangkat terlalu cepat agar mesin tidak mati)

4. Ganti gigi pada saat mobil berjalan (kaki kanan masih menginjak gas)
1) Injak kopling habis
2) Angkat gas
3) Pindahkan gigi ke posisi yang dikendaki
4) Angkat kopling pelan2
5) Injak gas pelan2, sampai terasa jalannya mobil stabil sesuai dengan kecepatan seharusnya
6) Lepaskan kaki dari kopling, atur jalannya mobil hanya dengan menginjak dan mengkat gas saja

5. Melalui polisi tidur
1) Angkat gas, tempel pedal rem
2) Injak kopling habis, pindahkan ke gigi 1
3) Angkat kopling pelan2, mobil dijalankan hanya dengan mengangkat kopling sekuku sampai setengah kopling atau kopling tak usah diinjak, biarkan saja mobil bergerak memakai lumpsum nya.
4) jika dirasa polisi tidur terlalu tinggi, Injak gas sedikit sampai dirasa mobil bisa melewati polisi tidur
5) Setelah dapat melewati polisi tidur injak gas pelan2

6. Menambah/mengurangi gigi
1) Injak kopling habis
2) Angkat gas
3) Pindahkan gigi ke gigi yang dikehendaki
3) Tempel gas
4) Angkat kaki dari kopling pelan2

7. Menghentikan mobil tiba2 dalam keadaan mobil sedang berjalan cepat
1) Injak rem pelan2 sampai terasa mobil berhenti
2) Injak kopling habis
3) Pindahkan gigi ke gigi 0
4) Angkat rem tangan

8. Menghadapi macet di lampu merah menggunakan rem
1) Injak kopling habis
2) Tempelkan kaki di rem (mainkan sesuai keadaan jalan)
3) Pindahkan gigi ke gigi 1
3) Angkat kopling sedikit demi sedikit untuk menjalankan mobil merayap atau injak saja kopling habis biarkan mobil berjalan menggunakan lumpsump nya

9. Menghadapi macet di lampu merah tanpa menggunakan rem, atau ketika hendak keluar dari gang ke jalan raya
1) Injak kopling habis
2) Tempelkan kaki di rem
3) Pindahkan gigi ke gigi 1
3) Angkat kopling sedikit demi sedikit untuk menjalankan mobil merayap
4) atau injak saja kopling habis biarkan mobil berjalan menggunakan lumpsump nya
5) Tempel kaki di gas

10. Berhentikan mobil: Angkat kopling sekuku dan injak rem sedikit (tempel rem)

11. Jalankan mobil merayap: Angkat kopling sekuku (Dengan posisi ini mobil akan berjalan merayap)

12. Belok balik (berputar balik 180o) ke kanan П
a) Jika mobil melaju terlalu cepat, tempel gas
b) Injak kopling habis
c) Angkat gas
d) Pindahkan gigi ke gigi 1
e) Angkat kopling sedikit demi sedikit untuk menjalankan mobil merayap (=bergerak perlahan), dan injak kopling sekuku kalau ingin mengurangi jalan merayapnya mobil, lihat jalur apakah bebas jika ada mobil yang ingin lewat maka injak lagi kopling sekuku sambil menempel rem atau menempel gas (sebaiknya dipilih memberhentikan mobil dengan menempel gas agar jika mau jalan lagi tinggal lepaskan gas dan angkat kopling saja sekuku).
Jika jalur sudah bebas hambatan, angkat kopling sekuku (mobil merayap maju)

f) Putar stir 2 x ke kanan (putar stir habis) (ingat jangan memutar stir dalam keadaan mobil diam/berhenti, bisa merusak komponen mobilnya nanti) (lihat jalur apakah bebas atau tidak)

- Jika jalur aman, jalankan/belokkan mobil dengan mengangkat kopling sekuku (mobil akan maju merayap), kurangi laju jalannya mobil dengan menginjak kopling sekuku

- Jika jalur sibuk berhentikan mobil dengan kombinasi mengangkat kopling sekuku dengan menempel rem (biasanya jika kopling diangkat sekuku akan terasa mobil bergetar sedikit)

- Jika jalur sudah bebas kembali ankat kopling sekukumkembali (mobil akan merayap maju kembali)

g) Setelah mobil berhasil belok dan dirasa sudah lurus, segera putar balik stir 2x ke kiri sambil mobil maju merayap

- Jika mobil sudah lurus, tempel gas (sesuaikan dengan kondisi lalu lintas), angkat kopling perlahan, jika sudah sesuai dengan kondisi jalan yang dihadapi lepaskan kaki dari pedal kopling biarkan jalannya mobil hanya diatur oleh gas
(gunakan gigi 1, 2, dan 3 saja jika berada di dalam kota)

13. Menghidupkan mobil yang mati mesin tiba2
1) Jangan panik !
2) Injak kopling habis
3) Angkat kopling perlahan2, rasakan sampai mobil bergerak maju perlahan
- Jika jalan menanjak, bantu tenaga mobil dengan menginjak gas sedikit
- Jika mobil sedah bergerak stabil, angkat kaki dari kopling, jalankan mobil hanya dengan gas saja

14. Macet di jalan tanjakan
1) Gigi dalam posisi gigi 1 (sebaiknya selalu gunakan gigi 1 kalau jalanan macet)
2) Injak kopling habis
3) Angkat kopling perlahan2, rasakan sampai mobil bergerak maju perlahan. Jika jalan menanjak, bantu tenaga mobil dengan menginjak gas sedikit. Jika mobil didepan berhenti di tanjakan , injak kopling habis, injak rem.

- Jika mobil di depan mulai bergerak sedikit di jalan tanjakan , angkat kopling perlahan sampai � kopling (rasakan sampai mobil bergetar)(agar mobil tidak mundur ketika melapas rem), baru lepaskan rem, tempel gas.

- Jika mobil di depan berhenti lama, injak rem, injak kopling, pindahkan gigi ke gigi 0, angkat rem tangan, angkat kaki dari kopling. Jika mobil di depan mulai bergerak maju, injak habis kopling, tekan rem tangan, injak pedal rem, masukkan gigi ke gigi 1, angkat kopling sekuku sampai mobil terasa bergetar sedikit (agar mobil tidak mundur), tempel gas

15. Tanjakan tanpa menggunakan rem
1) Gigi dalam posisi gigi 1
2) Injak kopling
3) Angkat kopling sekuku (mobil akan bergerak maju perlahan, MOBIL BERJALAN)
4) Injak kopling sekuku diimbangi dengan menginjak/menempel gas sedikit (mobil akan berhent, MOBIL BERHENTIi)
5) Angkat kopling sekuku (mobil akan merayap maju kembali, MOBIL BERJALAN). Untuk berjalan atau dan berhenti dalam posisi ini hanya menggunakan kombinasi injak dan angkat koling sekuku

16. Tiba2 ada orang menyeberang
1) Angkat gas
2) Injak rem
3) Injak kopling habis

17. Macet di jalan rata
1) Gigi dalam posisi gigi 1
2) Injak kopling habis
3) Angkat kopling perlahan2, rasakan sampai mobil bergerak maju perlahan

- Jika mobil di depan berhenti tiba2, injak rem perlahan atau angkat kopling sekuku sambil injak gas sedikit. Kombinasi kopling dangan gas ketika mobil didepan berhenti tiba2 lebih baik digunakan sehingga kalau mobil di depan maju tinggal angkat kopling sambil tempel gas. Jadi maju dan berhentinya mobil hanya menggunakan kombinasi kopling dan gas !

- Jika mobil di depan mulai bergerak maju sedikit, injak kopling habis, lalu angkat kopling sekuku rasakan mobil mulai maju merayap

- Jika mobil di depan mulai berhenti perlahan, angkat kopling sekuku, injak gas (rasakan sampai terasa mobil berhenti perlahan)

- Jika mobil di depan berhenti lama, injak rem, injak kopling, pindahkan gigi ke gigi 0, angkat rem tangan, angkat kaki dari kopling. Jika mobil di depan mulai bergerak maju, injak habis kopling, tekan rem tangan, masukkan gigi ke gigi 1, angkat kopling sampai terasa mobil maju jika perlu boleh tambahkan dengan menginjak gas

18. Macet di jalan turunan
1) Gigi dalam posisi gigi 0
2) Mainkan rem saja tak perlu gas karena mobil akan berjalan dengan sendirinya tanpa di gas

19. Mobil sedang melaju cepat tiba2 mobil didepan jalan merayap
1) Injak rem perlahan
2) Injak kopling habis, pindahkan ke gigi 1
3) Angkat kopling sekuku biarkan mobil maju merayap
4) jika mobil di depannya berhenti tinggal menginjak kopling lalu angkat sedikit kombinasikan dengan menginjak gas sampai mobil terasa berhenti perlahan, atau injak kopling dan tempel rem

20. Menghentikan mobil tiba2 dalam keadaan mobil sedang berjalan pelan
1) Injak kopling habis
2) Tempelkan kaki di rem, rasakan sampai mobil terasa berhenti secara perlahan2 (jangan menginjak rem terlalu cepat)
3) Pindahkan gigi ke gigi 0
4) Angkat rem tangan

21. Contoh cara Parkir(disebelah kiri jalan)

1) Injak kopling habis
2) Lepaskan gas
3) Pindahkan gigi ke gigi 1
4) Putar habis stir ke kiri (putar 2 x )
5) Angkat kopling sekuku (mobil bergerak maju perlahan)
6) Atur mobil hingga parkir dengan ban lurus ke depan, gunanya agar power stering tidak cepat aus/rusak

22. Memutar mundur mobil 180o (putar melawan arah jam)

1) Injak kopling habis
2) Putar stir habis ke kanan
3) Pindahkan gigi ke gigi R
4) Angkat kopling sekuku (mobil bergerak mundur perlahan dengan buntut mobil ke kanan)
5) Jika posisi sudah lumayan lurus, injak kopling sekuku (untuk memberhentikan laju mobil) kemudian lihat dari kaca spion ruangan di belakang mobil apakah ada jarak atau tidak antara pantat mobil dengan sesuatu dibelakangnya)
6) Jika posisi aman, maka angkat kopling sekuku (mobil merayap mundur kembali)
7) Setelah mobil lurus dan cukup buat memutar mobil kembali, injak habis kopling, pindahkan gigi ke gigi 1
8) Putar habis stir ke kiri ( 2 x putaran)
9) Angkat kopling sekuku (mobil mulai bergerak maju merayap lagi)
10) Jika masih belum dapat, injak lagi rem
11) injak kopling, pindahkan gigi ke R
12) Angkat kopling sekuku (mobil merayap mundur)
13) Luruskan stir agar posisi ban atau posis parkir menjadi lurus

23. Parkir mundur di garasi bagain kiri jalan
1) Posisi belakang mobil sedikit sebelum tonggak pagar
2) Injak kopling habis, pindahkan gigi ke R
3) Mundurkan mobil hanya dengan menggerakkan kopling sedikit,caranya: injak kopling habis, angkat kopling sekuku, tahan biarkan mobil merayap, injak lagi sekuku, tahan
4) Putar stir mobil 2 x ke kiri (putar habis)
5) Mobil luruskan (ban luruskan) dengan cara putar balik stir 2 x putaran ke kanan
6) Mundurkan lagi mobil sedikit agar mobil menjadi lurus

24. Berhentikan mobil ketika mundur
1) Angkat gas
2) Injak rem perlahan2
3) Injak kopling habis

25. Melambatkan jalannya mobil ketika mundur (Mobil berjalan merayap)
1) Posisi gigi di R, angkat gas, tempel rem
2) Injak kopling, angkat/lepas rem
3) Angkat kopling sekuku

Perhatikan ! Jika sudah dapat berhenti dengan kopling + tempel gas, maka jika gas ditambah sebesar apapun mobil tak akan bergerak

26. Parkir maju
1) Lewatkan mobil sebagian besar badannya
2) Belokin stir
3) Jalankan mobil pelan2 kopling diangkat pelan2 sekuku

27. Mundur/parkir ke kanan
1) Putar stir habis ke kanan
2) Mundur merayap
3) Putar balik stir
4) Mundur lurus

28. Parkir mundur ke kanan
1) Injak kopling habis
2) Pindahkan gigi ke R
3) Tempel rem
4) Mundur lurus
5) Jalankan mundur perlahan dengan pola: jalan mundur pelan - berhenti - jalan - berhenti -jalan dengan cara: Injak kopling sekuku, tahan, lalu angkat lagi kopling sekuku, tahan.
6) Mata lihat ke kaca spion
7) Perhatikan: Mundur mobil harus diusahakan lurus segaris dengan trotoar
Jika pantat mobil sudah sampai di ujung jalan atau kurang sedikit dari ujung jalan tempat parkir maka Injak kopling
8) Putar stir habis kekanan 2 x putaran
9) Angkat kopling sekuku
10) Jika jalan menanjak bantu tenaga mobil dengan menginjak gas
11) Jika kira2 mobil sudah masuk, luruskan mobil dengan cara injak kopling
12) Putar balik stir 2 x ke kiri
13) Angkat kopling sekuku agar mobil bisa masuk pas ke dalam tempat parkir
14) Injak kopling
15) Tempel rem
16) Pindahkan gigi ke gigi 0
17) Angkat rem tangan
18) Lepaskan kaki dari kopling dan pedal rem
19) Matikan AC, copot sealt belt, matikan mesin mobil, ambil kunci dan simpan, gembog stir mobil, buka pintu

- Jika kita salah perhitungan ketika membelokkan mundur mobil, maka
1) Injak kopling
2) Pindahkan gigi ke gigi 1
3) Majukan mobil sedikit, jika kira2 sudah lurus (kontrol dengan cara mengatur ban mobil agr lurus dengan cara putar balik stir)
4) Mundurkan mobil dengan cara Injak kopling, pindahkan ke gigi R, angkat kopling sekuku tahan, angkat lagi sekuku tahan, injak sekukuku taha, begitu seterusnya sampai posisi mobil benar2 masuk

- Jangan lupa melihat kondisi jalur jalan sebelah kanan dan kiri serta belakang melalui kaca spion



Perhatian saat menyetir mobil :
1) Stir tidak boleh diputar dalam keadaan mobil diam karena bisa merusak ban dan poros ban
2) Kalau jalan menanjak dan jalanan macet agak lama di tanjakan maka pakailah rem tangan jangan selalu mengandalkan kopling sebab kalau tidak dapat merusak mekanik kopling
3) Rem kaki tidak boleh diteka terus tapi harus dengan pola angkat, injak, angkat, injak (misalnya ketika turunan) sebab dapat menyebabkan rem terbakar
4) Pakailah selalu gigi 1 jika melalui jalan yang berlubang2
5) Untuk perjalanan dalam kota yang ramai dianjurkan untuk selalu menggunakan gigi 1 dan 2 saja
6) Kuasai emosi ketika berjalan lambat setelah berjalan cepat
7) Gigi 1, 2, 3 untuk jalan lambat dan tanjakan
8) Gigi 4,5 tak kuat jika digunakan untuk jalan tanjakan
9) Untuk menghindari mesin mati tiba2 maka angkatlah kopling pelan2 jangan menyentak dan sekaligus
10) setengah kopling berguna untuk jalan menanjak, macet, belok, start awal berjalan, mundur, belok/memutar mobil, dan parkir
11) Gigi 3 untuk jalan raya besar
12) Gigi 2 untuk jalan raya kecil/sempit.




















http://www.wahyu-winoto.com/2010/10/panduan-cara-setir-mobil-tanpa-perlu.html

Final Exam Semester 1

The text below is an example of what constraint type:

The value in the manager_id column of the EMPLOYEES table must match a value in the employee_id column in the EMPLOYEES table.

(4) Referential integrity         

A table must have at least one candidate key, as well as its primary key. True or False?     

(2) False                                                         

A table must have a primary key. True or False?                               

(2) False                                 

If a primary key is a set of columns then one column must be null. True or False?

(2) False

                                   

Attributes become tables in a database. True or False?                                 

(2) False                                                         

In a physical data model, an attribute becomes a _____________.

(4) Column                                                     

The transformation from an ER diagram to a physical design involves changing terminology. Primary Unique Identifiers in the ER diagram become __________ and relationships become ____________.       

(2) Primary keys, Foreign keys

The Oracle Database can implement a many to many relationship. You simply create two foreign keys between the two tables. True or False?

(2) False

                                   

Many to many relationships are implemented via a structure called a: ________________

(2) Intersection Table

An "Arc Implementation" can be done just like any other Relationship - you simply add the required Foreign Keys. True or False?

(2) False                                 

What command will return data from the database to you?

(3) SELECT

                                                           

The DESCRIBE command returns all rows from a table. True or False?

(2) False

What command can be used to create a new row in a table in the database?                       

(4) INSERT               

The f_customers table contains the following data:

ID        Name   Address           City     State    Zip

1          Cole Bee         123 Main Street          Orlando           FL       32838

2          Zoe Twee        1009 Oliver Avenue    Boston MA      02116

3          Sandra Lee      22 Main Street            Tampa FL       32444

If you run the following statement:

DELETE FROM F_CUSTOMERS WHERE ID <= 2;

How many rows will be left in the table?      

(3) 1

                                   

The SQL statement ALTER TABLE EMPLOYEES DELETE COLUMN SALARY is a valid statement. True or False?

(2) False                     

Systems are always just rolled out as soon as the programming phase is finished. No further work is required once the development is finished. True or False?

(2) False                                 

System Documentation is developed right at the end once the system has gone live and users have been using it for a little while. You are more likely to get it correct that way. True or False?    

(2) False                     

Which SQL statement will return an error?

(1) SEL * FR sky;

When you use the SELECT clause to list one or two columns only from a table and no WHERE clause, which SQL capability is used?                              

(3) Projection only

Which statement best describes how arithmetic expressions are handled?

(4) Division and multiplication operations are handled before subtraction and addition operations.                                   

In a SELECT clause, what is the result of 2 + 3 * 2?                                    

(2) 8                

Evaluate this SELECT statement:

SELECT (salary * raise_percent) raise

FROM employees;

If the RAISE_PERCENT column only contains null values, what will the statement return?        

(2) Only null values    

Which SQL keyword specifies that an alias will be substituted for a column name in the output of a SQL query?

(1) AS                        

You need to display employees with salaries that are at least 30000 or higher. Which comparison operator should you use?         

(3) >=                         

You need to display employees whose salary is in the range of 30000 and 50000. Which comparison operator should you use?

(3) BETWEEN...AND...

           

Which symbol represents the not equal to condition?                                   

(3) !=

                                   

The Concatenation Operator does which of the following?                          

(2) Links two or more columns or literals to form a single output column

You need to display all the rows in the EMPLOYEES table that contain a null value in the DEPARTMENT_ID column. Which comparison operator should you use?

(4) IS NULL              

What does the DISTINCT keyword do when it is used in a SELECT clause?        

(3) Eliminates duplicate rows in the result

You need to display all the values in the EMAIL column that contains the underscore (_) character as part of that email address. The WHERE clause in your SELECT statement contains the LIKE operator. What must you include in the LIKE operator?

(4) The ESCAPE option (\)

You need write a SELECT statement that should only return rows that contain 34, 46, or 48 for the DEPARTMENT_ID column. Which operator should you use in the WHERE clause to compare the DEPARTMENT_ID column to this specific list of values?

(3) IN                         

You want to determine the orders that have been placed by customers who reside in Chicago. You write this partial SELECT statement:

SELECT orderid, orderdate, total

FROM orders;

What should you include in your SELECT statement to achieve the desired results?

(3) WHERE city = 'Chicago';                                                

What will be the result of the SELECT statement and what will display?

SELECT last_name, salary, salary + 300

FROM employees;                 

(1) Display the last name, salary and the results of adding 300 to each salary for all the employees                                                            

When is an entity in 2nd Normal Form?

(1) When all non-UID attributes are dependent upon the entire UID.

Would it be a good idea to model age as an attribute of STUDENT?

(4) No - it breaks the Normalization rules

Which comparison condition means "Less Than or Equal To"?

(4) "<="                      

Which of the following best describes the meaning of the LIKE operator?

(3) Match a character pattern.                                                

You need to change the default sort order of the ORDER BY clause so that the data is displayed in reverse alphabetical order. Which keyword should you include in the ORDER BY clause?

(1) DESC                                                       

Which clause would you include in a SELECT statement to sort the rows returned by the LAST_NAME column?

(1) ORDER BY

The ORDER BY clause always comes last. True or False?

(1) True                                  

Which of the following are TRUE regarding the logical AND operator?                             

(4) TRUE AND FALSE return FALSE                                                        

Evaluate this SELECT statement:

SELECT last_name, first_name, salary

FROM employees;

How will the results of this query be sorted?

(1) The database will display the rows in whatever order it finds it in the database, so no particular order.                                                            

Evaluate this SELECT statement:

SELECT *

FROM employees

WHERE department_id = 34

OR department_id = 45

OR department_id = 67;

Which operator is the equivalent of the OR conditions used in this SELECT statement?   

(1) IN                                     

Evaluate this SELECT statement:

SELECT first_name, last_name, email

FROM employees

ORDER BY last_name;

Which statement is true?

(2) The rows will be sorted alphabetically by the LAST_NAME values.

What value will the following SQL statement return?

SELECT employee_id

FROM employees

WHERE employee_id BETWEEN 100 AND 150 OR employee_id IN(119, 175, 205) AND (employee_id BETWEEN 150 AND 200);

(3) 100, 101, 102, 103, 104, 107, 124, 141, 142, 143, 144, 149

                                                        

Evaluate this SELECT statement:

SELECT employee_id, last_name, first_name, salary 'Yearly Salary'

FROM employees

WHERE salary IS NOT NULL

ORDER BY last_name, 3;

Which clause contains an error?         

(1) SELECT employee_id, last_name, first_name, salary 'Yearly Salary'  

                                                   

The EMPLOYEES table contains these columns:

EMPLOYEE_ID NUMBER(9) PK

LAST_NAME VARCHAR2(25)

FIRST_NAME VARCHAR2(25)

DEPARTMENT_ID NUMBER(9)

Compare these two SQL statements:

1. SELECT DISTINCT department_id DEPT, last_name, first_name FROM employees ORDER BY department_id;

2. SELECT department_id DEPT, last_name, first_name FROM employees ORDER BY DEPT;

How will the results differ?                           

(3) There is no difference in the result between the two statements.    

                                            

The PLAYERS table contains these columns:

PLAYERS TABLE:

LAST_NAME VARCHAR2 (20)

FIRST_NAME VARCHAR2 (20)

SALARY NUMBER(8,2)

TEAM_ID NUMBER(4)

MANAGER_ID NUMBER(9)

POSITION_ID NUMBER(4)

You must display the player name, team id, and salary for players whose salary is in the range from 25000 through 100000 and whose team id is in the range of 1200 through 1500. The results must be sorted by team id from lowest to highest and then further sorted by salary from highest to lowest. Which statement should you use to display the desired result?

(2) SELECT last_name, first_name, team_id, salary

FROM players

WHERE salary BETWEEN 25000 AND 100000

AND team_id BETWEEN 1200 AND 1500

ORDER BY team_id, salary DESC;                         

The PLAYERS table contains these columns:

PLAYERS TABLE:

LAST_NAME VARCHAR2 (20)

FIRST_NAME VARCHAR2 (20)

SALARY NUMBER(8,2)

TEAM_ID NUMBER(4)

MANAGER_ID NUMBER(9)

POSITION_ID NUMBER(4)

You want to display all players' names with position 6900 or greater. You want the players names to be displayed alphabetically by last name and then by first name. Which statement should you use to achieve the required results?                       

(1) SELECT last_name, first_name

FROM players

WHERE position_id >= 6900

ORDER BY last_name, first_name;

The explanation below is a column integrity constraint:

A column must contain only values consistent with the defined data format of the column. True or False?

(1) True

Identify all of the incorrect statements that complete this sentence: A primary key is: 

(1) A single column that uniquely identifies each column in a table

(3) A set of columns in one table that uniquely identifies each row in another table

(4) Only one column that must be null

The explanation below is a User Defined integrity rule and must therefore be manually coded, the Database cannot enforce this rule automatically:

A primary key must be unique, and no part of the primary key can be null. True or False?

(2) False

The text below is an example of what constraint type:

The value in the manager_id column of the EMPLOYEES table must match a value in the employee_id column in the EMPLOYEES table.

(4) Referential integrity

In a physical data model, an attribute becomes a _____________. 

(4) Column 

The transformation from an ER diagram to a physical design involves changing terminology. Primary Unique Identifiers in the ER diagram become __________ and relationships become ____________. 

(2) Primary keys, Foreign keys 

In a physical data model, a relationship is represented as a combination of: 

(2) Primary Key or Unique Key 

(4) Foreign Key

It is possible to implement non-transferability via a simple Foreign Key Relationship. True or False? 

(2) False

Many to many relationships are implemented via a structure called a: ________________ 

(2) Intersection Table 

When mapping supertypes, relationships at the supertype level transform as usual. Relationships at subtype level are implemented as foreign keys, but the foreign key columns all become mandatory. True or False? 

(2) False

Which of the following are reasons why you should consider using a Subtype Implementation?

(3) Business functionality and business rules, access paths and frequency of access are all very different between subtypes. 

The _______ clause can be added to a SELECT statement to return a subset of the data. 

(3) WHERE 

The DESCRIBE command returns all rows from a table. True or False?

(2) False

Which SQL keyword specifies that an alias will be substituted for a column name in the output of a SQL query? 

(1) AS

You query the database with this SQL statement:

SELECT *

FROM transaction

WHERE product_id = 4569;

Which SQL SELECT statement capabilities are achieved when this statement is executed?

(1) Selection only 

Evaluate this SELECT statement:

SELECT (salary * raise_percent) raise

FROM employees;

If the RAISE_PERCENT column only contains null values, what will the statement return?

(2) Only null values 

What would you use in the SELECT clause to return all the columns in the table?

(1) An asterisk (*)

When you use the SELECT clause to list one or two columns only from a table and no WHERE clause, which SQL capability is used?

(3) Projection only 

In a SELECT clause, what is the result of 2 + 3 * 2?

(2) 8

You query the database with this SQL statement:

SELECT * FROM students;

Why would you use this statement?

(2) To view data 

Any Non-UID must be dependant on the entire UID. True or False?

(1) True 

When is an entity in 2nd Normal Form?

(1) When all non-UID attributes are dependent upon the entire UID.

What does the DISTINCT keyword do when it is used in a SELECT clause?

(3) Eliminates duplicate rows in the result

Which symbol represents the not equal to condition?

(3) !=

Which statement best describes how column headings are displayed by default in Oracle Application Express: 

(3) Column headings are displayed centered and in uppercase. 

Which operator is used to combine columns of character strings to other columns?

(4) ||

You need to display employees whose salary is in the range of 30000 and 50000. Which comparison operator should you use? 

(3) BETWEEN...AND... 

Which clause would you include in a SELECT statement to restrict the data returned to only the employees in department 10?

(1) WHERE 

Evaluate this SELECT statement:

SELECT *

FROM employees

WHERE department_id IN(10, 20, 30)

AND salary > 20000;

Which values would cause the logical condition to return TRUE?

(4) DEPARTMENT_ID = 10 and SALARY = 20001

What will the result of the following SELECT statement be:

SELECT last_name, salary, salary + 300

FROM employees;

How will the heading for the SALARY column appear in the display by default in Oracle Application Express?

(1) Display the last name, salary and the results of adding 300 to each salary for all the employees

The PLAYERS table contains these columns:

PLAYER_ID NUMBER(9)

LAST_NAME VARCHAR2(20)

FIRST_NAME VARCHAR2 (20)

TEAM_ID NUMBER (4)

MANAGER_ID NUMBER (9)

POSITION_ID NUMBER (4)

Which SELECT statement should you use if you want to display unique combinations of the TEAM_ID and MANAGER_ID columns?

(3) SELECT DISTINCT team_id, manager_id FROM players; 

You need write a SELECT statement that should only return rows that contain 34, 46, or 48 for the DEPARTMENT_ID column. Which operator should you use in the WHERE clause to compare the DEPARTMENT_ID column to this specific list of values?

 (3) IN

Which SELECT statement will display both unique and non-unique combinations of the MANAGER_ID and DEPARTMENT_ID values from the EMPLOYEES table?

(2) SELECT manager_id, department_id FROM employees; 

The EMPLOYEES table contains these columns:

EMPLOYEE_ID NUMBER(9) PrimaryKey

LAST_NAME VARCHAR2 (20)

FIRST_NAME VARCHAR2 (20)

DEPARTMENT_ID NUMBER(5) NOT NULL

MANAGER_ID NUMBER(9) NOT NULL

Evaluate these two SELECT statements:

1. SELECT DISTINCT employee_id, department_id, manager_id FROM employees;

2. SELECT employee_id, department_id, manager_id FROM employees;

Which of the following statements is true?

(1) The two statements will display the same data.

The STUDENT table contains these columns:

STUDENT_ID NUMBER(10) Primary Key

LAST_NAME VARCHAR2(25)

FIRST_NAME VARCHAR2(25)

MAIN_SUBJECT_ID NUMBER(3)

ADVISOR_ID NUMBER(5)

Evaluate this statement:

SELECT DISTINCT advisor_id, main_subject_id

FROM student;

Which statement is true?

(2) Each MAIN_SUBJECT_ID can be displayed more than once per ADVISOR_ID. 

The EMPLOYEES table includes these columns:

EMPLOYEE_ID NUMBER(4) NOT NULL

LAST_NAME VARCHAR2(15) NOT NULL

FIRST_NAME VARCHAR2(10) NOT NULL

HIRE_DATE DATE NOT NULL

You want to produce a report that provides the first names, last names and hire dates of those employees who were hired between March 1, 2000, and August 30, 2000. Which statements can you issue to accomplish this task?

(1)SELECT last_name, first_name, hire_date

FROM employees

WHERE hire_date BETWEEN '01-MAR-00' AND '30-AUG-00';

Evaluate this SQL statement:

SELECT e.employee_id, e.last_name, e.first_name, m.manager_id

FROM employees e, employees m

ORDER BY e.last_name, e.first_name

WHERE e.employee_id = m.manager_id;

This statement fails when executed. Which change will correct the problem?

(1) Reorder the clauses in the query. 

The PLAYERS table contains these columns:

PLAYERS TABLE:

LAST_NAME VARCHAR2 (20)

FIRST_NAME VARCHAR2 (20)

SALARY NUMBER(8,2)

TEAM_ID NUMBER(4)

MANAGER_ID NUMBER(9)

POSITION_ID NUMBER(4)

You want to display all players' names with position 6900 or greater. You want the players names to be displayed alphabetically by last name and then by first name. Which statement should you use to achieve the required results?

(1) SELECT last_name, first_name

FROM players

WHERE position_id >= 6900

ORDER BY last_name, first_name;

Evaluate this SELECT statement:

SELECT *

FROM employees

WHERE salary > 30000

AND department_id = 10

OR email IS NOT NULL;

Which statement is true?

(2) The AND condition will be evaluated before the OR condition.

Evaluate this SELECT statement:

SELECT *

FROM employees

WHERE department_id = 34

OR department_id = 45

OR department_id = 67;

Which operator is the equivalent of the OR conditions used in this SELECT statement?

(1) IN

You need to create a report to display all employees that were hired on or after January 1, 1996. The data should display in this format:

Employee Start Date and Salary

14837 - Smith 10-MAY-92 / 5000

Which SELECT statement could you use?

(5) SELECT employee_id ||' - '|| last_name "Employee",

hire_date ||' / '|| salary "Start Date and Salary"

FROM employees

WHERE hire_date <= '01-JAN-96';

You attempt to query the database with this SQL statement:

SELECT product_id "Product Number", category_id "Category", price "Price"

FROM products

WHERE "Category" = 5570

ORDER BY "Product Number";

This statement fails when executed. Which clause contains a syntax error?

(4) WHERE "Category" = 5570

Evaluate this SELECT statement:

SELECT employee_id, last_name, first_name, salary 'Yearly Salary'

FROM employees

WHERE salary IS NOT NULL

ORDER BY last_name, 3;

Which clause contains an error?

(1) SELECT employee_id, last_name, first_name, salary 'Yearly Salary' (*)

Evaluate this SELECT statement:

SELECT last_name, first_name, department_id, manager_id

FROM employees;

You need to sort data by manager id values and then alphabetically by employee last name and first name values. Which ORDER BY clause could you use?

(2) ORDER BY manager_id, last_name, first_name 

Which statement about the logical operators is true? 

(4) The order of operator precedence is NOT, AND, and OR. (*)

Which comparison condition means "Less Than or Equal To?" 

(4) "<=" 

From left to right, what is the correct order of Precedence?

(1) Arithmetic, Concatenation, Comparison, OR

Which statement about the ORDER BY clause is true? 

(1) You can use a column alias in the ORDER BY clause.

Which clause would you include in a SELECT statement to sort the rows returned by the LAST_NAME column?

(1) ORDER BY

You need to change the default sort order of the ORDER BY clause so that the data is displayed in reverse alphabetical order. Which keyword should you include in the ORDER BY clause?

(1) DESC

A foreign key cannot refer to a primary key in the same table. True or False?
(2) False

What do you create when you transform a many to many relationship from your ER diagram into a physical design?

(3) Intersection table

           

In the default order of precedence, which operator would be evaluated first?        

(2) Multiplications and Division are at the same level and would be evaluated first based on left to right order

           

The EMPLOYEES table contains these columns:

SALARY NUMBER(7,2) BONUS NUMBER(7,2) COMMISSION_PCT NUMBER(2,2)

All three columns contain values greater than zero. There is one row of data in the table and the values are as follows: Salary = 500, Bonus = 50, Commission_pct = .5

Evaluate these two SQL statements:

1. SELECT salary + bonus + commission_pct * salary - bonus AS income FROM employees;

2. SELECT (salary + bonus ) + commission_pct * (salary - bonus) income FROM employees;

What will be the result?         

(2) Statement 2 will return a higher value than statement 1.

Where in a SQL statement can you not use arithmetic operators?

(2) FROM      

You need to combine the FIRST_NAME and LAST_NAME columns in the EMPLOYEES table and display the columns as a combined character string. Which operator should you use?   

(3) ||    

Evaluate this SELECT statement:

SELECT last_name, first_name, salary FROM employees;

How will the heading for the SALARY column appear in the display by default in Oracle Application Express?

(3) The heading will display as uppercase and centered.

Which logical operator returns TRUE if either condition is true?

(1) OR

Evaluate this SQL statement:

SELECT product_id, product_name, price FROM products ORDER BY product_name, price;

What occurs when the statement is executed?

(4) The results are sorted alphabetically and then numerically.

Once you have created a table, it is not possible to alter the definition of it. If you need to add a new column you must delete the table definition and create a new, correct table. True or False?       

(2) False

           

In the analysis phase the tables are created and populated with test data. True or False?

(2) False

 

 

 

 

 

sumur : http://quizoracle.blogspot.co.id

Test: Mid Term Exam Semester 1

Test: Mid Term Exam Semester 1

-

Part I

Review your answers, feedback, and question scores below. An asterisk (*)

indicates a correct answer.

Mid Term Exam Semester 1

-

Part 1

1. Variables can be used in the following ways in a P

L/SQL block.

(Choose two.) Mark for Review

(1) Points

(Choose all correct answers)

To store data values. (*)

To rename tables and columns.

To refer to a single data value several times. (*)

To co

mment code.

Correct

2. Is the following variable declaration correct or not ?

DECLARE

display_qty CONSTANT NUMBER;

Mark for Review

(1) Points

Correct.

Not correct. (*)

Correct

3. Assignment statements can continue over several lines in PL/SQL.

True or False? Mark for Review

(1) Points

True (*)

False

Correct

4. When a variable is defined

using the NOT NULL keywords, the

variable must contain a value. True or False? Mark for Review

(1) Points

True (*)

False

Correct

5. Identify which of the following assignment statements are

valid.

(Choose three.) Mark for Review

(1) Points

(Choose all correct answers)

v_last_name := Chandra;

v_blackout_date := '31

-

DEC

-

2006'; (*)

v_population := 333444; (*)

v_music_type := 'ROCK'; (*

)

Correct

Page 1 of 10

Test: Mid Term Exam Semester 1

-

Part I

Review your answers, feedback, and question scores below. An asterisk (*)

indicates a correct answer.

Mid Term Exam Semes

ter 1

-

Part 1

6. When nested blocks are used, which blocks can or must be labeled?

Mark for Review

(1) Points

The inner block must be labeled, the outer block can be labeled.

Both blocks must be labeled

Ne

sted blocks cannot be labeled

The outer block must be labeled if it is to be referred to in the

inner block. (*)

Correct

7. What will be displayed when the following code is executed?

DECLARE

varA NUM

BER := 12;

BEGIN

DECLARE

varB NUMBER := 8;

BEGIN

varA := varA + varB;

END;

DBMS_OUTPUT.PUT_LINE(varB);

END;

Mark for Review

(1) Points

8

12

Nothing, the block will fail

with an error (*)

20

VarB

Correct

8. In the following code, Line A causes an exception. What value will

be displayed when the code is executed?

DECLARE

outer_var VARCHAR2(50) := 'My';

BEGI

N

outer_var := outer_var || ' name';

DECLARE

inner_var NUMBER;

BEGIN

inner_var := 'Mehmet';

--

Line A

outer_var := outer_var || ' is';

END;

outer_var := outer_var || ' Zeynep';

EXCEPTION

WHEN

OTHERS THEN

DBMS_OUTPUT.PUT_LINE(outer_var);

END;

Mark for Review

(1) Points

My

My name (*)

My name is

My name is Zeynep

Correct

9. An exception occurs withi

n the inner block of two nested blocks.

The inner block does not have an EXCEPTION section. What always happens?

Mark for Review

(1) Points

Both blocks fail and an error message is displayed by the calling

environment

The excepti

on is propagated to the outer block (*)

Oracle automatically tries to re

-

execute the inner block

The user's database session is automatically disconnected

Correct

10. When an exception occurs within

a PL/SQL block, the remaining

statements in the executable section of the block are skipped. True or

False? Mark for Review

(1) Points

True (*)

False

Correct

Page 2 of 10

Test: Mid Term Exam Semester 1

-

Part I

Review your answers, feedback, and question scores below. An asterisk (*)

indicates a correct answer.

Mid Term Exam Semester 1

-

Part 1

11. Which of these are PL/SQL data types? (Choose t

hree.) Mark for

Review

(1) Points

(Choose all correct answers)

Scalar (*)

Identifier

Delimiter

Composite (*)

LOB (*)

Correct

12. A collection is a

composite data type. True or False? Mark for

Review

(1) Points

True (*)

False

Correct

13. A movie is an example of which category of data type? Mark for

Review

(1) Points

Sca

lar

Composite

Reference

LOB (*)

Correct

14. A variable is declared as:

DECLARE

v_holdit employees.last_name%TYPE;

BEGIN ...

Which of the following is a correct use of the INT

O clause?

Mark for Review

(1) Points

SELECT *

INTO v_holdit

FROM employees;

SELECT last_name

INTO v_holdit

(1) Points

DELETE FROM employees

WHERE department_id=60;

(*)

SELECT salary FROM employees

WHERE department_id=60;

CREATE TABLE new_emps (last_name V

ARCHAR2(10), first_name

VARCHAR2(10));

DROP TABLE locations;

Correct

19. Assume there are 5 employees in Department 10. What happens when

the following statement is executed?

UPDATE employees

SET salar

y=salary*1.1;

Mark for Review

(1) Points

All employees get a 10% salary increase. (*)

No rows are modified because you did not specify "WHERE

department_id=10"

A TOO_MANY_ROWS exception is raised.

An error

message is displayed because you must use the INTO clause to

hold the new salary.

Correct

20. A PL/SQL block includes the following statement:

SELECT last_name INTO v_last_name

FROM employees

WHERE employee_id=1

00;

What is the value of SQL%ISOPEN immediately after the SELECT statement is

executed?

Mark for Review

(1) Points

True

False (*)

Null

Error. That attribute does not apply for implicit cursors.

Correct

Page 4 of 10

Test: Mid Term Exam Semester 1

-

Part I

Review your answers, feedback, and question scores below. An asterisk (*)

indicates a correct answer.

Mid Term Exam Semester 1

-

Pa

rt 1

21. Which SQL statement can NOT use an implicit cursor? Mark for

Review

(1) Points

A DELETE statement

An UPDATE statement

A SELECT statement that returns multiple rows (*)

A SELECT statement

that returns one row

Incorrect. Refer to Section 3.

22. Which statements are optional in a PL/SQL block? (Choose two.)

Mark for Review

(1) Points

(Choose all correct answers)

DECLARE (*)

BEGIN

EXCEPTION (*)

END;

Correct

23. Every PL/SQL anonymous block must start with the keyword DECLARE.

True or False? Mark for Review

(1) Points

True

False (*)

Correct

24. What kind of block is defined by the following PL/SQL code?

BEGIN

DBMS_OUTPUT.PUT_LINE('My first quiz');

END;

Mark for Review

(1) Points

procedure

subroutine

function

anonymous (*)

Correct

25. Errors are handled in the Exception part of the PL/SQL block. True

or False? Mark for Review

(1) Points

True (*)

False

Correct

Page 5 of 10

Test: Mid Term Exam Semester 1

-

Part I

Review your answers, feedback, and question scores below. An asterisk (*)

indicates a correct answer.