Assume that COL1 of table TAB1 contains the following values: 20 20 30 null What value...
Assume that COL1 of table TAB1 contains the following
values:
20
20
30
null
What value will be returned by the following query? (If your answer
is a number, state your answer as a number and not as text. For
example: use 10 and not TEN.)
SELECT SUM(COL1)
FROM TAB1;
Homework Answers
Add Answer to:
Assume that COL1 of table TAB1 contains the following
values:
20
20
30
null
What value...
Database Management 6. [5] Create the following table: CREATE TABLE customer ( cust_name VARCHAR(30) NOT NULL,...
Database Management
6. [5] Create the following table: CREATE TABLE customer ( cust_name VARCHAR(30) NOT NULL, address VARCHAR(60), UNIQUE (cust name, address)); A. Run the following inserts and explain why both work and how will you prevent it INSERT INTO customer VALUES ('Alex Doe', NULL); INSERT INTO customer VALUES ('Alex Doe', NULL); 7. [5] Modify the following table definition to ensure that all employees have a minimum wage of $10 CREATE TABLE employee ( empId INT PRIMARY KEY, empName VARCHAR(40)...
4. [35 points] The following table contains the ACT scores and the GPA for ten college...
4. [35 points] The following table contains the ACT scores and the GPA for ten college students. Student GPA ACT 2.821 3.4 24 3.026 3.5 27 3.629 3.025 3.225 3.5 28 2.520 3.7 30 10 (a) [10 points] Estimate the relationship between GPA and ACT; that is, obtain the intercept and slope estimates in the equation (You may use a calculator or a spreadsheet program, but show your work.) (b) [2 points] Does the intercept have a useful interpretation here?...
Answer all questions The statement Like "A?9 can be used as a query criterion to match...
Answer all questions
The statement Like "A?9 can be used as a query criterion to match several field values. List any one example of a field value that would match this criterion. 3. What specific type of query would use the following criterion? Like [Enter name:] & 4. What aggregate function would be used to output the number of nonnull field values in a crosstab query? 5. 6. The value Is Null would be used as a criterion in which...
If a variable contains _____, it means that the variable does not exist. a null value...
If a variable contains _____, it means that the variable does not exist. a null value void empty string 0 Question 2 Which of the following is required as the second argument of the TryParse() method? the name of the variable to parse the data type the out keyword the Boolean value Question 3 You must use the action attribute with a Web form. False No answer text provided. True No answer text provided. Question 4 Whether or not data...
CREATE TABLE DEPT ( DEPTNO INTEGER NOT NULL, DNAME VARCHAR(14), LOC VARCHAR(13), PRIMARY KEY (DEPTNO)); INSERT...
CREATE TABLE DEPT (
DEPTNO INTEGER NOT NULL,
DNAME VARCHAR(14),
LOC VARCHAR(13),
PRIMARY KEY (DEPTNO));
INSERT INTO DEPT VALUES (10,'SPORTS','NEW YORK');
INSERT INTO DEPT VALUES (20,'HOME','DALLAS');
INSERT INTO DEPT VALUES (30,'OUTDOOR','CHICAGO');
INSERT INTO DEPT VALUES (40,'CLOTHING','BOSTON');
CREATE TABLE EMP (
EMPNO INTEGER NOT NULL,
ENAME VARCHAR(10),
JOB VARCHAR(9),
MGR INTEGER,
SAL FLOAT,
COMM FLOAT,
DEPTNO INTEGER NOT NULL,
FOREIGN KEY (DEPTNO) REFERENCES DEPT (DEPTNO),
FOREIGN KEY (MGR) REFERENCES EMP(EMPNO),
PRIMARY KEY (EMPNO));
INSERT INTO EMP VALUES (7839,'KING','PRESIDENT',NULL,
5000,NULL,10);
INSERT INTO...
(20) 1. Complete the ANOVA table (9 points), state the null and alternate hypothesis in symbols...
(20) 1. Complete the ANOVA table (9 points), state the null and alternate hypothesis in symbols and in words (6 points). Copy the results using technology and use words to describe how f relates to the p value and what the results indicate (5 points). Girls from four different soccer teams are to be tested for mean goals scored per game. The entries in the table are the goals per game for the different teams as shown in the table...
emp table in bellow: 5. Query data from emp table for each non-deptno 20 employees to...
emp table in bellow:
5. Query data from emp table for each non-deptno 20 employees to display the ename and calculate the number of months between today and the date the employee was hired. Label the column heading to Ename and Months_Worked. Order your results by the number of months employed. Round the number of months to a whole number. Months _Worked - - - - - - - - Ename MILLER KING JAMES MARTIN TURNER CLARK BLAKE WARD ALLEN...
in a sample of n = 30 selected from a normal population, X=57 and S=20, what...
in a sample of n = 30 selected from a normal population, X=57 and S=20, what is your statistical decision if the level of significance, a, is 0.10, the null hypothesis, Hois - 50, and the alternative hypothesis, Hy is 750? Click here to view page 1 of the table of the critical values of Click here to view page 2 of the table of the critical values of Determine the critical value(s) The critical value(s) is (are) (Round to...
mysql> DESC shows; +--------------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra...
mysql> DESC shows; +--------------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------+-------------+------+-----+---------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | name | varchar(50) | YES | | NULL | | | network_id | int(11) | YES | | NULL | | | network_name | varchar(30) | YES | | NULL | | +--------------+-------------+------+-----+---------+----------------+ mysql> SELECT * FROM shows; +----+----------------+------------+--------------+ | id | name | network_id | network_name |...
The following table contains observed frequencies for a sample of 260. Column Variable A B C...
The following table contains observed frequencies for a sample of 260. Column Variable A B C Row Variable P 10 25 25 35 55 20 10 10 70 Test for independence of the row and column variables using a = .05. Compute the value of the x test statistic (to 3 decimals). The p-value is - Select your answer - What is your conclusion? - Select your answer - that the column variable is not independent of the row variable.
Database Management
6. [5] Create the following table: CREATE TABLE customer ( cust_name VARCHAR(30) NOT NULL, address VARCHAR(60), UNIQUE (cust name, address)); A. Run the following inserts and explain why both work and how will you prevent it INSERT INTO customer VALUES ('Alex Doe', NULL); INSERT INTO customer VALUES ('Alex Doe', NULL); 7. [5] Modify the following table definition to ensure that all employees have a minimum wage of $10 CREATE TABLE employee ( empId INT PRIMARY KEY, empName VARCHAR(40)...
4. [35 points] The following table contains the ACT scores and the GPA for ten college students. Student GPA ACT 2.821 3.4 24 3.026 3.5 27 3.629 3.025 3.225 3.5 28 2.520 3.7 30 10 (a) [10 points] Estimate the relationship between GPA and ACT; that is, obtain the intercept and slope estimates in the equation (You may use a calculator or a spreadsheet program, but show your work.) (b) [2 points] Does the intercept have a useful interpretation here?...
Answer all questions
The statement Like "A?9 can be used as a query criterion to match several field values. List any one example of a field value that would match this criterion. 3. What specific type of query would use the following criterion? Like [Enter name:] & 4. What aggregate function would be used to output the number of nonnull field values in a crosstab query? 5. 6. The value Is Null would be used as a criterion in which...
CREATE TABLE DEPT (
DEPTNO INTEGER NOT NULL,
DNAME VARCHAR(14),
LOC VARCHAR(13),
PRIMARY KEY (DEPTNO));
INSERT INTO DEPT VALUES (10,'SPORTS','NEW YORK');
INSERT INTO DEPT VALUES (20,'HOME','DALLAS');
INSERT INTO DEPT VALUES (30,'OUTDOOR','CHICAGO');
INSERT INTO DEPT VALUES (40,'CLOTHING','BOSTON');
CREATE TABLE EMP (
EMPNO INTEGER NOT NULL,
ENAME VARCHAR(10),
JOB VARCHAR(9),
MGR INTEGER,
SAL FLOAT,
COMM FLOAT,
DEPTNO INTEGER NOT NULL,
FOREIGN KEY (DEPTNO) REFERENCES DEPT (DEPTNO),
FOREIGN KEY (MGR) REFERENCES EMP(EMPNO),
PRIMARY KEY (EMPNO));
INSERT INTO EMP VALUES (7839,'KING','PRESIDENT',NULL,
5000,NULL,10);
INSERT INTO...
emp table in bellow:
5. Query data from emp table for each non-deptno 20 employees to display the ename and calculate the number of months between today and the date the employee was hired. Label the column heading to Ename and Months_Worked. Order your results by the number of months employed. Round the number of months to a whole number. Months _Worked - - - - - - - - Ename MILLER KING JAMES MARTIN TURNER CLARK BLAKE WARD ALLEN...
in a sample of n = 30 selected from a normal population, X=57 and S=20, what is your statistical decision if the level of significance, a, is 0.10, the null hypothesis, Hois - 50, and the alternative hypothesis, Hy is 750? Click here to view page 1 of the table of the critical values of Click here to view page 2 of the table of the critical values of Determine the critical value(s) The critical value(s) is (are) (Round to...
The following table contains observed frequencies for a sample of 260. Column Variable A B C Row Variable P 10 25 25 35 55 20 10 10 70 Test for independence of the row and column variables using a = .05. Compute the value of the x test statistic (to 3 decimals). The p-value is - Select your answer - What is your conclusion? - Select your answer - that the column variable is not independent of the row variable.
Most questions answered within 3 hours.
-
A stone is projected vertically upwards at 20 m/s.
a. What is the total time of...
asked 9 minutes ago -
Define a function named how_many_substr_of_string(...) which
receives two parameters, the first parameters is a list with...
asked 4 minutes ago -
Calculate the following binomial probability by either using one
of the binomial probability tables, software, or...
asked 4 minutes ago -
A small asteroid (mass of 150 g ) strikes a glancing blow at a
satellite in...
asked 20 minutes ago -
Suppose that the firm has a minimum quantity of employment,
N*, that is, the firm can...
asked 5 minutes ago -
A delivery car had a first cost of $30,000, an annual operating
cost of $14,000, and...
asked 11 minutes ago -
Answer the following True/False questions:
T F Pruning a model will generally improve the model’s accuracy...
asked 17 minutes ago -
A bus is scheduled to arrive at the bus stop every morning at
8:00 A.M; however,...
asked 12 minutes ago -
PLEASE WRITE A CRITICAL COMMENT TO THIS ESSAY IN ABOUT 150
WORDS. tHANK YOU!
Before talking...
asked 18 minutes ago -
Order-getting costs would NOT include
a. marketing costs.
b. salaries of sales personnel.
c. customer service...
asked 21 minutes ago -
7. Write the AVL tree code and insert the above numbers. Show
the screen shot of...
asked 25 minutes ago -
Draw two aspartate side chains and how they hydrogen bond to
eachother
asked 33 minutes ago