W01 Syllabus Quiz
.pdf
keyboard_arrow_up
School
Singapore University of Social Sciences *
*We aren’t endorsed by this school
Course
225
Subject
Computer Science
Date
Apr 30, 2024
Type
Pages
2
Uploaded by IshopThereforeIam on coursehero.com
ITM 220 SQL W01 Syllabus Quiz Due Apr 28 at 1:59pm Points 10 Questions 5 Time Limit 30 Minutes Allowed Attempts 2 Instructions Overview This quiz focuses on the course syllabus. Task: o Take the five-question quiz. e There are two attempts on the quiz and 30 minutes per attempt. Testing Topics: e The ITM 220 course syllabus Attempt History Attempt Time Score KEPT Aftempt 2 6 minutes 10 out of 10 LATEST Attempt 2 6 minutes 10 out of 10 Attempt 1 3 minutes 9 out of 10 (@ Correct answers are hidden. Score for this attempt: 10 out of 10 Submitted Apr 22 at 1:55pm This attempt took 6 minutes. Question 1 2/2pts A course outcome should be that you understand how convert SQL dialects? True
False Question 2 2/2pts A course outcome should be that you understand how to design and model a database. True False Question 3 2/2pts A course outcome should be that you understand how to use which of the following types of commands? (Multiple answers possible.) Data Definition Language (DDL) Data Manipulation Language (DML) Data Control Language (DCL) Transaction Control Language (TCL) None of the above. Question 4 2/2pts You should read the textbook chapters and slides before the middle of each week. True False Question 5 2/2pts A course outcome should be that you understand how to use basic Data Manipulation Language (DML) commands? True False Quiz Score: 10 out of 10
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
Consider the following PL/SQL script:
SET SERVEROUTPUT ON
BEGIN
INSERT INTO COURSE
(course_no, description, created_by, created-date, modified_by, modified_date)
VALUES
(course_no_seq.nextval, ‘database development’, USER, SYSDATE);
COMMIT
DBMS_OUTPUT.PUT_LINE (‘One course has been added’);
END;
Assumptions: All the COURSE table fields have check constraints defined on them indicating that none can be null.
Explain why the script does not execute successfully.
Add a user-defined exception to the script, so that the error generated by the INSERT statement is handled. Assign the code 2290 to this exception.
arrow_forward
Develop a C++ program to connect to a MS Access database (“Student.accdb” – attached to this assignment) and use SQL commands to manipulate its records. You may use MS Access, SQLite or another DB engine and drivers.
Scope
The user will be given a menu to choose from the following options:
Press (S) to select and display all students records
Press (D) to delete a student by ID#
Press (U) to update a student’s graduation year
Press (I) to insert a new student
Press (Q) to quit
For user option# 1, first display the header and then display every record on a separate line. See example below
Student ID
First Name
Last Name
Major
Graduation Year
1
Joe
Doe
Computer Science
2018
2
Emma
Smith
Electrical Engineering
2019
3
Juan
Perez
Marketing
2019
For user option#2, confirm back to the user whether the deletion was successful or the ID provided was not found in the students records.
For user option#3, prompt the user to enter a student ID, validate if the student ID exists…
arrow_forward
This assignment is aimed at building an understanding of how to improve performance within databases by taking advantage the computers hardware by modifying MS SQL settings
Prerequisites:
Completion of Assignment 1B, reading of Module Readings and Slides.
Run the following query to understand how much Memory is currently in use in the database:
SELECT
physical_memory_in_use_kb/1024 AS sql_physical_memory_in_use_MB,
large_page_allocations_kb/1024 AS sql_large_page_allocations_MB,
locked_page_allocations_kb/1024 AS sql_locked_page_allocations_MB,
virtual_address_space_reserved_kb/1024 AS sql_VAS_reserved_MB,
virtual_address_space_committed_kb/1024 AS sql_VAS_committed_MB,
virtual_address_space_available_kb/1024 AS sql_VAS_available_MB,
page_fault_count AS sql_page_fault_count,
memory_utilization_percentage AS sql_memory_utilization_percentage,
process_physical_memory_low AS sql_process_physical_memory_low,
process_virtual_memory_low AS…
arrow_forward
Database Transactions can occur concurrently by several users. This can cause issues with data consistency. To help resolve this problem, RDBMS can implement Read Consistency.
Q4. What is Read Consistency?
Q5. What are two problems that could occur without data/read consistency?
1.
2.
Q6. What is Data Locking and how/why is it used?
Q7. Please review the following SQL statements and answer the following questions.
On which line does the first commit occur?
Is this first commit implicit or explicit?
Which SQL DML statement is rolled back when line 12 is run?
Which SQL DML statement is committed on line 16?
Is the commit in line 16 implicit or explicit?
Assume 10 of the ‘SA_REP’ employees start with a salary of 1000.00. What is their salary when 17 is run?
NOTE: For those of you who are familiar with programming, assume there is no infinite loop here.
1 select * from employees;
2 DROP TABLE Employee_Project_Assignment;
3 UPDATE employees
4 SET salary…
arrow_forward
Using MySQL workbench to create a database with six tables. You need to set up primary key andforeign key each table. Make two lines of contents for each table. The export as a SQL file.In Tape table, set foreign key C_number with on update cascade, on delete set null. Set foreign keyM_number with on update cascade and on delete cascade. Remember don’t set customer number andmovie number as required (not null) if you want to set them as null when needed.In Movie table, set the foreign key D_number with on update cascade, on delete set nullIn Played_In, set two foreign keys with on update cascade and on delete cascade.Add one row of data in each table.Export the SQL file
arrow_forward
5. CRUD operations are used in persistent storage applications, meaning these applications will keep their data even after the system powers down. Explain what the CRUD operations are and provide an SQL state as an example for each CRUD operation.
arrow_forward
1. What are the three stages during the startup of an Oracle database? If a copy of the control file is corrupted, which stage of the startup would fail? Briefly explains why.
2. What are the SQL statements to perform the following tasks?
Create a smallfile tablespace Hw2Tbs that contains a 32MB datafile in the directory C:\app\abc\oradata\csc544744\myData
Add another 8MB to tablespace Hw2Tbs
arrow_forward
IN MYSQL write the command.
Using the UML designed create all the necessary tables for your database system.
Write the update, insert, select, and delete statements for each table.
arrow_forward
I got this error when running code:
DBMS_OUTPUT.PUT_LINE('Job Title: ' || Emp_rec.Job_Title); *ERROR at line 24:ORA-06550: line 24, column 49:PLS-00302: component 'JOB_TITLE' must be declaredORA-06550: line 24, column 3:PL/SQL: Statement ignored
arrow_forward
MC 2 .
Write an Anonymous PL/SQL block that will insert five records into the database; the records must include the "jpeg" binary files that contains the photographs associated with each record. One technique would be,
Create BFILE locators for each of the image files
Create 5 INSERT statements into the table
CREATE TABLE StudentRecord (
FirstName VARCHAR2 (20) NOT NULL,
LastName VARCHAR2 (40) NOT NULL,
HomeworkAvg NUMBER(10,2),
AttendanceAvg NUMBER (20,2),
ExamAvg NUMBER (10,2),
StudentID VARCHAR2 (10),
arrow_forward
Q1.) An integrity constraint is a rule that:
a. is kept in an external file
b. must be followed by data in the database
c. can be accessed by authorized users
d. can unintentionally be accessed by unauthorized users
Q2. __ is a property that lets you change the structure of the database without requiring you to change the programs that access the database.
a. Database design
b. Data independence
c. Integrity constraint
d. Data dependence
Q3. The basic form of an SQL retrieval command is:
a. SELECT-WHERE-FROM
b. CREATE-SELECT-FROM
c. SELECT-WHERE
d. SELECT-FROM-WHERE
Q4. Which of the following queries will list the number, name, credit limit, and balance for all customers with credit limits that exceed their balances.
a. SELECT CustomerNum, CustomerName FROM Customer WHERE CreditLimit>Balance ;
b. SELECT CustomerNum, CustomerName, CreditLimit, Balance FROM Customer WHERE CreditLimit>Balance ;
c. SELECT…
arrow_forward
65.
_________ dump schemes have been developed that allow transactions to be active while the dump is in progress.
a.
Archival
b.
Fuzzy
c.
SQL
d.
All of the mentioned
arrow_forward
169.
Each tablespace in an Oracle database consists of one or more files called
a.
Files
b.
name space
c.
datafiles
d.
PFILE
arrow_forward
Hey experts, please help me out on this :( xx
Sample database:
For all the implemented tasks, your report or output must include a listing of all PL/SQL statements processed. To achieve that put the following SQL*Plus commands in all your scripts:SPOOL file-nameSET ECHO ONSET FEEDBACK ONSET LINESIZE 100SET PAGESIZE 200SET SERVEROUTPUT ONat the beginning of SQL script andSPOOL OFFat the end of SQL script.
arrow_forward
In Python code:
Process: The user (client) requests data from the (server) database. The database sends back the data to the user. At acquisition of the data an XYPlot is drawn.
DataFile: USAStates2020.csv
User Layer:The user selects a country, and passes the country name to the Business Layer. Use TKinter to produce a UI for the user to select a country. Send the selected country to the Business Layer.
Business Layer:Receives the information from the User Layer and constructs a SQL query to send to the Data Layer. The query extracts the yearly data (1970,2020) for the requested country. The data may be queried either country year-by-year or in one query for year range. After receiving the JSON string back from the Data Layer, send the data to the Graphic Layer for plotting.
Data Layer:Construct a SQL Database based on the data from the DataFile. Processes the queries from the Business Layer. Sends back a JSON string for the requested query.
Graphic Layer:Create a graphics…
arrow_forward
(TCOs 4, 5) Address each of the following:Describe which SQL commands you would use and how you would use them to (a) build a database;(b) enter data into a database; and(c) verify that the database is correct.
arrow_forward
Access Assignment
Problem: JMS TechWizards is a local company that provides technical services to several small businesses in the area. The company currently keeps its technicians and clients’ records on papers. The manager requests you to create a database to store the technician and clients’ information.
The following table contains the clients’ information.
Client Number
Client Name
Street
City
State
Postal Code
Telephone Number
Billed
Paid
Technician Number
AM53
Ashton-Mills
216 Rivard
Anderson
TX
78077
512-555-4070
$315.50
$255.00
22
AR76
The Artshop
722 Fisher
Liberty Corner
TX
78080
254-555-0200
$535.00
$565.00
23
BE29
Bert's Supply
5752 Maumee
Liberty Corner
TX
78080
254-555-2024
$229.50
$0.00
23
DE76
D & E Grocery
464 Linnell
Anderson
TX
78077
512-555-6050
$485.70…
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Enhanced Discovering Computers 2017 (Shelly Cashm...
Computer Science
ISBN:9781305657458
Author:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher:Cengage Learning
Related Questions
- Consider the following PL/SQL script: SET SERVEROUTPUT ON BEGIN INSERT INTO COURSE (course_no, description, created_by, created-date, modified_by, modified_date) VALUES (course_no_seq.nextval, ‘database development’, USER, SYSDATE); COMMIT DBMS_OUTPUT.PUT_LINE (‘One course has been added’); END; Assumptions: All the COURSE table fields have check constraints defined on them indicating that none can be null. Explain why the script does not execute successfully. Add a user-defined exception to the script, so that the error generated by the INSERT statement is handled. Assign the code 2290 to this exception.arrow_forwardDevelop a C++ program to connect to a MS Access database (“Student.accdb” – attached to this assignment) and use SQL commands to manipulate its records. You may use MS Access, SQLite or another DB engine and drivers. Scope The user will be given a menu to choose from the following options: Press (S) to select and display all students records Press (D) to delete a student by ID# Press (U) to update a student’s graduation year Press (I) to insert a new student Press (Q) to quit For user option# 1, first display the header and then display every record on a separate line. See example below Student ID First Name Last Name Major Graduation Year 1 Joe Doe Computer Science 2018 2 Emma Smith Electrical Engineering 2019 3 Juan Perez Marketing 2019 For user option#2, confirm back to the user whether the deletion was successful or the ID provided was not found in the students records. For user option#3, prompt the user to enter a student ID, validate if the student ID exists…arrow_forwardThis assignment is aimed at building an understanding of how to improve performance within databases by taking advantage the computers hardware by modifying MS SQL settings Prerequisites: Completion of Assignment 1B, reading of Module Readings and Slides. Run the following query to understand how much Memory is currently in use in the database: SELECT physical_memory_in_use_kb/1024 AS sql_physical_memory_in_use_MB, large_page_allocations_kb/1024 AS sql_large_page_allocations_MB, locked_page_allocations_kb/1024 AS sql_locked_page_allocations_MB, virtual_address_space_reserved_kb/1024 AS sql_VAS_reserved_MB, virtual_address_space_committed_kb/1024 AS sql_VAS_committed_MB, virtual_address_space_available_kb/1024 AS sql_VAS_available_MB, page_fault_count AS sql_page_fault_count, memory_utilization_percentage AS sql_memory_utilization_percentage, process_physical_memory_low AS sql_process_physical_memory_low, process_virtual_memory_low AS…arrow_forward
- Database Transactions can occur concurrently by several users. This can cause issues with data consistency. To help resolve this problem, RDBMS can implement Read Consistency. Q4. What is Read Consistency? Q5. What are two problems that could occur without data/read consistency? 1. 2. Q6. What is Data Locking and how/why is it used? Q7. Please review the following SQL statements and answer the following questions. On which line does the first commit occur? Is this first commit implicit or explicit? Which SQL DML statement is rolled back when line 12 is run? Which SQL DML statement is committed on line 16? Is the commit in line 16 implicit or explicit? Assume 10 of the ‘SA_REP’ employees start with a salary of 1000.00. What is their salary when 17 is run? NOTE: For those of you who are familiar with programming, assume there is no infinite loop here. 1 select * from employees; 2 DROP TABLE Employee_Project_Assignment; 3 UPDATE employees 4 SET salary…arrow_forwardUsing MySQL workbench to create a database with six tables. You need to set up primary key andforeign key each table. Make two lines of contents for each table. The export as a SQL file.In Tape table, set foreign key C_number with on update cascade, on delete set null. Set foreign keyM_number with on update cascade and on delete cascade. Remember don’t set customer number andmovie number as required (not null) if you want to set them as null when needed.In Movie table, set the foreign key D_number with on update cascade, on delete set nullIn Played_In, set two foreign keys with on update cascade and on delete cascade.Add one row of data in each table.Export the SQL filearrow_forward5. CRUD operations are used in persistent storage applications, meaning these applications will keep their data even after the system powers down. Explain what the CRUD operations are and provide an SQL state as an example for each CRUD operation.arrow_forward
- 1. What are the three stages during the startup of an Oracle database? If a copy of the control file is corrupted, which stage of the startup would fail? Briefly explains why. 2. What are the SQL statements to perform the following tasks? Create a smallfile tablespace Hw2Tbs that contains a 32MB datafile in the directory C:\app\abc\oradata\csc544744\myData Add another 8MB to tablespace Hw2Tbsarrow_forwardIN MYSQL write the command. Using the UML designed create all the necessary tables for your database system. Write the update, insert, select, and delete statements for each table.arrow_forwardI got this error when running code: DBMS_OUTPUT.PUT_LINE('Job Title: ' || Emp_rec.Job_Title); *ERROR at line 24:ORA-06550: line 24, column 49:PLS-00302: component 'JOB_TITLE' must be declaredORA-06550: line 24, column 3:PL/SQL: Statement ignoredarrow_forward
- MC 2 . Write an Anonymous PL/SQL block that will insert five records into the database; the records must include the "jpeg" binary files that contains the photographs associated with each record. One technique would be, Create BFILE locators for each of the image files Create 5 INSERT statements into the table CREATE TABLE StudentRecord ( FirstName VARCHAR2 (20) NOT NULL, LastName VARCHAR2 (40) NOT NULL, HomeworkAvg NUMBER(10,2), AttendanceAvg NUMBER (20,2), ExamAvg NUMBER (10,2), StudentID VARCHAR2 (10),arrow_forwardQ1.) An integrity constraint is a rule that: a. is kept in an external file b. must be followed by data in the database c. can be accessed by authorized users d. can unintentionally be accessed by unauthorized users Q2. __ is a property that lets you change the structure of the database without requiring you to change the programs that access the database. a. Database design b. Data independence c. Integrity constraint d. Data dependence Q3. The basic form of an SQL retrieval command is: a. SELECT-WHERE-FROM b. CREATE-SELECT-FROM c. SELECT-WHERE d. SELECT-FROM-WHERE Q4. Which of the following queries will list the number, name, credit limit, and balance for all customers with credit limits that exceed their balances. a. SELECT CustomerNum, CustomerName FROM Customer WHERE CreditLimit>Balance ; b. SELECT CustomerNum, CustomerName, CreditLimit, Balance FROM Customer WHERE CreditLimit>Balance ; c. SELECT…arrow_forward65. _________ dump schemes have been developed that allow transactions to be active while the dump is in progress. a. Archival b. Fuzzy c. SQL d. All of the mentionedarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781285196145Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos CoronelPublisher:Cengage Learning
- Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781285867168Author:Ralph Stair, George ReynoldsPublisher:Cengage LearningEnhanced Discovering Computers 2017 (Shelly Cashm...Computer ScienceISBN:9781305657458Author:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. CampbellPublisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Enhanced Discovering Computers 2017 (Shelly Cashm...
Computer Science
ISBN:9781305657458
Author:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher:Cengage Learning