This article is prepared for the one going to face Oracle job Interview. The tips to understand and master before having the interview are:
What are the components of physical database structure of Oracle database?
Oracle database is comprised of three types of files. One or more datafiles, two are more redo log files, and one or more control files.
What are the components of logical database structure of Oracle database?
There are tablespaces and database’s schema objects.
What is a tablespace?
A database is divided into Logical Storage Unit called tablespaces. A tablespace is used to grouped related logical structures together.
What is SYSTEM tablespace and when is it created?
Every Oracle database contains a tablespace named SYSTEM, which is automatically created when the database is created. The SYSTEM tablespace always contains the data dictionary tables for the entire database.
Explain the relationship among database, tablespace and data file ?
Each databases logically divided into one or more tablespaces one or more data files are explicitly created for each tablespace.
What is schema?
A schema is collection of database objects of a user.
What are Schema Objects?
Schema objects are the logical structures that directly refer to the database’s data. Schema objects include tables, views, sequences, synonyms, indexes, clusters, database triggers, procedures, functions packages and database links.
Can objects of the same schema reside in different tablespaces?
Yes.
Can a tablespace hold objects from different schemes?
Yes.
What is Oracle table?
A table is the basic unit of data storage in an Oracle database. The tables of a database hold all of the user accessible data. Table data is stored in rows and columns.
What is an Oracle view?
A view is a virtual table. Every view has a query attached to it. (The query is a SELECT statement that identifies the columns and rows of the table(s) the view uses.)
What is Partial Backup ?
A Partial Backup is any operating system backup short of a full backup, taken while the database is open or shut down.
What is Mirrored on-line Redo Log ?
A mirrored on-line redo log consists of copies of on-line redo log files physically located on separate disks, changes made to one member of the group are made to all members.
What is Full Backup ?
A full backup is an operating system backup of all data files, on-line redo log files and control file that constitute ORACLE database and the parameter.
Can a View based on another View ?
Yes.
Can a Tablespace hold objects from different Schemes ?
Yes.
Can objects of the same Schema reside in different tablespace ?
Yes.
What is the use of Control File ?
When an instance of an ORACLE database is started, its control file is used to identify the database and redo log files that must be opened for database operation to proceed. It is also used in database recovery.
Do View contain Data ?
Views do not contain or store data.
What are the Referential actions supported by FOREIGN KEY integrity constraint ?
UPDATE and DELETE Restrict - A referential integrity rule that disallows the update or deletion of referenced data. DELETE Cascade - When a referenced row is deleted all associated dependent rows are deleted.
What are the type of Synonyms?
There are two types of Synonyms Private and Public.
What is a Redo Log ?
The set of Redo Log files YSDATE,UID,USER or USERENV SQL functions, or the pseudo columns LEVEL or ROWNUM.
What is an Index Segment ?
Each Index has an Index segment that stores all of its data.
Explain the relationship among Database, Tablespace and Data file?
Each databases logically divided into one or more tablespaces one or more data files are explicitly created for each tablespace
What are the different type of Segments ?
Data Segment, Index Segment, Rollback Segment and Temporary Segment.
What are Clusters ?
Clusters are groups of one or more tables physically stores together to share common columns and are often used together.
What is an Integrity Constrains ?
An integrity constraint is a declarative way to define a business rule for a column of a table.
What is an Index ?
An Index is an optional structure associated with a table to have direct access to rows, which can be created to increase the performance of data retrieval. Index can be created on one or more columns of a table.
What is an Extent ?
An Extent is a specific number of contiguous data blocks, obtained in a single allocation, and used to store a specific type of information.
What is a View ?
A view is a virtual table. Every view has a Query attached to it. (The Query is a SELECT statement that identifies the columns and rows of the table(s) the view uses.)
What is Table ?
A table is the basic unit of data storage in an ORACLE database. The tables of a database hold all of the user accessible data. Table data is stored in rows and columns.
Oracle Interview Questions and Answers
Best way to invest money
Do you know the best way to invest money? The answer can be “may be or may be not”. “Well, Don’t worry be happy” The article below may answer your questions.Remember that this is only one of hundreds or even thousands of opinion about The best way to invest money.
First, there are those who say that the stock market is the best way to invest money due to the high rewards you can receive if the stock soars. The stock market is the only investment area where you can see you money multiple ten fold over the course of a week, thus making it seem to be the best way to invest money. Also, you don’t need to have large amounts of cash on hand to be able to get involved in the stock market. Many people will start out getting involved with penny stocks, which can be purchased as low as 1 cent. Therefore, if you invest only $20 you will still be responsible for 2,000 shares. Although penny stocks are typically never big money returns they are a great way to get your feet wet with the stock market and still be able to make a profit, thus providing another reason the stock market seems to be the best way to invest money. However, there are those who also say that the stock market is not the best way to invest money due to the high risks that come with having money tied up in an ever changing stock market. The stock market has been known throughout history to crash, causing investors to be out millions of dollars. Also, there is no real way to know when a crash is coming. While the stock market may be the only investment area you can see your money multiple ten fold in a week it is also the only area you can see your money decrease 10 fold over the course of a day, thus making it seem to not be the best way to invest money. In summary, the stock market is the ultimate high risk/high reward investment. So before you play the stock market the question you have to ask yourself as an investor is do you view the best way to invest money as the safest or as the most profitable possibility?
Now, if you answered the previous question that the best way to invest money is the safest then rather then look to the stock market place your money in real estate investments. The easiest, most common and most profitable way to get involved with real estate investments is by “flipping” houses. In this case people will buy homes that are in foreclosure directly from the mortgage lender. Due to the fact that the lender is not making any money on a house that is not being occupied they will look to fill the house as soon as possible. This allows the investor to be the strong hand in the negotiation process. An investor can purchase the property below market value, sometimes up to 40%, which means that the property already has equity. Now, the investor can turn around and sell the property at full market value and make a profit. It seems so easy that you might think it was illegal. However, there are no laws against “flipping” houses. Also, the reason real estate is a safer way to invest your money is because historically property values do not crash like stock values. For the most part, property values continually increase overtime allowing the investor to make a higher profit when the property is sold. This is especially true in bigger markets such as California, Florida, and New York. For these reasons many people believe that real estate is the best way to invest money. So why would real estate not be the best way to invest money? Well, first off you have to have a lot more capital in hand to be able to start investing in real estate as opposed to the stock market. In essence, there are no penny real estate ventures. Also, while there is an unlimited amount of stocks available there is only a certain amount of real estate available. Finally, real estate investments require more hands on work and usually take longer to account for the same amount of profit that a stock can achieve. It is for these reasons many people believe that real estate is not the best way to invest money.
So what is the best way to invest money? The answer is there is no answer. Everybody has different needs and different wants. Therefore, what investment may be right for one person may not be what’s right for another person. Maybe you want a chance at striking gold quickly no matter what the risk. Maybe you would rather wait a while if it means that your risk is less. Nobody knows but you. So what is the best way to invest money? Well, only you can answer that one.
Learn to invest money
The information here will help you to better understand the stock trading and other investment vehicles. I will teach you how to invest your money for the greatest possible gains while reducing the associated risks in the stock market and other investing opportunities.
The lessons I have learned during my investment career are passed on here to help guide you through the sometimes confusing world of the stock market. This information will give you the knowledge and expertise to make informed decisions regarding your portfolio.
I know there are many people out there who want to learn how to invest, but are apprehensive because they just don’t have the education or the background to make informed choices. And admittedly there are many financial websites that you can visit to try to gain a better understanding of stock trading, and investing in general. The advantage here is that I designed this site to be extremely user-friendly with step by step instructions on how to invest that other investing websites do not match.
Many sites have so much information that it is overwhelming, so I am keeping this a common sense, simple to use, free financial site to help people start from scratch and be successful with their investment portfolio. I will show you the things you need to know as you start on this journey and I will be here to help you every step of the way.
How to Invest Small Amounts of Money?
Do you want to Invest Small Amounts of Money? If yes , you may have the other questions “How to Invest my Small Amounts of Money?”Well don’t worry” The tips below might solve your problem. Just try it. GOOD LUCK and happy investing
Step1
One way that you can start to invest with a small amount of cash is direct investing, it is a method of buying stock directly from the company without going through a broker. This saves you the broker fees that you would normally have to pay.
Step2
So for as little as less then that coffee a day you can invest in your future. There are also programs available that allow you to automatically deduct from your banking account and invest directly into your stock.
Step3
Here is a website that can help you to research companies that you may want to invest in ~ Sharebuilder.com.
It is very useful, and you can invest any amount of money you choose. They offer very low trading fees $1-$4 per trade.
Step4
When you are knew to the investment arena do your research before investing. Choose a well known company that you know you can trust. You don’t want to have a negative first time experience.
Step5
Once you buy your first share of stock in some companies you don’t have to buy a full stock the next time. With doing this it makes it easier for you to build up your share of stock little by little at your own pace.
Step6
Realizing that there are options for investing even for those on a budget is a great way to head into investing. It can be fun and rewarding if you know what you are doing. Just make sure that you research each company and get the information that you need before handing over any
How do I Invest Small Amounts of Money?
Do you know the word “investing”? Are you familiar with that Catchy word? It is a kind of word leading you think about ” getting more and more money” .But actually the word “investing” is not as simply as you think. Investing comes in a wide range as well as spectrum of types and ways. In the currently context of investment arena, there are basically four types of investment:
1. Stock equities
2. Funds
3. Warrants
4. Bonds
5. Insurance / Regular saving
6. Foreign Exchange
However, the negative side of this coin is that all these investment instruments require thousands to start up. Especially money market, time deposit of foreign currencies require at least $50,000 to start up. However, it is not in the case of Mini-Forex account that works on margin trading between two stipulated currencies. But this is not consider as investing as it is very highly speculative in nature and is usually termed as gambling.
Well, not enough money to start investing? There is a solution for you. But you require at least $1,000 to start up. As you can see from the global market review, Asia market has the highest level of potential and emergence opportunity. So buy a regional fund like Asia except Japan and hold it at a minimum price of $1,000. Subsequently applied for a RSP or regular saving plan that stipulate to buy at least $100 worth of units monthly.
The advantage of capitalizing on RSP is that during volatile market movement, it tends to do a dollar-cost-average on a monthly basis for you. Conversely speaking, in a high trending market, it will collect these unit and stepping up the amount of profit for your fund.
It is such a win-win strategy to take when you are keen to invest but was limited by financial capacity.
Job Vacancies for Deputy General Manager - Branded Restaurant, Heathrow
Location: London
Salary: £24000 - £30000 per annum + bonus scheme
Company: Core Recruitment
Core Recruitment
*
* Company vacancies…
* Company profile…
Job type: Permanent
Date posted: 02/10/2008 16:35
Description: Position:Deputy General Manager - Branded Restaurant, Heathrow!!!
Location: Heathrow
The Client
My client currently operates high volume, high quality branded restaurants, cafes and bars and in the UK’s busiest airports and shopping centres. A market leader with over 15 years experience of delivering enhanced customer satisfaction and business profitability, through the development and delivery of outstanding brands!!!
The Role
As Deputy General Manager, you will be responsible for the daily operations and financial performance of this high volume, full table service branded restaurant operation within a busy airport! Working with a General Manager, this is very much a hands-on position, leading from the front, maintaining high company standards of product and service. The focus will be on team training and maintaining excellent service standards while driving the business forward and maximizing growth. This is a great opportunity to join one of the UKs leading branded companies!
The Person
A background in branded food led bar or restaurant industry is essential. Ideally my client is looking for an ambitious Manager with an outgoing personality and strong motivational skills. The right candidate will be a strong existing Assistant or Deputy Manager, have good basic P&L knowledge and a passion for customer focus with an eye for detail! A background in training would be an advantage. There are great career progression opportunities for a vibrant and driven Manager!!!
Salary: £24 - 30,000 per annum plus bonus scheme!!! (dependant on skills and experience)
Position: Deputy General Manager - Branded Restaurant, Heathrow!!!
Job Vacancies for Contracts Manager - Heathrow
Location: Heathrow, Hounslow (TW6)
Salary: Circa £50k plus package
Company: McGinley Recruitment Services
McGinley Recruitment Services
*
* Company vacancies…
* Company profile…
Job type: Permanent
Date posted: 02/10/2008 09:16
Description: Contracts Manager - Heathrow - circa £50k plus package - Our client currently has an immediate vacancy for an exoerienced Contracts Manager to oversee numerous works within the airports division. The work is a maintenance contract for BBA (small civil engineering works) and they are currently looking for a Contracts Manager to be based at Heathrow Airport.
As a Contracts Manager, you will be responsible for overseeing managing Civil Engineering Projects from planning stage through to final accounts. Responsibilities will include overseeing site teams, health & safety management, cost/value control, programming, commercial reporting, client liaison and you will be responsible for all correspondence and record keeping in accordance with company procedures.
You must be from an Engineering background and are likely to have obtained a minimum of a HNC in Civil Engineering. You may currently be working as a Contracts Manager for a Civil Engineering Contractor or you may be a Senior Project Manager looking for a new challenge. Either way, it is vital that you possess excellent communication and people management skills and have the drive and enthusiasm to manage multiple projects through to completion, within budget and program.
If you think you have the skills we need then please get in touch by clicking the apply online button below.
