1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
yaroslaw [1]
1 year ago
15

write sql commands for the following: a. create two different fom1s of the insert command to add a student with a studen t id of

65798 and last name lopez to the student table. b. now write a command that will remove this student from the student table. c. how would your command look like if your task was to remove any student with the last name lopez from the student table? d. create an sql conm1and tha t will modify the name of course ism 4212 from da tabase to introduction to relational databases.
Computers and Technology
1 answer:
RoseWind [281]1 year ago
6 0

a. INSERT INT0 Student(StudentID, StudentName)

   VALUES(65798, Lopez);

b. DELETE FROM Student

   WHERE StudentName = 'Lopez';

c. DELETE FROM Student

   WHERE StudentLastName = 'Lopez';

d. UPDATE Course

   SET CourseName = 'Introduction to Relational Databases

   WHERE CourseID = 'ISM 4212';

<h2>About SQL</h2>

SQL is a standardized programming language used to manage relational databases and execute various operations on their contents.

SQL is the most used database language. Thereforeore it may be utilized by virtually any organization that needs to store relational data. SQL queries are used to obtain data from the database. However, their performance varies.

Some of the largest organizations use SQL on a daily basis. They are used for performance analysis and data analysis. Even small businesses and startups utilize SQL for comparable goals. SQL is an excellent language for communicating with databases and retrieving crucial data.

Learn more about SQL here:

brainly.com/question/14469511

#spj4

You might be interested in
Under which menu option of a word processing program does a star appear?
Citrus2011 [14]

A callout is a type of text box that also includes a line for pointing to any location on the document. A callout appears under the SHAPES <span>menu of the word processing program. The answer that completes this statement is the word "shapes". Hope this answers your question. </span>
3 0
3 years ago
Read 2 more answers
A file named 'input.txt' contains a list of words. Write a program that reads the content of the file one word at a time. Check
Margarita [4]

Answer:

// here is code in java.

import java.io.*;

import java.util.Scanner;

class Main{  

    // function to check a word is palindrome or not

 private static boolean is_Palind(String str1)

 {

     // if length of String is 0 or 1

   if(str1.length() == 0 || str1.length() == 1)

   {

     return true;

   }

   else

   {

       // recursively check the word is palindrome or not

     if(str1.charAt(0) == str1.charAt(str1.length()-1))

     {

       return is_Palind(str1.substring(1,str1.length()-1));

     }

     

     else

     {

       return false;

     }

   }

 }

// driver function

 public static void main(String[] args)

 {// variable to store word

   String word;

   // BufferedWriter object

   BufferedWriter buff_w = null;

   // FileWriter object

   FileWriter file_w = null;

   // Scanner object

   Scanner sc = null;

   try

   {

       // read the input file name

     sc = new Scanner(new File("input.txt"));

     // output file

     file_w = new FileWriter("output.txt");

     // create a buffer in output file

     buff_w = new BufferedWriter(file_w);

     

     // read each word of input file

     while(sc.hasNext())

     {

       word = sc.next();

     // check word is palindrome or not

       if(is_Palind(word))

       {

           // if word is palindrome then write it in the output file

         buff_w.write(word);

         buff_w.write("\n");

       }

     }

     // close the buffer

     buff_w.close();

     // close the input file

     sc.close();

   }

   // if there is any file missing

   catch (FileNotFoundException e) {

     System.out.println("not able to read file:");

   }

   // catch other Exception

   catch (IOException e) {

     e.printStackTrace();

   }

 }

}

Explanation:

Create a scanner class object to read the word from "input.txt" file.Read a word  from input file and check if it is palindrome or not with the help of is_Palind() function.it will recursively check whether string is palindrome or not. If it is  palindrome then it will written in the output.txt file with the help of BufferedWriter  object. This will continue for all the word of input file.

Input.txt

hello world madam

level welcome

rotor redder

output.txt

madam

level

rotor

redder

3 0
3 years ago
What are the best gta online buisinesses?​
ELEN [110]

Answer:

Night club

Explanation:

Because night club isn't a day club

3 0
3 years ago
Read 2 more answers
Choose the word that best completes this sentence. Caught-in and caught-between injuries result from a person being squeezed, ca
loris [4]
I do not know, i really hope you dont fail!!!!!!!!!
8 0
3 years ago
Read 2 more answers
Jeremy forgot where he saved a certain file on her computer. Therefore, he searches for all files with a .jpg file extension. Wh
Irina-Kira [14]
The jpg (or jpeg) extension stands for <span>Joint Photographic Experts Group. A file with this extension is an image, usually a photo. Other types of images are better stored using a lossless format.</span>
4 0
3 years ago
Read 2 more answers
Other questions:
  • The Tell Me feature also includes access to the _____ feature.
    13·1 answer
  • The frame work for storing records in database is a
    7·1 answer
  • K
    15·2 answers
  • What does ADF means????
    13·2 answers
  • Given the lists list1 and list2 that are of the same length, create a new list consisting of the last element of list1 followed
    13·1 answer
  • Convert the following Base 2 (binary) numbers to base 10(decimal):<br> 11101<br> 1010101
    13·1 answer
  • Create a program that will read in a Salesperson name, employment status (1=Full-time AND 2=Part-time) and the sales amount.
    5·1 answer
  • The answer is D!!Readable code includes
    9·2 answers
  • It means fruit- trees garden.
    8·1 answer
  • What year does futurist ray kurzweil believe ai will meet human intelligence?.
    11·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!