what the REPLACE('JACK AND JUE','J','BL') will return ?
Answer Posted / guest
BLACK AND BLUE
| Is This Answer Correct ? | 48 Yes | 2 No |
Post New Answer View All Answers
Explain about cursors?
What database should I learn first?
What is a candidate key in a database?
What are dml and ddl statements?
What is the example of rdbms?
How do you use a database worksheet?
What is optimization in database?
1. Difference between Lookup and join? 2. Difference between funnel and join? 3. What type of load you have used in your project? 4. What type of data warehouse schema you have fallowed in you project? 5. How many fact tables and dimension tables is their in project? 6. How do you kill the job process using windows environment? 7. Difference between sequence file and dataset? 8. What is delta load and subsequent load? 9. By using which stages you have implemented the SCD
What is key dbms?
Describe the differences between vertical and horizontal portioning.
Do I need ccp4?
What are the functions of a database?
What are data modelling tools?
What is openedge workgroup rdbms?
1.If we have a Salary coloumn in Staff entity with this description the salary must be monetary and >=$35450.00, how we can write it in into schemain SQL? 2. If we have Weight and Marks in Assessment entity and the Weight has the description of this it must be Non-zero percentage. And also the Marks attribute stores the maximum possible raw mark for assessment (e.g., 30), while Weight stores of the weight of this assessment for the paper as a whole (e.g., 10%). If Marks is not specified, then Weight is used for both. How we can convert this into schema in SQL????