(a). The electrician will works on Tuesday and the interior decorator on Friday
(b). The painter will work on wednesday and plumber on thursday
(c). The carpenter will works on Tuesday and the painter on Friday
(d). THe painter will work on Monday and the carpenter on Thursday
(e). The carpenter will work on Wednesday and the plumber on Thursday
Ans: (e)
CMC software-B'lore
ORACLE TEST
1. What are the difference b/w candidate key, primary key and unique key?
2. What is difference b/w pre query and post query?
3. How many number of columns can be created in a single table.
4. What is meant by ROWID? Why we need it?
5. What is transaction?
6. Difference b/w function, procedure?
7. Which one is the best way to find out the number of rows in a table, state
by following a) count (1) b) count (*), count (rowed)
They gave one table and questions and asked to write queries for that
They are
Write query to delete a single column in a table.
Write query to add one more column in a existing table.
Write query to delete only 2 duplicate records in a table. But the table they have
given contains 3 duplicate records. How to do it.
Some SELECT statements queries they asked like using group by, ordered by,
where...etc.
So prepare well for queries and concepts. All the best and best of luck
|
|
