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% (8 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...
-
A fraction nonconforming control chart is to be established with a center line of 0.01 and two-sigma control limits. (a) How large should the sample size be if the lower control limit is to be...
-
What are the functions in executing and recording these two classes of transactions and custody of related assets?
-
Wheeled Coach, the worlds largest manufacturer of ambulances, builds thousands of different and constantly changing configurations of its products. The custom nature of its business means lots of...
-
A flexible pavement is constructed with 102 mm (4 inches) of hot mix asphalt (HMA) wearing surface, 203 mm (8 inches) of emulsion/aggregate- bituminous base, and 203 mm (8 inches) of crushed stone...
-
Question 8 (15 points): It is the end of 2019 and you have just been hired as CFO of BREW Inc, the world's leading maker of home brewing supplies, which plans to have its IPO next year. As one of...
-
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.
-
Has social medias role in pay transparency been a good thing or a negative thing? Discuss.
-
Consider the virtual circuit switches in Figure 3.45. Table 3.17 lists, for each switch, what port, {VCI} (or {VCI, interface}) pairs are connected to what other. Connections are bidirectional. List...
-
Prepare a report or exhibit showing how statistics are used in educational testing.
-
XDR is used to encode/decode the header for the SunRPC protocol illustrated by Figure 5.18. The XDR version is determined by the RPCVersion field. What potential difficulty does this present? Would...
-
Suppose a router has three input flows and one output. It receives the packets listed in Table 6.1 all at about the same time, in the order listed, during a period in which the output port is busy...
-
MPLS has sometimes been claimed to improve router performance. Explain why this might be true, and suggest reasons why in practice this may not be the case.
-
A thin metal plate is insulated on the back and exposed to solar radiation on the front surface. The exposed surface of the plate has an absorptivity of 0.7 for solar radiation. If solar radiation is...
-
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.
-
A luge and its rider, with a total mass of 85.0 kg, emerge from a downhill track onto a horizontal straight track with an initial speed of 34.0 m/s. If a force slows them to a stop at a constant rate...
-
Use conservation of energy to determine the angular speed of the spool shown in the figure below after the 3.00-kg bucket has fallen 3.70 m, starting from rest. The light string attached to the...
-
3) Two masses are connected with a thin string over a massless, frictionless pulley. If the 12.0 kg box descends 14.0 m in 8.00 seconds after being released from rest, draw two free body diagrams and...
Study smarter with the SolutionInn App