1. An error that has a severity level of 10 is considered to be an at...
1. An error that has a severity level of 10 is considered to be an at what level?
A. Warning
B. Fatal
C. Informational
D. Urgent
2. When declaring a variable in a SQL statementm what character(s) precedes the variable name?
A. &
B. ##
C. !
D. @
3. If the @@CURSOR_ROWS value is -1, what does that tell you?
A. No rows were returned by the cursor
B. It is a dynamic cursor
C. The cursor is not open
D. It is a static cursor
Homework Answers
1. An error that has a severity level of 10 is considered to be at what level?
Answer: C. Informational
The severity level of an error occurred indicates the type of the error encountered.
Errors at severity level 10 are informational which means these are the error caused by the information entered by the user.
2. When declaring a variable in a SQL statement what character(s) precedes the variable name?
Answer: D. @
Variables in SQL are declared using the DECLARE statement, the variable name should be preceded by @ symbol followed by the datatype.
The syntax for declaring a variable in SQL is
DECLARE @variablename datatype;
Example: DECLARE @name varchar(50)
The above statement declares a variable ‘name’ of type varchar
3. If the @@CURSOR_ROWS value is -1, what does that tell you?
Answer: B. It is a dynamic cursor
@@CURSOR_ROWS returns the number of rows qualified by a cursor when it is lastly called.
If the cursor is opened synchronously the value returned by @@CURSOR_ROWS is positive and if it is opened asynchronously the value will be negative.
If the value returned by @@CURSOR_ROWS is -1 it means it is a dynamic cursor. Since for a dynamic cursor the number of values qualifying the cursor will be repeatedly changing and as we cannot get the definite number of rows qualifying the cursor and hence returns -1.
Add Answer to:
1. An error that has a severity level of 10 is considered to be
an at...
in C++ 1. Answer the following questions: a) 2 pts] Explain why it is important to...
in C++
1. Answer the following questions: a) 2 pts] Explain why it is important to indent code. What happens if code is not indented? b) 2 pts) Explain how you can prevent the unintended use of garbage values? c) (2 pts] Give one reason why you should use the keyword const when dealing with constant values. Make sure to explain what could happen if you fail to use this keyword. d) 2 pts) Give an example where simply declaring...
1) Which of the following is the name of a local variable in the Strange class...
1) Which of the following is the name of a local variable in the
Strange class below?
public class Strange{
public static final int MAX = 5;
public static void unknown(){
int number = 0;
for (int i = MAX; i >= 1; i--)
number += i * i;
System.out.println(number);
}
public static void main(String[] a){
unknown();
}
}
a) Strange
b)
int
c)
MAX
d)
number
e)
main
2) Which of the following is NOT a method of the...
1) Which type of error is more likely to be made if it is difficult to...
1) Which type of error is more likely to be made if it is difficult to perform sampling and there is high population variance? Select one: a. Type I error b. Type II error c. Type III error d. a and b, but not c e. a, b and c 2) Pearson's r is suitable to measure the linear relationship between two __________ level variables. Select one: a. interval/ratio b. ratio but not interval c. interval but not ratio d....
17. Given the following definition of function £, what does the expression "t (1: 2: 3]::" return? let rec f listl match listl with 1 I head::rest -> head f resti b. 6 c. 120 d. 123 456...
17. Given the following definition of function £, what does the expression "t (1: 2: 3]::" return? let rec f listl match listl with 1 I head::rest -> head f resti b. 6 c. 120 d. 123 456 e. g. 14; 5; 6] h. (6; 5; 4] i. Error message j. None of the above 18. Which of the following is the correct meaning of the C declaration "double (*a [n]) "? a is an array of n pointers to...
1.What is the return value if the user try to do the following: SELECT TRUNC (65.73,-2)...
1.What is the return value if the user try to do the
following:
SELECT TRUNC (65.73,-2) FROM DUAL;
Select one:
a. 60
b. 00
c. 0
d. 600
2.Supposed that the user uses the ff SELECT statement: what will
be the possible output.
SELECT GRADE AS STUDENT MARK
FROM GRADE_REPORT;
Select one:
a. Error because of the keyword AS.
b. Error because of missing “” mark.
c. Will display the column GRADE rename as STUDENT MAK
d. Will display all...
Comments used to document code should: A. be used as little as possible B. be insightful...
Comments used to document code should: A. be used as little as possible B. be insightful and explain what the instruction's intention is C. only be included in code that is difficult to understand D. be used to define variables whose names are not easy to understand E. not be included with the program 2 points QUESTION 2 The main method for a Java program is defined by: A. public static main( ) B. public static main(String[ ] args);...
what is wrong with my code. what should I do with this kind of error 61...
what is wrong with my code. what should I do with this kind of
error
61 QueueDemo java - Files - RaProjects/one- A Queue Demoava Queueinterface Java inport java.util.LinkedList; import java.util.Queue public class QueueDemo public static void main(String[] args) { 10 11 12 13 Queue String myQueue new LinkedlistString();//Create a reference to a queue Interface myqueue.add("A");//Call the enqueue method on myQueue passing the string value of "A" myQueue.add("B");//call the enqueue method on nyQueue passing the String value of "3" myQueue.add("C");//Call...
QUESTION 1 Which of the following Python variable names has syntax error ? OA. A. CSC121...
QUESTION 1 Which of the following Python variable names has syntax error ? OA. A. CSC121 OB. B. CSC121 Oc. C. CSC-121 D. None of the above QUESTION 2 What data type will Python use to store the value of num_students ? num_students = 17.0 A. floating point number (i.e. float) OB. B. integer (i.e. int) Oc. string (i.e. str) Od. D. None of the above
In C code 1. Write and submit the algorithm OR flowchart to indicate you understand the...
In C code 1. Write and submit the algorithm OR flowchart to indicate you understand the problem 2. Create a project and name the source code lastname_firstname_prog5.c 3. Use the prog5.c as a guide, copy/ paste into your project source code *** build run and test, the outline code - You will need to declare an integer variable called again and initialize it 4. Add the function prototype and implement the function definition for the Greeting function 5. Add the...
Description 1. This project will create a base account class that has the members: std::string account_code;...
Description 1. This project will create a base account class that has the members: std::string account_code; std::string first_name; std::string last_name; double balance; Provide a constructor that initializes ALL members in its initialization list with data passed in as arguments to the constructor. Provide any accessor functions you may need (e.g. to get the account code and balance and to set the balance). In addition, include two pure virtual functions that look like the following: virtual void monthly_update() = 0; virtual...
in C++
1. Answer the following questions: a) 2 pts] Explain why it is important to indent code. What happens if code is not indented? b) 2 pts) Explain how you can prevent the unintended use of garbage values? c) (2 pts] Give one reason why you should use the keyword const when dealing with constant values. Make sure to explain what could happen if you fail to use this keyword. d) 2 pts) Give an example where simply declaring...
1) Which of the following is the name of a local variable in the
Strange class below?
public class Strange{
public static final int MAX = 5;
public static void unknown(){
int number = 0;
for (int i = MAX; i >= 1; i--)
number += i * i;
System.out.println(number);
}
public static void main(String[] a){
unknown();
}
}
a) Strange
b)
int
c)
MAX
d)
number
e)
main
2) Which of the following is NOT a method of the...
17. Given the following definition of function £, what does the expression "t (1: 2: 3]::" return? let rec f listl match listl with 1 I head::rest -> head f resti b. 6 c. 120 d. 123 456 e. g. 14; 5; 6] h. (6; 5; 4] i. Error message j. None of the above 18. Which of the following is the correct meaning of the C declaration "double (*a [n]) "? a is an array of n pointers to...
1.What is the return value if the user try to do the
following:
SELECT TRUNC (65.73,-2) FROM DUAL;
Select one:
a. 60
b. 00
c. 0
d. 600
2.Supposed that the user uses the ff SELECT statement: what will
be the possible output.
SELECT GRADE AS STUDENT MARK
FROM GRADE_REPORT;
Select one:
a. Error because of the keyword AS.
b. Error because of missing “” mark.
c. Will display the column GRADE rename as STUDENT MAK
d. Will display all...
what is wrong with my code. what should I do with this kind of
error
61 QueueDemo java - Files - RaProjects/one- A Queue Demoava Queueinterface Java inport java.util.LinkedList; import java.util.Queue public class QueueDemo public static void main(String[] args) { 10 11 12 13 Queue String myQueue new LinkedlistString();//Create a reference to a queue Interface myqueue.add("A");//Call the enqueue method on myQueue passing the string value of "A" myQueue.add("B");//call the enqueue method on nyQueue passing the String value of "3" myQueue.add("C");//Call...
QUESTION 1 Which of the following Python variable names has syntax error ? OA. A. CSC121 OB. B. CSC121 Oc. C. CSC-121 D. None of the above QUESTION 2 What data type will Python use to store the value of num_students ? num_students = 17.0 A. floating point number (i.e. float) OB. B. integer (i.e. int) Oc. string (i.e. str) Od. D. None of the above
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago