Description : Ms. Shalini has just created a table named “Employee” containing columns Ename, Department, Salary. -Technology
Last Answer : SQL command to add a primary key column:Alter table employee add empid int primary key;Importance of Primary key in a table:Primary key column is used to uniquely identify each record of the table. A column defined as primary key cannot have a duplicate entry and can't be left blank.
Description : Mr. Manav, a database administrator in “Global Educational and Training Institute” has created following table named “Training” -Technology
Last Answer : i. Select count(name) from training where name like ‘Ms.%’;ii. Select * from training where fee is NULL;iii. Select city, fee from training where topic = ‘Cyber Security’;iv. Alter table training add feedback varchar(20);
Description : In a school, a database named “school” is created in mysql whose password is “cbse”. Smith is trying to add a new record of a student having details -Technology
Last Answer : import mysql.connectormydb = mysql.connector.connect{host='localhost',user='root',passwd='cbse',database='school'}mycursor = mydb.cursor()mycursor.execute('INSERT INTO student values(3,'Michelle', 'Agartala');')mydb.commit()
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 : While creating a table named “Employee”, Mr. Rishi got confused as which data type he should chose for the column “EName” out of char and varchar. -Technology
Last Answer : Varchar would be the suitable data type for EName column as char data type is a fixed length data type while varchar is a variable length data type.Any employee‟s name will be of variable length so it‟s advisable to choose varchar over char data type.
Description : For what, Memo data type is used? (a) To add table (b) To store objects created in other programs -Technology
Last Answer : (c) As we know, Memo provides character upto 65536 so, it is used for long text entries.
Description : Yesterday, Rahul created a file named detail.txt and saved it. -Technology
Last Answer : He can find his file by using Search option.
Description : The following table named SummerCamp shows part of the information kept on children attending the summer camp in Shimla. -Technology
Last Answer : 1. Number of fields-62. Number of records-73. If a new child joins the SummerCamp, then SummerCamp would add a record to the table.4. If a child is shifted from one group to another, then ... the SummerCamp, then SummerCamp would delete a record of that child from the table.6. Text and Date/Time.
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 : What is the degree and cardinality of the above given table named ‘Training’. -Technology
Last Answer : Degree: 6Cardinality: 5
Description : Observe the given table named “Loan” carefully and predict the output of the following queries: -Technology
Last Answer : (i)(ii)(iii)(iv)
Description : A relationship cannot be created with the help of a table. -Technology
Last Answer : False A relationship is a connection between two tables of data.
Description : What are table sections? How can they be created? -Technology
Last Answer : In HTML tables, there are three different sections: header, body and footer. These sections can be created using (header section), (body section) and (footer section) tags.e.g MonthSavings January$100February$80Sum$180
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 : Write a statement in HTML that inserts an image named ‘school.jpg’ found in the ‘images’ folder of the current folder. -Technology
Last Answer :
Description : The range of cells containing data that makes a chart is termed as ……………… data. -Technology
Last Answer : The range of cells containing data that makes a chart is termed as Numbers data.
Description : You cannot insert ………………… into a main document until after the data source has been created in Word. -Technology
Last Answer : fields into a main document until after the data source
Description : Copy of data created for safe storage is ………… -Technology
Last Answer : Copy of data created for safe storage isback up.
Description : Copy of data created for safe storage is a) Saved copy b) Backup c) Dcopy d) Stored copy -Technology
Last Answer : Copy of data created for safe storage isBackup
Description : Name the data type that should be used to store Student’s Admission numbers. -Technology
Last Answer : Data type should be Text.
Description : Write the data type of variables that should be used to store : 1. Marks of students 2. Grades of students (Grade can be ‘A or ‘B’ or ‘C’) -Technology
Last Answer : (i) int data type(ii) char data type
Description : Data is stored in RDBMS in the form of (a) table (b) query -Technology
Last Answer : (a) Relational Database Management System stores data in the form of relation. As we know, relations are known as table.
Description : Out of the following, which one is the most appropriate data field in context of employee table, if only one of these is required? -Technology
Last Answer : (b) Date of birth is the most appropriate data field in the context of the employee table.
Description : ………….. is the smallest part of a table in which one data item can be kept. -Technology
Last Answer : Fieldis the smallest part of a table in which one data item can be kept.
Description : What data type should you choose for a zipcode field in a table? (a) Text (b) Number -Technology
Last Answer : (b) Number data type should be chosen for a zip code field in a table.
Description : Which field property helps in setting data validation in a table? -Technology
Last Answer : (d) Validation Rule property specifies a condition that must be met before the data is accepted into the database.
Description : Memo data type allows you to store character type values in a table. -Technology
Last Answer : True Memo data type allows upto 65536 characters.
Description : Memo data type allows you to store only 255 characters in the table. -Technology
Last Answer : False Memo data type is used when character size is more than 255.
Description : The Datasheet View displays the data in a table in tabular format. -Technology
Last Answer : True A datasheet is a simple view of data arranged in rows and columns.
Description : Design View allows users to enter data in the table. -Technology
Last Answer : False Because Design View is used to edit the table design only.
Description : The tag is used to specify the individual table data in a table. (a) (b) -Technology
Last Answer : (b)The tag is used to specify the individual table data in a table.
Description : Which one of the following is not an option for aligning data in a table? (a) justify (b) right -Technology
Last Answer : (a) justify option is not used for aligning data in a table.
Description : In the tag, td stands for (a) Table Data (b) Table Time and Date -Technology
Last Answer : (a) td stands for Table Data.
Description : What is data cell? Name the tag, which is used as data cell. -Technology
Last Answer : The data cell defines a cell of a table that contains data. The table data cell is coded with tag of tag. Here, td stands for Table Data. The content in the table data cell is normal and left-aligned.
Description : …………… tag is used to insert data into a table. -Technology
Last Answer : tag is used to insert data into a table.
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 : Consider a table SALESMAN with the following data: SNO SNAME SALARY BONUS DATE OF JOIN A01 Beena Mehta 30000 45.23 29_10_2019 A02 K. L. -Technology
Last Answer : alternative answer
Description : Write the HTML code to display an inline image named pencil.jpg located at C:\ in the center of your Web page. -Technology
Description : Suppose you move or copy a folder named Alignment. The Alignment folder contains four subfolders, -Technology
Last Answer : Yes, the Alignment folder will carry the four sub-folders Left, Center, Right and Justify because when we move or copy a folder to a new location, then all its contents (i.e. sub-folders and files) also get moved or copied.
Description : In PowerPoint 2007 under the Insert tab, there is a button named Text Box. What is the utility of this button? -Technology
Last Answer : Like a title placeholder, a Text Box is used to hold the text information
Description : Fill in the blanks (i) Viruses, worms and trojans are collectively named ________________. -Technology
Last Answer : (i) Malware(ii) (iii) Web browser(iv) Website(v) (vi) Worm(vii) href(viii) Spyware(ix) Quotes(x) Trojan Horse
Description : Predict the output displayed in text fields named jTextField2 and jTextField3 after running the above code. -Technology
Last Answer : (i) GREEN WORLD, CLEAN WORLD76 more characters can be entered(ii)length(),toUpperCase()
Description : Write java statement to make the Net Fee text field named txtNetFee un_editable at run time. -Technology
Last Answer : txtNetFee.setEditable(false);
Description : Ms. Achla, works as a Programmer in a survey firm named “National Survey Foundation”. In her current project, she is supposed to design -Technology
Last Answer : S. No.Control used to inputControl1TRAINEE’S NAMETextField2TRAINING LOCATIONRadio Button/Combo Box3GRADE THE SESSION(Excellent, Good, Satisfactory, Unsatisfactory)Radio Button/Combo Box4SUGGESTIONSText Area
Description : Ms. Juhi, works as an IT Executive in a health insurance company named 'Total Health'. She has been assigned a task to design -Technology
Last Answer : S. No.Control used toControl1CUSTOMER‟S NAMETextField2CUSTOMER‟S CITYComboBox3POLICY TYPE (Individual/Family)RadioButton4INCLUSIONS (Critical Illness/Accidental Coverage/Health Checkup/Others)CheckBox/ListBox
Description : Write the command using Insert() function to add a new column in the last place(3rd place) named “Salary” from the list Sal=[10000,15000,20000] -Technology
Last Answer : EMP.insert(loc=3,column=”Salary”,value=Sal)
Description : Mr. Harry wants to draw a line chart using a list of elements named LIST. -Technology
Last Answer : (i) PLINE.plot(LIST)(ii) PLINE.ylabel(“Sample Numbers”)
Description : Write the Django command to start a new app named ‘users’ in an existing project? -Technology
Last Answer : python manage.py startapp users
Description : Pronita is a programmer in an institution and is asked to handle the records containing personal information -Technology
Last Answer : Suggested five fields are as follows:1. TCode -> To store the code of the teachers.TName -> To store the name of the teachers.TSubject -> To store the name of subjects for which the teacher is placed ... TCode is most likely to be the key field because it has a unique value for each of the records.