Question 2 Which of the following is true about MYSQL PDO Transaction? [You can choose more than one answer] A) It's used to support payments for online transactions. B) It can be used to ensure that several related SQLS should be executed successfully. It has the capability of rolling back to initial state in case one of the SQL has failed. D) All are valid

Question 2 Which of the following is true about MYSQL PDO Transaction? [You can choose more than one answer] A) It's used to support payments for online transactions. B) It can be used to ensure that several related SQLS should be executed successfully. It has the capability of rolling back to initial state in case one of the SQL has failed. D) All are valid

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

A select operation in a relational database decreases the size of a table by removing columns that fulfill certain criteria.Is this statement truthful or false?
Q1) Consider the employees database , where the primary keys are underlined. Give an expression in SQL for each of the following queries. Employee(ID, name, age, address, salary, departmet, position, ministry_name) Ministry(ministry name, address,No_of_employee, No_of_dept., category) 1- Find all employees who work as manger in ministery of foreign affairs or ministry of education and their salary greater than 40. 2- Find the adress of employees who have salary between 15000 and 20000 and work as a driver in ministries that have more than 50 employees. 3- delete the all munisteries that have more that 6 deparments and 70 employees
b) Consider the relational table PARTSUPP of the TPCHR sample database. Find SELECT statements that will use the index in the ways specified in the questions (i) to (iv) below. The values used to create the query such that the queries can meet the specified criteria is up to you, but the values must be sensible. i. ii. iii. iv. Execution of the first SELECT statement must traverse the index vertically then horizontally and it must not access the relational table PARTSUPP. Execution of the second SELECT statement must traverse the index vertically then horizontally and it must access the relational table PARTSUPP. Execution of the third SELECT statement must traverse the leaf level of the index horizontally and it must not access the relational table PARTSUPP. Execution of the fourth SELECT statement must traverse the leaf level of the index horizontally and it must access the relational table PARTSUPP. Deliverables Submit your spooled file solution 1b.lst (or solution 1b.pdf) that…
Simplify the following query (WHERE clause), expressed in SQL, on the example database above: SELECT ENAME, PNAME FROM EMP, ASG, PROJ WHERE (DUR > 12 OR RESP = "Analyst") AND EMP.ENO = ASG.ENO AND (TITLE = "Elect. Eng." OR ASG.PNO < "P3") AND (DUR > 12 OR RESP NOT= "Analyst") AND ASG.PNO = PROJ.PNO
3. The following relational schema form a university database which is implemented in a relational database: student (s ID, s_name, semester, year) department(d_ID, d_name, floor) course (c_code, c_title, d_ID, credits) Write down the SQL commands for the following queries: a) Find the titles of all courses from your own CSE department using subquery. b) Show the department names starting with “C" and ending with “g". c) Sort the number of courses for each department in a descending order. d) Insert your own information into the student table.
1. Discuss the various PL/ SQL scalar data types available to store specific kinds of data with the use of examples.
A select operation in a relational database reduces the size of a table by removing columns that meet particular criteria.Is this true or false?
PL/SQL stands for Procedural Language/SQL, and it is an extension of the SQL language. (a) Name and explain THREE important features that are offered by PL/SQL blocks. (b) PL/SQL supports two types of subprogrammes; Procedures; and functions. Define Procedures and describe their TWO advantages.
(a) With the aid of a practical example (two tables), explain the SQLstatement below:SELECT FIRST_NAME, LAST_NAME, SCHOOL_FEE4FROM STUDENT, FEE_PAYMENTWHERE STUDENT.STUDENT_ID = FEE_PAYMENT.STUDENT_IDORDER BY FIRST_NAME
Write SQL update statements to do the following on the database schema shown in Figure 1.i. Insert a new course, <‘Knowledge Engineering’, ‘CS4390’, 3, ‘CS’>.ii. Delete the record for the student whose name is ‘Smith’ and whose student number is 17.
name PERSON address salary fee EMPLOYEE STUDENT thesis RESEARCH TEACHING POST GRAD UNDER GRAD Year = 4 FINAL YEAR LECTURER TUTOR SUPERVISOR project courseno PART II: University Database in MYSQL • Create a database and its tables and constraints based on the relational model of PART I. • You can use my slides and any other resources to complete this exercise. • Submit the SQL statements you used to create the database and its tables (you can copy/paste directly from the mysql console).
How does the SQL ORDER BY clause work, and why might it be important when using database functions like MAX() or MIN()? Provide a query illustrating its usage.