...Interview Questions for hiring an Oracle mid-level developer in an IT organization General Questions: • Please tell us a little about the organization that you work for and your role in it. • Do you see yourself as a nut and bold developer or more of team lead role within your organization • Do you have any issues with working on all phases of a project (such as Analysis, Design, Coding, Documentation and Implementation)? Under your current role, do you work in all these phases yourself or are you usually involved with one particular phase? General Oracle Database and PL/SQL Questions: • Do you have any experience with Autonomous Transactions in Oracle database? The purpose is to complete (commit/rollback) a transaction in a called procedure irrespective of the transaction state in the calling procedure. • Have you ever encountered a situation with Mutating Tables and what did you do to work around it? When a table is in state of transition it is said to be mutating. eg: If a row has been deleted then the table is said to be mutating and no operations can be done on the table except select. • What’s your experience with Oracle Forms and Reports. Where would you implement bulk of business rules so as to make your coding more modular in Oracle Forms? PLL’s (PL/SQL Libraries). • What is referential integrity? Rules governing the relationships between primary keys and foreign keys of tables within a relational database that determine data consistency. Referential ...
Words: 1951 - Pages: 8
...I bought a book from crossword; he packed the book and added two bookmarks into my pack. A thought came to my mind. Why do I need a bookmark? I can easily memorize the page number and the next time resume from the same page when I resume reading, or read them all over to reach to the point where I stopped reading. But not all have a blessed memory; moreover, there are better things to remember, my grandpa would rather bookmark and rely on it to help him resume reading. It’s a kind of simple index, isn’t it? This article focuses on how MS SQL Server uses indexes to read and write data. Data is arranged by SQL Server in the form of extents and pages. Each extent is of size 64 KB, having 8 pages of 8KB sizes. An extent may have data from multiple or same table, but each page holds data from a single table only. Logically, data is stored in record sets in the table. We have fields (columns) identifying the type of data contained in each of the record sets. A table is nothing but a collection of record sets; by default, rows are stored in the form of heaps unless a clustered index has been defined on the table, in which case, record sets are sorted and stored on the clustered index. The heaps structure is a simple arrangement where the inserted record is stored in the next available space on the table page. Heaps seem a great option when the motive is simply storing data, but when data retrieval steps in, this option back fires. An index acts as a fire fighter in this scenario. Indexes...
Words: 433 - Pages: 2
...DEPARTMENT (DepartmentName, BudgetCode, OfficeNumber, Phone) Solution: CREATE TABLE DEPARTMENT( DepartmentName Char(35) NOT NULL, BudgetCode Char(30) NOT NULL, OfficeNumber Char(15) NOT NULL, Phone Char(12) NOT NULL, CONSTRAINT DepartmentPK PRIMARY KEY(DepartmentName) ); ========================================================================================== 7.5 Write a CREATE TABLE statement for the EMPLOYEE table. Email is required and is an alternate key, and the default value of Department is Human Resources. Cascade updates but not deletions from DEPARTMENT to EMPLOYEE. • EMPLOYEE (EmployeeNumber, FirstName, LastName, Department, Phone, Email) • Department in EMPLOYEE must exist in DepartmentName in DEPARTMENT • EmployeeNumber is a surrogate key that starts at 1 and increments by 1. Solution: CREATE TABLE EMPLOYEE( EmployeeNumber Int NOT NULL IDENTITY(1,1), FirstName Char(25) NOT NULL, LastName Char(25) NOT NULL, Department Char(35) NOT NULL DEFAULT ‘Human Resources’, Phone Char(12) NULL, Email Char(100) NOT NULL, CONSTRAINT EmployeePK PRIMARY KEY(EmployeeNumber), CONSTRAINT DepartmentFK FOREIGN KEY(Department) REFERENCES DEPARTMENT(DepartmentName) ON UPDATE CASCADE ON DELETE NO ACTION, CONSTRAINT EmployeeAK UNIQUE(Email) ); ========================================================================================= ...
Words: 409 - Pages: 2
...UNDERSTANDING THE RELATIONAL DATABASES Student’s Name Instructor’s Name Course Name 03/05/2016 RELATIONAL DATABASES Being a data administrator is to handle and organize the bulk of data masses for easy and convenient retrieval of the information at any point of time. I generally believe that compiling a bulk of data is very difficult task for anyone who has the responsibility to manage the information. Therefore, here we go through and understand the concept of relational databases and use of tables designed to manage the data for the problem cases in our daily life. A relational database is a defined group of data items systematized and controlled as a set of formally defined tables from which the collected and unmanageable data can be reassembled or accessed in various different techniques deprived of having to restructure the pre-arranged database tables (Rouse, n.d.). According to Codd (1982), “Relational processing entails treating whole relationships as operands. Its primary purpose is loop-avoidance, an absolute requirement for end users to be productive at all, and a clear productivity booster for application programmers” (p.298). It comprises of designed data tables that are connected together in some important way. For instance, consider an organization that offers items to clients. The organization keeps up a database of the items it offers. Every item has a one of a kind code so it can be uniquely recognized. The item database comprises of a table, and each...
Words: 631 - Pages: 3
...Search 990 000 Essays Essays » Business & Economy » Marketing & Advertising Abbot - Alza Case Report | By baskakov, Jun 2012 | 4 Pages (860 Words) | 63 Views| This is a Premium essay for members like you Risk arbitrage (or merge arbitrage) is a trading strategy related to M&A transactions. For example, if an M&A transaction is carried out by means of share exchange between the buzzer and the target, then an arbitrageur may short sell buyer’s stocks and purchase stocks of the target. Until the acquisition is completed, the stock of the target typically trades below the purchase price. After the merger is completed, the target's stock will be converted into stock of the acquirer based on the exchange ratio predetermined in the merger agreement. The arbitrageur delivers the converted stock into his short position to complete the arbitrage. In an efficient capital market, the price of the target and acquirer will fully and immediately reflect the terms of the merger. However, risk arises from the possibility of deals failing to go through. Such possibility put the risk in the term “risk arbitrage”. Green circle had USD 500 million in AUM with 5% upper bound of position in a distinct investment (or 25 million). Smith arbitrage position was within the bounds or 13.5 million in short Abbot and 12.5 million in long position for Alza stocks. The proportion between Abbot and Alza shares was determined by the appropriate market prices of Abbot and Alza shares and announced exchange...
Words: 1196 - Pages: 5
...the perceptions of those behaviors. Think of the study of conflict as a view through a lens, like the lens of a camera, or through prescription glasses. The lens model of conflict specifies that each person has a view of (1) oneself, (2) the other person, and (3) the relationship. These perceptual pieces form the fundamental views of all conflicts, and combined together they form the mosaic of a particular conflict (Wilmot & Hocker 2010). There are also minimal features of all conflicts. They are: (1)the communicative acts or behaviors of each person, (2)the meanings or attributions attached to those acts by each person, which are each person’s view of self and each person’s views of the other, and (3)the meanings or attributions the two people ascribe to their relationship, which include past events, current events, and future projections. Each person also has a lens that gives that person a particular perspective, just as people use different types of glasses to see. There are multiple views of conflict, yet each looks real to the one seeing it (Wilmot & Hocker 2010). In a conflict, each person will have their own view of the situation at hand and react differently. As the old saying says, there are two sides to every story. For example, let’s say you have a couple that gets into an argument or should I say, a conflict, about their child spilling juice on the living room carpet. The mother may view it as being a simple mistake and can easily be cleaned, whereas the father...
Words: 381 - Pages: 2
...2. IMAGE ANNOTATION 2.1. LABELLING IMAGE DATA Looking at the Data panel in the upper right corner of the (Fig. 2.3). Opening an image dataset folder by pressing the button Open Image Folder. Then selecting an image in the listbox underneath. We may now specify the Image source in the Current image panel. In case the popup menu does not offer a relevant option, we may specify an alternative source of the image by choosing the option ‘other’. After pressing the annotate button on the New Annotation panel the tool will switch to annotation mode where only image labelling using the mouse is allowed. Annotate by pressing the left mouse button and clicking in the image area. Pressing the right mouse button will finish the object labelling and will close the polygon. (See fig. 2.3). If we press the Annotate button now, the previous label will be erased and we may label the object again. Pressing the right mouse button without having labelled anything will just cancel the annotation mode. The zoom feature will ease the annotation of smaller objects. Figure 2: Annotating an image object from our database 2.2. OBJECT ANNOTATION Having labelled an image we may now specify its class, degree of its occlusion, representativeness...
Words: 431 - Pages: 2
...Julius Chen George Chiu Armen Odadjian Mengyang Wu FBE459: Stock-Trak End of Semester Report Our portfolio had a return of +6.97% as of November 28th compared with a +3.86% return on the S&P 500 in the same time period. We ended with a Sharpe Ratio of 4.30 and portfolio beta of 0.23. Over 136 trades, we employed various option strategies, longed and shorted equities, speculated on commodities with futures, and invested in fixed income securities. Listed below are a few highlights and in-depth analysis of the strategies that we used. Protected Put Ticker | Position | Cost | Strike | S0 | ST | Profit/Loss | MU | Long | | | 30.61 | 34.30 | +$369.00 | | Buy Put | 1.72 | 31 | 30.61 | 34.30 | -$172.00 | DVN | Long | | | 59.02 | 67.20 | +$818.00 | | Buy Put | 1.60 | 57.5 | 59.02 | 67.20 | -$160.00 | SSYS | Long | | | 116.63 | 102.42 | -$1,421.00 | | Buy Put | 6.70 | 115 | 116.63 | 102.42 | +588.00 | *where S0= price at position open and ST=price at position close On October 22, we entered into three protect put strategies for Micro Technology (semiconductor maker), Devon Energy Corp. (energy company), and Stratasys, Ltd. (3-D printer maker). Our team believed that each company would outperform their peers in their perspective industries. Each company, however, operates in volatile industries. The semiconductor industry suffers from cyclical demand and producers often see margins slashed due to constant price wars. The stock prices of energy companies often...
Words: 3188 - Pages: 13
...the prices of the 225 stocks and divides this sum by a divisor. When the announcement about index change takes place, the index is calculated as the above-mentioned method until the new composition of stocks becomes effective. The announcement date and the date of “effectiveness” are different – there is a time period between them. After the effectiveness date the shares of new member companies are added and divided by the new divisor. The price sequence has to be maintained by the index. Therefore, the new divisor is calculated to guarantee the sequence before and after the effectiveness date. The equation below must be satisfied: Σ 225 stocks before changeDivisor before change= Σ 225 stocks after changeNew divisor From the point of view of one who does not like a lot of risk and wants to minimize it. So, I would like to sell stocks that will be deleted and then will be stocks that will be added one day before the effectiveness date. In this case, if I would be able to swap the deletions and additions at the date, I would bear no risk. 2) What would you do if, instead, you were at the proprietary trading desk of Goldman Sachs? There are two possible trading strategies. 1st: used by arbitrageurs who anticipate a continuous price rise in the period after the announcement. But simply irrational bull traders may cause the price rise. Arbitrageur shorts deletions (buy additions) on announcement and holds the position until one day prior to the change date and settles it...
Words: 502 - Pages: 3
...Hence it has been rightly said that “It is not as easy to short as it is to go out and buy a stock”. They also identified 11 anomalies that are partly explained by sentiment related mispricing. Some of the anomalies are related to financial distress, net stock issues and equity issuance, asset growth, net operating assets, momentum etc. They also used the Baker and Wurgler market wide investor sentiment index to explore the sentiment effects They develop and test three hypotheses that result from combining the presence of market-wide sentiment with short sale argument. They are as follows: 1) Anomalies should be stronger following high sentiment as the most optimistic views will be very optimistic and will result in considerable overpricing as compared to low sentiment period where, the optimistic views will be by rational investors and hence less mispricing. Moreover, selling a stock short by betting on price drop is harder than buying stocks on price gain. Hence stocks are more likely to be over-priced when sentiments are high as compared to under-priced when sentiments are low. It was found from the tables that all 11 anomalies were stronger following high levels of investor sentiment. When averaged across anomalies, 70% of the benchmark adjusted profits were in months...
Words: 502 - Pages: 3
...pound Grade A ostrich carcasses. The daily Price cannot be $0.05/lb. above or below the previous day’s settlement price. 2. i) According to world – ostrich organization (http://www.world-ostrich.org/demand.htm), the current demand for ostrich meat is way far more than supply. Therefore, there will be a constantly increase in the price of ostrich meat. Investors are reluctant to take short positions of ostrich meat futures; however, there would be a lot of people willing to take long positions. Thus, the long positions will be in far excess of short positions. Was the market exist, it would not be balanced. ii) Breeders of the ostrich meat, such as rancher, who tend to avoid the risk of ostrich disease or to offset the rising of feed price, will undertake short position of the future contract. The users of the ostrich meat, such as the food processor, who expect the price to rise, will undertake long position. For example, an investor who expects the ostrich meat to be in excess of demand will long the contract. 3. i) The deliverable grades of the contract are specific, it includes the weight, grade, and the pack standard of the meat, this will help the contract to be better executed. ii) The daily price limit of each contract is 5 cents per pound ($3,000/contract) above or below the previous day’s settlement price (expendable to $0,075/lb) which could secure the loss of both sellers and buyers. 4. i) The trading unit of 60,000 lbs. is not appropriate for a meat...
Words: 1090 - Pages: 5
...Cover Letter Advice When writing a Cover Letter to send to a potential employer, try to include the following elements: 1. State what are you applying for eg. "I am writing to apply for the position of Marketing Assistant..." 2. Say why are you applying for this specific position. eg. "I am passionate about marketing and feel that this position would enable me to develop my skills further..." 3. Elaborate on why you want to work for this specific company. eg. "... in your company, to become part of such an iconic brand..." 4. Give some basic pesonal information. eg. "I am a third year ESPEME student at EDHEC Business School, Nice,.." 5. List a few of your best qualities and motivations. eg. "I am highly motivated, hard-working, with great attention to detail..." 6. Let them know that relocation isn't a problem, if the position involves moving to another country or city.eg. "London is an interesting city, and I would enjoy working in such a vibrant environment..." 7. Specify that you are enclosing (post) or attaching (email) your CV eg; "Please see my attached CV for your consideration..." 8. End the letter hopeful and confident of a response.and ususally signed "Yours sincerely" eg "I look forward to hearing from you." 9. Re-read your Cover Letter and ensure that it is concise, polite and formal. 10. Remember, you need to try to "stand out from the crowd"! The person receiving your application may receive hundreds of applications...
Words: 277 - Pages: 2
...capitalization rate). Liquidity – the ability to convert an asset into cash easily and at fair value * Long position – if you are “Long” a stock, you own it. * Short position -- If you are “Short” as stock, you have shorted it. Order Type | Purpose | Trigger price | Market Order | Trade (buy, sell or short) at current price | N/A | Limit buy | Buy at an attractive price | Below current price | Limit sell | Sell at an attractive price | Above current price | Stop-loss | Limit loss on a long position | Below current price | Stop-buy | Limit loss on a short position | Above current price | * Limits and Stops are called contingent trade orders because the trade is contingent on the price. * Margin percentage = equity/stock * Equity=Assets-Liabilities * For long positions the stock is an asset rf= 30 year treasury (thay E(rm)-rf = MRP) * When the constant growth DDM holds, the stock price will grow at the same rate as dividends * Capital Gains Yield equals ‘g’ * The Expected HPR then is: * Growth Rate: g= ROE * b * b= plowback ratio= (1- payout ratio) * payout ratio = div/EPS * ROE = Net Income/Shareholder’s Equity * The capital asset pricing model (CAPM) defines the relationship between risk and return E(RA) = Rf + A(E(RM) – Rf) * Risk-free rate Analysts and Corporations typically use current market yields on long-term bonds * The expected risk premium of an asset depends on the market risk premium and the...
Words: 537 - Pages: 3
...1.10 x 0.35 x 2 2x 0.85 cu.m. F.A. 2x 2.31 sq.m. Cutting List To be purchased Converted into Kilograms ALONG SHORT SPAN 2x 12pcs-12mmdia x 1.10m 3pcs-12mmdia x 9.00 24.00 kgs ALONG LONG SPAN 2X 12pcs-12mmdia x 2.20m 3pcs-12mmdia x 9.00 24.00 kgs -------------------------------------------------------------------------------------------------------------------------------------------------------- F ALONG LONG SPAN 1X 116pcs-10mmdia x 0.30m 6pcs-10mmdia x 6.00 24.00 kgs C-1 2-units (Foundation up to top of Roof Beam Level) Volume 0.15 x 0.40 x 6.60 x 2 2x 0.40 cu.m. F.A. 2x 7.26 sq.m. C Concrete : cu.m. F.A. : sq.m. Structural Grade 33 : Intermediate Grade 40 : S-1 Volume 0.115x 3.45x 4.40 1x 1.75cu.m. F.A. 17.00 sq.m. Cutting List To be purchased Converted into Kilograms Remarks Along Short span Excess 1x 34pcs-12mmdiax 3.45m 17pcs-12mmdiax 7.50m 113.27 kgs 1x 8pcs-12mmdiax 2.10m 2pcs-12mmdiax 9.00m 16.00 kgs Extra Bars Along Short span 1x 88pcs-12mmdiax 1.00m 15pcs-12mmdiax 6.00m 80.00 kgs Along Long span 1x 27pcs-12mmdiax 4.40m 13 1/2pcs-12mmdiax 9.00m 111.93 kgs 4.60m 1x 6pcs-12mmdiax 2.50m 2pcs-12mmdiax 7.50m 13.33 kgs Extra Bars Along Long span 1x 64pcs-12mmdiax 1.20m 13pcs-12mmdiax 6.00m 69.29 kgs -------------------------------------------------------------------------------------------------------------------------------------------------------- ...
Words: 645 - Pages: 3
...BUS 415: Investment and Portfolio Management SPRING 2011, AUBG Quiz 1(a) 1. If you place a stop-loss order to sell 100 shares of stock at $55 when the current price is $62, how much will you receive for each share if the price drops to $50? A. $50 B. $55 C. $54.87 D. Cannot tell from the information given Answer B. The broker will sell at current market price, after the first transaction at $55 or less. 2. You wish to sell short 100 shares of XYZ Corporation stock. If the last two transactions were at $34.12 followed by $34.25, you can sell short on the next transaction only at a price of: A. $34.12 or higher B. $34.25 or higher C. $34.25 or lower D. $34.12 or lower Answer B. 3. If you buy 100 shares at $20 per share with 50% margin, the cash you must put in your brokerage account is _______________. A. $2,000 B. $1,500 C. $1,000 D. $500 Answer: C 50% = (100*20 – L) / (100*20) Liability =1000 Initial Cash outlay = 1000 4. If you originally bought 100 shares at $20 per share with 50% margin, and the price of the security falls to $15 per share, your margin now is ____________________. A. 100% B. 67% C. 50% D. 33% E. 0% Answer: D 50% = (100*20 – L) / (100*20) => Liability = 1000 Margin = (100*15 - 1000) / (100*15) Margin = 33% 5. Suppose you short sold 100 shares of DIS at $40 per share, and that the broker required 50% margin. On the next day...
Words: 499 - Pages: 2
