19. Which of the following shows One to Many relationship?O A.B.One user has one set of user settings. One set of user settings is associated with exactly one user.A customers can purchase different products and products can be purchased by different customers.One school can have many phone numbers but a phone number belongs to one school.C.20. To declare a primary key go tocolumn, then choose Primary Key.A.AttributesB.NullO C.IndexD.Type21. Which among the string data type requires to specify the length the field can hold?A.VARCHARB.BLOBC.LONGBLOBD.TEXT22. If Product Code is 78178, it can be declared using the following data type exceptI. INTII. TINYINTIII. BIGINTIV. SMALLINTOA.I AND IIIB.II AND IVC.II ONLYO D.II AND III23. In $x= new mysqli("localhost","root","","student"); What is the username?"1"O A.B.studentO c.localhostroot

19 ) One to Many relationship are : one school can have many phone numbers but a phone number…

19. Which of the following shows One to Many relationship? O A. One user has one set of user settings. One set of user settings is associated with exactly one user. О в. A customers can purchase different products and products can be purchased by different customers. O C. One school can have many phone numbers but a phone number belongs to one school. 20. To declare a primary key go to column, then choose Primary Key. O A. Attributes OB. Null 0 с. Index O D. Type 21. Which among the string data type requires to specify the length the field can hold? OA. VARCHAR О в. BLOB O C. LONGBLOB D. TEXT 22. If Product Code is 78178, it can be declared using the following data type except I. INT II. TINYINT III. BIGINT IV. SMALLINT O A. I AND III O B. II AND IV 0 с. II ONLY O D. II AND III ** H 23. In $x= new mysqli("localhost","root"," ,"student"); What is the username? O A. OB. student 0 с. localhost root

19. Which of the following shows One to Many relationship? O A. One user has one set of user settings. One set of user settings is associated with exactly one user. О в. A customers can purchase different products and products can be purchased by different customers. O C. One school can have many phone numbers but a phone number belongs to one school. 20. To declare a primary key go to column, then choose Primary Key. O A. Attributes OB. Null 0 с. Index O D. Type 21. Which among the string data type requires to specify the length the field can hold? OA. VARCHAR О в. BLOB O C. LONGBLOB D. TEXT 22. If Product Code is 78178, it can be declared using the following data type except I. INT II. TINYINT III. BIGINT IV. SMALLINT O A. I AND III O B. II AND IV 0 с. II ONLY O D. II AND III ** H 23. In $x= new mysqli("localhost","root"," ,"student"); What is the username? O A. OB. student 0 с. localhost root

Database Systems: Design, Implementation, & Management

12th Edition

ISBN:9781305627482

Author:Carlos Coronel, Steven Morris

Publisher:Carlos Coronel, Steven Morris

Chapter8: Advanced Sql

Section: Chapter Questions

Problem 10RQ

See similar textbooks

Similar questions

87. A relationship should be specified how in the ODL? a. One direction starting with the first class b. One direction starting with the second class c. Neither direction. d. Both directions.
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.
Exercise A: In this exercise, you are asking the user to set a alpha numeric password for any website. Put some conditions. Password must be 8 characters long. There must be at-least one uppercase letter There must be at least one number. Then show the user, you have set the correct password or not. Exercise B: This exercise is the extension of the above Exercise. In this exercise we are not checking all the criteria of having a good password. Here ask the user to enter his/her password twice. If both matches, thanks the customer otherwise loop your code until user enters both passwords same.
Which of the followings describe the relationship between “super key” and “candidate key”?(a) A super key is also a candidate key.(b) A Super key K is a candidate key, if K is minimal(c) A candidate key K is a super key, if K is minimal(d) A candidate key is also a super key
Consider an attribute whose data type is specified as NUMERIC(4, 2). Which of the following values conformto the specified data type?(a) 106.59(b) 1065.59(c) 65.59(d) 5.59(e) 555.9
Assume an Oracle database administrator has connected to a pluggable database. What will be the statements the DBA use to create a password verification function emp_pass_verify to enforce a password to conform to all the following rules:• contains at least 8 characters• contains at least one letter, at least one digit, and at least one specialcharacter (that is not a letter or a digit)• starts with an upper-case letter• does not contain the username as a substring
Create the following indices, giving them an appropriate name in your spreadsheet (make sure to use the reverse-coded variable where relevant): Belief that climate change is a real phenomenon: Take the mean of scepticism_2, scepticism_6, and scepticism_7. Preferences for government intervention to solve problems in society: Take the mean of cog_1, cog_2, cog_3, cog_4, cog_5, and cog_6. Feeling of personal responsibility to act pro-environmentally: Take the mean of PN_1, PN_2, PN_3, PN_4, PN_6, and PN_7. When creating indices, we may be interested to see if each item used in the index measures the same underlying variable of interest (known as reliability or consistency). There are two common ways to assess reliability: either look at the correlation between items in the index, or use a summary measure called Cronbach’s alphaCronbach’s alpha A measure used to assess the extent to which a set of items is a reliable or consistent measure of a concept. This measure ranges from 0–1,…
Primary keys and candidate keys may both be assigned to the same attribute.
1.1 tblMembers The tblMembers will be used to store the details of the Gym Members MemberID, Name, Surname, DateOfBirth, ID,Contact, DateJoined MemberType (Annual: R200/year, Monthly: R50/month)1.2 The tblPayments table will be used to keep track of payments made by Members. PaymentID, Date, Amount. The tblPayments should be related to tblMembers accordinglyUsing Java and the jdbc API , create a startup frame that will be used navigate the application. The frame should have 3 buttons.1.3 The first button will open aa frame that can be used to add, update and delete Gyjm Members. 1.4 The second button will open a frame that will be used to collect the payments made by students.1.5 The third button will display a frame that calculates the current age and the balances, and displays a summary report in a table, as follows for an example:Order # is the sequence number of the member in tblMembers table. Should a member be deleted the system should adjust the sequence as well.- Age is the…
Explain in detail the syntax and functionalities of the following Mongoose code: x.findOneAndUpdate({"clientID": req.query.clientid}, {"status": req.query.status}, {new: true}, function (err, data){ /* statement block */ });
15. Which one of the following attribute can be taken as a primary key ? a. Name b. Street c. Id d. Department
Which of the following symbols represents an optional relationship in an E-R model?a. a straight lineb. a dashed linec. a straight line with a crow’s foot at both endsd. a straight line with a crow’s foot at one end