Which of the following commands creates a new table containing two columns? a. CREATE TABLE newname (coll
Question:
Which of the following commands creates a new table containing two columns?
a. CREATE TABLE newname (coll DATE, col2 VARCHAR2);
b. CREATE TABLE newname AS (SELECT title, retail, cost FROM books);
c. CREATE TABLEnewname (coll, col2);
d. CREATE TABLE newname (coll DATE DEFAULT SYSDATE, col2 VARCHAR2(1));
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 42% (7 reviews)
d CREATE TABL...View the full answer
Answered By
Umber Talat
I am providing full time mentoring and tutoring services in Business Finance, Contemporary issue in Global Economy, Quantitative Techniques, Principles of Marketing, strategic marketing, International Marketing, Organizational Behavior (OB), Consumer Behavior, Sales Force Management, Strategic Brand Management, Services Marketing, Integrated Marketing Communication (IMC), Principles of Management, General Management, Strategic Management, Small and Medium Enterprise Management, Innovation Management, Change Management, Knowledge Management, Strategic Planning, Operations Management, Supply Chain Management, Logistics Management, Inventory management, Total Quality Management (TQM), Productions Management, Project Management, Production Planning, Human Resource Management (HRM), Human Resource Development, Strategic HRM, Organizational Planning, Performance and Compensation Management, Recruitment and Selection, Organizational Development, Global Issues in Human Resource Management, Retail Marketing, Entrepreneurship, Entrepreneurial Marketing, International Business, Research Methods in Business, Business Communication, Business Ethics.
4.70+
158+ Reviews
236+ Question Solved
Related Book For
Question Posted:
Students also viewed these Computer science questions
-
Which of the following commands creates a private synonym? a. CREATE PRIVATE SYNONYM b. CREATE NONPUBLIC SYNONYM c. CREATE SYNONYM d. CREATE PUBLIC SYNONYM
-
Which of the following commands creates a new table containing a virtual column? a. CREATE TABLE newtable AS (SELECT order#, title, quantity, retail FROM orders); b. CREATE TABLE newtable (price...
-
Which of the following commands can be used to enable a disabled constraint? a. ALTER TABLEMODIFY b. ALTER TABLEADD c. ALTER TABLEDISABLE d. ALTER TABLEENABLE
-
Given an \(n\)-by- \(n\) subarray of black (1) and white (0) pixels, design a linear-time algorithm that finds the largest square subarray that contains no white pixels. In the following example, the...
-
What is liquidity? Identify one measure of liquidity.
-
Solar Electronics has enjoyed tremendous sales growth during the last 10 years. However, even though sales have steadily increased, the company's CEO. Dana Byrnes, is concerned about certain aspects...
-
Elliott started business on 1 July 2025. The accounting system includes a sales journal, a purchases journal, a cash receipts journal, a cash payments journal and a general journal. The chart of...
-
The manager of catering services for the Roanoker Hotel has a problem. The banquet hall at the hotel is booked each evening during the coming week for groups who have reserved the following numbers...
-
3. You purchased a 3 year coupon bond one year ago. Its par value is $1,000 and coupon rate is 6%, paid annually. At the time you purchased the bond, its yield to maturity was 6.5%. Suppose you sell...
-
Marquis Westbury invested $19,100 in the Ternton and Rainwater partnership for ownership equity of $119,000. Prior to the investment, equipment was revalued to a market value of $77,400 from a book...
-
Which of the following commands is valid? a. RENAME customer# TO customernumber FROM customers; b. ALTER TABLE customers RENAME customer# TO customernum; c. DELETE TABLE customers; d. ALTER TABLE...
-
Which of the following is a valid table name? a. 9NEWTABLE b. DATE9 c. NEWTABLE d. None of the above are valid table names.
-
Ciaras Cookie Company provided the following accounts from its year- end trial balance. Ciara's Cookie Company Unadjusted Trial Balance (Selected Accounts) For the CurrentYear Ended Debit Credit S...
-
An analyst has calculated the CVA for a 4-year 6% $100 annual coupon paying bond to be 4.256. If the risk-free rate was 2%, what would be the fair value of the risky bond? Give your answer correct to...
-
Assume that your company successfully sold 7 million shares at a price of $2 in a SEO, including 2 million shares from existing shareholders. If the underwriter's fee is 10%, the amount of money...
-
What would your NPV be if your cash flow was $381,250 and the discount is 12%?
-
Why do most cross currency rates use the US dollar as the base currency? Explain.
-
Why is AUD depreciating against the British pound (AUD/GBP)? Could it be because of economic factors such as inflation rates, interests rates or growth rates?
-
Give an example in which each member of an audience may be trying to obtain a different goal from the same presentation.
-
H.J. Heinzs annual dividends were as follows: 1990 ..............$0.540 1991.............. 0.620 1992 .............. 0.700 1993.............. 0.780 1994 .............. 0.860 1995 .............. 0.940...
-
Consider the sequence of keys (5,16,22,45,2,10,18,30,50,12,1). Draw the result of inserting entries with these keys (in the given order) into a. An initially empty (2,4) tree. b. An initially empty...
-
Give a proof of Proposition 11.10 Proposition 11.10 The algorithm for deleting an entry from a red-black tree with n entries takes O(log n) time and performs O(log n) recolorings and at most two...
-
Is the search tree of Figure 11.22(a) a (2,4) tree? Why or why not? Figure 11.22(a) 22 5 10 25 3 4 23 24 6 8 14 27 11 13 17 (a)
-
Sophia operates a large singing school with 22 employees. She receives advance fee payments from students in respect of each course (a course consists of 26 lessons). If a student does not attend all...
-
What role does agency play in the Hypodermic Model of Communication? Long after the model has been abandoned by experts in persuasion and mass media, why does this model live on as common sense?
-
Daniel is a resident individual who carries on a retail business but does not use the SBE method of accounting for income in his business. On 30 June of the current tax year he had trade debtors of...
Study smarter with the SolutionInn App