Oracle 1Z0-007 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Displaying Data from Multiple Tables | - Equality and nonequality joins - Self–join - Outer joins |
| Writing Basic SQL SELECT Statements | - Capabilities of SQL SELECT statements - Differentiate between SQL and iSQL*Plus commands - Execute a basic SELECT statement |
| Creating Other Database Objects | - Indexes - Sequences - Synonyms |
| Restricting and Sorting Data | - Sort rows retrieved by a query - Limit rows retrieved by a query |
| Producing Readable Output with iSQL*Plus | - Substitution variables - Script files |
| Subqueries | - Single–row and multiple–row subqueries - Define subqueries |
| Manipulating Data | - DELETE rows - UPDATE rows - MERGE rows - INSERT rows |
| Creating Views | - Create, alter, drop views - DML through views |
| Single–Row Functions | - Use character, number, and date functions in SELECT statements - Use conversion functions |
Oracle Introduction to Oracle9i: SQL Sample Questions:
1. Which constraint can be defined only at the column level?
A) FOREIGN KEY
B) NOT NULL
C) CHECK
D) UNIQUE
E) PRIMARY KEY
2. The CUSTOMERS table has these columns:
Which statement finds the rows in the CUSTOMERS table that do not have a postal code?
A) SELECT customer_id, customer_name FROM customers WHERE postal_code = '________';
B) SELECT customer_id, customer_name FROM customers WHERE postal_code = NULL;
C) SELECT customer_id, customer_name FROM customers WHERE postal code IS NVL;
D) SELECT customer_id, customer_name FROM customers WHERE postal_code IS NULL;
E) SELECT customer_id, customer_name FROM customers WHERE postal_code CONTAINS NULL;
3. Which constraint can be defined only at the column level?
A) FOREIGN KEY
B) NOT NULL
C) CHECK
D) UNIQUE
E) PRIMARY KEY
4. Which describes the default behavior when you create a table?
A) Tables are created in your schema.
B) The table is accessible to all users.
C) You must specify the schema when the table is created.
D) Tables are created in the DBA schema.
E) Tables are created in the public schema.
5. The EMPLOYEES table contains these columns:
You need to write a query that will produce these results:
1.Display the salary multiplied by the commission_pct.
2.Exclude employees with a zero commission_pct.
3.Display a zero for employees with a null commission value.
Evaluate the SQL statement:
SELECT LAST_NAME, SALARY*COMMISSION_PCT
FROM EMPLOYEES
WHERE COMMISSION_PCT IS NOT NULL;
What does the statement provide?
A) An error statement
B) Two of the desired results
C) One of the desired results
D) All of the desired results
Solutions:
| Question # 1 Answer: B | Question # 2 Answer: D | Question # 3 Answer: B | Question # 4 Answer: A | Question # 5 Answer: C |
587 Customer Reviews
Quality and ValueITCertKing Practice Exams are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development - no all study materials.
Tested and ApprovedWe are committed to the process of vendor and third party approvals. We believe professionals and executives alike deserve the confidence of quality coverage these authorizations provide.
Easy to PassIf you prepare for the exams using our ITCertKing testing engine, It is easy to succeed for all certifications in the first attempt. You don't have to deal with all dumps or any free torrent / rapidshare all stuff.
Try Before BuyITCertKing offers free demo of each product. You can check out the interface, question quality and usability of our practice exams before you decide to buy.
