Description : The number of tuples in a relation is called its …………. While the number of attributes in a relation is called it’s ……………….. A) Degree, Cardinality B) Cardinality, Degree C) Rows, Columns
Last Answer : B) Cardinality, Degree
Description : What is the degree and cardinality of the above given table named ‘Training’. -Technology
Last Answer : Degree: 6Cardinality: 5
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 : In the relational modes, cardinality is termed as: (A) Number of tuples. (B) Number of attributes. (C) Number of tables. (D) Number of constraints
Last Answer : (A) Number of tuples
Description : The number of attributes in relation is called as its ..................... A) Cardinality B) Degree C) Tuples D) Entity
Last Answer : B) Degree
Description : Given a Pandas series called Sequences, the command which will display the first 4 rows is .... (a) print(Sequences.head(4)) -Technology
Last Answer : (a) print(Sequences.head(4))
Description : A database is typically composed of one or more: a) Columns b) Files c) Rows d) Tables e) None of These
Last Answer : d) Tables
Description : In a relational model, relations are termed as (A) Tuples. (B) Attributes (C) Tables. (D) Rows.
Last Answer : (C) Tables
Description : Identify the columns out of the given three, which should not be present in each of the following tables: -Technology
Last Answer : (i) DateofBirth(ii) Admno(iii) Phonenumber
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 : Consider the tables given below. Salesperson -Technology
Last Answer : (i) Primary, Foreign(ii) Salespersons cannot be set as the primary key in the table Orders because table Orders has already primary key and one table cannot have more than one primary key column.
Description : What is the difference between ‘Rows’ and ‘Columns’ in a table? -Technology
Last Answer : Distinguish between data and information are as follows:DataInformationIt is a raw fact.It is a process form of data.It considers facts symbols, images for reference or analysis.It considers knowledge derived from study, experience or instruction.e.g. 23 is data.e.g age = 23 is information
Description : Key field is a unique identifier for each record. It is defined in the form of (a) rows (b) columns -Technology
Last Answer : (b) Key is a data item that allows you to uniquely identify individual occurrences which is defined as the column or set of columns.
Description : In a table, columns are called ………. and rows are called ………… . -Technology
Last Answer : In a table, columns are called fields and rows are called records.
Description : Which attribute tells, how many rows a cell should span? (a) colspan = n (b) rowspan = n -Technology
Last Answer : (b) rowspan = n will tell how many rows a cell should span.
Description : Name the attributes that are used to do the following in HTML: 1. merge two or more rows. -Technology
Last Answer : 1. rowspan2. bgcolor3. valign4. colspan
Description : In the rules attribute, the………… value helps to display a table border only between rows. -Technology
Last Answer : In the rules attribute, the rows value helps to display a table border only between rows.
Description : ...method in Pandas can be used to change the index of rows and columns of a Series or Dataframe : -Technology
Last Answer : Correct option(ii)reindex
Description : The ....... command can be used to makes changes in the rows of a table in SQL. -Technology
Last Answer : The update command can be used to makes changes in the rows of a table in SQL.
Description : Draw construction of Cartesian and cylindrical robots and explain their degree of freedoms.
Last Answer : Diagram: DOF: A Cartesian coordinate robot (also called linear robot) is an industrial robot whose three principal axes of control are linear (i.e. they move in a straight line rather than ... rotation at its base around the two axes. The work envelope is in the shape of a cylinder.
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 : A database that contains tables linked by common fields is called a (a) Centralized database (b) Flat file database -Technology
Last Answer : (c) Relational database stores data in the form of tables which are linked by common fields.
Description : A report allows you to represent data retrieved from one or more tables so that, it can be analysed and printed if required. -Technology
Last Answer : True When you want to print those records which are fetched from your database then, reports are more useful for this purpose.
Description : In a MS_Access database, which component is not present? (a) Formula Bar (b) Tables -Technology
Last Answer : (a) MS-Access contains various components, i.e. Tables, Queries, Forms, Reports, Macros and Modules.
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 : Which of the following is used to specify the beginning of a table’s row? (a) -Technology
Last Answer : (b) tag indicates the beginning of a table’s row.
Description : Which tag is used to add columns in the tables? (a) (b) -Technology
Last Answer : (b) is used to add columns in the tables.
Description : Which tags divide HTML tables in multiple section? -Technology
Last Answer : , and
Description : Define cell padding and cell spacing with respect to tables in HTML. -Technology
Last Answer : CELLSPACING controls the space between table cells and CELLPADDING sets the amount of space between the contents of the cell and the cell wall.
Description : In a Bank’s database, there are two tables ‘Customer’ and ‘Transaction’ as shown below. -Technology
Last Answer : (i)Acc_No, Cust_Phone(ii)All the columns having capability to become Primary Key are known as Candidate Keys.(iii)Acc_No(iv)Trans_Id
Description : In a Bank’s database, there are two tables ‘Customer’ and ‘Transaction’ as shown below. Write a query to display customer’s name who has -Technology
Last Answer : (i) Select cust_name from customer c,transaction t where c.Acc_No=t.Acc_No and Transaction_Type= 'Debit';(ii)Select cust_name, t.* from customer c, transaction t where c.Acc_No=t.Acc_No;(iii) ... total amount of all type of transactions, it will only display the total of credit transactions only.
Description : Consider the following tables PATIENT and TEST and answer the questions that follow : -Technology
Last Answer : Primary key in PATIENT and TEST tables are PCODE and TESTID respectively. Because primary key of a relational table uniquely identifies each record.Foreign key in PATIENT table is TESTID whose value is derived from the primary key (TESTID) of another table (TEST).
Description : Mention any two main differences between HTML and XML. Also mention any two main features of XML for which it’s used extensively now a days. -Technology
Last Answer : Two main differences between HTML and XML:HTML is used to display data and to focus on formatting of data, whereas XML is used to describe data and focus on what data is.HTML tags are predefined, ... for which it's used extensively nowadays:XML is used to store data.XML is used to exchange data.
Description : Explain the purpose of pow() method with the help of suitable java code. Also mention that pow() method belongs to which class? -Technology
Last Answer : pow() method, a mathematical method, helps in calculating the power of any number.For example:int num=2,power=4;int ans=Math.pow(num,power);t1.setText(''+ans);The above code will calculate the value of 24 and will give answer 16.pow() method belongs to math class.
Description : Write down any one situation where waterfall software process can be used. Also mention one advantage and one disadvantage of waterfall -Technology
Last Answer : Situations to use/apply waterfall model(i) When project is small(ii) When problem is static.(iii) Clear and fixed requirements. Stable problem definition. Technology is static.Advantage :Simple and easy to understandDisadvantage :No working software till the last phase
Description : Write down any one situation where spiral delivery model can be used. Also mention one advantage and one disadvantage of spiral delivery model. -Technology
Last Answer : Situations to use/apply spiral model When project is large,When releases are required to be frequent,When risk and costs evaluation is important For medium to high-risk projectsAdvantage-Additional ... becomes easy as the prototype building is done in small fragmentsDisadvantage-Risk of not meeting
Last Answer : Two main differences between HTML and XML:HTML is used to display data and to focus on formatting of data, whereas XML is used to describe data and focus on what data is.HTML tags are predefined, whereas ... it's used extensively now a days:XML is used to store data.XML is used to exchange data
Description : The order of column matrix containing n rows is _____.
Last Answer : The order of column matrix containing n rows is _____.
Description : If an unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE ?
Last Answer : It won't, Because SYSDATE format contains time attached with it.
Description : The minimum number of rows and columns that a word table can have, is: a) Zero b) 1 Row and 1 Column c) 1 Row and 2 Columns d) None of The Above
Last Answer : b) 1 Row and 1 Column
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 : What is the cardinality of a set which contains sets within it?
Last Answer : Its been a little while but I think each set is 1 item. So in your case the cardinality is 5. (Someone correct me if I’m wrong).
Description : Based on the cardinality ratio and participation ............... associated with a relationship type, choose either the Foreign Key Design, the Cross Referencing Design or Mutual Referencing Design. (A) Entity (B) Constraints (C) Rules (D) Keys
Last Answer : (B) Constraints
Description : Write difference between cardinality and modaling.
Last Answer : Cardinality Modality Cardinality defines the range of object-to object Relationships Modality indicates whether or not a relationship between objects is mandatory Expected ... maximum numbers occurrences in relationship It gives minimum numbers occurrences in relationship
Description : The cylindrical coordinate system is also referred to as a) Cartesian system b) Circular system c) Spherical system d) Space system
Last Answer : b) Circular system
Description : The Cartesian system is also called as a) Circular coordinate system b) Rectangular coordinate system c) Spherical coordinate system d) Space coordinate system
Last Answer : b) Rectangular coordinate system
Description : What do you mean by cartesian product? -Maths 9th
Last Answer : Cartesian product: Let A and B be two non-empty sets. Then the set of all possible ordered pairs (x, y) such that the first component x of the ordered pairs is an element of set A, and the second component y is an element of set B, is called ... 6), (4, 2), (4, 4), (4, 6), (6, 2), (6, 4), (6, 6)}.
Description : Find the Cartesian product of two lists in Python -Web-Development
Last Answer : Input: somelists = [ [1, 2, 3], ['a', 'b'], [4, 5] ] Desired output: [(1, 'a', 4), (1, 'a', 5), (1, 'b', 4), (1, 'b', 5), (2, 'a', 4), (2, 'a', 5) ...]
Description : _____ produces the relation that has attributes of R1 and R2 (A) Cartesian product (B) Difference (C) Intersection (D) Product
Last Answer : A) Cartesian product