HOW TO APPEAR FOR ONLINE EXAMS OF SQL & PL/SQL? WHICH BOOKS
WILL BE BETTER FOR REFERENCE TO QUALIFY THESE EXAMS? ARE
THERE ANY MODEL PAPERS AVAILABLE IN THE MARKET ABOUT SQL &
Answers were Sorted based on User's Feedback
Answer / m.m
You can go through the Oracle press book for sql and pl/sql.
To get an idea on the type of qs asked in the exam, surf
and run through the dumps.
|Is This Answer Correct ?||4 Yes||0 No|
Answer / somashekhar m
Better U join ucertigy.com MS PL/SQL on line course where
they will even teach you how to appear for exam, where and
when. Once if you become a member to ucertify pl. notify me
|Is This Answer Correct ?||0 Yes||0 No|
1 SELECT a.field1, b.field2, c.field3, d.field4 2 FROM atable a, atable b, ctable c, dtable d 3 ? 4 ORDER BY 1 What is the minimum number of joins that must be specified on line 3 in the sample code above to properly link the tables? Notice that the table "atable" is aliased twice: once as "a" and once as "b." 1. One join 2. Two joins 3. Three joins 4. Four joins 5. Five joins
What are the steps you take to tune(performance tuning) the code in plsql?
sql query to get zero records from a table having n no of records
i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this
write a query to find 4th max salary
What is the difference between join and union.
How many LONG columns are allowed in a table?
What is the differnce between view and materialized view
Source is Sales Table: Sno Prod Sales Sales_Amount 1 A 10 2000 2 A 20 1000 3 C 10 3000 4 D 30 4000 5 A 20 1000 Target : Sales_Count T_Sales_Amt Sales_Count(A) T_Sales_Amt(A) 90 11000 50 4000 In single query, pls tell me.
What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?
Difference between aggregate function and analytical function?
Can 2 queries be executed simultaneously in a distributed database system?