Which of the following clauses of the UPDATE command is optional? (Points : 2) UPDATE
SET
WHERE
FROM

Answers

Answer 1

Answer:

FROM.

Explanation:

UPDATE table

SET column=value,column1=value1,.....

WHERE condition;

In the UPDATE command given in the question FROM is optional because when using UPDATE we already mention the table name with update look at the syntax above.So there is no need to again mention the table name in FROM.All other three are required that is UPDATE,SET,WHERE.


Related Questions

What is the Java source filename extension? What is the Java bytecode filename extension?

Answers

Answer:

The extension of java source filename is .java and the extension of bytecode filename is .class

Explanation:

The java program is saved with the classname along with .java extension. The .java extension indicated that the particular file in java file.

Suppose we have a program  

public class Main1

{

public static void main(String[] args) {

 System.out.println("Hello:");

}

}

This program is saved as :Main1.java

To compile this program in command prompt we use javac Main1.java.

On compiling the java program it will be converted into byte code which has extension .class filename extension. So on compile, this program will be converted into Main1.class

. Within data mining, what it it’s robustness?

Answers

Answer:

Data mining is the extraction/mining of the required/ actual data from the raw data .Rest of the data that is not required is eliminated in this process.It is used in the many field such as research, scientific, etc.

Robustness in the data mining field is for defining the strong nature of the data .This feature is responsible for stability of the data even at the occurrence of the error.The resistance shown by the data towards the problem makes the data robust .

In a typical configuration the total RAM capacity is less than total ROM capacity.

True

False

Answers

Answer:

False

Explanation:

The difference between RAM and RAM is as follows

(1) RAM (random access memory) is meant for temporary storage whereas ROM (read-only memory) is meant for permanent storage.

(2) RAM chip is volatile, means once the power is turned off, it loses the previously holding information, where as ROM is non-volatile it doesn't losses any information even though power is turned off.

(3) RAM chip is used in the normal operations of the computer, whereas the ROM chip is used mainly for the startup process of computer.

(4) Generally, A RAM can store several gigabytes (GB) of data that is up to 16 GB whereas a ROM chip can typically store that much data. It only stores several megabytes (MB) of data that is up to 4 MB.

hence, the given statement about RAM is false.

Does Kennesaw State University have any computing ethical policy for computer usage? If so - what is it?

Answers

Answer:

The answer to the questions: Does Kennesaw State University have any computing ethical policy for computer usage? If so - what is it? Would be as follows:

1. Yes, Kennesaw State University, a university in Georgia, does have a computing ethical policy that regulates the proper use of the facilities and computing services within the facilities of the university and the use of computing equipment that belongs to the university. This policy is known as the KSU Computer Usage Policy.

2. As said before this policy establishes that the use of computing services are not the right of a person, but rather a privilege afforded to the students, faculty and other people who are present in the university and who may need to use its computing services. The use of the computing services would be whitin this policy as long as it stays inside the delimitations established by federal, state and University policies.

Explanation:

In MIPS architecture, the Program Counter is:

A register that stores the next instruction to be executed

A register that stores the address of the next instruction to be executed

A binary counter that counts how many instructions have been executed

A control circuit that steps through a sequence of instructions

A register that stores the current location in memory to read and write from

Answers

Answer: A register that stores the address of the next instruction to be executed

Explanation: Program counter is register of the CPU(central processing unit) .It contains the memory address of the instruction that is to be executed in next turn after the present instruction is executed.This is also known as the instruction pointer .The cycle followed by the counter is fetch ,decode and execute.

Other options are incorrect because it does not store next instruction,does not count number of instruction or stores the memory for reading and writing.It also does not act as a control circuit.

While the concept of ____ has well served scientists who share scientific text files and application developers who exchange code, the greater use has been in downloading artistic files, such as music and video files.

VPNs

LANs

point-to-point file protocol

peer-to-peer (P2P) file sharing

Answers

Answer: peer-to-peer (P2P) file sharing

Explanation: Peer-to-peer file sharing is the technique in which networking technology is used for the sharing and distribution of the files digitally. The sharing of the files are in the form of movies, games music etc.

Peer are considered as the nodes which are the end-user so, the end-user to end-user file transfer is done through this technology.

Other options are incorrect because VPN(virtual private network) is the connection between network and client over less secure network,LAN (Local area network) is the network that can be established for single infrastructure to connect  and point to point protocol is protocol for the routers for communication.Thus the correct option is P2P file sharing.

What is an operating system? What are the main functions of a modern general purpose operating system?

Answers

Answer:

An operating system is a software that allows a user to run other applications on a computing device. The applications generally are not designed to interface directly with hardware, almost all of the applications are written to run on an operating system, in order to become independent of the hardware design.

The main function of an operating system are:

manage the hardware resources of a computer: central processing unit, memory, disk drives, and printers. establish a user interface to facilitate the interaction human-computer. execute and provide services for software applications.

A use case model describes what a system does without describing how the system does it. (Points : 1.5) True
False

Answers

Answer:

The correct answer is true.

Explanation:

By definition, a use case is a list of events that defines the interactions between an actor and a system to achieve a goal. Generally, Use cases are used by functional analysts at a higher level to represent requirements, missions or stakeholder goals.  

"What does the list look like after this code executes?

colors = "red,orange,yellow,green,blue"
s = colors.split(",")

["red", "orange", ""yellow", "green", "blue"]

["red orange yellow green blue"]

[red,orange,yellow,green,blue]

red

Answers

Answer:

The list created by the split method in Python 3 will be ["red", "orange", ""yellow", "green", "blue"]

Explanation:

In Python 3, the split method takes the input string, in this case is colors = "red,orange,yellow,green,blue", and split it into a list and you can indicate the separator that the method will use.

The general syntax for this method is:

string.split(separator,max)

separator indicates the character that will be used as a delimiter of each list member and the max parameter indicates the maximum number of separations to make.  

Since each color in your string is separated by the character "," the code will make a list in which every color is a separated string.

To edit a form, use

datasheet view.
design view.
layout view.
layout view or design view.

Answers

Answer: Design view

Explanation:

 We use design view for editing and modifying the forms. The design view is basically used to create the form and then also edit the form structure. It is also capable for reducing the scope in the particular structure.

In the design view, we can use the property sheet for modifying the properties in the form and also control its features in the particular section of the form structure.

It basically provide the wide variety of comprehensive form structure and it basically helped to organize the proper information in the form.  

Answer: layout view

Explanation; on edge

A sequential file stored on a(n) ____________ can be updated in place.

(Points : 2) direct access storage device
paper tape
punch card file
line printer

Answers

Answer: Direct access storage device

Explanation:

 The sequential file is the simple method for organization of different types of files. The files and records are basically stored in the direct access storage device in the sequentially manner so that we can directly access the particular file according to the requirement.

The direct access storage device basically allow the any file and elements to access directly from the given storage device and address. It is less time consuming method so that it increase the overall efficiency of the system.

On the other hand, all the other options are not associated for storing the sequential file. Therefore, Direct access storage device is the correct option.

Time and weather Write a program to take as input and 4-digit number from the user. The first two digits represent the day of the month and the last two digits represent the month of the year. The program should then display the following: "It's winter" if the month entered is 12, 1 or2 . "It's Spring" if the month entered is 3, 4, or 5 "It's Summer", if the month entered is 6,7, or 8 "It's Fall", if the month entered is 9, 10, or 11 The program should also display the current week number of the month

Answers

Answer:

#here is program in python

#read 4 digit number

date=int(input("enter the date:"))

#first 2 digit is day

day=int(date/100)

#last 2 digit is month

month=date%100

#find the week of the month

if day<=7:

  week=1

elif day>=8 and day<=14:

  week=2

elif day>=15 and day<=21:

  week=3

elif day>=22 and day<=28:

  week=4

elif day>=29:

  week=5

#check for Winter

if month in [12,1,2]:

  print("week {} of Winter.".format(week))

# check for Spring

elif month in [3,4,5]:

  print("week {} of Spring.".format(week))

#check for Summer

elif month in [6,7,8]:

  print("week {} of Summer.".format(week))

#check for Fall

elif month in [9,10,11]:

  print("week {} of Fall.".format(week))

Explanation:

Read a 4 digit number from user.first 2 digits represents the day and last 2 month.Then find the week of the month.If the month is in [12,1,2] then it will print "Winter" and week of that month.If month is in [3,4,5] then print "Summer" with week.If the month is in [6,7,8] then "Summer" and if the month is in [9,10,11] then "Fall".

Output:

enter the date:1212

week 2 of Winter.

Business competition is no longer limited to a particular country or even a region of the world.
True
False

Answers

Answer:

The best answer to the question: Business competition is no longer limited to a particular country or even a region of the world:___, would be: True.

Explanation:

Globalization has changed the way that all aspects of human life, and human activities develop. Globalization has meant the erasing of limitations that were placed primarily on trade and economic activities, but it also extended to other aspects of life. Because of technology advancements, especially in communications, connectivity, and travelling, the world is now easily connected and limitations are only placed up to a certain level. Thus, and especially economically, business competition has become a global issue too, with now more and more presence of multinational businesses, companies that extend not necessarily to one country, or even one region of the world, but extend to any region that will allow them to enter for business exchanges.

From an IT perspective, which of the following best describes BI and BI apps?
a. Stand-alone
b. Support a specific objective
c. A collection of ISs and technologies
d. Web-based systems designed for for-profits

Answers

Answer:a)Stand-alone

Explanation: Stand-alone application is the application that is found on the system of every client.In accordance with the IT section, Business intelligence can be transferred into stand-alone application .This helps in the development of the essence of the system at an independent level.

Other options are incorrect because supporting a certain factor will not make it independent, cannot act as the group of ISs technology or web system for gaining profit.Thus,the correct option is option(a).

The parameters needed for a MySQL database connect string are

a

host name

b

user name

c

password

d

All of the above

Answers

Answer:

d. All of the above.

Explanation:

The parameters required to for a MYSQL database connect string are as following:-

Host Name.User Name.Password.New link.Client flags.

So  among  the  given  options all of them  are  required  and  those are host name,user name,password.

Hence the answer to this question is option d all of the above.

What is TCP/IP's Transport layer's primary duty?

Answers

Answer:

 The TCP/IP is the transmission control protocol and internet protocol and in the TCP/IP model the transport layer is the second layer.

The primary responsibility of this layer is that it is basically used to deliver messages to the host and that is why it is known as end to end layer.

It basically provide the point to point connection between the destination to server host for delivering the various types of the services efficiently and reliably.

In the TCP/IP model the transport layer are basically responsible for transferring the data or service error free between the server to destination host.

. Use one command to create a /sales directory with the permissions of 770

Answers

Answer:

mkdir -m 770 sales

Explanation:

The command mkdir is used to create a directory and the attribute or flag

-m is used to  assign permissions on create a folder.

Example:

mkdir -m 770 sales

Create a folder with permissions 770 with name sales

What does it mean to 'instantiate' an object?

Answers

Explanation:

Instantiate an object means creating an instance of accessing the property of a class we can create instance or object for that class. The property of class means method and variable with the help of instance we can directly access the method and variable.

For example  

class abc // class abc

{

public:

void sum1() // function definition

{

cout<<" hello "; // display hello

}

};

void main() // main method  

{

abc ob; //  creating an instance  

ob.sum1(); // calling a function sum1  

}

Output:

hello

Here we create a instance of class abc i.e ob which can access the method sum1().

What is ‘verification’?

Answers

Answer: Verification in the terms of the computer field is defined as the process which is for testing of the consistency and the accuracy of the information, algorithm, data, etc. Verification is carried out by the approval or disapproval method after the checking process.

This techniques helps in verifying whether the function,algorithm ,data that has been accessed in the system is complete and precise or not so that it can properly function in the operating system.

How many bytes are there in 256 Kbytes?

Answers

Answer:

256000 bytes.

Explanation:

One Kilo byte(KB) consists of 1000 bytes.So the number of bytes in 256 kilo bytes is :-

1 kilobyte = 1000 bytes.    

256 kilo bytes = 256 x 1000 bytes.  

256 kilo bytes = 256000 bytes.  

Also 1 bytes consists of 8 bits.

1 kb = 1000 bytes.

1GB Giga byte = 1024 kilo bytes.

1 TB Tera Byte = 1024 Giga Bytes (GB).  

Hence the answer to this question is  256,000 bytes.

Write a C++ program that will convert distance measurements from miles to kilometers. Specifically, the program needs to convert 0, 10, 20, 30, 40 , 50, 60, 70, 80, and 90 miles to kilograms displaying both the number of miles and the number of kilograms on the same line.

Answers

Answer:

// here is code in C++.

#include <bits/stdc++.h>

using namespace std;

// main function

int main()

{

// loop that will convert 0,10,20.....90 miles to kilometer

   for(int a=0;a<=90;a=a+10)

   {

   // convert miles to kilometer

       double kilo_m=a*1.609;

       // print the result

       cout<<a<<" miles is equal to "<<kilo_m<<" kilometer."<<endl;

   }

return 0;

}

Explanation:

Run a for loop from 0 to 90.First change 0 miles to kilograms by multiply 1.609. Then Increment "a" by 10 until it "a" is less or equal to 90.And change them into kilometer.

Output:

0 miles is equal to 0 kilometer.

10 miles is equal to 16.09 kilometer.

20 miles is equal to 32.18 kilometer.

30 miles is equal to 48.27 kilometer.

40 miles is equal to 64.36 kilometer.

50 miles is equal to 80.45 kilometer.

60 miles is equal to 96.54 kilometer.

70 miles is equal to 112.63 kilometer.

80 miles is equal to 128.72 kilometer.

90 miles is equal to 144.81 kilometer.

Please discuss the differences between the array implementation and the linked list implementation of queues. List the advantages and disadvantages of each implementation.

Answers

Answer:

Arrays and linked list are data structures used to store data but it has some advantages and disadvantages.It Is important keep in mind thath both of them are completely usefull in it own case

Explanation:

Advantages:

Linked list: It doesn't have a size limitationIt is easy insert new elementsit doesn't have memory limitationArray:It is possible access random elementsThe memory requirements are less than linked list

Disadvantages:

Linked list:It is not possible access random element in the listit Require more memory to store the pointer to the next elementArray:It is expensive insert new elementsit is fixed sizeit needs continuos memory (memory limitation)

. What is an APT? What are some practical strategies to protect yourself from an APT?

Answers

Answer and Explanation:

Advanced Persistent Threat abbreviated as APT is a type of cyber attack which gives access to the unauthorized user  to enter the network without being detected for a long period.

APTs are generally sponsored by the government agencies of the nation or large firms. For example, one of the ATPs used was Stuxnet in the year 2010 against Iran, in order to put off the nuclear program of Iran.

Some of the practical strategies for protection against APT are:

Sound Internal AuditingStrong Password Accessing PoliciesStringent policies for accessing any deviceIntroduction and implementation of multi factor authenticationStrong IDs and sound honeypot solutions

Many business databases consist of multiple tables with ____ among them.

Relationships

Arrows

Objects

Constraints

Answers

Answer: Relationship

Explanation:

 Many organization and business consist multiple tables with the relationship when the multiple data in the table are basically associate with the multiple data in the another table.

When we create a database, then foe each entities we use separate table for every particular entities. The relationship between the multiple table is basically used to represent multiple data in the database.

There are basically different type of the relationship in the database that are:

One to one relationshipOne to many relationshipMany to many relationship  

 

Write a function called reverse() with this prototype:

void reverse(char dest[], char source[], int size);

Your function should copy all the elementsin the array source into the array dest, except in reverse order. The number of elements in the source array is give in the parameter size. Use a for loop to do the copying. Assume that dest is large enough to hold all of the elements. Please be thorough with commenting.

Answers

Answer:

void reverse(char dest[], char source[], int size)

{

   for(int i=0;i<size;i++)//using for loop.

   {

       dest[i]=source[i];//assigning each element of source array to dest array.

   }

   int s=0,e=size-1;//initializing two elements s with 0 and e with size -1.

   while(s<e){

       char t=des[s];             //SWAPPING

       dest[s]=dest[e];            //SWAPPING

       dest[e]=t;                  //SWAPPING

       s++;

       e--;

   }

}

Explanation:

I have used while loop to reverse the array.I have initialize two integer variables s and e with 0 and size-1.Looping until s becomes greater than e.

It will work as follows:

first s=0 and e=0.

dest[0] will be swapped with dest[size-1]

then s=1 and e=size-2.

then des[1] will be swapped with dest[size-2]

and it will keep on going till s is less than e.

An oral defamatory statement is ____.

Abuse
Slang
Slander
Defamation

Answers

Answer: Slander

Explanation: Slander is the orally spoken statement that has the defamatory meaning.The meaning of the defamatory statement is having the negative, false, hatred, ridicule etc feeling in the hidden form.This statement shows the false intention.

Slander is marked as the untrue defamatory statement .Other options are incorrect because abuse is statement containing abusive language, slang contains the informal language and defamation is the false claim .Thus the correct answer is slander.

Write a program that prompts the user to enter the month and year and displays the number of days in the month. For example, if the user entered month 2 and year 2000, the program should display that February 2000 has 29 days. If the user entered month 3 and year 2005, the program should display that March 2005 has 31 days.Here is a sample run of this program:Enter a month in the year (e.g., 1 for Jan): 1Enter a year: 2009January 2009 has 31 daysExercise 3.11Liang, Y. Daniel. Introduction to Java Programming (8th Edition)

Answers

Answer:

Following are the program in JAVA language  

import java.util.Scanner; // import package

import java.util.Calendar; // import package

public class Main // class main  

{  

public static void main(String[] args) // main function  

{  

Scanner input = new Scanner(System.in); // for user input  

Calendar calendar = Calendar.getInstance(); //get calendar instance for methods  

int nYear , nMonth , date =1 , nDays;

String MonthOfName = "";

 System.out.print(" Enter a month in the year :");

 nMonth = input.nextInt(); //input Month

 System.out.print("Enter a year :");

 nYear = input.nextInt(); //Input Year

 switch (nMonth) //Find month name via 1-12

 {

  case 1:

MonthOfName = "January";

nMonth = Calendar.JANUARY;

break;

case 2:

MonthOfName = "February";

nMonth = Calendar.FEBRUARY;

break;

case 3:

 MonthOfName = "March";

nMonth = Calendar.MARCH;

break;

 case 4:

 MonthOfName = "April";

nMonth = Calendar.APRIL;

 break;

 case 5:

MonthOfName = "May";

nMonth = Calendar.MAY;

break;

case 6:

MonthOfName = "June";

nMonth = Calendar.JUNE;

break;

case 7:

 MonthOfName = "July";

nMonth = Calendar.JULY;

break;

 case 8:

MonthOfName = "August";

nMonth = Calendar.AUGUST;

break;

case 9:

MonthOfName = "September";

nMonth = Calendar.SEPTEMBER;

break;

case 10:

MonthOfName = "October";

nMonth = Calendar.OCTOBER;

break;

case 11:

 MonthOfName = "November";

nMonth = Calendar.NOVEMBER;

break;

case 12:

MonthOfName = "December";

nMonth =Calendar. DECEMBER;

         }        

 calendar.set(nYear, nMonth, date); // set date to calender to get days in month

nDays=calendar.getActualMaximum(Calendar.DAY_OF_MONTH); // get no of days in month

System.out.println(MonthOfName + " " + nYear + " has " + nDays + " days."); //print output

}

}

Output:

Enter a month in the year : : 09

Enter a year : 2019

September 2019 has 30 days.

Explanation:

In this program we have take two user input one for the  month and other for the year Also take two variables which are used for storing the month name and no of days in a month. with the help of switch we match  the cases  and store the month value .After that  set the date to calender with help of calendar.set(nYear, nMonth, date) method and  To get the number of days from a month  we use  calendar.getActualMaximum(Calendar.DAY_OF_MONTH);  method and finally print year and days.

 

     

The default behavior for Connector/Python is to use __________ results.

a

buffered

b

unbuffered

c

uninitialized

d

list-based

Answers

Answer: (C) Uninitialized

Explanation:

 The default behavior is basically used as the uninitialized result for the connector and python. As a matter of course, MySQL Connector/Python doesn't cradle or pre-fetch results. This implies after a question is executed, your program is in charge of bringing the information.

This stays away from unnecessary memory use when inquiries return huge outcome sets. On the off chance that you realize that the outcome set is little enough to deal with at the same time, you can get the outcomes promptly by setting supported as "TRUE".

Writе thе dеclaration of a doublе pointеr namеd avеragе

Answers

Answer:

double *average; //  declaration of a doublе pointеr .

Explanation:

A pointer is a variable that will store the address of another variable of the same datatype. Here average is a pointer type variable that means it will store the address of double datatype variable.  

syntax of declaring double datatype variable  

double *variable_name  ;

double *average;  

For example:

double *average;

//declaration of a doublе pointеr

double r=90.897;

// variable r of double datatype

average=&r;// storing the address of r

Is spread spectrum transmission done for security reasons in commercial WLANs?

Answers

Answer: No

Explanation: Spread spectrum transmission is the wireless transmission technique for the wide channel that helps in decrement of the potential interference.The transmission of signal is based on the varying the frequency knowingly to achieve larger bandwidth.

The use of spread spectrum transmission in the WLAN(wireless local area network)is used for the regulatory purpose The regulation is the controlling of the area  through policies.Thus,security is not the service that is provided to WLAN by spread spectrum transmission.

Other Questions
Simplify:(-3x)(-2x5) Which of the following is not true of a codon?a. It may code for the same amino acid as another codon.b. It never codes for more than one amino acid.c. It extends from one end of a tRNA molecule.d. It is the basic unit of the genetic code. Which of the following factors led to the development of ancient civilizations? climate invasion agriculture location a piston executes simple harmonic motion with an amplitude of 0.1m. If it passes through the center of it's motion with a speed of 0.5 m/s, what is the period of oscillation? Reduce the fractions 32/68,22/28, and 21/49 The dimension that includes a persons ability to respond appropriately to upsetting events and to express feelings in appropriate ways is the __________ dimension of psychological health. Solve for m.m - 5= 49A.m=2 B.m=7 C.m=12 D.m=35 Which equation could be solved using the graph above?X^2+x-2=0X^2+2x+1=0X^2-1=0X^2-2x+1=0 It costs Orkid Company $17 of variable costs and $3 of fixed costs to produce its product. The company currently has unused capacity. The product sells for $25. Homer Industries offers to purchase 5,000 units at $19 each. In the deal, Orkid will incur special shipping costs of $1.50 per unit. If the special offer is accepted and produced with unused capacity, net income will: A. increase $2,500. B. decrease $5,000. C. increase $10,000. D. decrease $30,000. You estimate that you have completed 1/4 of the work your boss expects this week. What precent if your work is complete? Which process is part of the carbon cycle?A. AmmonificationB. TranspirationC. PhotosynthesisD. Evaporation what is it called when a scientists personal opinion affects the way experimental results are reported A. bias B. curiousity C. inductive reasoning D. deductive reasoning A rigid tank contains water at 200kPa and an unknown temperature. When the tank is 100 C the vapour starts condensing. Calculate the initial temperature of the water. Show the process on T-v diagram. 1) What is the value for the digit 8 in the given number?38.165.0479 you will get 25 points!!!!!! Nights and Dragons From the memoir of author Abigail Prynne As I started my research, I discovered many skeptics. Scientists presented evidence to show why dragons could notand did notexist. They explained that it would be impossible for dragons to fly because they would be too big. They laughed at the idea of dragons breathing fire. They pointed out that no other animal has ever done this. They said that if dragons had lived, someone would have found remains somewhere in the world. No bones about it, there were plenty of logical explanations. It would have been easy for me to accept that the only place dragons ever existed was in the imaginations of those who believed. What is the main idea of text? (5 points) Scientists have lots of evidence to explain why dragons don't exist. Scientists say it would be impossible for dragons to fly because they would be too big. They laughed at the idea of dragons breathing fire. They said that if dragons had lived, someone would have found remains somewhere in the world. Type your answer and then click or tap Done.Simplify -(x-2y) - y. What are CRC cards and use-case scenarios used for in object-oriented analysis and design? You are a junior in high school and have always been fascinated with bridges. You think it would be great to build bridges for a living but have no idea that you should study engineering in college to accomplish this goal. You've decided that it's time to talk to someone who can help you plan for college and give you guidance and the information you need. Who should you talk to? The estimated answer to a multiplication problem is 800,000. Which of the following expressions could result in this answer? Explain how you know.8,146 x 1281,467 x 1218,146 x 12181,477 x 1,217 Light dependent repair is carried out by which of the following enzymes?a. DNA gyraseb. DNA polymerasec. DNA photolyased. RNA polymerasee. DNA helicase