W01 Syllabus Quiz

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.

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…

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…

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…

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

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.

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

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.

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

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),

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…

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

169. Each tablespace in an Oracle database consists of one or more files called a. Files b. name space c. datafiles d. PFILE

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.

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…

(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.

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…