Which of the following statements is correct? a. A table can contain a maximum of only one
Question:
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 UNUSED clause allows you to free up storage space used by a column.
d. None of the above statements are correct.
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 100% (8 reviews)
d None o...View the full answer
Answered By
Michael Owens
I am a competent Software Engineer with sufficient experience in web applications development using the following programming languages:-
HTML5, CSS3, PHP, JAVASCRIPT, TYPESCRIPT AND SQL.
5.00+
1+ Reviews
10+ Question Solved
Related Book For
Question Posted:
Students also viewed these Computer science questions
-
Which of the following statements is correct? a. A PRIMARY KEY constraint allows NULL values in the primary key column(s). b. You can enable a dropped constraint if you need it in the future. c....
-
Which of the following statements is correct? a. If a subquery is used in the outer querys FROM clause, the data in the temporary table cant be referenced by clauses used in the outer query. b. The...
-
Which of the following statements is correct? a. The COUNT function can be used to determine how many rows contain a NULL value. b. Only distinct values are included in group functions, unless the...
-
Factors that affect the selection of an inventory costing method do not include: (a) tax effects. (b) balance sheet effects. (c) income statement effects. (d) perpetual vs. periodic inventory system.
-
Choi Company has an inexperienced accountant. During the first two weeks on the job, the accountant made the following errors in journalizing transactions. All incorrect entries were posted. 1. A...
-
A fraction nonconforming control chart with n = 400 has the following parameters: UCL = 0.0809, Center line = 0.0500, LCL = 0.0191. (a) Find the width of the control limits in standard deviation...
-
Discuss the personnel and sound practices aspects of an internal control environment that relate to cash receipts transactions.
-
At the beginning of 2012, D & L Enterprises had the following balances in its accounts: Cash $8,400 Inventory 2,000 Common stock 8,000 Retained earnings 2,400 During 2012, D & L Enterprises...
-
The material cost for a concrete retaining wall is estimated to be $250,000 based on the national average costs provided in the unit cost section of RS Means. This amount includes the material cost...
-
Imagine that you are an investor on January 1, 2004, and using the historical data up to that date. Assume that the Global index cannot be included in your portfolio. a. Plot the efficient frontier...
-
Which of the following commands drops any columns marked as unused from the SECUSTOMERORDERS table? a. DROP COLUMN FROM secustomerorders WHERE column_status = UNUSED; b. ALTER TABLE secustomerorders...
-
Which of the following commands removes all data from a table but leaves the tables structure intact? a. ALTER TABLE secustomerorders DROP UNUSED COLUMNS; b. TRUNCATE TABLE secustomerorders; c....
-
A 100 m3 storage tank with fuel gases is at 20C, 100 kPa containing a mixture of acetylene C2H2, propane C3H8 and butane C4H10. A test shows the partial pressure of the C2H2 is 15 kPa and that of...
-
Suppose that when a TCP segment is sent more than once, we take SampleRTT to be the time between the most recent transmission and the ACK, as in Figure 5.10(b). Assume, for definiteness, that TimeOut...
-
What kind of problems can arise when two hosts on the same Ethernet share the same hardware address? Describe what happens and why that behavior is a problem.
-
The existing Internet depends in many respects on participants being good network citizenscooperating above and beyond adherence to standard protocols. (a) In the PIM-SM scheme, who determines when...
-
Having ARP table entries time out after 1015 minutes is an attempt at a reasonable compromise. Describe the problems that can occur if the timeout value is too small or too large.
-
Consider a router that is managing three flows, on which packets of constant size arrive at the following wall clock times: All three flows share the same outbound link, on which the router can...
-
A soldering iron has a cylindrical tip of 2.5 mm in diameter and 20 mm in length. With age and usage, the tip has oxidized and has an emissivity of 0.80. Assuming that the average convection heat...
-
Classify each of the following activities as proper or prohibited under the various consumer statutes you have studied. a. Calling a hospital room to talk to a debtor who is a patient there. b....
-
Describe an efficient algorithm for finding the ten largest elements in an array of size n. What is the running time of your algorithm?
-
Give an example of a positive function f (n) such that f (n) is neither O(n) nor (n).
-
Show that n i=1 i/2 i < 2.
-
A horizontal board of negligible thickness and area 4.0 m hangs from a spring scale that reads 60 N when a 2.0 m/s wind moves below the board. The air above the board is stationary. When the wind...
-
A force in the positive direction of an x axis acts on an object moving along that axis. If the magnitude of the force is F = 7.2e*/3.1 N, with x in meters, find the work done by as the object moves...
-
The only force acting on a 2.2 kg body as it moves along the positive x axis has an x component Fx = -5x N, where x is in meters. The velocity of the body at x = 2.5 m is 9.0 m/s. (a) What is the...
Study smarter with the SolutionInn App