Which of the following commands removes all data from a table but leaves the tables structure intact?
Question:
Which of the following commands removes all data from a table but leaves the table’s structure intact?
a. ALTER TABLE secustomerorders DROP UNUSED COLUMNS;
b. TRUNCATE TABLE secustomerorders;
c. DELETE TABLE secustomerorders;
d. DROP TABLE secustomerorders;
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 100% (7 reviews)
b TRUNC...View the full answer
Answered By
Simon kingori
I am a tier-one market researcher and content developer who has been in this field for the last six years. I’ve run the freelancing gamut; from market research, data mining and SEO/SMM to copywriting, Content Development, you name it, I’ve done it. I’m extremely motivated, organized and disciplined – you have to be to work from home. My experience in Freelancing is invaluable- but what makes me a cut above the rest is my passion to deliver quality results to all my clients- it’s important to note, I've never had a dissatisfied client. Backed by a Masters degree in Computer Science from MOI university, I have the required skill set and burning passion and desire to deliver the best results for my clients. This is the reason why I am a cut above the rest. Having taken a Bsc. in computer science and statistics, I deal with all round fields in the IT category. It is a field i enjoy working in as it is dynamic and new things present themselves every day for research and exploration.
5.00+
1+ Reviews
10+ Question Solved
Related Book For
Question Posted:
Students also viewed these Computer science questions
-
Which of the following commands removes all orders placed before April 1, 2009? a. DELETE FROM orders WHERE orderdate
-
Which of the following commands changes a tables name from OLDNAME to NEWNAME? a. RENAME oldname TO newname; b. RENAME table FROM oldname TO newname; c. ALTER TABLE oldname MODIFY TO newname; d....
-
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...
-
Modify BST to add a method rangeCount() that takes two keys as arguments and returns the number of keys in a BST between the two specified keys. Your method should take time proportional to the...
-
Selected accounts for Lee's Salon at December 31, 2017 are presented below. Instructions (a) Prepare closing entries to close the accounts. (b) Post the entries A. Lee, Capital Dr. A. Lee, Drawings...
-
On June 10, Pais Company purchased $9,000 of merchandise from McCiver Company, terms 3/10, n/30. Pais pays the freight costs of $400 on June 11. Goods totaling $600 are returned to McGlver for credit...
-
Meagan and Jenny are in partnership, sharing profits equally. Provision exists in the partnership agreement for charging interest on capital at the rate of 8% p.a. and interest on drawings at 10%...
-
Saddleback Company makes camping lanterns using a single production process. All direct materials are added at the beginning of the manufacturing process. Information for the month of March follows:...
-
Duncan's Diamond Bit Drilling Corporation (Duncan) purchased the following assets in 2023. Assume its taxable income was $60,000 for purposes of computing the 179 expense deduction. Asset Purchase...
-
When did the rapid development of the management science discipline begin?
-
Which of the following statements is correct? a. A table can contain a maximum of only one column marked as unused. b. You can delete a table by removing all columns in the table. c. Using the SET...
-
The default width of a VARCHAR2 field is: a. 1 b. 30 c. 255 d. Nonetheres no default width for a VARCHAR2 field.
-
From your perspective, discuss how pay-for-performance programs, or scan-downs, would, if widely implemented, virtually eliminate forward buying and diverting.
-
Explain what we mean by information asymmetry (between firm managers and investors), and provide a brief example (real or hypothetical).
-
Why is it a prudent policy to separate credit appraisal and sanctioning from the work out function?
-
In the following table, you will find annual return data for six high-tech companies between the years 1997 and 2007. Use the information below to compute the variance - covariance matrix of the...
-
What is expected price of the bond in 4 yrs? Assume the interest rate will remain the same. par = 1000 Yrs to maturity = 25 Coupon = 8% paid semi-annually B= 1.5 Rf = 4% Market Risk Premium = 8%
-
Given the zero coupon yields above, what is the arbitrage free, price of a $10 annual coupon (paid annually), 5 year maturity, $100 face value bond?
-
List some linking devices that may be used to develop coherence in a paragraph. Give an example of each.
-
Before the 1973 oil embargo and subsequent increases in the price of crude oil, gasoline usage in the United States had grown at a seasonally adjusted rate of 0.57 percent per month, with a standard...
-
Show that log b f (n) is (log f (n)) if b > 1 is a constant.
-
In Section 5.2 we prove by induction that the number of lines printed by a call to drawInterval(c) is 2 c 1. Another interesting question is how many dashes are printed during that process. Prove by...
-
Give a recursive algorithmto compute the product of two positive integers, m and n, using only addition and subtraction.
-
Hinrich Company traded machinery with a book value of $120,000 and a fair value of $200,000. It received in exchange from Noach Company a machine with a fair value of $180,000 and cash of $20,000....
-
You have just moved from Norfolk, Virginia (sea level), to Taos, New Mexico (high in the mountains), and you find yourself out of breath climbing a small hill. Three months later, climbing the same...
-
Starline is a small children's clothing manufacturer and retailer that has seen rapid growth in the last twelve months and a significant increase in employees. At a meeting of managers, a number of...
Study smarter with the SolutionInn App