Testking Oracle 10g 1z0-047
Visited 6259 times, 1 so far today
1z0-047 Exam : Oracle Database SQL Expert
Exam Number: 1Z0-047
Associated Certifications: Oracle 11g DBA OCA
Oracle Database: SQL Certified Expert
Oracle9i DBA OCA
Oracle PL/SQL Developer Certified Associate
Exam Price: $125 US
Exam Registration: Register
Duration: 120 minutes
Number of Questions: 70
Passing Score: 66%
Recommended Training and Preparation
Oracle Database 10g: Introduction to SQL
OR
Oracle Database 11g: Introduction to SQL
OR
Oracle Database 11g: SQL Fundamentals I and Oracle Database 11g: SQL Fundamentals II
Exam 047 has been validated against Oracle Database 10g and Oracle Database 11g. Training on either version will be appropriate preparation.
Additional Information & Resources
Material on the topics “Generating Reports by Grouping Related Data” and “Hierarchical Retrieval” are found in the Appendix of the Oracle Database 11g training manuals that accompany the Recommended Training courses.
Exam Retake Policy
Sample Questions
Exam Topics
Retrieving Data Using the SQL SELECT Statement
[ ]
List the capabilities of SQL SELECT statements
[ ]
Execute a basic SELECT statement
[ ]
Describe how schema objects work
Restricting and Sorting Data
[ ]
Limit the rows that are retrieved by a query
[ ]
Sort the rows that are retrieved by a query
Using Single-Row Functions to Customize Output
[ ]
Describe various types of functions that are available in SQL
[ ]
Use character, number, and date functions in SELECT statements
[ ]
Describe the use of conversion functions
Reporting Aggregated Data Using the Group Functions
[ ]
Identify the available group functions
[ ]
Describe the use of group functions
[ ]
Group data by using the GROUP BY clause
[ ]
Include or exclude grouped rows by using the HAVING clause
Displaying Data from Multiple Tables
[ ]
Write SELECT statements to access data from more than one table using equijoins and nonequijoins
[ ]
Join a table to itself by using a self-join
[ ]
View data that generally does not meet a join condition by using outer joins
[ ]
Generate a Cartesian product of all rows from two or more tables
Using Subqueries to Solve Queries
[ ]
Define subqueries
[ ]
Describe the types of problems that subqueries can solve
[ ]
List the types of subqueries
[ ]
Write single-row and multiple-row subqueries
Using the Set Operators
[ ]
Describe set operators
[ ]
Use a set operator to combine multiple a single query
[ ]
Control the order of rows returned
Manipulating Data
[ ]
Describe each data manipulation language (DML) statement
[ ]
Insert rows into a table
[ ]
Update rows in a table
[ ]
Delete rows from a table
[ ]
Control transactions
Using DDL Statements to Create and Manage Tables
[ ]
Categorize the main database objects
[ ]
Review the table structure
[ ]
List the data types that are available for columns
[ ]
Create a simple table
[ ]
Explain how constraints are created at the time of table creation
Creating Other Schema Objects
[ ]
Create simple and complex views
[ ]
Retrieve data from views
[ ]
Create, maintain, and use sequences
[ ]
Create and maintain indexes
[ ]
Create private and public synonyms
Managing Objects with Data Dictionary Views
[ ]
Use the data dictionary views to research data on your objects
[ ]
Query various data dictionary views
Controlling User Access
[ ]
Differentiate system privileges from object privileges
[ ]
Grant privileges on tables
[ ]
View privileges in the data dictionary
[ ]
Grant roles
[ ]
Distinguish between privileges and roles
Managing Schema Objects
[ ]
Add constraints
[ ]
Create indexes
[ ]
Create indexes using the CREATE TABLE statement
[ ]
Creating function-based indexes
[ ]
Drop columns and set column UNUSED
[ ]
Perform FLASHBACK operations
[ ]
Create and use external tables
Manipulating Large Data Sets
[ ]
Manipulate data using subqueries
[ ]
Describe the features of multitable INSERTs
[ ]
Use the following types of multitable INSERTs (Unconditional, Conditional and Pivot)
[ ]
Merge rows in a table
[ ]
Track the changes to data over a period of time
Generating Reports by Grouping Related Data
[ ]
Use the ROLLUP operation to produce subtotal values
[ ]
Use the CUBE operation to produce crosstabulation values
[ ]
Use the GROUPING function to identify the row values created by ROLLUP or CUBE
[ ]
Use GROUPING SETS to produce a single result set
Managing Data in Different Time Zones
[ ]
Use Various datetime functions
Retrieving Data Using Subqueries
[ ]
Write a multiple-column subquery
[ ]
Use scalar subqueries in SQL
[ ]
Solve problems with correlated subqueries
[ ]
Update and delete rows using correlated subqueries
[ ]
Use the EXISTS and NOT EXISTS operators
[ ]
Use the WITH clause
Hierarchical Retrieval
[ ]
Interpret the concept of a hierarchical query
[ ]
Create a tree-structured report
[ ]
Format hierarchical data
[ ]
Exclude branches from the tree structure
Regular Expression Support
[ ]
Using Meta Characters
[ ]
Regular Expression Functions
[ ]
Replacing Patterns
[ ]
Regular Expressions and Check Constraints
Oracle Certification Program Fraudulent Activity Policy
Oracle reserves the right to take action against any candidate involved in fraudulent activities, including, but not limited to, fraudulent use of vouchers, promotional codes, reselling exam discounts and vouchers, cheating on an exam, alteration of score reports, alteration of completion certificates, violation of exam retake policies or other activities deemed fraudulent by Oracle.
If Oracle determines, in its sole discretion, that fraudulent activity has taken place, it reserves the right to take action up to and including, but not limited to, decertification of a candidate’s Oracle Certified Associate, Oracle Certified Professional and/or OCM credentials, temporary, indefinite or permanent ban of a candidate from Oracle certification programs, notification to a candidate’s employer, and notification to law enforcement agencies. Candidates found committing fraudulent activities forfeit all fees previously paid to Oracle, or to Oracle’s authorized vendors, and may be required to pay additional fees for services rendered.
View the Oracle Certification Program Candidate Agreement which requires your agreement before the start of each exam.
Recommended Training about 1z0-047 exam PDF
The following courses are the recommended training for 1z0-047 exam PDF.
1z0-047 Q & A with Explanations
1z0-047 Audio Exam
1z0-047 Study Guide
1z0-047 Preparation Lab
1z0-047 Exam: Freetestking’s Oracle Database SQL Expert PDF
The Oracle Database SQL Expert PDF for preparing for the 1z0-047 exam – Freetestking’s Oracle Database SQL Expert. Freetestking is your premier source for practice tests, and true testing environment. Nothing will prepare you for your next exam like a Freetestking. You find it all here at certbible.org.
Question: 1
You need to load information about new customers from the NEW_CUST table into the tables
CUST and CUST_SPECIAL. If a new customer has a credit limit greater than 10,000, then the details have to be inserted into CUST_SPECIAL. All new customer details have to be inserted into the CUST table. Which technique should be used to load the data most efficiently?
A. external table
B. the MERGE command
C. the multitable INSERT command
D. INSERT using WITH CHECK OPTION
Answer: C Question: 2
View the Exhibit and examine the description of the CUSTOMERS table.
You want to add a constraint on the CUST_FIRST_NAME column of the CUSTOMERS table so that the value inserted in the column does not have numbers.
Which SQL statement would you use to accomplish the task?
A. ALTER TABLE CUSTOMERS ADD CONSTRAINT cust_f_name
CHECK(REGEXP_LIKE(cust_first_name,’^A-Z’))NOVALIDATE ; B. ALTER TABLE CUSTOMERS ADD CONSTRAINT cust_f_name
CHECK(REGEXP_LIKE(cust_first_name,’^[0-9]‘))NOVALIDATE ;
C. ALTER TABLE CUSTOMERS ADD CONSTRAINT cust_f_name
CHECK(REGEXP_LIKE(cust_first_name,’[[:alpha:]]’))NOVALIDATE ; D. ALTER TABLE CUSTOMERS ADD CONSTRAINT cust_f_name
CHECK(REGEXP_LIKE(cust_first_name,’[[:digit:]]’))NOVALIDATE ;
Answer: C Question: 3
Which three tasks can be performed using regular expression support in Oracle Database 10g?
(Choose three.)
Page 1 of 91
Exam Name: Oracle Database SQL Expert
Exam Type Oracle
Exam Code: 1Z0-047 Total Questions: 168
A. It can be used to concatenate two strings.
B. It can be used to find out the total length of the string.
C. It can be used for string manipulation and searching operations.
D. It can be used to format the output for a column or expression having string data.
E. It can be used to find and replace operations for a column or expression having string data.
Answer: C, D, E Question: 4
View the Exhibit and examine the structure of the EMP table which is not partitioned and not an index-organized table.
Evaluate the following SQL statement: ALTER TABLE emp
DROP COLUMN first_name;
Which two statements is true regarding the above command? (Choose two.)
A. The FIRST_NAME column would be dropped provided it does not contain any data.
B. The FIRST_NAME column would be dropped provided at least one or more columns remain in the table.
C. The FIRST_NAME column can be rolled back provided the SET UNUSED option is added to the above SQL statement.
D. The FIRST_NAME column can be dropped even if it is part of a composite PRIMARY KEY
provided the CASCADE option is used.
Answer: B, D Question: 5
Evaluate the CREATE TABLE statement: CREATE TABLE products
(product_id NUMBER(6) CONSTRAINT prod_id_pk PRIMARY KEY, product_name VARCHAR2(15));
Which statement is true regarding the PROD_ID_PK constraint?
A. It would be created only if a unique index is manually created first.
B. It would be created and would use an automatically created unique index.
C. It would be created and would use an automatically created no unique index.
D. It would be created and remains in a disabled state because no index is specified in the command.
Answer: B Question: 6
Page 2 of 91
Exam Name: Oracle Database SQL Expert
Exam Type Oracle
Exam Code: 1Z0-047 Total Questions: 168
Which two statements are true? (Choose two.)
A. The USER_SYNONYMS view can provide information about private synonyms.
B. The user SYSTEM owns all the base tables and user-accessible views of the data dictionary.
C. All the dynamic performance views prefixed with V$ are accessible to all the database users.
D. The USER_OBJECTS view can provide information about the tables and views created by the user only.
E. DICTIONARY is a view that contains the names of all the data dictionary views that the user can access.
Answer: A, E Question: 7
View the Exhibit and examine the description of the ORDERS table.
Which two WHERE clause conditions demonstrate the correct usage of conversion functions?
(Choose two.)
A. WHERE order_date > TO_DATE(’JUL 10 2006′,’MON DD YYYY’) B. WHERE TO_CHAR(order_date,’MON DD YYYY’) = ‘JAN 20 2003′
C. WHERE order_date > TO_CHAR(ADD_MONTHS(SYSDATE,6),’MON DD YYYY’)
D. WHERE order_date IN ( TO_DATE(’Oct 21 2003′,’Mon DD YYYY’), TO_CHAR(’NOV 21
2003′,’Mon DD YYYY’) )
Answer: A, B Question: 8
View the Exhibit and examine the description of the EMPLOYEES table.
Interactive Testing 10g 1z0-047 Engine Included!
71 Questions
Updated : 09/18/2008
Price : $87.99 $79.99
Exam Number/Code:1z0-047
Exam Name: Oracle Database SQL Expert
Testking 1z0-047 Exam will provide you with exam simulation questions and actual answers that reflect the actual exam
Preparing for the Testking 1z0-047 exam?Searching 1z0-047 Test Questions,
1z0-047 Practice Exam,1z0-047 Braindumps ? 1z0-047 practice exam covers all
the practice test objectives to pass 1z0-047 exam.
Pass your exam at first attempt with our Testking 1z0-047 study guide,1z0-047 Braindumps, As well Audio exam, Realistic
Practice Labs, and Interactive Testing Engine.
Our Testking practice test covers the information associated with each 1z0-047 exam topics in details and includes
information found in no other practice test sites on the web.
Our challenging questions with Correct Answers built to simulate the actual exam. Unlimited, FREE auto-updates so you’re
never behind on any topic. The whole package comes as an automatic download so there’s no waiting or shipping. Our most
questions and answers along with explanations. Our practice test will determine you to take your 1z0-047 certification exam
and pass the official exam on your first try, guaranteed
Now guaranteed Testking 1z0-047 exam training is available in various formats to best suit your needs and learning style.
Whether you are a hands-on tactile learner, visually or even a textbook training veteran, Real-Exams has the 1z0-047 pdf vce
format resources that will enable you to pass your 1z0-047 test with flying colors.
Comprehensive questions with complete explanations about actualtests 1z0-047 exam
download 1z0-047 exam questions accompanied by exhibits
Verified Answers Researched by Industry Experts and almost 100% correct
1z0-047 exam questions updated on regular basis
Oracle 1z0-047 Transcender Torrent
Oracle 1z0-047 P4S
Oracle 1z0-047 Study Guide
Oracle 1z0-047 Exams
Oracle 1z0-047 Braindumps
Oracle 1z0-047 Pass4sure
Oracle 1z0-047 Real Exams
Oracle 1z0-047 Exam
Oracle 1z0-047 Actual Tests
Oracle 1z0-047 Pdf
1z0-047 also gives new editions of Real Exams 1z0-047 for enhancing professional skills and knowledge. These Testking Real Practice Questions 000-
710 are useful for understanding 1z0-047 exam terminologies and these brain dumps also very useful for enhancing people brain
power. These Testking Real Practice Questions 1z0-047 are prepare by highly qualified and 1z0-047 professionals. 1z0-047 Certification experts’
teams always try to give you real exam environment in these 4shared training materials links.
Question: 1
You need to load information about new customers from the NEW_CUST table into the tables
CUST and CUST_SPECIAL. If a new customer has a credit limit greater than 10,000, then the
details have to be inserted into CUST_SPECIAL. All new customer details have to be inserted
into the CUST table. Which technique should be used to load the data most efficiently?
A. external table
B. the MERGE command
C. the multitable INSERT command
D. INSERT using WITH CHECK OPTION
Answer: C
Question: 2
View the Exhibit and examine the description of the CUSTOMERS table.
You want to add a constraint on the CUST_FIRST_NAME column of the CUSTOMERS table so
that the value inserted in the column does not have numbers.
Which SQL statement would you use to accomplish the task?
A. ALTER TABLE CUSTOMERS ADD CONSTRAINT cust_f_name
CHECK(REGEXP_LIKE(cust_first_name,’^A-Z’))NOVALIDATE ;
B. ALTER TABLE CUSTOMERS ADD CONSTRAINT cust_f_name
CHECK(REGEXP_LIKE(cust_first_name,’^[0-9]‘))NOVALIDATE ;
C. ALTER TABLE CUSTOMERS ADD CONSTRAINT cust_f_name
CHECK(REGEXP_LIKE(cust_first_name,’[[:alpha:]]’))NOVALIDATE ;
D. ALTER TABLE CUSTOMERS ADD CONSTRAINT cust_f_name
CHECK(REGEXP_LIKE(cust_first_name,’[[:digit:]]’))NOVALIDATE ;
Answer: C
Question: 3
Which three tasks can be performed using regular expression support in Oracle Database 10g?
(Choose three.)
A. It can be used to concatenate two strings.
B. It can be used to find out the total length of the string.
C. It can be used for string manipulation and searching operations.
D. It can be used to format the output for a column or expression having string data.
E. It can be used to find and replace operations for a column or expression having string data.
Answer: C, D, E
Question: 4
View the Exhibit and examine the structure of the EMP table which is not partitioned and not an
index-organized table.
Evaluate the following SQL statement:
ALTER TABLE emp
DROP COLUMN first_name;
Which two statements is true regarding the above command? (Choose two.)
A. The FIRST_NAME column would be dropped provided it does not contain any data.
B. The FIRST_NAME column would be dropped provided at least one or more columns remain in
the table.
C. The FIRST_NAME column can be rolled back provided the SET UNUSED option is added to
the above SQL statement.
D. The FIRST_NAME column can be dropped even if it is part of a composite PRIMARY KEY
provided the CASCADE option is used.
Answer: B, D
Question: 5
Evaluate the CREATE TABLE statement:
CREATE TABLE products
(product_id NUMBER(6) CONSTRAINT prod_id_pk PRIMARY KEY,
product_name VARCHAR2(15));
Which statement is true regarding the PROD_ID_PK constraint?
A. It would be created only if a unique index is manually created first.
B. It would be created and would use an automatically created unique index.
C. It would be created and would use an automatically created no unique index.
D. It would be created and remains in a disabled state because no index is specified in the
command.
Answer: B
Question: 6
Which two statements are true? (Choose two.)
A. The USER_SYNONYMS view can provide information about private synonyms.
B. The user SYSTEM owns all the base tables and user-accessible views of the data dictionary.
C. All the dynamic performance views prefixed with V$ are accessible to all the database users.
D. The USER_OBJECTS view can provide information about the tables and views created by the
user only.
E. DICTIONARY is a view that contains the names of all the data dictionary views that the user
can access.
Answer: A, E
Question: 7
View the Exhibit and examine the description of the ORDERS table.
Which two WHERE clause conditions demonstrate the correct usage of conversion functions?
(Choose two.)
A. WHERE order_date > TO_DATE(’JUL 10 2006′,’MON DD YYYY’)
B. WHERE TO_CHAR(order_date,’MON DD YYYY’) = ‘JAN 20 2003′
C. WHERE order_date > TO_CHAR(ADD_MONTHS(SYSDATE,6),’MON DD YYYY’)
D. WHERE order_date IN ( TO_DATE(’Oct 21 2003′,’Mon DD YYYY’), TO_CHAR(’NOV 21
2003′,’Mon DD YYYY’) )
Answer: A, B
Testking 1z0-047
TK Questions&Answers(Q & As with Expert Explanations): 168 Q&A
Update: 02/08/2008
Free Down: Testking 1z0-047
Free Down: Pass4sure 1z0-047
Dowload PassGuide Practice Test Questions
7 Comments on “Testking Oracle 10g 1z0-047”
could sum 1 giv me tips in sql,oca n ocp exams