Quiz Space

Database Management Systems · Quiz 1 · 16 Jul 2023 · May 2023 term

Question 4: Consider the schema given below : Emp (<u>eid</u>, ename,…

Question 4

+2 marksOne correct option

Consider the schema given below :

Emp (eid, ename, age, salary)
Works (eid, did, pct_time)
Dept (did, budget, managerid)

Identify the correct SQL command to create a view named, EMPLOYEE, by selecting attributes like eid, salary, and managerid. Select those employees whose salary is greater than 1,00,000 and are atleast 45 years old.

  1. A
  2. B
  3. C
  4. D
Show answer

Correct answer

  • D
See the whole paperTake it as a mock test

Question 4 of 17 in the IIT Madras BS Database Management Systems (DBMS) Quiz 1 paper sat on 16 Jul 2023, in the May 2023 term (IIT M FOUNDATION AN2 EXAM QPF2 16 JULY 2023). It carries 2 marks.

More questions from this paper

  1. Q1The lowest level of data abstraction is
  2. Q2Suppose a company wants to determine whether the ’price’ of the commodity will be an attribute in the shopping database…
  3. Q3Consider the following scenario:\ The Reserve Bank of India (RBI) has issued guidelines declaring that the Rs. 2000 not…
  4. Q5An instance of the relation students is given below. | sid | name | age | gpa | |---|---|---|---| | 53831 | Madayan | 1…
  5. Q6Consider two relations R and S as shown below. | A | B | C | |---|---|---| | 1 | 2 | 3 | | 2 | 4 | 6 | | 3 | 7 | 3 | | …
  6. Q7Figure question
  7. Q8Figure question
  8. Q9Consider the relation G20(country_name, foreign_minister_name, events, date, venue)\ Questions: Find the name of foreig…
  9. Q10Figure question
  10. Q11Figure question
  11. Q12Consider the student relation given below. Select the correct query/queries to obtain the last name of students whose a…
  12. Q13Consider the two relations R and S. | A | B | C | |---|---|---| | 0 | 9 | 0 | | 2 | 2 | 2 | | 1 | 1 | 1 | | A | B | C |…
  13. Q14Consider the relation student shown in Table 3 | Roll_no | Name | marks | |---|---|---| | 1 | Ram | 50 | | 2 | Rakesh |…
  14. Q15Consider the following table which has four attributes: A, B, C, and D where A is the primary key and C is the foreign …
  15. Q16Figure question
  16. Q17Figure question