You attempt to insert today's date (which happens to be September 2, 2022) using the built-in function sysdate to put a value into an attribute of a table on the class server with an Oracle built in data type of date. What is actually stored? Choose the best answer. a) Values corresponding to the date of September 2, 2022 and a time value corresponding to 5 minutes and 13 seconds after 11 AM in all appropriate datetime fields of the 7-field object that is available for every Oracle field typed as date (where the insert action took place at 11:05:13 AM server time. b) Nothing, the insert throws an exception that says something about a non-numeric character found where a numeric was expected. c) Nothing, the insert throws an exception that says something else. d) There is an error message because the built-in function is system_date. e) values corresponding to the date of September 2, 2022 in 3 of 7 available datetime fields of the 7-field object that is available for every Oracle field typed as date, nothing in the other available fields

You attempt to insert today's date (which happens to be September 2, 2022) using the built-in function sysdate to put a value into an attribute of a table on the class server with an Oracle built in data type of date. What is actually stored? Choose the best answer. a) Values corresponding to the date of September 2, 2022 and a time value corresponding to 5 minutes and 13 seconds after 11 AM in all appropriate datetime fields of the 7-field object that is available for every Oracle field typed as date (where the insert action took place at 11:05:13 AM server time. b) Nothing, the insert throws an exception that says something about a non-numeric character found where a numeric was expected. c) Nothing, the insert throws an exception that says something else. d) There is an error message because the built-in function is system_date. e) values corresponding to the date of September 2, 2022 in 3 of 7 available datetime fields of the 7-field object that is available for every Oracle field typed as date, nothing in the other available fields

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter3: Performing Calculations With Formulas And Functions

Section: Chapter Questions

Problem 3.15CP

See similar textbooks

Similar questions

In java create an application to manage your data base information the database is already created in mysql tables, the tables are fill, So the user can use your database application user friendly Retrieve all data: Given a table name, retrieve all data from the table and present it to the user. Average: Given a table name and a column name, return the average of the column. Here the assumption is that the column type will be numeric (e.g., cost column). Insert: Given a table name, your program should show the column names of that table and ask the users to input new data to the table. In case of errors, your program should directly show the MySQL errors to the users. Assumption 1: Users will enter data according to the database constraints. Assumption 2: Users will input one record at a time. Delete: Given a table name, your program should show the column names of that table and ask the users to input data that they want to delete. Assumption 1: Users will enter data according to the…
When the Search button is pressed in the screen depicted, the getSales() function from the PosDAO.java class is called, the parameters of this function are the from date and to date.The getSales () function should return a list of Pos objects that matches the criteria specified, Note this function has to perform two INNER JOINs in to combine all three tables in order to get all the needed data to fill the Pos object. The database schema is also depicted. The PosDAO, Product, SalesDetails and Pos classes are shown BELOW Write the getSales() function public class PosDAO { private Connection conn; PreparedStatement stmt = null; public boolean openConnection(){ try { // db parameters String url = "jdbc:mysql://localhost:4306/swen2005"; String user = "root"; String password = ""; // create a connection to the database conn = DriverManager.getConnection(url, user, password); if (conn!= null){ return true;…
Which of the following statement(s) is(are) correct? Group of answer choices Both a. and b. Neither a. nor b. a. The default cut-off value in two-class classifiers is 0.5. b. The cut-off value can be adjusted to accept more records in high value class and to accept more misclassification errors where the misclassification error is low.
Create a Client class that interacts with an SQLDatabase Server (provided below). The Client sends a SQLQuery to the SQLDatabase and receives a Dataframe from the SQLDatabase. The class should contain the default __dunders__ and potentially introduce some custom __dunders__. The SQLDatabase Server: import pandas as pd import sqlite3 class Server: def __init__(self, database): self.conn = sqlite3.connect(database) def __enter__(self): return self def __exit__(self, exc_type, exc_val, exc_tb): self.conn.close() def __repr__(self): return f"Server({self.conn})" def execute_query(self, query): cursor = self.conn.cursor() cursor.execute(query) columns = [desc[0] for desc in cursor.description] results = cursor.fetchall() df = pd.DataFrame(results, columns=columns) cursor.close() return df
This is an ITSE1303 class,using My SQL workbench, Import the following database: CREATE DATABASE COUNTRIES; USE COUNTRIES; DROP TABLE IF EXISTS `City`; CREATE TABLE `City` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `Name` char(35) NOT NULL DEFAULT '', `CountryCode` char(3) NOT NULL DEFAULT '', `District` char(20) NOT NULL DEFAULT '', `Population` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM AUTO_INCREMENT=4080 DEFAULT CHARSET=latin1; -- -- Dumping data for table `City` -- -- ORDER BY: `ID` INSERT INTO `City` VALUES (1,'Kabul','AFG','Kabol',1780000); INSERT INTO `City` VALUES (2,'Qandahar','AFG','Qandahar',237500); INSERT INTO `City` VALUES (4,'Mazar-e-Sharif','AFG','Balkh',127800); INSERT INTO `City` VALUES (5,'Amsterdam','NLD','Noord-Holland',731200); INSERT INTO `City` VALUES (6,'Rotterdam','NLD','Zuid-Holland',593321);(3068,'Berlin','DEU','Berliini',3386667); INSERT INTO `City` VALUES (3069,'Hamburg','DEU','Hamburg',1704735); INSERT INTO `City` VALUES…
Write a script that creates and calls a stored function named TotalOrders that calculates the total number of orders in the orders table. To do that, this function should not accept any parameter, and it should return the total number of orders in the orders table. Call the function from an anonymous block. Add SQL statement(s) that will display current date and your name and student ID in the format specified below. Your anonymous block must include exception handling.
Call the function from a PROCEDURE. Name the procedure findDiscPrice. Allow the user to pass a parameter customer ID (customer_id) to the procedure. Calculate and display the new item price for the customer similar to the example below. Assume we will call the procedure from the following Anonymous Block begin findDiscPrice (1); findDiscPrice (2); findDiscPrice (3); end; Expected output: Customer Doctor Who new item price is 990 Customer Harry Potter new item price is 40 Customer Captain Awesome new item price is 2400
Write a program (call it chr21_gene_names.py) that asks the user to enter a gene symbol and then prints the description for that gene based on data from the chr21_genes.txt file. The program should give an error message if the entered symbol is not found in the table (the user should should not have to worry about case, i.e. it will be a case-insensitive search). The program should continue to ask the user for genes until "quit" or "exit" is given (case-insensitive). Make sure to prompt the user to enter the quit to end the program. Use Dictionaries to solve this problem.HINT: Feel free to use as Dictionary of Dictionaries, but it is not required. HINT: First read the entire text file into a Dictionary that maps the association between gene symbol and description. Once again, make sure to use a Dictionary. Remember to have these command line options: $ python3 chr21_gene_names.py -h usage: chr21_gene_names.py [-h] -i INFILE Open chr21_genes.txt, and ask user for a gene name optional…
In Python, create a Server Class that enables interaction with a SQLDatabase. The users of your SQLDatabase server can send SQLQueries to the SQLDatabase. The SQLDatabase handles the SQLQuery and retrieves the Query's data in a DataFrame format. Your class should incorporate the default __dunders__ (underscores) and may also include additional custom __dunders__.
18. What is the best data type definition for Oracle when a field is alphanumeric and has a length that can vary? a. VARCHAR2 b. CHAR c. LONG d. NUMBER
Create a function in your own database that takes two parameters: A year parameter A month parameter The function then calculates and returns the total sales of the requested period for each territory. Include the territory id, territory name, and total sales dollar amount in the returned data. Format the total sales as an integer. Hints: a) Use the TotalDue column of the Sales.SalesOrderHeader table in an AdventureWorks database for calculating the total sale. b) The year and month parameters should have the SMALLINT data type.
a. Software Engineering Research Group (SERG) IIUM is organizing a programming competition. Students are allowed to use either Python or C++ programming language for the competition. Student who wishes to opt for Python goes into lab 1 while for C++ in lab 2. The seating arrangement is based on question ID. The number of students that registered for the competition are 10 students only. Each lab has capacity of 13 students. You are required to create a hash table to indicate where each student with the following question IDs (keys) be hashed/mapped to in the slot of the lab (hash table). IDs = {41, 28, 54, 18, 36, 10, 90, 12, 38, 25} using the hash function, h1(ID) = (ID) % lab capacity Show all your calculations and indication to where the values are being hashed.