Consider the table teacher given below
Web8 rows · Consider a table “Billboard_top_100” which lists top 100 songs of each year from 1990 to 2024. ... WebOct 21, 2024 · Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and …
Consider the table teacher given below
Did you know?
WebMrs. Sharma is the classteacher of Class ‘XII A’ She wants to create a table ‘Student’ to store details of her class. i) Which of the following can be the attributes of Student table? a) RollNo b) “Amit” c) Name d) 25 ii) Name the Primary key of the table ‘Student’. State reason for choosing it. 2 Ans: i. a) RollNo b) Name WebQuestion 3: Write SQL query to add a column total price with datatype numeric and size 10, 2 in a table product. Аnswer: ALTER TABLE product ADD total price number. Question 4: While creating table ‘customer’, Rahula forgot to add column ‘price’. Which command is used to add new column in the table.
WebConsider the table TEACHER given below. Write commands in SQL for (1) to (3) and output for (4) i. To display all information about teachers of PGT category. ii. To list the names of female teachers of Hindi department. iii. To list names, departments and date of hiring of all the teachers in ascending order of date of joining iv. WebMar 16, 2024 · (b) The code given below inserts the following record in the table Student: RollNo – integer Name – string Clas – integer Marks – integer Note the following to establish connectivity between Python and MYSQL: Username is root Password is tiger The table exists in a MYSQL database named school.
WebQuestion 4: Write SQL query to add a column total price with datatype numeric and size 10, 2 in a table product. Answer: ALTER TABLE PRODUCT ADD TOTAL PRICE NUMBER (10,2). Question 5: Sonal needs to display name of teachers, who have “0” as the third character in their name. She wrote the following query. WebMay 6, 2024 · Consider the table below that represents a function. Which number(s) below can be placed in the empty cell so that the table continues to represent a function? Select all that apply. 1. -17 2. -8 3. -3 4. 2 5. 5 6. 8 7. 15
WebMar 29, 2024 · Write queries (a) to (d) based on the tables EMPLOYEE and DEPARTMENT given below: Table: EMPLOYEE EMPID NAME DOB DEPTID DESIG SALARY 120 Alisha 23 - Jan- - 1978 D001 Manager 75000 123 Nitin 10-Oct-77 D002 AO 59000 129 Navjot 12-Jul-71 D003 Supervisor 40000 130 Jimmy 30-Dec-80 ...
WebQ. Consider the following structure of TEACHER and STUDENT table: Table: TEACHER. TeacherID TName City Subject Qualification Designation; Table: STUDENT. StdID … taiga shield climateWeb73 views, 1 likes, 2 loves, 4 comments, 1 shares, Facebook Watch Videos from Mount Olympus Presbyterian Church: Please click the link below to fill out... twice unitsWebMar 29, 2024 · A table can have multiple candidate keys but only a single primary key . MOVIEID and TITLE for each movie(row) are unique and not repeated. (b) Consider the table SCHEDULE given below: Table: SCHEDULE taiga shield locationWebQuestion: 9. Consider the Student database schema given below. CREATE TABLE Student ( StudentId int PRIMARY KEY, Stud_Name varchar NOT NULL); CREATE … taiga shield ecozone saskatchewanWebConsider the table TEACHER given below. Write commands in SQL for (i) to (iii) and output for (iv) to (v) . Note: Hiredate is in mm/dd/yyyy format. To display all information … twice upcoming eventsWebFeb 1, 2005 · Ans. Select tname, salary, salary*12 from teacher; ix. List name of all teachers teaching class XII. Ans. Select tname from teacher where incharge=’XII’; x. List name and salary of all teachers who joined before ‘2016-10-01’. Ans. Select tname, salary from teacher where dateofjoin<‘2016-10-01’; Q3. twice university trading cardWebJul 15, 2014 · Create a table according to the schema given below. Choose the appropriate data types while creating the table. Insert the records given in Table 1 into the Employee table. And, write SQL queries to satisfy the questions given below. taiga shield population