What are inner join and outer join?3 5954
what are indexes..how many types of index's are there and what are they?6 8953
What are functions3 3739
What are the different table present in MYsql?3 6294
Is Oracle 7.3 is a single user or multi user..Is it possible to use this as a backend for web applications?2 2092
What are the consideration at tehe migration of Oracle 9i to 10G.
IS it possible to built the oracle database without setting the kernal parameters?
what is data access layer?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
can i use the commands "modify" and Change in DB2 to alter my column datatype and its name in a table?
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
Suppose database is running slow, what will you do?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
Have you ever used MySQL Administrator and MySQL Query Browser? Describe the tasks you accomplished with these tools?
if i want to display the name of students such that to which city they belong must have count greaer than two
I'm need to prepare Month Over Month Sales Growth report. Is there any function available in OBIEE to perform this task.
Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?
How to fetch/retrieve the data from hieranchical database and put it into the relational database? for e.g I want to extract the data from IMS DB2 database which is a hierarchical db and load that data into the relational database which is a SQL server.Are there any tools available for directing extracting data from hierarchical db and loading into the relational database (SQL server)?
write a query that returns first characters of each word in Oracel/Sql pl sql