QUESTION 18 The maximum value that can be stored by defining an attribute as NUMBER (5,3) is O a. 99.999 O b. 9.999 Oc. 99999.999 O d. 55.333 QUESTION 19 ... will change department ID 20 of employee table to 15. O a. UPDATE Employee SET Department ID = 15 WHERE Department ID = 20; !! UPDATE Employee SET Department ID = 20 WHERE Department ID = 15; Ob. Oc. UPDATE Employee SET Department_ID = 20: Od UPDATE Employee SET Department_ID = 15

QUESTION 18 The maximum value that can be stored by defining an attribute as NUMBER (5,3) is O a. 99.999 O b. 9.999 Oc. 99999.999 O d. 55.333 QUESTION 19 ... will change department ID 20 of employee table to 15. O a. UPDATE Employee SET Department ID = 15 WHERE Department ID = 20; !! UPDATE Employee SET Department ID = 20 WHERE Department ID = 15; Ob. Oc. UPDATE Employee SET Department_ID = 20: Od UPDATE Employee SET Department_ID = 15

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

Similar questions

"3,4,and 5 are answered" as per our policy we are only allowed to solve 3 subparts.kindly reupload rest of the question 3 create table CREATE TABLE table1 ( day varchar(255), client_code varchar(255), client_name varchar(255), team_ID varchar(255), member int, team_leader varchar(255), leader_wage int, total int); Step 2 4.insert data into table INSERT INTO table1 (day,client_code,client_name,team_ID,member,team_leader,leader_wage,total) VALUES ( 'monday','c4','aeliana gebahard','T3','6','jaymes merrickson','350','850'); INSERT INTO table1 (day,client_code,client_name,team_ID,member,team_leader,leader_wage,total) VALUES (' ','c10','alfher dareia','T1','6','geoffrey glover','250','750'); INSERT INTO table1 (day,client_code,client_name,team_ID,member,team_leader,leader_wage,total) VALUES ( ' ','c8','felina diodotus','T2','5','elmer victorson','300','700'); INSERT INTO table1 (day,client_code,client_name,team_ID,member,team_leader,leader_wage,total) VALUES ('…
Q51: Which of the following tables will be the better candidate for Incremental Backup? • Customers • Products • Sales • Employees Q52: When normalizing tables and we say that attribute a determines attribute b we mean that : • When we type in a value for a, we can get multiple values for b • When we type in a value for a, we do not get any values for b • When we type in a value for a, we get one and only one value for b • Attribute a is the parent attribute and attribute b is the child attribute
Write a mysql query to get the answer to the following question using the given tables and data. Which player(s) had the longest reception in the 4th quarter. What team where they on and what year was it? (breaking non-trivial ties is 5 of the 15 points, (i.e 10 points with LIMIT, 15 points without LIMIT) cfb_player has columns player_id, team_id, last_name, first_name cfb_team with columns team_id, year, name, conference_id cfb_reception with columns game_id, team_id, player_id, yards cfb_game with columns game_id, game_date, visit_team_id, home_team_id
Consider these relations:Emp(eid: integer, ename: varchar, sal: integer, age: integer, did: integer)Dept(did: integer, budget: integer, floor: integer, mgr eid: integer) Salaries range from $5K to $50K, ages vary from 16 to 65, each department has aboutfive employees on average, and budgets vary from $10K to $1 million. For each of the following queries, which of the listed index choices would you choose to speed up thequery? Note: index only plan can be used. Query: Find employees who are younger than 18 with salary more than 8K.(a) b and c.(b) Clustered B+ tree index on < age, sal> fields of Emp.(c) Unclustered B+ index on < age, sal> fields of Emp.(d) Clustered B+ tree index on <sal, age> fields of Emp. Query: Find the dids of departments that are on the 10th floor and have a budget of lessthan $15,000.(a) Clustered B+ tree index on <floor, budget> fields of Dept.(b) Clustered hash index on the <budget, floor > fields of Dept.(c) Unclustered hash index…
You are given this table: Registration SID CourseID SemID Instructor Grade 282712 ENGL210 201701 H. Zacny B+ 362112 CS101 201701 K. Ross C 652123 CS403 201701 K. Ross A 362112 CS403 201701 K. Smith C+ 282712 BIO101 201601 I. Olsen C What will the result of the following query be? select sid, count(*)from registrationgroup by sid Select one: a. The entire table sorted by sid b. No results due to an error c. 282712 2362112 2652123 1 d. 282712 1362112 1652123 1
You are given the schema of a table with its columns inside the bracket as follows: STUDENT(Name, Student_id, Major, Marks, Email) (The Primary Key is underlined) Write an SQL query for the following tasks: (Hint: the queries are nested) 1. Write an SQL query to retrieve the name, student id and the maximum marks of students of each major where that maximum marks is greater than all students with CS major. 2. Write an SQL query to retrieve the name, student id and the maximum marks of students with ECE major where that maximum marks is greater than all students with CS major.
DATABASE SQL PLEASE DO NOT COPY AND PASTE FROM PREVIOUS ANSWERS TABLES: drop table tech_supplier cascade constraints;drop table teacher cascade constraints;drop table student cascade constraints;drop table tablet cascade constraints;drop table tablet_amountstatus cascade constraints;create table tech_supplier(supplier_id number(5) primary key,supplier_name varchar2(15),address varchar2(15));insert into tech_supplier values(201,'ali','Amman');insert into tech_supplier values(202,'omar','Zarqa');insert into tech_supplier values(203,'hend','Irbid');insert into tech_supplier values(204,'bana','Amman');insert into tech_supplier values(205,'zaid',null);-----------------------------------------------------------------------------------------------------------------------create table teacher(id number(5) primary key,name varchar2(15),specialty varchar2(25));insert into teacher values(121,'said','physics');insert into teacher values(122,'reem','math');insert into teacher…
DATABASE SQL PLEASE DO NOT COPY AND PASTE FROM PREVIOUS ANSWERS TABLES: drop table tech_supplier cascade constraints;drop table teacher cascade constraints;drop table student cascade constraints;drop table tablet cascade constraints;drop table tablet_amountstatus cascade constraints;create table tech_supplier(supplier_id number(5) primary key,supplier_name varchar2(15),address varchar2(15));insert into tech_supplier values(201,'ali','Amman');insert into tech_supplier values(202,'omar','Zarqa');insert into tech_supplier values(203,'hend','Irbid');insert into tech_supplier values(204,'bana','Amman');insert into tech_supplier values(205,'zaid',null);-----------------------------------------------------------------------------------------------------------------------create table teacher(id number(5) primary key,name varchar2(15),specialty varchar2(25));insert into teacher values(121,'said','physics');insert into teacher values(122,'reem','math');insert into teacher…
how could this sql code alwasy shows "missing right parenthesis"???? its surely have parenthesis. CREATE TABLE lifeexpahelp( REF_DATE varchar(10), GEO varchar(10), DGUID varchar(10) DEFAULT '', Sex varchar(12), Life_Expectancy varchar(12), UOM varchar(10), UOM_ID int, SCALAR_Factor varchar(10), Scalar_ID int, Vector varchar(12), Coordinate varchar(10), Value int, Status varchar(10) default '', Symbol varchar(10) default '', Terminated varchar(10) deafult '', decimals int ); decimals int )Error report -ORA-00907: missing right parenthesis00907. 00000 - "missing right parenthesis"*Cause: *Action:
Having 3 tables with the following sturucture (see image). Write MYSQL code for the following: (1) Which courses (course name, course credits) have been taken by the student with student ID 861103-2438? (2) For students who have registered courses, how many credits has each student taken? In the query result, list student ID, student first name, student last name, and his/her credits. (3) First define a view that gives the student ID, student last name, student first name, and the grade average for each student who has registered courses. Then use the view to find which students have the highest grade average.
In the query below, what does AUTOINCREMENT do? Why is it used? CREATE TABLE Worker ( WORKER_ID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, FIRST_NAME TEXT, LAST_NAME TEXT, SALARY INTEGER(15), JOINING_DATE DATETIME, DEPARTMENT CHAR(25));
Closely examine the following tables and use it to answer the questions that follow:departmentstudent_type student_categorycourseStudentregistration registration_typeSuppose that the following are true:- all id column are primary keys in whichever table they are- the dept_id in course table is foreign key that is referencing the id column in the department table- the foreign keys stud_type_id, stud_cat_id in the student table are referencing the id columnsin the student_type and student_category tables respectively.- the coursecode and stud_id columns in the registration table are foreign keys in the courseand student tables respectively.1. Design an Entity Relationship Diagram for the system above.2. Write query that would return the names and contacts of all Local students.3. Write a query that would return names, contact and locations of all departments that has alocation text with Ave 3 as part of it. [hint: use the LIKE clause with “_” or “%”]4. What would be the result returned…