What is the purpose of the description column in table Design View? -Technology

1 Answer

Answer :

(a) A Design View of the table provides three columns as Field Name, Data Type, and Description. The description column provides the facility to write the description about Field Name.

Related questions

Description : What are two areas of the Design View of the table? -Technology

Last Answer : Field description and Field properties.

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 : ‘tag is used to specify the column heading in a table. -Technology

Last Answer : True tag is used to specify the column heading in a table.

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 : 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 : 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 : 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 : What are Datasheet View and Design View? -Technology

Last Answer : In MS-Access 2007, two types of views are available to create a table as follows:1. Datasheet View It provides a visual way to create a table. It is a simple view which arranges the ... available properties for each field and can open existing tables in Design View, add, remove or change fields.

Description : How can you add a record in the table in Datasheet View? -Technology

Last Answer : Insert a RecordSteps to insert a record in a Datasheet View are as follows:Step 1When you create a table, a new blank record automatically appears in the second row of the table or If you enter ... into the fields.Step 3When you have finished adding records in the datasheet, save it and close it.

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 : What is database template? Give the description of five templates, used in Microsoft Access 2007. -Technology

Last Answer : A template is a complete tracking application with predefined tables, forms, reports, queries, macros, and relationships. Each template creates a complete end-to-end solution that you can use ... to create a projects tracking database to track multiple projects and assign tasks to different people.

Description : see the description -Technology

Last Answer : This answer was deleted by our moderators...

Description : match the time period in column one to the correct population description in column twoAPEX : Geography?

Last Answer : 1950 - 2000 : population increased by at least 38 million each yearindustrial revolution : when human populations began a rapid increaseblack plague pandemic : the last drop in human population rates20th century : when population doubled twiceAPEX

Description : .Match the terms in column I with their description in column II and choose the correct option. Column I Column II A. Dominance (i) Many genes govern a single character B. Co-dominance (ii) In a heterozygous organism only one allele ... (i) (ii) (c) (ii) (i) (iv) (iii) (d) (ii) (iii) (iv) (i)

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

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.

Description : A cell is an intersection of a row and a column. -Technology

Last Answer : True A cell is an intersection of a row and a column.

Description : The tag (column setting) have higher priority than tag (row setting). -Technology

Last Answer : True The tag (column setting) have higher priority than tag (row setting).

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.

Description : What is the name of the column heading for each category in a data source? (a) Data field (b) Field (c) Field name (d) Record -Technology

Last Answer : (c) Field name is the name of the column heading for each category in a data source.

Description : Soham has clicked on the cell residing at the intersection of first row and ninth column. What will be the address of the selected cell? -Technology

Last Answer : First row and ninth column address will be II.

Description : First row and ninth column address will be II. -Technology

Last Answer : There are two methods of adding a new worksheet iasm Excel workbook; Insert worksheet tab at the bor >m and Insert button on cells group under Home tab.

Description : What will be the column names of the below statement? -Technology

Last Answer : 1. 26th column: Z2. 28th column: AB

Description : A cell range starting from first row, first column to fourth row and fifth column be can be represented as -Technology

Last Answer : (a) [A1: E4] because row count starts from 1 and column count starts from A andfirst we write the starting cell address.

Description : Address of the cell at 10th column and 30th row is ……………… -Technology

Last Answer : Address of the cell at the 10th column and 30th row is J30.

Description : Suggest the suitable data type for Issue_Date column. -Technology

Last Answer : (i)Date(ii) alter table library modify name varchar(50);(iii) Bid column will always have a unique value which will help uniquely identify each record of Library table.(iv) Select name from library order by status desc;

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 : Identify the primary key column of Train and Reservation. -Technology

Last Answer : (i) Train-TrainIdReservation-RefNo(ii) (d) By default, the UNION operator selects all the values.

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 : (i) Write command to compute sum of every column of the data frame. -Technology

Last Answer : (i) df1.sum()(ii) df1[‘Rainfall’].mean()(iii) df1.loc[:11, ‘maxtemp’:’Rainfall’].mean( )

Description : How many rows and column will be there in the Cartesian product of the above given tables. Also mention the degree and cardinality -Technology

Last Answer : Cartesian Product:Number of Rows: 20Number of Columns: 9Degree: 9Cardinality: 20

Description : Which of the following best describes a form? (a) Form enables people to enter or view data in a database easily -Technology

Last Answer : (a) The form enables people to enter or view data in a database easily.

Description : The ………….. contains various options such as File, Edit, View etc. -Technology

Last Answer : The menu barcontains various options such as File, Edit, View etc.

Description : ……………… feature allows you to view different items such as comments, formatting etc. and also provides the option to view other author’s comments. -Technology

Last Answer : (c) Show Markup feature under Review tab allows you to view different items.

Description : Under which tab, Comments group is present, ……………… (a) Insert (b) Review (c) View (d) Mailings -Technology

Last Answer : (b) Review tab contains the Comments groug.

Description : The ………………… feature allows you to highlight and view changes made to a document. -Technology

Last Answer : TheTrack Changesfeature allows you to highlight and view changes made to a document.

Description : Write down the name of default view in a PowerPoint presentation. -Technology

Last Answer : By default, a presentation screen is always shown in Normal view.

Description : Write three functions that can be performed in Slide Sorter view of a presentation. -Technology

Last Answer : The three functions that can be performed in Slide Sorter view are as follows:1. We can see the entire presentation.2. We can move slide from one place to another using click-drag method. Also, we can rearrange the order of slides.3. We can insert, rename and delete slides.

Description : Which of the following view is useful for representing the structure of a presentation? -Technology

Last Answer : (b) Outline view is useful for checking the flow or structure of a presentation

Description : The entire presentation can be seen at a time in ………………. (a) Slide Show view (b) Outline view (c) Normal view (d) Slide Sorter view -Technology

Last Answer : (d) Slide Sorter view enables you to view the entire presentation at a time

Description : Which among the following views allows you to give a thumbnail view of all the slides in a presentation? (a) Normal view -Technology

Last Answer : (d) Slide Sorter view

Description : Rehearse Timings command is present on ………………. tab. (a) Animations (b) Review (c) Slide Show (d) View -Technology

Last Answer : c) Rehearse Timings command is present on Slide Show tab.

Description : In ………………. view, you can see all the slides in a presentation concurrently -Technology

Last Answer : In Slide Sorter view, you can see all the slides in a presentation concurrently

Description : We can delete slides in Slide Sorter view. -Technology

Last Answer : FalseUse this view to work with a group of slides or with only one slide.

Description : Has this been invented? (See description)

Last Answer : ummmmm you mean an inverter? The power source has to pull from somewhere and it would be limited in its output. They have them for cars. Or maybe this

Description : LG/Mobile phone question:Why is my phone not working? (More info in description).

Last Answer : I too have an LG phone! I would guess that it’s a combination of the battery needing to be replaced and letting it sit for so long with a dead battery in it! Call your provider and they’ll let you know for certain!

Description : ……………….. contains information that defines valid values that are stored in a column or data type. A) View B) Rule C) Index D) Default

Last Answer : C) Index

Description : Write the steps to design a database. -Technology

Last Answer : Steps to Design a DatabaseThere are various steps to design a database which are as follows:Step 1 Determine the purpose of your database The first step of designing a database is to determine the ... that the database structure meets the goals you needed, add all your existing data to the tables.

Description : XML is design to describe data. -Technology

Last Answer : True The focus of XML is on the description of data, not its presentation.

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.