SQL | 7. which one(s) of the following SQL statements keep(s) the relation definition intactonce executed?a) DELETEb) DROPc) REMOVEd) TRUNCATEe) (a) and (b)f) (a) and (c)g) (a) and (d) h) (b) and (c)i) (b) and (d)j) (c) and (d)8. Which one of the following statements returns the same result no matter howmany times it is executed?a) GETDATE()b) RAND(5) c) RAND()d) DATENAME(year, GETDATE())e) GETUTCDATE()f) MONTH(GETDATE())e) (b) and (c)9. SELECT CHAR(ASCII(CHAR(ASCII('A')))) statement returnsa) nothing. It causes a syntax error.b) 'A'c) 65d) ASCII code of the character 'A'.e) (c) and (d).| 10. print FLOOR(SQRT(5)) statement returnsa) 5.b) 2.c) 3.d) 2.23.e) 25.| 11. Which one of the following do we need to use to retrieve the definition of analready existing relation?a) sp_databaseb) sp_databases c) sp_tabled) sp_tables e) sp_help

| 7. which one(s) of the following SQL statements keep(s) the relation definition intact once executed? c) REMOVE g) (a) and (d) h) (b) and (c) a) DELETE b) DROP d) TRUNCATE e) (a) and (b) f) (a) and (c) i) (b) and (d) j) (c) and (d)

| 7. which one(s) of the following SQL statements keep(s) the relation definition intact once executed? c) REMOVE g) (a) and (d) h) (b) and (c) a) DELETE b) DROP d) TRUNCATE e) (a) and (b) f) (a) and (c) i) (b) and (d) j) (c) and (d)

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

TRUE OR FALSE In the Relational Data Model, Referential Integrity Constraint is a special kind/case of Foreign Key Constraint. Multiple Inheritance happens when a class has more than one sub-class. This problem can be observed in Programming Languages as well. Given two relations named A and B, if we q-JOIN A and B, the maximum number of attributes in the result relation could be (the number of attributes of A) times(*) the number of attributes of B). * in an SQL SELECT statement means “all the tuples”. In relational algebra, Cartesian Product (X) can be implemented using the q-JOIN operator. Cartesian Product ISA q-JOIN where q-condition always evaluates to true. SQL is based on Predicate Calculus. A query in SQL always specifies what should be included in the query result.
Consider the following relational schemaStudent (StudentID, SName, Major, level, age) Class (ClassCode, CName, Room, ProfID) Enrolled (StudentID, ClassCode) Professor (ProfID, ProfName, DeptID) Department (DeptID, DeptName) Write the SQL statements for the following queries: a) Find the class name and name of professor who teach each class. b) Find the names of all Professors who work in the Business department. c) Find the Class information of the classes that have more than 50 students enrolled. d) Find the names of all year level 3 students who are enrolled in a class taught by Professor John e) Find the student name, major, level, and average age for all of the students in each year level.
Write a SQL trigger to carryout the following action: If an account is deleted, then write a trigger to delete thedependent tuple(s) from the depositor table for every owner of the deleted account. Notethat there may be jointly-owned bank accounts. In other words, you are to write a triggerthat performs the exact action of an ON DELETE CASCADE clause of a FOREIGNKEY CONSTRAINT. You must submit both your trigger function definition, and yourtrigger definition
Please produce a set of normalized relations for the following statements.
51. The given SQL statement is intended to either (1) list the customer numbers, customers names, and headquarter cities of customers headquartered in Los Angeles or (2) satisfy the two conditions of having a customer number higher than 1000 and being headquartered in Denver. SELECT CUSTNUM, CUSTNAME, HQCITY FROM CUSTOMER WHERE HQCITY= 'Los Angeles" Which set of lines should be added to the end of the statement to make the statement work as intended? A: (CUSTNUM>1000 AND HQCITY-'Denver'); B: AND (CUSTNUM>1000 AND HQCITY='Denver*); C:OR CUSTNUM>1000 OR HQCITY='Denver": D:OR (CUSTNUM> 1000 AND HQCITY='Denver*);
101. The basic operations that can be performed on relations are a. deletion b. insertion c. modification d. all of above
Identify all the functional dependencies in the following relation with columns A, B, C, and D a.A→B b.A→C c.A→D d.B→A e.B→C f.B→D g.C→A h.C→B i.C→D j.D→A k.D→B l.D→C
This is a database system question regarding SELECT: Which of the following statements is true for SELECT statements in general? a. HAVING is executed before WHERE when running an SQL query b. SELECT is executed before FROM when running an SQL query c. Each SELECT clause must have a WHERE clause as well. d. COUNT(column_name) function returns the number of values in the column, including any NULLs e. HAVING clause specifies a condition for selecting grouped tuples from the GROUP BY clause.
Which of the following functional dependencies are satisfied (and not satisfied) by this relation and Why? (g) AD → BC WHY? (h) D → B WHY? (i) D → C Why? (j) C → D Why?
Execute the following statements using MYSQL: 1. Insert a row with the values (005, "Your name", , "Your Dept", 50000, 40) 2. Create a trigger (model trigger) to ensure that no employee of salary less than 20000 can be inserted in the database. Show the result for your trigger condition by inserting a new row.
12.13 LAB - Select lesson schedule with multiple joins Hello, I need help on this sql query statement. Write a SELECT statement to create a lesson schedule for Feb 1, 2020 with the lesson date/time, student's first and last names, and the horse's registered name. Order the results in ascending order by lesson date/time, then by the horse's registered name. Make sure unassigned lesson times (student ID is NULL) appear in the results. Hint: Perform a join on the LessonSchedule, Student, and Horse tables, matching the student IDs and horse IDs. This is my database... Horse with columns: ID - primary key RegisteredName Breed Height BirthDate Student with columns: ID - primary key FirstName LastName Street City State Zip Phone EmailAddress LessonSchedule with columns: HorseID - partial primary key, foreign key references Horse(ID) StudentID - foreign key references Student(ID) LessonDateTime - partial primary key
(a) What SQL statement would you use to create the table ”staff”, including specifying the primary key? (b) What SQL statement would you use to find out how many lecturers there are in the School of Computing? (c) What SQL statement would you use to list the lecturers of the modules COMP1121 and COMP1211? (d) Write an SQL statement, using the inner join construct, that will, for the lecturer John Smith, list in alphabetical order the students taking any module which he teaches. (e) What information does the output from the following SQL query provide? SELECT Lecturer, COUNT(DISTINCT Student) FROM class INNER JOIN staff ON class.Module = staff.Module WHERE Grade < 40 GROUP BY Lecturer; (f) Write an SQL query which would obtain the following information: for each lecturer, what is the average grade obtained by students across all of the modules which they have taught?