Question: Thank you for your help, if you cannot solve all these questions do not bother. Which SQL component allows records in one or more tables




Thank you for your help, if you cannot solve all these questions do not bother.
Which SQL component allows records in one or more tables to be updated? The DDL None of these The DCL The DML Question 6 1 pts In the SQL DDL, specifying that a column may or may not hold a NULL value or that it must be unique is an example of specifying a table name 0 none of these 0 constraint data type Question 7 2 pts A table named C112Students will have a primary key named studentID that will be stored as an integer. There will also be a studentName column stored as text and a studentGrade column stored as a single letter (no pluses or minuses in this fictional version of C112.). Write down a CREATE TABLE statement matching these requirements. Question 8 2 pts For our C112Students table in the previous question, we want to add a row for student "Hisham Sliman" with ID number 31415 and a grade of A (I always get an A because I get to teach the course). Write down an INSERT INTO statement that will put this data into the table. Write an SQL query for the Member table from the slides that will find the first and last name of every female golfer. All columns involved in this query are TEXT or CHAR types, so don't forget quotation marks for any values you use. Edit View Insert Format Tools Table 12pt Paragraph Tv : Question 9 1 pts For the previous question's query, if we wanted to sort the results alphabetically, we would add the clauseStep by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
