Description : Consider the following table Furniture. Write SQL commands for the statements (i) to (viii) and write output for SQL queries (ix) and (x). -Technology
Last Answer : SQL commands for the given statements (i) to (viii) ;1. SELECT FCODE, NAME. PRICE FROM Furniture WHERE PRICE < 5000;2. SELECT NAME. PRICE FROM Furniture3.4. WHERE NAME LIKE %table% ;5. SELECT DISTINCT WCODE ... ;15.16. Output for SQL queries (ix) and (x)(ix)SUM(PRICE)6500(x)COUNT(DISTINCT PRICE)5
Description : Observe the table named “Training” given above carefully and predict the output of the following queries: -Technology
Last Answer : (i) New DelhiFaridabadGurugram(ii) 2(iii) 11000(iv) Ms. Neena
Description : Observe the given table named “Loan” carefully and predict the output of the following queries: -Technology
Last Answer : (i)(ii)(iii)(iv)
Description : Consider the table Student(stuid, name, course, marks). Which one of the following two queries is correct to find the highest marks student in course 5? Q.1. Select S.stuid From student S Where not exists (select * from student ... ) Q.1 (B) Q.2 (C) Both Q.1 and Q.2 (D) Neither Q.1 nor Q.2
Last Answer : (B) Q.2 Explanation: First query gives stuid of students whose marks are greater than all students taking course 5. Second query gives stuid of students whose marks are greater than any student taking ... comparison is between maximum of marks by any student in course 5. So the answer is option D.
Description : Database is made up of all the following components except (a) tables (b) queries -Technology
Last Answer : (d) A database is made up of tables, queries, and forms.
Description : The different objects supported by MS_Access are tables, queries, ………… and reports. -Technology
Last Answer : The different objects supported by MS-Access are tables, queries, forms, and reports.
Description : Consider the relations R(A,B) and S(B,C) and the following four relational algebra queries over R and S: I. πA,B(R⋈S) II. R⋈πB(S) III. R∩(πA(R) Χ πB(S)) IV. πA,R.B(R Χ S) where R.B refers to ... IV are the same query. (C) I, II and IV are the same query. (D) I, III and III are the same query.
Last Answer : (D) I, III and III are the same query.
Description : Develop a dialogue between a teacher and a student regarding the student's queries. (8 to 10 dialogues)
Last Answer : Ans: Tarun : Excuse me Sir. May I come in? Teacher : Yes come in, Tarun. Tarun : Good Morning Sir. Teacher : Good Morning Tarun. How are your studies going on ? Tarun : Doing well Sir; I ... silence'. Student : Thank you so much sir. Teacher : You are welcome and all the best for your exams.
Description : Help Ramesh in identifying any two columns for a table named student along with their suitable data type. -Technology
Last Answer : Column NameData TypeRollNoIntegerNameVarchar(20)
Description : In the table “Student”, Priya wanted to increase the Marks (Column Name: Marks) of those students -Technology
Last Answer : Correct SQL statement :UPDATE Student SET Marks = Marks +5 WHERE Marks
Description : While creating the table Student last week, Ms. Sharma forgot to include the column -Technology
Last Answer : ALTER TABLE Student ADD Game_Played VARCHAR (30) ;
Description : In Marks column of ‘Student’ table, for Rollnumber 2, the Class Teacher entered the marks as 45. -Technology
Last Answer : UPDATE Student SET Marks = 50 WHERE Roll number = 2;
Description : Mrs. Sharma is the classteacher of Class ‘XII A’. She wants to create a table ‘Student’ to -Technology
Last Answer : (i) RolINo, Name can be the attributes of Student table.(ii) Primary key of the table Student is RolINo, because RolINo is a field in Student table which uniquely identifies each rows/records in a database table.
Description : Consider the table STUDENT given below: RollNo Name Class DOB Gender City Marks 1 Anand XI 6/6/97 M Agra 430 -Technology
Last Answer : (1)b. Both (iii) and (iv)(2) b.RollnoNameClassDOBGenderCityMarks6734MaakhiyNehaGeetPreetiXIXXIXII12/12/948/12/956/5/978/8/95FFFFDubaiMoscowAgraMumbai256324470492
Description : The output of executing string.ascii_letters can also be achieved by: a) string.ascii_lowercase_string.digits b) string.ascii_lowercase+string.ascii_upercase c) string.letters d) string.lowercase_string.upercase
Last Answer : d) string.lowercase_string.upercase
Description : Consider the following three SQL queries (Assume the data in the people table) : (a) Select Name from people where Age>21; (b) Select Name from people where Height>180; (c) Select Name from people where (Age>21) or (Height ... number of rows returned by the SQL query (c) ? (A) 3 (B) 7 (C) 10 (D) 21
Last Answer : (C) 10
Description : Consider a database table R with attributes A and B. Which of the following SQL queries is illegal ? (A) SELECT A FROM R; (B) SELECT A, COUNT(*) FROM R; (C) SELECT A, COUNT(*) FROM R GROUP BY A; (D) SELECT A, B, COUNT(*) FROM R GROUP BY A, B;
Last Answer : (B) SELECT A, COUNT(*) FROM R;
Description : The CPU of a system having 1 MIPS execution rate needs 4 machine cycles on an average for executing an instruction. The fifty percent of the cycles use memory bus. A memory read/write employs one machine cycle. For ... (A) 500 Kbytes/sec (B) 2.2 Mbytes/sec (C) 125 Kbytes/sec (D) 250 Kbytes/sec
Last Answer : (D) 250 Kbytes/sec
Description : Write a code to produce the following output. -Technology
Last Answer : ComputerAn electronic machineCPU Brain of computer
Description : Write the output on the Web page for the following HTML command. -Technology
Last Answer : The output on the Web page will be the Atomic weight of O 2
Description : Write the HTML code to generate the following output: -Technology
Last Answer : The HTML code isTableABD EG HI
Description : With reference to the above given tables, write commands in SQL for (i) and (ii) and output for (iii) below: -Technology
Last Answer : (i) select TName, Passenger from Train T, Reservation R where T.TrainId=R.TrainId;(ii) select T.* from Train T, Reservation R where T.TrainId!=R.TrainId;(iii)TrainIdTNameSourceDestination3424Lucknow MailLucknowNew Delhi5400Century ExpressNew DelhiKanpur
Description : Write the output of the following code : -Technology
Last Answer : [10 12 16 20]
Description : Consider the following python code and write the output for statement S1 import pandas as pd -Technology
Last Answer : 0.50 8.00.75 11.0
Description : Write the output of the following SQL command. select round (49.88); (a)49.88 (b)49.8 (c)49.0 (d)50 -Technology
Last Answer : The correct answer is : (a) 50
Description : The type(s) of auto executing macros, in Microsoft word is/are A) Auto execute B) Auto macro C) Command macro D) All of the above
Last Answer : D) All of the above
Description : Suppose ORACLE relation R(A, B) currently has tuples {(1, 2), (1, 3), (3, 4)} and relation S(B, C) currently has {(2, 5), (4, 6), (7, 8)}. Consider the following two SQL queries SQ1 and SQ2 ... (A) 2 and 6 respectively (B) 6 and 2 respectively (C) 2 and 4 respectively (D) 4 and 2 respectively
Last Answer : (D) 4 and 2 respectively
Description : Consider the following ORACLE relations: R(A,B,C) = {, , , , ,< 3,1,4>} S(B,C,D) = {, , , , } Consider the following two SQL queries SQ1 and SQ2: SQ1: SELECT R.B, AVG(S.B) FROM R, S WHERE R.A = S.C AND S.D ... tuples returned by SQ2 then (A) M=4, N=2 (B) M=5, N=3 (C) M=2, N=2 (D) M=3, N=3
Last Answer : (A) M=4, N=2
Description : Write the relationship between a database and a table. -Technology
Last Answer : A database contains multiple tables whereas, a table cannot exist outside a database.
Description : Write down the steps to insert a new row into the table. -Technology
Last Answer : Insert a RecordSteps to insert a record in a Datasheet View are as follows:Step 1 When you create a table, a new blank record automatically appears in the second row of the table or If you enter ... into the fields.Step 3 When you have finished adding records in the datasheet, save it and close it.
Description : Write HTML code to display a table with border of 5px. -Technology
Last Answer : l2 „
Description : Write the HTML code to create the exact table which is given below: ADMNO SNAME NAME DOB -Technology
Last Answer : The HTML code is ADMNO SNAMENAMEDOB1110MANJITRANJIT4-MAR-1998
Description : Write an HTML code to create the following table: 100 Amit 10 A -Technology
Last Answer : The HTML code is Roll NumberNameClass 100 Amit 10 A 101 Ankit 10 B 102 Arnab 10C Footer 1 Footer 2 Footer 3
Description : Observe the following table and write the HTML code to generate it: Question Marks -Technology
Last Answer : The HTML code isquestion< /th >marksl225
Description : Observe the following table and write the HTML code to generate it: Period 1 Period 2 -Technology
Last Answer : The HTML code isPeriodlPeriod2 MathScienceEnglishSST Science< /td >SST
Description : Write the HTML code to generate the following table with the contents exactly in the same format as shown within the table: -Technology
Last Answer : The HTML code is
Description : Write the HTML code to generate the following table on a Web page with the contents and alignment exactly as shown below: -Technology
Description : Write the complete … tags to create a table with the following contents. -Technology
Last Answer :
Description : Observe the following table and write the HTML code to generate it: Activities -Technology
Last Answer : HTML code is: Acdvities Sr School Maths Club Robotics Club Photography Middle School Gymnastic Yoga Computer Club Primary School Dance Vocal Music Swimming
Description : Write an HTML code to print the following table: -Technology
Description : Observe the following table and write the HTML code to generate it : -Technology
Last Answer : GenerateHTML code
Description : Write any two attributes for each tag: (a) (b) (c) -Technology
Last Answer : img tag-src, alt, height, widthtable tag - align, bgcolor, border, cellpadding, cellspacinga tag -href, name
Description : Write HTML code to display the following table : -Technology
Last Answer : scheduleDuty Chart8 AM10AM12 AM KEVIN KHUSHBOO AMARJEET
Description : Write SQL query to create a table “BOOKS” with the following structure: Table: BOOKS -Technology
Last Answer : Create table Books(BOOK_ID Integer (2) Primary Key,BOOK_NAME Varchar (20),CATEGORY Varchar (20),ISSUE_DATE Date);
Description : Write SQL query to create a table “Registration” with the following structure: -Technology
Last Answer : Create table Registration(Reg_Id Integer(2) Primary Key,Name varchar(20),Course varchar(10),Join_Dt date);
Description : (i) Write the degree and cardinality of the above table. -Technology
Last Answer : (i) The degree is 6 and cardinality is 5.(ii)+------------+|max(DOJ)|+------------+|1998-02-21|+------------+(iii) Delete from Customer_Details where Accumlt_Amt is NULL;
Description : Write the code in python to read the contents of “number.csv” file consisting of data from a mysql table and print the data of the table -Technology
Last Answer : f = open('numbers.csv', 'r') with f:reader = csv.reader(f)for row in reader:for e in row:print(e)
Description : Write SQL query to create a table Inventory with the following structure : -Technology
Last Answer : CREATE TABLE Inventory(Material Id Integer Primary Key,Material Varchar (50) NOT NULL,Category Char,DatePurchase Date) :
Description : Write SQL query to create a table Player with the following structure : -Technology
Last Answer : CREATE TABLE Player(};
Description : Write SQL Query commands based on the following table: -Technology
Last Answer : This answer was deleted by our moderators...