1Z0-051: Oracle Db 11g: SQL Fundamentals I: Practice Tests

Course details

About The Course

The "1Z0-051: Oracle Db 11g: SQL Fundamentals I: Practice Tests" course contains 2 complete tests (totalling to 128 questions). 

The practice questions are categorised according to the official Oracle Exam Topics at the "Oracle Database 11g_ SQL Fundamentals I _ Oracle Certification Exam" page. 

Each complete test (there are 2) has full coverage (100%) of the major categories. 

The questions are about 10% easier than the real exam questions. 

The questions are the best out there. 

All the questions underwent thorough review to remove any traces of vagueness or inaccuracy.

What are the requirements?

• The student should have studied everything mentioned in the exam topics published by Oracle.
• The student should have done hands-on usage or practice of the SQL constructs mentioned in the exam topics published by Oracle.

What am I going to get from this course?

• If the student have a weakness on any topic (Knowledge Area, or Official Exam Category), they will be able to identify it. They can then restudy those topics.
• If the student is strong on some topics, he will be able to identify it. He will have more confidence on these topics.
• The student will be able to pass the "1Z0-051: Oracle Db 11g: SQL Fundamentals I" exam.

What is the target audience?

Anyone who wants to pass the "1Z0-051: Oracle Db 11g: SQL Fundamentals I" exam.

How To Pass The Test

1. Study all the topics mentioned in the official Oracle list of exam topics.
2. The exam has a lot of questions that are related to SQL statement syntax. It is almost necessary that you feel very comfortable (and fast) in evaluating statements and scenarios.This can be achieved by doing actual hands-on on the SQL commands and statements.
3. Use the Practice Test 1 in this course. Follow the time limit. Do not extend over the time limit. This is so that you get the feel of the real test. Even if you havent answered all the questions, you must stop the test. You must do this to learn time management. You must monitor the time while taking the test, so that you will know if you are at the risk of reaching the time limit without processing all the questions. DO NOT TAKE THIS TEST MORE THAN ONCE. This test (and any practice test anywhere) is good only the first time. Of course, you can take it as many as you want. What is meant here, is that, it wouldnt be a realistic experience on your side, because you may have memorized some of the questions already. The score on your second try, would be misleading.
4. Study EACH question in the result of your Practice Test 1 test. Know why the correct choices are correct, and why the wrong choices are wrong. This is what differs those who score high in the real test, and those who dont.
5. Identify your weaknesses (topics or Knowledge Area that you scored low), and study them further.
6. Repeat Step 3, 4 and 5 above, on the Practice Test 2.
7. Unfortunately, there are only 2 tests. Hopefully, this is enough to help you pass the test. At this point, you should have identified your remaining weaknesses. Study them further.
8. On the night before the test, sleep enough - e.g. at least 8 hours.
9. On the day of the test
   • If it is OK with you, take coffee or something similar, about 30 minutes before the test, to make you more alert during the real test.
   • It is also observed that meditating for a few minutes before the test, helps clear your mind and become more receptive.
   • Better take a less stressful path to the testing center. For example, take a taxi, instead of taking a bus or train, to avoid loading your mind with other things that you dont need in the test.
   • Better schedule your test as the first thing in the day. For example, it is better to take it as the first thing in the morning, instead of going to work in the morning, and taking the test in the afternoon. You need energy in your body and clarity in your mind when taking the test.

Exam Topics

Official Oracle Exam Topics
[Retrieving Data Using the SQL SELECT Statement][][]
[Retrieving Data Using the SQL SELECT Statement][List the capabilities of SQL SELECT statements][]
[Retrieving Data Using the SQL SELECT Statement][Execute a basic SELECT statement][]
[Restricting and Sorting Data][][]
[Restricting and Sorting Data][Limit the rows that are retrieved by a query][]
[Restricting and Sorting Data][Sort the rows that are retrieved by a query][]
[Restricting and Sorting Data][Use ampersand substitution to restrict and sort output at runtime][]
[Using Single-Row Functions to Customize Output][][]
[Using Single-Row Functions to Customize Output][Describe various types of functions available in SQL][]
[Using Single-Row Functions to Customize Output][Use character, number, and date functions in SELECT statements][]
[Using Conversion Functions and Conditional Expressions][][]
[Using Conversion Functions and Conditional Expressions][Describe various types of conversion functions that are available in SQL][]
[Using Conversion Functions and Conditional Expressions][Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions][]
[Using Conversion Functions and Conditional Expressions][Apply conditional expressions in a SELECT statement][]
[Reporting Aggregated Data Using the Group Functions][][]
[Reporting Aggregated Data Using the Group Functions][Identify the available group functions][]
[Reporting Aggregated Data Using the Group Functions][Describe the use of group functions][]
[Reporting Aggregated Data Using the Group Functions][Group data by using the GROUP BY clause][]
[Reporting Aggregated Data Using the Group Functions][Include or exclude grouped rows by using the HAVING clause][]
[Displaying Data from Multiple Tables][][]
[Displaying Data from Multiple Tables][Write SELECT statements to access data from more than one table using equijoins and nonequijoins][]
[Displaying Data from Multiple Tables][Join a table to itself by using a self-join][]
[Displaying Data from Multiple Tables][View data that generally does not meet a join condition by using outer joins][]
[Displaying Data from Multiple Tables][Generate a Cartesian product of all rows from two or more tables][]
[Using Subqueries to Solve Queries][][]
[Using Subqueries to Solve Queries][Define subqueries][]
[Using Subqueries to Solve Queries][Describe the types of problems that the subqueries can solve][]
[Using Subqueries to Solve Queries][List the types of subqueries][]
[Using Subqueries to Solve Queries][Write single-row and multiple-row subqueries][] [Using the Set Operators][][]
[Using the Set Operators][Describe set operators][]
[Using the Set Operators][Use a set operator to combine multiple queries into a single query][]
[Using the Set Operators][Control the order of rows returned][] [Manipulating Data][][]
[Manipulating Data][Describe each data manipulation language (DML) statement][]
[Manipulating Data][Insert rows into a table][]
[Manipulating Data][Update rows in a table][]
[Manipulating Data][Delete rows from a table][]
[Manipulating Data][Control transactions][]
[Using DDL Statements to Create and Manage Tables][][]
[Using DDL Statements to Create and Manage Tables][Categorize the main database objects][]
[Using DDL Statements to Create and Manage Tables][Review the table structure][]
[Using DDL Statements to Create and Manage Tables][List the data types that are available for columns][]
[Using DDL Statements to Create and Manage Tables][Create a simple table][]
[Using DDL Statements to Create and Manage Tables][Explain how constraints are created at the time of table creation][]
[Using DDL Statements to Create and Manage Tables][Describe how schema objects work][]
[Creating Other Schema Objects][][]
[Creating Other Schema Objects][Create simple and complex views][]
[Creating Other Schema Objects][Retrieve data from views][]
[Creating Other Schema Objects][Create, maintain, and use sequences][]
[Creating Other Schema Objects][Create and maintain indexes][]
[Creating Other Schema Objects][Create private and public synonyms][]

Udemy Knowledge Areas (shortened version of Official Oracle Exam Topics, because Udemy limits the Knowledge Area to 60 characters)
[1.Retrieving Data Using the SQL SELECT][][]
[1.Retrieving Data Using the SQL SELECT][List][]
[1.Retrieving Data Using the SQL SELECT][Execute][]
[2.Restricting and Sorting Data][][]
[2.Restricting and Sorting Data][Limit][]
[2.Restricting and Sorting Data][Sort][]
[2.Restricting and Sorting Data][Use ampersand][]
[3.Using Single-Row Functions to Customize][][]
[3.Using Single-Row Functions to Customize][Describe][]
[3.Using Single-Row Functions to Customize][Use][]
[4.Using Conversion Functions and Conditional][][]
[4.Using Conversion Functions and Conditional][Describe][]
[4.Using Conversion Functions and Conditional][Use][]
[4.Using Conversion Functions and Conditional][Apply][]
[5.Reporting ... Group Functions][][]
[5.Reporting ... Group Functions][Identify][]
[5.Reporting ... Group Functions][Describe][]
[5.Reporting ... Group Functions][Group data][]
[5.Reporting ... Group Functions][... HAVING ...][]
[6.... Data from Multiple Tables][][]
[6.... Data from Multiple Tables][... equijoins ...][]
[6.... Data from Multiple Tables][... self-join][]
[6.... Data from Multiple Tables][... outer joins][]
[6.... Data from Multiple Tables][... Cartesian][]
[7.Using Subqueries to Solve Queries][][]
[7.Using Subqueries ...][Define subqueries][]
[7.Using Subqueries ...][... problems ... can solve][]
[7.Using Subqueries ...][List the types of subqueries][]
[7.Using Subqueries ...][... single-row ...][]
[8. ... Set Operators][][]
[8. ... Set Operators][Describe set operators][]
[8. ... Set Operators][Use a set operator ...][]
[8. ... Set Operators][Control the order ...][]
[9.Manipulating Data][][]
[9.Manipulating Data][... (DML) statement][]
[9.Manipulating Data][Insert rows into a table][]
[9.Manipulating Data][Update rows in a table][]
[9.Manipulating Data][Delete rows from a table][]
[9.Manipulating Data][Control transactions][]
[10.Using DDL ...][][]
[10.Using DDL ...][... main database objects][]
[10.Using DDL ...][... table structure][]
[10.Using DDL ...][... data types ...][]
[10.Using DDL ...][... simple table][]
[10.Using DDL ...][... constraints ...][]
[10.Using DDL ...][... schema objects ...][]
[11. ... Other Schema Objects][][]
[11. ... Other Schema Objects][... views][]
[11. ... Other Schema Objects][Retrieve ... views][]
[11. ... Other Schema Objects][... sequences][]
[11. ... Other Schema Objects][... indexes][]
[11. ... Other Schema Objects][... synonyms][]

The 2 sets correspond exactly to each other. The 2nd one is just a shortened name (due to the 60-character limit in Udemy, for the Knowledge Area text).