Which of the following SQL statements is invalid and returns an error message? ( refer to the tables in the JustLee Books database). a. ALTER TABLE books ADD CONSTRAINT books_pubid_uk UNIQUE (pubid);  b. ALTER TABLE books ADD CONSTRAINT books_pubid_pk PRIMARY KEY (pubid);                                                                                                                c. ALTER TABLE books ADD CONSTRAINT books_pubid_nn NOT NULL (pubid); d. ALTER TABLE books ADD CONSTRAINT books_pubid_fk FOREIGN KEY (pubid) REFERENCES publisher (pubid); e. All of the above statements are invalid

Im trying to run the following SQL in Oracle: SELECT GUEST_KR.FIRSTNAME, GUEST_KR.LASTNAME,FEE_KR.DateCharged,FEE_KR.FeeDescription,FEE_KR.FeeCharged,SUM(FeeCharged) AS TotalFeeChargedFROM FEE_KRJOIN SERVICE_KR ON FEE_KR.ServiceID = SERVICE_KR.ServiceIDJOIN GUEST_KR ON SERVICE_KR.ServiceID = GUEST_KR.GuestIDWHERE ServiceName IN ('First Name', 'Last Name', 'Date Charged', 'Fee Description')WHERE ServiceName NOT IN (SELECT FEETYPE FROM REPORT_FILTER_KR)GROUP BY GUEST_KR.FIRSTNAME, GUEST_KR.LASTNAME,FEE_KR.DateCharged,FEE_KR.FeeDescription,FEE_KR.FeeChargedORDER BY SUM(FeeCharged) DESC; And I'm recieving this error:   Error starting at line : 1 in command -SELECT GUEST_KR.FIRSTNAME, GUEST_KR.LASTNAME,FEE_KR.DateCharged,FEE_KR.FeeDescription,FEE_KR.FeeCharged,SUM(FeeCharged) AS TotalFeeChargedFROM FEE_KRJOIN SERVICE_KR ON FEE_KR.ServiceID = SERVICE_KR.ServiceIDJOIN GUEST_KR ON SERVICE_KR.ServiceID = GUEST_KR.GuestIDWHERE ServiceName IN ('First Name', 'Last Name', 'Date Charged', 'Fee…

<?php session_start(); include "db_conn.php"; if (isset($_POST['uname']) && isset($_POST['password'])) {     function validate($data){        $data = trim($data);        $data = stripslashes($data);        $data = htmlspecialchars($data);        return $data;     }     $uname = validate($_POST['user_name']);     $pass = validate($_POST['password']);     if (empty($uname)) {         header("Location: index.php?error=User Name is required");         exit();     }else if(empty($pass)){         header("Location: index.php?error=Password is required");         exit();     }else{         $sql = "SELECT * FROM users WHERE user_name='$uname' AND password='$pass'";         $result = mysqli_query($conn, $sql);         if (mysqli_num_rows($result) === 1) {             $row = mysqli_fetch_assoc($result);             if ($row['user_name'] === $uname && $row['password'] === $pass) {                 echo "Logged in!";                 $_SESSION['user_name'] = $row['user_name'];…

awk is similar to the SQL language in that you can query certain records. What command below will search the the file /etc/passwd file by locating all users that have a default shell '/bin/bash' and print the first column (which is the user name). awk -D: '$7 == "/bin/bash" {print $3}' /etc/passwd Give this to your new intern to figure out. awk -F: '$4 == "/bin/bash" {print $10}' /etc/passwd awk -F: '$7 == "/bin/bash" {print $1}' /etc/passwd awk -F: '$1 == "/bin/bash" {print $7}' /etc/passwd.

Add a connection string in the appsettings.json file.Open the Startup.cs file to add the SQL server db provider for EF Core. Add the code services.AddDbContext<ProductContext>(o => o.UseSqlServer(Configuration.GetConnectionString("ProductDB"))); under ConfigureServices method. Note that in the GetConnectionString method the name of the key of the connection string is passed that was added in appsettings file.

Which of the following statements retrieves data from the Friends database and stores it in the FriendsDataSet?a. Me.FriendsDataSet.Fill(Friends.accdb)b. Me.TblNamesBindingSource.Fill(Me.FriendsDataSet)c. Me.TblNamesBindingNavigator.Fill(Me.FriendsDataSet.tblNames)d. Me.TblNamesTableAdapter.Fill(Me.FriendsDataSet.tblNames)

In Python, create a Server Class that enables interaction with a SQLDatabase. The users of your SQLDatabase server can send SQLQueries to the SQLDatabase. The SQLDatabase handles the SQLQuery and retrieves the Query's data in a DataFrame format. Your class should incorporate the default __dunders__ (underscores) and may also include additional custom __dunders__.

Using the Vince's Vinyl Database that you created and populated, write the following SQL statements. Save all of your SQL statements as one .sql file. Copy your SQL statements into a Word document. As you execute each statement, take a screenshot of the results and also include them in the Word document. For additional details, please refer to the Scenario Rubric. 1. Display all the rows and columns from the Person table.2. Display AlbumKey, AlbumTitle and AlbumDate from the Album table that have AlbumStudio equal to Atlantic.3. Display details of people from the Person table whose phone numbers are not known.4. Display each distinct PersonKey from the Purchase table.5. Display SaleDetailKey and SaleDetailPrice from the SaleDetail table. Change the column headings to Transaction Number and Sales Amount, respectively.6. Display the total value of Vince’s inventory.7. Display the total value of Vince's inventory grouped by Condition.8. Display the total value of Vince's inventory grouped…

Question 4  You do not have a table named ‘employee’.What happens when you run this piece of code? What happens if you place the stmt.execute(sql) outside try block and run it again? try { string sql = “drop table employee”; stmt.xecute(sql); } catch (Exception e) { }  Full explain this question and text typing work only