Mrs. Sharma is the classteacher of Class ‘XII A’. She wants to create a table ‘Student’ to -Technology

1 Answer

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.

Related questions

Description : Rishi, a class XII student has given following commands for the given purposes: (i) To add a new column “Rating” : -Technology

Last Answer : No, above commands will not be able to achieve desired task as update and alter commands have been interchanged.In order to achieve desired result, following corrections should be incorporated in the previously used ... give an increase of 50 Rs. to all the books:Update library set price=price+50;

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 : Mrs. Sharma bought a packet of dal from her local grocer. When she came back home and began cooking the dal, she could not find the best before the date on the packet. -SST 10th

Last Answer : right to information hope it helps

Description : Mrs. S.K is writing her daily observations of a student and writes, without interpretation, that the student is not completing the class work and is constantly speaking out of turn. Which of the ... objectives does she appear to be using? a. Prediction b. Description c. Explanation d. Exploration

Last Answer : b. Description

Description : What is the easiest way to get rid of sleep ? I am a class XII student and I get a lot of sleep in the evening when I sit down to study. Can I get rid of this sleep by playing ? Can I read for many more nights ?

Last Answer : In fact, this happens due to physical weakness, that is, sleep comes again and again. You will have tea and books at night. Or sleep, actually eat tea, then read the book again. Or sleep will actually take a splash of water in the eyes. Then sleep will not come.

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 : 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 : There was a circular building with three floors. On the first floor lived elderly Mr. Davis and Mrs. Davis. On the second lived a newly-married couple, Sam and Jenny. On the third floor lived ... was studying for her upcoming exams on Face Time with her friend. Who murdered Mrs. Davis? -Riddles

Last Answer : Sam was the murderer. He said he was drinking coffee in a corner of the room, but the building was a circular building.

Description : Raj at is a commerce student and wants to do his homework but somehow he has lost his calculator and wants to take computer’s help. -Technology

Last Answer : Rajat can use calculator in the system that can do simple as well as sophisticated calculations.To start the calculator:Click Start —> All Programs —> Accessories —> Calculator.

Description : Sona wants to add her pictures in a Word document. 1. Which tab she should use? 2. Which command she should use to open Insert Picture dialog box? -Technology

Last Answer : 1. Insert tab2. Picture command in the Illustrations group.3. Yes4. Yes

Description : Seema wants to give identical design to all the slides and handouts, she is going to print from her presentation. -Technology

Last Answer : 1. Seema can do this in following two ways:(a) Creating same design on each slide and handouts manually.(b) Using slide master and handout master.2. In the first method , the efforts are ... design may creep in. The second method ensures reduce efforts and identical design on each slide and handout.

Description : Rama is preparing a presentation on her company’s annual performance. She wants some text present on a slide to fly in from the left, -Technology

Last Answer : (c) Custom Animation can be used for the desired functionality.

Description : While working in Netbeans, Ms. Sonia has designed a login page where she wants to display -Technology

Last Answer : If statement is more appropriate for this situation because here is given only two conditions which will be executed by if statement while switch statement is used where multiple branch selection statements are given.

Description : Ram wants to create a text file to store name and roll number of his students. Suggest, which program he should use. -Technology

Last Answer : He can create a text file using Notepad or WordPad. Follow these steps to create a file using Notepad:(a) Step 1:Click Start.(b) Step 2:Choose All Programs -> Accessories -> Notepad.(c) Step 3: ... dialog box will appear.(g) Step 7:Give file name with extension.(h) Step 8: Click Save button.

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 : On the basis of the Table Student, write the output(s) produced by executing the following queries: -Technology

Last Answer : (i)Max(Average)Min(Average)9565(ii)NameShrishtiAdityaRitu RajSaumyaAshutoshAman

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 : There are 312, 260 and 156 students in class X, XI and XII respectively. Buses are to be hired to take these students to a picnic. Find the maximum number of students who can sit in a bus if each bus takes equal number of students (a) 52 (b) 56 (c) 48 (d) 63

Last Answer : (a) 52

Description : Consider the following database Student:Roll No. First Name Last Name Class Marks Obtained(%) Scholarship Awarded -Technology

Last Answer : 1. 95.42. Mohan Garg and scholarship awarded is 50000.3. 54. 6

Description : Vani, a class X student has recently completed her HTML course and just started learning XML. Help her in the following: -Technology

Last Answer : (i) Primary purpose of HTML is to design a webpage while XML is used to store and transport the data.(ii) Right(iii) Comments are added as notes or lines for understanding the purpose of an XML ... .Syntax for comments are as follows:(v)An XML document with correct syntax is called 'Well Formed'.

Description : Ruby, a class XI student has just started learning java programming. Help her in the following: (i) Explain her the concept of variable -Technology

Last Answer : (i)Variables are named storage location to store values temporarily which can be changed during program execution.Data type states the way the values of that type are stored, the operations that can be done ... setText( Just Pass );In the above if statement, value of marks is being compared with 40.

Description : Ms. Archana, a class XI student has just started learning MySQL. Help her in understanding the basic difference between -Technology

Last Answer : ALTERUPDATEIt s a DDL command.It s a DML command.It can be used for the following purpose:To add a new column.To remove an existing column.To modify a column.To add/remove a constraint.It s ... Delhi ;suitable command:(i)Show Databases(ii) Use City(iii) Drop Database Clients(iv) Drop table Club

Description : Ruby, a class XI student has just started learning java programming. Help her in the following: -Technology

Last Answer : i. Variables are named storage location to store values temporarily which can be changed during program execution.Data type states the way the values of that type are stored, the operations that can be done ... setText( Just Pass );In the above if statement, value of marks is being compared with 40.

Description : (1) Prachi has given the following command to obtain the highest marks Select max(marks) from student where group by class; -Technology

Last Answer : (1)d. Select class, max(marks) from student group by class;(2)b. Both (ii) and (iv)(3)b. select name,max(DOB) from student;

Description : Lakshmi works for a school. She wishes to create controls on a form for the following functions. -Technology

Last Answer : S.No.control used tocontrol1.Enter Admission numberText Field2.select StreamCombo Box3.select StreamCheck Box4.Clear the FromButton

Description : A command tab which allows to create the table in an interactive manner is called (a) Home -Technology

Last Answer : (d) MS-Access provides a command tab named Create which allows creating the table in an interactive manner.

Description : To store object like image, you need to create a field in a table, having field type as …………. . -Technology

Last Answer : To store object like image, you need to create a field in a table, having field type as OLE Object.

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 : Write the complete … tags to create a table with the following contents. -Technology

Last Answer :

Description : Cellspacing is used to create space between different…………… in a table. -Technology

Last Answer : Cellspacing is used to create space between different cells in a table.

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 : 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 : Which one of the following can be termed as verbal communication ? (A) Prof. Sharma delivered the lecture in the class room. (B) Signal at the cross-road changed from green to orange. (C) The child was crying to attract the attention of the mother. (D) Dipak wrote a letter for leave application.

Last Answer : Answer: C  Verbal communication Effective verbal or spoken communication is dependent on a number of factors and cannot be fully isolated from other important interpersonal skills such as non-verbal ... intensively during human childhood. The communication is two way process instead of one way. 

Description : So who wants to congratulate Mrs Strachan on the birth of her baby girl ?

Last Answer : Congratulations on the safe arrival of your baby girl xxxx ICan’t wait to find out teh name, dibs on Ellis Mae Katie Mae

Description : Sara is concerned that the police in her community stop more people of color than whites for driving over the speed limit. She wants to build a multiracial coalition to protest what is happening. What must Sara do to create a multiracial coalition?

Last Answer : Include people of different races in the coalition.

Description : ‘Class’ table has columns RNO and NAME. The following statements are executed: -Technology

Last Answer : Output for the 1st SELECT * FROM Class ; statement -RNONAME5Rajeev6Chris7FerozeOutput for the llnd SELECT * FROM Class; statementRNONAME5Rajeev6Chris

Description : What convincing argument was made by Anne? i) She was talkative just like any other student in the class. ii) She had the right to be talkative, as it was a classroom and not a prison. iii) ... being talkative. iv) She found it impossible to be quiet like the others as she couldn t change herself.

Last Answer : iii) She had inherited the trait from her mother, so couldn‘t stop being talkative.

Description : Ashwini has a certain number of Pencils she wishes to distribute in the class. when she tries to distribute 7 pencils to each student, 3 pencils are left out. if the class had 3 less students, each student would have ... How many pencils does Ashwini have? a) 90 b) 120 c) 140 d) 160 e) None of these

Last Answer : Let number of students be X. so, total Pencils = 7X + 3 7X + 3 = (7+2) (X-3) or., 7X + 3 = 9X – 27 or X = 15 total Pencils = 7X + 3 = 108 Answer: e)

Description : Write a C++ program to create a class STUDENT The data members of STUDENT class. Roll_No Name Marks

Last Answer : #include #include class STUDENT { int Roll_No; char Name[20]; float Marks; }; OR #include #include class STUDENT { int Roll_No; char Name[20]; float Marks; public: void Accept(); void Display(); }; void STUDENT::Accept() { cout

Description : All of Mrs. Smith pets are dogs except one, and all her pets are cats except one. How many cats and dogs does she have? -Riddles

Last Answer : Mrs. Smith has one cat and one dog.

Description : What did Mrs. Claus say to Santa when she looked up in the sky? -Riddles

Last Answer : Looks like rain dear.

Description : After Mrs. Annie Besant joined Congress in 1914, she started propagating her views. -SST 10th

Last Answer : Mrs. Besant dominated the Lucknow session of the Congress at which Assertive, Moderates, Hindus and Muslims were reunited. In 1915, she formed the Home Rule League. The self government later became a common demand of both the Congress and Muslim League.

Description : In this state, each employee’s insurance plan is considered primary for him or her, which means Mrs. Gonzales’s HMO is her primary payer and the $25 copay from her last visit is now past due, because she wanted this submitted to her husbands insurance?

Last Answer : The insurance company refused coverage because of a $1000 yearly deductible, which has not yet been met. How will you handle this?

Description : What physical changes does Mrs. Mallard undergo as she considers the implications of her husband and death?

Last Answer : The physical change that occurs in the character of Mrs. Mallardof course is due to first the news that her husband has died andsecond that he has not actually died. The first bit of newstriggers ... how oppressive marriage has been to her, and thatshe is ready to start planning her new life.

Description : When Mrs. Winthrop visited Silas one Sunday afternoon what and whom did she bring with her?

Last Answer : Gold