Question

Using a DROP TABLE command results in Group of answer choices the table structure and its...

Using a DROP TABLE command results in

Group of answer choices the table structure and its contents are deleted.

the table structure is deleted but the contents remain.

the table contents are deleted but the structure remains.

only specified portions of the table are deleted.

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Ans:- a.the table structure and its contents are deleted

This is a command in SQL which removes rhe content as well as the table from the data base.Once a table is drop it is not possible to get it back.

Add a comment
Know the answer?
Add Answer to:
Using a DROP TABLE command results in Group of answer choices the table structure and its...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • A promotor is used by RNA polymerase during which stage of transcription? Group of answer choices...

    A promotor is used by RNA polymerase during which stage of transcription? Group of answer choices A. Initiation B. Elongation C. Termination D. Promotion 2. In eukaryotic cells, mRNA is modified in several ways. Match the mRNA modifications to their functions. Group of answer choices [ Choose ]            Portions of the mRNA that are removed before translation.            Helps ribosomes attach to the mRNA.            Depending on the length, this structure can help...

  • Choose the best Lewis structure for OCl2. Group of answer choices

    Choose the best Lewis structure for OCl2. Group of answer choices

  • DROP TABLE EMPLOYEE; DROP TABLE JOB; DROP TABLE EMP; DROP TABLE EMP_1; DROP TABLE EMP_2; CREATE...

    DROP TABLE EMPLOYEE; DROP TABLE JOB; DROP TABLE EMP; DROP TABLE EMP_1; DROP TABLE EMP_2; CREATE TABLE JOB(JOB_CODE CHAR (3) PRIMARY KEY, JOB_DESCRIPTION VARCHAR (20) NOT NULL,JOB_CHG_HOUR NUMBER (5,2) NOT NULL,JOB_LAST_UPDATE DATE NOT NULL); INSERT INTO JOB VALUES('500','Programmer','35.75','20-Nov-2017'); INSERT INTO JOB VALUES('501','System Analyst','96.75','20-Nov-2017'); INSERT INTO JOB VALUES('502','Database Designer','125.00','24-Mar-2018'); CREATE TABLE EMPLOYEE(EMP_NUM CHAR (3) PRIMARY KEY,EMP_LNAME VARCHAR (15) NOT NULL,EMP_FNAME VARCHAR (15) NOT NULL, EMP_INITIAL CHAR (1),EMP_HIREDATE DATE NOT NULL,JOB_CODE CHAR (3), EMP_YEARS NUMBER (2),FOREIGN KEY (JOB_CODE) REFERENCES JOB (JOB_CODE)); INSERT...

  • 16. The primary key is selected from the: Group of answer choices composite keys. foreign keys....

    16. The primary key is selected from the: Group of answer choices composite keys. foreign keys. candidate keys. surrogate keys. 17. "Delete Table" statement is used to remove a table definition and all the data, indexes, triggers, constraints and permission specifications for that table. Group of answer choices True False 18. Which of the following commands always affect one row at a time when it runs? Group of answer choices Drop Insert Delete Update 19. Data stored as an image...

  • 1. If the government imposes a price ceiling, then: Group of answer choices producers would be...

    1. If the government imposes a price ceiling, then: Group of answer choices producers would be inclined to increase the quantity supplied. producers must charge the ceiling price. the price offered by producers must be at or below the ceiling price. the market supply curve will shift to the right. the price offered by producers must be at or above the ceiling price. 2. If foreign exchange rates are determined by the interaction of supply and demand forces for the...

  • Which of the following statements is positive? Group of answer choices When the Federal Reserve increases...

    Which of the following statements is positive? Group of answer choices When the Federal Reserve increases the money supply, interest rates decrease. Large budget deficits should be avoided. A tax cut that benefits low-income households is acceptable. Higher taxes are needed to support education. The standard of living in an economy is best measured by: Group of answer choices output per person. average labor productivity. total output. the inflation rate. If average labor productivity increases while population and the number...

  • Which of the following is the best Lewis structure for BF3? Group of answer choices D...

    Which of the following is the best Lewis structure for BF3? Group of answer choices D C B A (a)

  • The binominal assumes that the trials are independent. Group of answer choices True False In an...

    The binominal assumes that the trials are independent. Group of answer choices True False In an attempt to minimize no-shows on high-demand days a golf course has implemented an online check-in procedure. Preliminary results indicate that once a golfer has checked in, there is only at 20% chance that he or she will be a no-show. This chance of being a no-show can be modeled using the binomial distribution. If 15 golfers have checked in using this process, what is...

  • Zappos use of Holacracy showed its keen attention to Group of answer choices Business ethics Organizational...

    Zappos use of Holacracy showed its keen attention to Group of answer choices Business ethics Organizational structure International business Corporate strategy

  • Which organization helps define the overall structure of the Internet? Group of answer choices none (no...

    Which organization helps define the overall structure of the Internet? Group of answer choices none (no one "owns" the Internet) W3C ICANN The Department of Commerce (U.S.) IAB

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT