1 Given the table STUDENT(StudentID, Name, Advisor), which of the following SQL statements would be used to add new student data to the STUDENT table?…

Need help with SQLQUESTION 1Given the table STUDENT(StudentID, Name, Advisor), which of the following SQL statements would be used to add new student data to the STUDENT table?INSERT DATA STUDENT SET StudentID=123, Name=’Jones’, Advisor=’Smith’;INSERT INTO STUDENT VALUES (123, ‘Jones’, ‘Smith’);INSERT INTO STUDENT (New Student Data) VALUES (123, ‘Jones’, ‘Smith’);INPUT DATA STUDENT SET StudentID=123, Name=’ Jones’, Advisor=’Smith’;INPUT INTO STUDENT (123, ‘Jones’, ‘Smith’);QUESTION 2The order of the columns returned by an SQL SELECT statement is determined by the:ORDER BY clause.SORT BY clause.order they are listed in following SELECT.order they are listed in following WHERE.order they are listed in following FROM.rQUESTION 3Which SQL keyword is used to eliminate duplicate rows in the results of an SQL SELECT query?UNIQUESORTORDER BYDISTINCTREDUCE1 points  Save AnswerWhich SQL keyword is used to specify a condition that rows must meet to be included in the results of an SQL SELECT query?SELECTFROMWHEREORDER BYGROUP BYQuestion 5Which of the following is the correct SQL clause to restrict the results of a SELECT query to only records that have a value in the range of 10 to 50 in the Hours column?WHERE Hours = MIN(10) and MAX(50)WHERE Hours IN [10, 50]WHERE Hours = 10 and Hours = 50WHERE Hours BETWEEN 10 AND 50WHERE Hours RANGE 10 TO 50QUESTION 6Which symbol is used in standard SQL as a wildcard to represent a single, unspecified character?% (percent sign)! (exclamation mark)_ (underscore)? (question mark); (semi-colon)QUESTION 7Which symbol is used in standard SQL as a wildcard to represent a series of one or more unspecified characters?% (percent sign)! (exclamation mark)_ (underscore)? (question mark); (semi-colon)QUESTION 8Which SQL keyword can be used in conjunction with wildcards to select partial values?SELECTSEARCHFINDSUBSTRINGLIKErQUESTION 9Which of the following is the correct SQL clause to sort the results of a SELECT query in reverse-alphabetic order using the Department field?SORT BY DepartmentREVERSE DepartmentORDER BY Department DESCSORT BY Department DESCSORT BY Department REVERSEQUESTION 10Which of the following is not one of the five SQL built-in functions?MODESUMCOUNTMAXAVGQUESTION 11Given the table CUSTOMER(CustID, Name, PhoneNum, AcctBalance), what is the standard SQL query phrase to retrieve the Name and Phone Number of customers?SELECT CUSTOMER-Name AND CUSTOMER-PhoneNumSELECT (CUSTOMER-Name AND CUSTOMER-PhoneNumSELECT Name, PhoneNumSELECT (Name, PhoneNum)SELECT *QUESTION 12Given the table CUSTOMER(CustID, Name, PhoneNum, AcctBalance), what is the standard SQL query phrase to retrieve data for customers with an account balance greater than 50?WHERE CUSTOMER-AcctBalance > 50WHERE (CUSTOMER-AcctBalance > 50)WHERE AcctBalance > 50WHERE (AcctBalance > 50)HAVING AcctBalance > 50QUESTION 13Which SQL keyword is used to apply conditions to restrict groups that appear in the results of a SELECT query that uses GROUP BY?WHEREHAVINGLIKESORTDISTINCTrQUESTION 14Given the tables STUDENT(StudentID, StudentName, AdvisorID) and ADVISOR(AdvisorID, AdvisorName, Office, Phone), which of the following SQL statements would be used to implant a join between the two tables?WHERE STUDENT MATCH ADVISORWHERE STUDENT.AdvisorID MATCH ADVISOR.AdvisorIDWHERE STUDENT = ADVISORWHERE STUDENT JOIN ADVISORWHERE STUDENT.AdvisorID = ADVISOR.AdvisorIDQUESTION 15Which of the following SQL commands would be used to remove only the data from a table named STUDENT while leaving the table structure intact?DROP TABLE STUDENT;DELETE TABLE STUDENT;REMOVE TABLE STUDENT;SELECT * FROM STUDENT THEN DROP;DELETE FROM STUDENT;rQUESTION 16The SQL keyword(s) ________ mean(s) that a value must be supplied before a new row can be created.QUESTION 17The SQL command used to add new data to a table is ________.QUESTION 18The values of existing data can be modified using the SQL ________ command, which can be used to change several column values at once.QUESTION 19The values of existing data can be removed from a table using the SQL ________ command, which can even be used to remove all the data in the table at one time.QUESTION 20A complete table, including both the table structure and any data in the table, can be removed from the database by using the SQL ________ command.QUESTION 21Given the table CUSTOMER(CustID, Name, PhoneNumber, AccountBalance), write the standard SQL query to retrieve the Name and Phone Number of customers with a balance greater than 50.QUESTION 22Given the table CUSTOMER(CustID, Name, PhoneNumber, AccountBalance), write the standard SQL query to retrieve the Name and Phone Number of customers whose name begins with ‘S’.

Give us your instructions.
Select the type of service you need: writing, calculations, or programming. We’ve created an intuitive order form that tells you what information to enter and where, so make sure to fill out each required field. Also, make your requirements as specific as possible. Don’t rush! Take your time and explain everything in detail how it works.

Proceed to checkout and enter your credit card details or PayPal login, how to pay. Follow the payment provider’s instructions to confirm the transaction.
Now your order is in our system! We’ll start processing it right away.

Place Your Order

Contact Us

Frequently asked questions
Is your service confidential?

When you place an order with our company, we ask you to provide us with such personal information as your name, phone number, and email address. We need this data to keep you updated on the important things related to your order or account.

Is there a possibility of plagiarism in my completed order?

We complete each paper from scratch and in order to make you feel safe regarding its authenticity, we check it for plagiarism before its delivery. To do that, we use our in-house software, which can find not only copy-pasted fragments but even paraphrased pieces of text. Unlike popular plagiarism detection systems that are used by most universities (e.g. Turnitin.com), we do not report to any public databases—therefore, such checking is safe.

We provide a plagiarism-free guarantee that ensures your paper is always checked for its uniqueness.

Is there a money-back guarantee? If yes, how can I receive a refund?

You can certainly get your money back in several cases. You can receive a full refund if you have paid for your order twice or if you have placed two identical orders. In case your paper was late or the quality of the paper does not correspond to your expectations, you will get compensation for these issues.

Do you keep a database of pre-written essays?

No, we do not have such a database. All papers you order from us are written from scratch. This means your paper is unique and has never been published before—neither will it be published after we deliver it to you.

 

When will my custom paper be done?

While placing an order with WritersHub, you can choose a period of time within which a paper should be delivered to you. The countdown until the specified deadline starts automatically from the moment we receive your payment in our system. For example, if you pay for your order at 6pm on Monday and choose a 3-day delivery option, you will receive your custom paper by 6pm on Thursday.

Remember that a writer needs a sufficient amount of time in order to conduct thorough research. Therefore, please choose the most suitable deadline when you place an order. Moreover, the later you need your paper to be delivered to you, the cheaper it will be. Thus, you will be able to save your money while your writer will have enough time to work on your order and ensure its quality.

Make sure you upload all the additional materials at the very beginning. If you fail to do that, the deadline for your order will be postponed as well.

I haven’t received my custom paper by the deadline. What should I do?

Let us know immediately about that. You can do it by writing a message on Facebook or email us. Our support manager will carefully examine your order and will assist you with it right away. The reasons for late delivery may vary from time to time. It can happen that you have entered a wrong email address or your spam filter does not allow you to receive emails from us. It is also possible that the writer is waiting for your reply and can not continue working without your assistance, or we are checking the work for plagiarism. Whatever the case may be, contact us if you have any problems with getting your order on time.