| Oracle 1Z0-047 practice exams [message #487960] |
Mon, 03 January 2011 19:41  |
kghkg
Messages: 5
Registered: September 2010
|
Junior Member |
|
|
Exam Number/Code : 1z0-047
Exam Name : Oracle Database SQL Expert
Questions and Answers : 278 Q&As
Update Time: 2010-12-13
1. 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: CDE
2. 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 nonunique index.
D. It would be created and remains in a disabled state because no index is specified in the command.
Answer: B
3. 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
Test1pass provides real exam test engine, it Include exam free demos.Test1pass help you pass the exam for the first time and provide three months of free upgrades and a full money back guarantee!Believe Test1pass, help you succeed!
Site 1z0-047 1z0-047 exam item bank according to the change dynamic updates, changes in the factory after each exam, we are committed to two days, updated 1z0-047 question bank. 1z0-047 exam questions to ensure coverage of more than 95% always; We provide two kinds of master versions of 1z0-047 exam for you to choose.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
