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

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

1 Answer

Answer :

Output for the 1st SELECT * FROM Class ; statement -RNONAME5Rajeev6Chris7FerozeOutput for the llnd SELECT * FROM Class; statementRNONAME5Rajeev6Chris
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.

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

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

Last Answer : Output of the given statements(i)AVG (POINTS)30(ii)COUNT(POINTS)2

What will be the final value of variable x after the following code is executed: -Technology

Description : What will be the final value of variable x after the following code is executed: -Technology

Last Answer : The value is:1

Explain with the help of an example that why should atransaction be executed as a whole or it should be not executed at all -Technology

Description : Explain with the help of an example that why should atransaction be executed as a whole or it should be not executed at all -Technology

Last Answer : A transaction is a set of changes that must be made together. It is a program unit whose execution mayor may not change the contents of a database. Transaction is executed as a single unit. ... from one bank account to another requires two changes to the database both must succeed or fail together

What values will be displayed in JOptionPane when the following code is executed? -Technology

Description : What values will be displayed in JOptionPane when the following code is executed? -Technology

Last Answer : No value will be displayed in JOptionPane because it will give exception in thread ‘main’ due to null.

What will be the values of i and z after the following code is executed : -Technology

Description : What will be the values of i and z after the following code is executed : -Technology

Last Answer : Value of i = 10Value of z = 5

What will be displayed in jTextFieldl and jTextField2 after the following code is executed : -Technology

Description : What will be displayed in jTextFieldl and jTextField2 after the following code is executed : -Technology

Last Answer : OutputjTextFieldl will contain value = 12jTextField2 will contain value = 13

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

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

In Marks column of ‘Student’ table, for Rollnumber 2, the Class Teacher entered the marks as 45. -Technology

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;

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

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.

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

Consider the following table Furniture. Write SQL commands for the statements (i) to (viii) and write output for SQL queries (ix) and (x). -Technology

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

A king decided to let a prisoner try to escape the prison with his life. The king placed 2 marbles in a jar that was glued to a table. One of the marbles was supposed to be black, and one was supposed to be blue. If the prisoner could pick the blue marble, he would escape the prison with his life. If he picked the black marble, he would be executed. However, the king was very mean, and he wickedly placed 2 black marbles in the jars and no blue marbles. The prisoner witnessed the king only putting 2 black marbles in the jars. If the jar was not see-through and the jar was glued to the table and that the prisoner was mute so he could not say anything, how did he escape with his life? -Riddles

Description : A king decided to let a prisoner try to escape the prison with his life. The king placed 2 marbles in a jar that was glued to a table. One of the marbles was supposed to be black, and one was ... and that the prisoner was mute so he could not say anything, how did he escape with his life? -Riddles

Last Answer : The prisoner grabbed one of the marbles from the jar and concealed it in his hand. He then swallowed it, and picked up the other marble and showed everyone. The marble was black, and since the other marble was swallowed, it was assumed to be the blue one. So the mean king had to set him free

..... is a set of Keywords, s symbols, and a system of rules for constructing statements by which humans can communicate the instructions to be executed by a computer... 1) A Computer Program 2) A Programming Language 3) An Assembler 4) Syntax

Description : ..... is a set of Keywords, s symbols, and a system of rules for constructing statements by which humans can communicate the instructions to be executed by a computer... 1) A Computer Program 2) A Programming Language 3) An Assembler 4) Syntax

Last Answer : 2) A Programming Language

Which one of the following statements is false regarding the Distributed Cache? a) The Hadoop framework will ensure that any files in the Distributed Cache are distributed to all map and reduce tasks. b) The files in the cache can be text files, or they can be archive files like zip and JAR files. c) Disk I/O is avoided because data in the cache is stored in memory. d) The Hadoop framework will copy the files in the Distributed Cache on to the slave node before any tasks for the job are executed on that node.

Description : Which one of the following statements is false regarding the Distributed Cache? a) The Hadoop framework will ensure that any files in the Distributed Cache are distributed to all map and reduce tasks. b) ... Cache on to the slave node before any tasks for the job are executed on that node.

Last Answer : MapReduce tries to place the data and the compute as close as possible

Which of the following statements is true about a software verification and validation program? I. It strives to ensure that quality is built into software. II. It provides management with insights into the state of a software project. III. It ensures that alpha, beta, and system tests are performed. IV. It is executed in parallel with software development activities. A. I, II&III B.II, III&IV C.I, II&IV D.I, III&IV

Description : Which of the following statements is true about a software verification and validation program? I. It strives to ensure that quality is built into software. II. It provides management with insights into the state ... software development activities. A. I, II&III B.II, III&IV C.I, II&IV D.I, III&IV

Last Answer : C.I, II&IV

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?

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

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