2 a)String norse_god = "+++" ;int a = 10;int b = 20;int c = 30;c = b;b = a;a = c;if (b <= 12){norse_god = "Thor";}else if (b == 10){}norse_god = "Odin";}else{norse_god = "Loki";System.out.println(norse_god);//L1//L2//L3//L4//L5//L6//L7//L8//L9//L10//L11//L12//L13 Answer to question 2 a):i) Complete the dry run table (you may not need all rows):LINE norse_god abсb<=12?b==10?printed

Whenever If condition executes to True, the else if blocks and else blocks will not get executed.…

Answered: Answer to question 2 a): i) Complete…

Answer to question 2 a): i) Complete the dry run table (you may not need all rows): LINE norse_god a b C b<=12? b==10? printed

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Q: What is the result of the query below: SELECT V_CODE, COUNT (P_CODE) FROM PRODUCT HAVING V_CODE…

A: Answer: Data is filtered using the having clause in accordance with the specified requirements.…

Q: THIS MODULE IS ABOUT SUBQUERIES, SO YOU MUST USE SUBQUERIES INSTEAD OF TABLE JOINS IN THIS…

A: In SQL we use the sub queries along with the IN clause to get the set of records for which we need…

Q: Can I get a screen shot for each querirs

A: Here we make use of select statements along with the required filter condition in such cases we used…

Q: What is the highest normal form (NF) for table "Person" Select one: a. 2NF b. 1NF c. 4NF d.…

A: ANSWER :-- 4NF

Q: CREATE TABLE EMPLOYEE( ENUM DECIMAL(12) NOT NULL,/* Employee number */ FNAME VARCHAR(50) NOT NULL,/*…

A: the answer is:

Q: Given an Employee table with columns for salary and dept, to raise the salaries of all employees in…

A: This question deals with SQL (Structured Query Language), which is used to manage and query…

Q: DROP TABLE IF EXISTS Worker; CREATE TABLE Worker ( WORKER_ID INTEGER NOT NULL PRIMARY KEY…

A: Answer in step 2

Q: 1) Make a list of customers: first name, last name, city 2) Make a list of customers who live in…

A: Structured Query Language (SQL) is a computer language used to manage and modify relational…

Q: 1. Write a SELECT statement that returns four columns from the Products table: ProductCode,…

A: “Since you have posted a question with multiple sub-parts, we will solve first three sub- parts for…

Q: Question 10 When sorting query output, you use the key words 'sort by'. Question 10 options:…

A: The given question is false.

Concept explainers

Procedures in SQL

A pre-compiled stored procedure is a logical unit made up of one/more SQL statements (SQL stands for Structured Query Language). The database server saves it as an object. An SQL procedure is a collection of SQL statements and logic that is written and saved to accomplish a specified goal. An SQL procedure consists of a name, a parameter list, and a set of Transact-SQL statements. Stored procedures are stored as named objects in SQL Database Server.

Question

2 a)
String norse_god = "+++" ;
int a = 10;
int b = 20;
int c = 30;
c = b;
b = a;
a = c;
if (b <= 12)
{
norse_god = "Thor";
}
else if (b == 10)
{
}
norse_god = "Odin";
}
else
{
norse_god = "Loki";
System.out.println(norse_god);
//L1
//L2
//L3
//L4
//L5
//L6
//L7
//L8
//L9
//L10
//L11
//L12
//L13

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Introduction

VIEW

Answer

VIEW

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

what does aggregate function do? a) It eliminates one or more columns of a table. b) it list combinations of rows in two tables. c) it selects roes that appear in one table but another. d) it compares values over a set of rows
Task 3: The Car Maintenance team wants to insert and store the following maintenance types to the MAINTENANCE_TYPES table: ID: 1; Description: Tire Change; Price: 50 ID: 2; Description; Oil Change; Price: 45 ID: 3; Description; Full Cleaning; Price: 100 ID: 4; Description; Gas Pump Change; Price: 145 Add the four maintenance types to the MAINTENANCE_TYPES table.
Below are some rows of the PROVIDERS table for a factory: PCODE 10192 98411 0489035 NAME Hans, Inc. Tools and More Motors Inc. PHONE 231 - 3092 231-1029 993 - 1821 All providers from the factory zone of the city start with 231. You want to get the providers that are in the factory zone of the city. Which of the following is more appropriate? O a. O b. SELECT * FROM PROVIDERS WHERE PHONE LIKE '% 231' O C. O d. SELECT * FROM PROVIDERS WHERE PHONE LIKE $231%' SELECT * FROM PROVIDERS WHERE PHONE LIKE 231 SELECT * FROM PROVIDERS WHERE PHONE LIKE '%231%'
Query 3: Write a parameter query to display the names of all prospects each member tried to recruit based on the member’s first name and the member’s last name you input. List the member’s First Name, member’s Last Name, prospect’s First Name, and prospect’s Last Name (in this order in the query grid). Display the member’s First Name Heading as Member First Name, member’s Last Name Heading as Member Last Name, prospect’s first name heading as Prospect First Name, and prospect’s last name heading as Prospect Last Name. Sort the list by Member Last Name, Member First Name, Prospect Last Name, and Prospect First Name, all ascending order. (WE ARE USING ACCESS SO I AM JUST TRYING TO UNDERSTAND WHAT TO PUT AND PLUG IN ETC. USE MY PICTURES AS REFERRENCE!)
Task 12: When deleting a customer, subtract the balance multiplied by the sales rep’s commission rate from the commission for the corresponding sales rep.
Task 3: ' The Car Maintenance team wants to insert and store the following maintenance types to the MAINTENANCE_TYPES table: ID: 1; Description: Tire Change; Price: 50 ID: 2; Description; Oil Change; Price: 45 ID: 3; Description; Full Cleaning; Price: 100 ID: 4; Description; Gas Pump Change; Price: 145 ANSWER IN MYSQL PLEASE
Composite main keys have prospective keys.
calculate_new_balance Given a starting balance (a number), and a list of transaction tuples, calculate the final balance for an account. Transaction tuples are of the shape ("description", amount, "withdrawal") , or ("description", amount, "deposit"). The last entry in the tuple will be either "withdrawal" or "deposit". Every withdrawal decreases the balance of the account by the specified amount, and every deposit increases the balance. The return value is the new account balance, as a number. (which could be negative) Sample calls should look like: >>> calculate_new_balance(100, [("payday", 20, "deposit"), ("new shoes", 50, "withdrawal"), ("illicit winnings", 200, "deposit")])270>>> calculate_new_balance(100, [])100
C sharp Table: Student (the headers are the field names in the Students table) StudentID Name Age Gender ProgramID 791 Stephanie Brown 19 Female BCS 236 Shannon Dawn 25 Female BA 618 Geoff Berg 24 Male ARET 256 Andrew Schilling 22 Male BSC 902 Gary Sang 23 Male DAAD Note: There is a StudentDataSet with a Student table, a StudentTableAdapter, a StudentBindingSource, and a StudentDataGridView control on the form.Note: There is an Average query, named Average, that returns the average age of the student from the Student table.Note: There is also Max query, named Highest, that returns the highest age of the student from the Student table.Write the code you would place in the AverageButton click event on your form to call the Average query and the Highest query and display in a DifferenceLabel, the difference between the highest age of a student and the average age.