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: The statement y = sortrows(x, 3) arranges the elements of the third column of the table x in an…

A: As per guidelines, only single question is answered at a time, kindly post remaining question…

Q: Average of column table Be sure, the class should have a property to hold the “upper bound” value.

A: The average of a column table in Java is shown in the below steps.

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: SOQL Assignment: You have to write a SOQL Query In which we have to find all the contact whose…

A: Intro: This is Salesforce Object Query Language designed to work with SFDC Database. It can search a…

Q: From the given below URL implements these aggregate functions AVG COUNT FIRST МAX MIN STDDEV SUM…

A: It is defined as a low-level programming language for a computer or other programmable device…

Q: Suppose a qbery sumServ sums the quantities in the CustomerBilltem table and a query sumWaste sums…

A: Given two tables contains an entity each. The sumServ table is used to sum all the quantities in the…

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

A: the answer is:

Q: Explain about in order and post order.

A: Traverse the right subtree, i.e., call Preorder(right-subtree) Uses of Preorder. Preorder traversal…

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: Find the result relation of the above query

A: The Relational is query is a very interesting one. Let's understand step by step. The Infinite…

Q: ult value for table boarders that gives each cell its own boarder

A: Required: Default value for table boarders that gives each cell its own boarder

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: When all the elements you want to query belong to the same namespace, declaring a default element…

Q: 7

A: Here Use the Salesforce Object Query Language (SOQL) to search your organization’s Salesforce data…

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

( Please answer this question immediately I do not have time ) Use the following table to answer the questions below: Table name: Books Column Name Role Data Type Length Constraint bookID Stores the ID of a book Number 5 Primary key bookTitle Stores the title of a book Varchar2 50 - bookISBN Stores the ISBN of a book Number 13 Cannot be null and duplicated publicationDate Store the publication date of a book Date - Cannot be null bookPrice Stores the price of a book Number 2,2 Cannot be null a. Write in SQL a command that creates the table Books according to the above description b. Write in SQL a statement that adds a new column named publisherID of type Char(10). This column should be defined as a foreign key that relates the table Books to the table Publisher c. Write in SQL a command that deletes the books that are published before 20-Aug-2010 d. Write a SQL query that displays the number of books that are published in the year 2018 e. Write in SQL a…
2- selects the order line items (orderNumber, orderlinenumber) fromthe “orderdetails” table. Also, display the subtotal (quantityOrdered * priceEach) for eachline item and sorts the result set based on the subtotal descending .3- Display unique last names from employees table ordered by last name.4- Display customerNumber, customerName and creditLimit for getting the top five customerswho have the highest creditLimit.5- Find customer Name, customer country, sales representative employee number fromcustomers who do not have a sales representative.6- For each order status, display status and count of orders have this status.7- For Each order number in order details table, Display order number, sum of quantityordered (itemsCount) and sum of (priceEach * quantityOrdered) as total. With condition“total” greater than 1000.8- Display product code, product name and text description for product.9- Find customer number, customer name, order status and order number, for customerwith their orders…
If a particular column is not allowed to be null, what is the result if the column is left empty?
Convert the following sets: Y = {Tuesday, Thursday} to rule method
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.
Employee(empno, ename, street, city, mgrssn) work_project(eno, pno, number_of_hours) Write a query and optimize it to find employee name and project number in which they work and who live in "New_york". Identify the type of indexing to be applied on 'empno' in Employee Table.
Employees(employee id, first name, last name, salary, hire date, job title, manager id, department id) Departments(department id, department name, location_ id) Which of the following queries will display the name of all employees who does not work for 'EXECUTIVE' department a.SELECT first name, last name FROM employees WHERE department id not in (SELECT department id FROM departments WHERE upper(department name) = 'EXECUTIVE'); b.SELECT first name, last name FROM employees WHERE department id != (SELECT department id FROM departments WHERE upper(department name) = 'EXECUTIVE'); c.SELECT first name, last name FROM employees WHERE department id = (SELECT department id FROM departments WHERE upper(department name) = 'EXECUTIVE'); %3D d.SELECT first name, last name FROM employees WHERE department id In (SELECT department id FROM departments WHERE upper(department name) = 'EXECUTIVE');
Question 5 Suppose that you have the following table: CREATE TABLE coupons ( coupon id INTEGER name VARCHAR2 (30) duration INTERVAL YEAR (3) TO MONTH Now, considers the following INSERT statement: INSERT INTO coupons (coupon id, name, duration) VALUES (4, 'BD1.5 Corn Flakes, INTERVAL 1- 3 YEAR TO MONTH) The above INSERT statement stores the following data: A. 4 BD1.5 Corn Flakes +000-14 4 BD1.5 Corn Flakes +014-00 4 BD1.5 Corn Flakes +014 None of the above
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%'
SOQL Assignment: You are required to construct a SOQL Query in which we must locate all of the contacts whose accountld is not null and order the first names in descending order in order to complete the assignment.
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!)