How do you release all storage space with TRUNCATE statement?

What will be an ideal response?


TRUNCATE TABLE tablename REUSE STORAGE;

Computer Science & Information Technology

You might also like to view...

What is a class?

A. an instance of an object. B. A job description for an object. C. A list of tasks which automatically creates the object. D. B and C.

Computer Science & Information Technology

If you are developing a Web site for a client, this is the time to conduct a user analysis. Describe the general characteristics of your users including learning style, knowledge of technology, age, and general education level. If this Web site supports an office function, describe workers’ knowledge about their jobs. Will the site have secondary users as well as primary users? Also specify their level of familiarity with your Web site. Cite the sources of your information.

What will be an ideal response?

Computer Science & Information Technology

Which of the following statements is false?

a. Seaborn refers to the following type of graph as a bar plot:

b. For 600 rolls, we expect about 100 occurrences of each die face. As we run the simulation for 60,000 die rolls, the bars will become much closer in size. At 6,000,000 die rolls, they’ll appear to be exactly the same size. This is the “principal of least privilege” at work.
c. The second screen capture below shows the results for 6,000,000 rolls—surely something you’d never do by hand! In this case, we expect about 1,000,000 of each face, and the frequency bars appear to be identical in length (they’re close but not exactly the same length).
d. With large numbers of die rolls, the frequency percentages are much closer to the expected 16.667%.

Computer Science & Information Technology

Suppose your computer screen resolution is set to 1600x1200, and you want to create an image that will occupy a quarter of a screen based on your monitor screen size.

(i) What are the pixel dimensions of the image? 800x600 pixels (ii) You post this image on your Web site. Your target audience's computer-screen resolution is only 800x600 pixels. When they look at your image, how big is the image relative to its screen? A. one-eighth of the screen B. one-quarter of the screen C. one-half of the screen D. three-quarters of the screen E. larger than the maximized browser window can fit in

Computer Science & Information Technology