All categories

3 years ago

What commands would return all the rows and columns in the ProductCategory table?

Computers and Technology

1 answer:

Delvig [45]3 years ago

8 0

Answer:

Select commands would return all the rows and columns in the table.

Explanation:

In the database management system, it consists of one or more table. To handle this table it provides the concept of SQL(Structured Query Language). It is a programming language that design, manage, store data into the relational database. It is case sensitive language. In the SQL many commands used for handle table data, it returns all rows and columns from the table.

Syntax of select command can be given as:

Select * from tablename;

Example:

select * from ProductCategory;

returns all the data from the table.

In select command, we will also return select data by using condition

SELECT column1 [, column2, ...]

FROM tablename

WHERE condition

In the conditional clause we use these operators that can be given as:

= Equal, > Greater than, < Less than, >= Greater than equal to, <= Less than equal to, != Not equal to.

You might be interested in

Define a function called 'findWordFreq, which takes two parameters. The first parameter, 'text" is an nltk.text.Text object and

MakcuM [25]

Answer:

import os

import nltk

import zipfile

from nltk. corpus import gutenberg

from nltk. text import Text

def findWordFreq(text, word):

textfreq = nltk. FreqDist(text)

wordfreq = nltk.FreqDist(word)

maxfreq = max(textfreq)

return wordfreq, maxfreq

if -_name__ == '__main__':

text = input()

word = input()

if not os.path.exists(os.getcwd() + "/nltk_data"):

with zipfile.ZipFile("nltk_data.zip", 'r') as zip_ref:

zip_ref.extractall(os.getcwd())

os.environ['NLTK_DATA'] = os.getcwd() + "/nltk_data"

text = Text(gutenberg.words (text))

word_freq, max_freq = findWordFreq(text, word)

print(word_freq)

print(max_freq)

Explanation:

The natural language package in python is used to get and analyse word from voice input. The python code above get words from a zipfile extract, and the 'findWordFreq' function gets the word count and the maximum number of alphabet used in the word distribution.

4 0

3 years ago

Note that common tasks are listed toward the top, and less common tasks are listed toward the bottom. According to O*NET, what a

Aleksandr-060686 [28]

Answer:

1). organizing and leading religious services.

3). praying and promoting spirituality.

4). preparing and delivering sermons or talks.

5). reading from sacred texts.

Explanation:

The clergy is defined as the 'body of persons including ministers, sheiks, priests, and rabbis who are trained and ordained for religious service.' Thus, the more common tasks performed by them include arranging and directing the religious services along with calling upon and encouraging spirituality amongst people. While the less common tasks carried out by them include assembling and carrying out sermons and studying the religious texts. Thus, options 1, 3, 4, and 5 are the correct options.

8 0

2 years ago

I need someone whos really good with computers to help me with some things

posledela

Okay what do you need to know

4 0

3 years ago

Write a program that prompts the user for the lengths of the two legs of a right triangle, and which reports the length of the h

timurjin [86]

Answer: The following code is in c++

#include <iostream>

#include<math.h>

using namespace std;

int main()

{

float a,b,c;

cout<<"Enter height and base of triangle\n";

cin>>a>>b; //reading two sides from user

c=sqrt(pow(a,2)+pow(b,2)); //calculating hypotenuse

cout<<"Length of hypotenuse is "<<c; //printing third side of triangle

return 0;

}

OUTPUT :

Enter height and base of triangle

Length of hypotenuse is 5

Explanation:

In the above code, three variables a, b and c of int type are declared. After that, it is asked from user to enter the value of a and b. The user puts the value and then c is calculated with the help of Pythagoras theorem formulae which squares the values of two sides and then adds them to calculate hypotenuse of a right angled triangle and finally c is printed to console.

3 0

3 years ago

Modify the code below to do the following:

Kitty [74]

Answer:

The code is appropriately given below with comments for better understanding

Explanation:

#include <linux/init.h>

#include <linux/module.h>

#include <linux/kernel.h>

#include <linux/hash.h>

#include <linux/gcd.h>

#include <asm/param.h>

#include <linux/jiffies.h>

/* This function is called when the module is loaded. */

static int simple_init(void)

{

printk(KERN_INFO "Loading Module\n");

printk(KERN_INFO "These are the HZ: %d\n", HZ);

printk(KERN_INFO "These are the jiffies: %lu\n", jiffies);

printk(KERN_INFO "Golden Ratio is: %lu\n", GOLDEN_RATIO_PRIME);

return 0;

}

/* This function is called when the module is removed. */

static void simple_exit(void) {

printk(KERN_INFO "Removing Module");

unsigned long a = gcd(3300, 24);

printk(KERN_INFO "Greatest Common Denominator between 3,300 and 24 is: %lu\n", a);

printk(KERN_INFO "These are the jiffies: %lu\n", jiffies);

}

/* Macros for registering module entry and exit points. */

module_init( simple_init );

module_exit( simple_exit );

MODULE_LICENSE("GPL");

MODULE_DESCRIPTION("Simple Module");

MODULE_AUTHOR("SGG");

7 0

3 years ago