Question Completion Status: uestion 9 Moving to another question will save this responseQuestion 9 5 points Consider the Enrolment table from the university database (as in lectures)which has the following schema: Enrolment(sId, uCode, yr, mark) What does the following query produce? (Here 'CITS1402' is the unit codefor Databases.) SELECT sidFROM EnrolmentWHERE mark >= 50AND uCode <> 'CITS1402'; O The ids of students who have passed Databases O None of the other options O The ids of students who have passed some unit other than Databases O The ids of students who have failed Databases O The ids of students who have failed some unit other than Databases Moving to another question will save this respons uestion 9 of 13

During the entrance examination to the school, the management decided that only the top 25% of test takers will be allowed to enroll. Who among the following has the highest possibility of being enrolled?a.Person B who got +0.3 z-score;b.Person A who got 73th percentile rank;c.Person D who got 82nd percentile rank.d.Person C who got a T score of 30

You are given the following tables:CourseCourseID Description CreditsCS101 Computer Science I 3CS201 Elementary Data Structures 3ENGL210 Technical Writing 3RegistrationSID CourseID SemID Instructor Grade282712 ENGL210 201701 H. Zacny B+362112 CS101 201701 K. Ross CWhat would the following SQL Select statement produce for output?select course.description, registration.SID,registration.gradefrom registration right join courseon registration.courseID = course.courseIDSelect one:a.Computer Science I 362112 Cb.Computer Science I 362112 CTechnical Writing 28212 B+c.Computer Science I 362112 CElementary Data Structures null nullTechnical Writing 28212 B+d.No results due to syntax errorClear my choiceSkip Quiz navigationQuiz navigationQuestion1Question2Question3Question4Question5Question6Question7Question8Question9Question10Question11Question12Question13Question14Question15Question16Question17Question18Question19Question20Question21Question22Question23Question24Question25Question26Question27Question28Question29Question30Question31Question32Question33Question34Question35Question36Question37Question38Question39Question40Question41Question42Question43Question44Question45Question46This pageQuestion47This pageQuestion48This pageQuestion49This pageQuestion50This page

can you fetch questions related Durkheim in UGC NET EXAM ?

2.Question 2You are the database administrator for a school. Student information is kept in a students table where students are tracked by student_id. Students have a grade point average listed for each semester in a table named grades where each student is referenced by student_id.The school is giving an award to all students who achieved a 4.0 grade point average during any semester. You need to generate a list of all the students who should get the award. You begin typing your query:What should you type in the blank space? (Please type your answer all in lower case. Example: select)1 point

Students Table Surname   First_Name   Student_No   Dept_No   Year Duke Fitzroy 1 4 2Al-Essawy Zaid 2 4 2Ayton Phil 3 3 1Patel Mahesh 4 2 1Jones Gareth 5 2 1Scott Gavin 6 2 2CREATE VIEW Freshman     AS Select * From Students Where Year = 2;Considering the above Students table and Freshman view, what will be the result of the following SQL query:Select * From Freshman Where Dept_No=2;Question 8Select one:a. Surname   First_Name   Student_No   Dept_No   Year Duke Fitzroy 1 4 2Al-Essawy Zaid 2 4 2b. Surname   First_Name   Student_No   Dept_No   Year PatelMahesh4 2 1JonesGareth5 2 1 Scott  Gavin  6  2  2c. Surname   First_Name   Student_No   Dept_No   Year Scott Gavin6 2 2d. Surname   First_Name   Student_No   Dept_No   Year PatelMahesh4 2 1Jones Gareth 5