Given the table ‘Player’ with the following columns : -Technology

Given the table ‘Player’ with the following columns : -Technology
by

1 Answer

Answer :

Output of the given statements(i)AVG (POINTS)30(ii)COUNT(POINTS)2
by

Related questions

What is the difference between ‘Rows’ and ‘Columns’ in a table? -Technology

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

In a table, columns are called ………. and rows are called ………… . -Technology

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.

The……………… attribute is used to span two or more columns in a table. -Technology

Description : The……………… attribute is used to span two or more columns in a table. -Technology

Last Answer : The colspanattribute is used to span two or more columns in a table.

The cols value in the rules attribute, allows you to display table border only between columns. -Technology

Description : The cols value in the rules attribute, allows you to display table border only between columns. -Technology

Last Answer : True The cols value in the rules attribute is drawn between columns only.

Help Ramesh in identifying any two columns for a table named student along with their suitable data type. -Technology

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)

Ms. Shalini has just created a table named “Employee” containing columns Ename, Department, Salary. -Technology

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.

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

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

Identify the columns out of the given three, which should not be present in each of the following tables: -Technology

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

Write SQL query to create a table Player with the following structure : -Technology

Description : Write SQL query to create a table Player with the following structure : -Technology

Last Answer : CREATE TABLE Player(};

Key field is a unique identifier for each record. It is defined in the form of (a) rows (b) columns -Technology

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.

Which tag is used to add columns in the tables? (a) <colspan> (b) <td> -Technology

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.

Which attribute of <td> tag is used to merge two or more columns to form a single column? (a) colspan (b) cellspacing -Technology

Description : Which attribute of tag is used to merge two or more columns to form a single column? (a) colspan (b) cellspacing -Technology

Last Answer : (a) colspan attribute is used to merge two or more columns to form a single column.

Which tag is used for giving heading to the columns? -Technology

Description : Which tag is used for giving heading to the columns? -Technology

Last Answer : The tag is used to display the table heading only once for a table column.

The rowspan attribute is used to make a cell span multiple columns. -Technology

Description : The rowspan attribute is used to make a cell span multiple columns. -Technology

Last Answer : False The rowspan attribute is used to make a cell span multiple rows

…………. splits text in columns at a specific point. (a) Column break (b) Page break (c) Next page (d) Continuous -Technology

Description : …………. splits text in columns at a specific point. (a) Column break (b) Page break (c) Next page (d) Continuous -Technology

Last Answer : (a) Column bj;eak splits text in columns at a specific pointing.

...method in Pandas can be used to change the index of rows and columns of a Series or Dataframe : -Technology

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

Matching the information given in the three columns of the following table. [Note: Atomic Number of Cr=24,V=23,Pt=78)] Correct combination for `[PtCl_

Description : Matching the information given in the three columns of the following table. [Note: Atomic Number of Cr=24,V=23,Pt=78)] Correct combination for `[PtCl_

Last Answer : Matching the information given in the three columns of the following table. [Note: Atomic Number of Cr=24,V=23,Pt=78 ... (IV),(iv),P D. (III),(ii),R

Matching the information given in the three columns of the following table. [Note: Atomic Number of Cr=24,V=23,Pt=78)] Correct combination for `[VCl_(

Description : Matching the information given in the three columns of the following table. [Note: Atomic Number of Cr=24,V=23,Pt=78)] Correct combination for `[VCl_(

Last Answer : Matching the information given in the three columns of the following table. [Note: Atomic Number of Cr=24,V=23,Pt=78 ... (III),(ii),R D. (IV),(iv),Q

Matching the information given in the three columns of the following table. [Note: Atomic Number of Cr=24,V=23,Pt=78)] About `(CrCl_(3)(NH_(3))_(3))`

Description : Matching the information given in the three columns of the following table. [Note: Atomic Number of Cr=24,V=23,Pt=78)] About `(CrCl_(3)(NH_(3))_(3))`

Last Answer : Matching the information given in the three columns of the following table. [Note: Atomic Number of Cr=24,V=23,Pt=78)] ... (IV),(i), R D. (I),(ii),S

Look at the given table called ‘Item’ and answer the questions. ItemId ItemName ItemStock ItemDOP Quanity Purchased -Technology

Description : Look at the given table called ‘Item’ and answer the questions. ItemId ItemName ItemStock ItemDOP Quanity Purchased -Technology

Last Answer : 1. ItemID —> TextItemName —> TextItemStock —> NumberItemDOP —> DateQuantityPurchased —> Number2. ItemID and ItemName can act as primary key.

Write the HTML code to create the exact table which is given below: ADMNO SNAME NAME DOB -Technology

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

Observe the table named “Training” given above carefully and predict the output of the following queries: -Technology

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

What is the degree and cardinality of the above given table named ‘Training’. -Technology

Description : What is the degree and cardinality of the above given table named ‘Training’. -Technology

Last Answer : Degree: 6Cardinality: 5

Observe the given table named “Loan” carefully and predict the output of the following queries: -Technology

Description : Observe the given table named “Loan” carefully and predict the output of the following queries: -Technology

Last Answer : (i)(ii)(iii)(iv)

What is the degree and cardinality of the above given table named ‘Training’. -Technology

Description : What is the degree and cardinality of the above given table named ‘Training’. -Technology

Last Answer : Degree: 6Cardinality: 5

Consider the table ‘Teacher’ given below. -Technology

Description : Consider the table ‘Teacher’ given below. -Technology

Last Answer : (i) Select count(Department) from Teacher ;(ii) Select count (*) from Teacher ;

Consider the table STUDENT given below: RollNo Name Class DOB Gender City Marks 1 Anand XI 6/6/97 M Agra 430 -Technology

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

Prepare a table having two columns depicting names of endocrine glands and hormones secreted by them. -Science

Description : Prepare a table having two columns depicting names of endocrine glands and hormones secreted by them. -Science

Last Answer : Endocrine glands Hormones 1. Pituitary gland (i) Growth hormones 2. Ovaries (ii) Estrogen 3. Testes (iii) Testosterone 4. Thyroid (iv) Thyroxine 5. Pancreas (v) Insulin 6. Adrenal glands (vi) Adrenaline

Statistical table is the systematic arrangement of numerical data presented in rows and columns. What are the rules to be followed while constructing such a table?

Description : Statistical table is the systematic arrangement of numerical data presented in rows and columns. What are the rules to be followed while constructing such a table?

Last Answer : Statistical table is the systematic arrangement of numerical data presented in rows and columns. ... be followed while constructing such a table?

How many horizontal rows and vertical columns are present in the modern periodic table?

Description : How many horizontal rows and vertical columns are present in the modern periodic table?

Last Answer : How many horizontal rows and vertical columns are present in the modern periodic table?

What is the default alignment for a table with 3 rows and 4 columns?

Description : What is the default alignment for a table with 3 rows and 4 columns?

Last Answer : What is the answer ?

What is the Vertical columns on the periodic table is called?

Description : What is the Vertical columns on the periodic table is called?

Last Answer : groups or families

What's the name of the columns in the Periodic Table?

Description : What's the name of the columns in the Periodic Table?

Last Answer : groups

What's the name of the columns in the Periodic Table?

Description : What's the name of the columns in the Periodic Table?

Last Answer : groups

In a relational database, this is a data structure that organizes the information about a single topic into rows and columns. 1) Block 2) Record 3) Tuple 4) Table 5) Command line interface

Description : In a relational database, this is a data structure that organizes the information about a single topic into rows and columns. 1) Block 2) Record 3) Tuple 4) Table 5) Command line interface

Last Answer : Answer :4

How many columns can table have?

Description : How many columns can table have?

Last Answer : The number of columns in a table can range from 1 to 254.

Suppose a customer table is having different columns like customer no, payments.What will be the query to select top three max payments?

Description : Suppose a customer table is having different columns like customer no, payments.What will be the query to select top three max payments?

Last Answer : SELECT customer_no, payments from customer C1 WHERE 3

How many LONG columns are allowed in a table ? Is it possible to use LONG columns in WHERE clause or ORDER BY ?

Description : How many LONG columns are allowed in a table ? Is it possible to use LONG columns in WHERE clause or ORDER BY ?

Last Answer : Only one LONG columns is allowed. It is not possible to use LONG column in WHERE or ORDER BY clause.

The vertical columns of the periodic table are called

Description : The vertical columns of the periodic table are called

Last Answer : Groups

Columns are periodic table called?

Description : Columns are periodic table called?

Last Answer : Groups

The vertical columns of periodic table are called

Description : The vertical columns of periodic table are called

Last Answer : groups.

How many rows and columns are in the modern Periodic Table? A. 18 columns and 7 rows (Answer) B. 12 columns and 9 rows C. 7 columns and 18 rows D. 25 columns and 15 rows

Description : How many rows and columns are in the modern Periodic Table? A. 18 columns and 7 rows (Answer) B. 12 columns and 9 rows C. 7 columns and 18 rows D. 25 columns and 15 rows

Last Answer : A. 18 columns and 7 rows (Answer)

What are Columns in Periodic table called? A. Period B. Group (Answer) C. Verticals D. Perpendiculars

Description : What are Columns in Periodic table called? A. Period B. Group (Answer) C. Verticals D. Perpendiculars

Last Answer : B. Group (Answer)

What is the minimum number of rows and columns that a word table can have a) 1 row & 1 columnb) 2 rows & 2 columnsc) Zerod)1 row & 2 columnse) None of The Above

Description : What is the minimum number of rows and columns that a word table can have a) 1 row & 1 column b) 2 rows & 2 columns c) Zero d)1 row & 2 columns e) None of The Above

Last Answer : a) 1 row & 1 column

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 Columnsd) None of The Above

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

Numbers in table columns are usually- 1) Right-aligned 2) Left-aligned 3) justified 4) Centered

Description : Numbers in table columns are usually- 1) Right-aligned 2) Left-aligned 3) justified 4) Centered

Last Answer : 2) Left-aligned

the number of columns in a state table for a sequential circuit with m flip-flops and n inputs is.

Description : the number of columns in a state table for a sequential circuit with m flip-flops and n inputs is.

Last Answer : Ans-Its 2m+2n because.. If there are m flip-flops there should be 2m nodes. If there are n inputs then each node will have 2n.

What is the maximum no. of columns a table can have ?

Description : What is the maximum no. of columns a table can have ?

Last Answer : 254.

How many columns can table have?

Description : How many columns can table have?

Last Answer : The number of columns in a table can range from 1 to 254.

Is it possible to update another table with 2 concatenated columns?

Description : Is it possible to update another table with 2 concatenated columns?

Last Answer : Yes, the following update statement will work: UPDATE tablename SET colname = columnX || columnY WHERE colname = ¤t_value_for_this_column ;