Which of the following fields will not make a suitable primary key? (a) A customer’s account number -Technology

Which of the following fields will not make a suitable primary key? (a) A customer’s account number -Technology
by

1 Answer

Answer :

(b) From the given options, the data field can not be set as a primary key because it can’t be fixed for an object.
by

Related questions

Explain when the primary key fields of two data tables need to be the same. ?

Description : Explain when the primary key fields of two data tables need to be the same. ?

Last Answer : Due to the following condition of the relation, the primary key fields of the data tables of the two databases need to be the same to create the relation. 1. The common field must be the primary key ... field size , format etc. should be the same and two tables should be open at the same time.

A power tiller is relatively more suitable for : A. Puddling of low land paddy fields with a rotary tiller B. Primary tillage of upland paddy fields with a rotary tillers C. Primary tillage with a mould board plough D. Farm transportation work

Description : A power tiller is relatively more suitable for : A. Puddling of low land paddy fields with a rotary tiller B. Primary tillage of upland paddy fields with a rotary tillers C. Primary tillage with a mould board plough D. Farm transportation work

Last Answer : A. Puddling of low land paddy fields with a rotary tiller

What is a primary key? -Technology

Description : What is a primary key? -Technology

Last Answer : A field which uniquely identifies each record in a table is known as the primary key. e.g. emp id is the primary key of the Employee table.

Define primary key with an example. -Technology

Description : Define primary key with an example. -Technology

Last Answer : A field which uniquely identifies each record in a table is known as the primary key. e.g. emp id is the primary key of the Employee table.

What is primary key? Give an example. -Technology

Description : What is primary key? Give an example. -Technology

Last Answer : A field which uniquely identifies each record in a table is known as the primary key. e.g. emp id is the primary key of the Employee table.

What is a primary key in database? Give an example. -Technology

Description : What is a primary key in database? Give an example. -Technology

Last Answer : A field which uniquely identifies each record in a table is known as the primary key. e.g. emp id is the primary key of the Employee table.

Give one advantage of using primary key. -Technology

Description : Give one advantage of using primary key. -Technology

Last Answer : A primary key uniquely identifies the record in the table.

What is the significance of a primary key? -Technology

Description : What is the significance of a primary key? -Technology

Last Answer : A primary key cannot allow null values and must have a unique index.

What is the utility of primary key in database? Write distinct features of primary keys. -Technology

Description : What is the utility of primary key in database? Write distinct features of primary keys. -Technology

Last Answer : The primary key is used to uniquely identify the record in a database. It can be a column or a set of columns in the table.Main features of the primary key are as follows:1. It must contain a unique value for each record of the table.2. It does not contain null values.

Primary key is used to …………….. identify the record. -Technology

Description : Primary key is used to …………….. identify the record. -Technology

Last Answer : Primary key is used to uniquelyidentify the record.

The candidate key, which is not used as primary key is called ………….. key. -Technology

Description : The candidate key, which is not used as primary key is called ………….. key. -Technology

Last Answer : The candidate key, which is not used as primary key is calledalternate key.

Primary key field gives us permission to record duplicate entry. -Technology

Description : Primary key field gives us permission to record duplicate entry. -Technology

Last Answer : False A primary key is a key which identifies records uniquely in a table so it does not give us permission to record duplicate entry.

A primary key field does not allow numbers. -Technology

Description : A primary key field does not allow numbers. -Technology

Last Answer : False Primary key has to identify a unique value which can be present in a table, in a number form also. It means primary key field allow number too.

A primary key value can be NULL. -Technology

Description : A primary key value can be NULL. -Technology

Last Answer : False The primary key of table is used to uniquely identify each and every row in the table. So, its all keys and columns must be defined as NOT NULL.

A foreign key is a primary key in another table. -Technology

Description : A foreign key is a primary key in another table. -Technology

Last Answer : True When a table’s primary key field is added to a related table in order to create the common field which relates two tables, it is called a foreign key in the related table.

What is a primary key? How do we set a primary key? -Technology

Description : What is a primary key? How do we set a primary key? -Technology

Last Answer : Primary key is the key which is used to uniquely identify the records into the table. To set the primary key you have to follow the steps given below:Step 1 Select the field that you want ... 2 Click Primary Key button from the Design tab.orRight click on the selected field and select Primary Key.

Define primary key. How do you set it in MS_Access? -Technology

Description : Define primary key. How do you set it in MS_Access? -Technology

Last Answer : Primary key is the key which is used to uniquely identify the records into the table. To set the primary key you have to follow the steps given below:Step 1 Select the field that you want ... 2 Click Primary Key button from the Design tab.orRight click on the selected field and select Primary Key.

…………. is a field which is used as a primary key and numbers each record sequentially. -Technology

Description : …………. is a field which is used as a primary key and numbers each record sequentially. -Technology

Last Answer : AutoNumberis a field which is used as a primary key and numbers each record sequentially.

What is a primary key in a table? -Technology

Description : What is a primary key in a table? -Technology

Last Answer : A primary key is a special relational database table column (or combination of columns) designated to uniquely identify each & every table record. It does not contain NULL & duplicate values

Write any one similarity and one difference between primary key and unique Constraint. -Technology

Description : Write any one similarity and one difference between primary key and unique Constraint. -Technology

Last Answer : Similarity: Column with both the constraints will only take unique values.Difference: Column with Primary key constraints will not be able to hold NULL values while Column with Unique constraints will be able to hold NULL values.

Identify the primary key column of Train and Reservation. -Technology

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.

Write any one similarity and one difference between primary key and unique Constraint -Technology

Description : Write any one similarity and one difference between primary key and unique Constraint -Technology

Last Answer : Similarity: Column with both the constraints will only take unique values.Difference: Column with Primary key constraints will not be able to hold NULL values while Column with Unique constraints will be able to hold NULL values.

How NUMBER and DATE/TIME type fields are different in Access? Give any one difference. -Technology

Description : How NUMBER and DATE/TIME type fields are different in Access? Give any one difference. -Technology

Last Answer : NUMBER data type contains numeric values, while DATE/TIME type field contains date and time values.

How are fields, record and a table related to each other? Explain with the help of an example. -Technology

Description : How are fields, record and a table related to each other? Explain with the help of an example. -Technology

Last Answer : Fields are one type of information. A record contains logically related fields. A table Emp name contains logically related records.Emp NoNameSalary1.Shridhar200002.Raghav40000Here EmpNo, Name, and Salary are three different fields. 1, Shridhar, 20000 represents one complete record.

A ……… is a group of related fields. -Technology

Description : A ……… is a group of related fields. -Technology

Last Answer : A databaseis a group of related fields.

A database that contains tables linked by common fields is called a (a) Centralized database (b) Flat file database -Technology

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.

What are the views in which fields can be deleted in MS_Access? -Technology

Description : What are the views in which fields can be deleted in MS_Access? -Technology

Last Answer : Datasheet View and Design View.

Predict the output displayed in text fields named jTextField2 and jTextField3 after running the above code. -Technology

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()

Anjali writes the following commands with respect to a table employee having fields, empno, name, department, commission. -Technology

Description : Anjali writes the following commands with respect to a table employee having fields, empno, name, department, commission. -Technology

Last Answer : This is because the column commission contains a NULL value and the aggregate functions do not take into account NULL values. Thus Command1 returns the total number of records in the table whereas Command2 returns the total number of non NULL values in the column commission.

……….. allows customers to conduct financial transactions on a secure Website. -Technology

Description : ……….. allows customers to conduct financial transactions on a secure Website. -Technology

Last Answer : E-banking allows customers to conduct financial transactions on a secure Website.

Sanchita is working for a nationalized bank and is in the process of creating a table to store the details of customers of the bank. -Technology

Description : Sanchita is working for a nationalized bank and is in the process of creating a table to store the details of customers of the bank. -Technology

Last Answer : Primary key AccountNoCandidate key AccountNo and PAN NumberAlternate key PAN Number

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

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.

Write a query to display customer’s name who has withdrawn the money. -Technology

Description : Write a query to display customer’s name who has withdrawn the money. -Technology

Last Answer : Select cust_name from customer c,transaction t where c.Acc_No=t.Acc_No and Transaction_Type= 'Debit';

Write a query to display customer’s name along with their transaction details. -Technology

Description : Write a query to display customer’s name along with their transaction details. -Technology

Last Answer : Select cust_name, t.* from customer c, transaction t where c.Acc_No=t.Acc_No;

Write a query to display customer’s name who have not done any transaction yet. -Technology

Description : Write a query to display customer’s name who have not done any transaction yet. -Technology

Last Answer : Select cust_name from customer c,transaction t where c.Acc_No!=t.Acc_No;

Name the data type that should be used to store AccountCodes liko “A1001” of Customers -Technology

Description : Name the data type that should be used to store AccountCodes liko “A1001” of Customers -Technology

Last Answer : varchar data type should be used to store AccountCodes like ”A100111 of customers.

What are the types of key fields and what are they ?

Description : What are the types of key fields and what are they ?

Last Answer : There are generally 3 types of key fields such as a) Primary Key Field b) Composite Primary Key Field c) Foreign Key Field .

Which shortcut key is used to make the selected text italic? (a) Ctrl +I (b) Shift +I (c) F1 + I (d) None of these -Technology

Description : Which shortcut key is used to make the selected text italic? (a) Ctrl +I (b) Shift +I (c) F1 + I (d) None of these -Technology

Last Answer : (a) Ctrl+I is the shortcut key to make the selected text italic.

Write the significance of a foreign key. -Technology

Description : Write the significance of a foreign key. -Technology

Last Answer : A foreign key is used to Establish the relationship between any two tables of RDBMS.

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.

A foreign key is a reference of the ………….. key in another table. -Technology

Description : A foreign key is a reference of the ………….. key in another table. -Technology

Last Answer : A foreign key is a reference of the primary keyin another table.

What is the use of Enter and Esc key in a Slide Show? -Technology

Description : What is the use of Enter and Esc key in a Slide Show? -Technology

Last Answer : Press Enter to move to the next slide and Esc to close the Slide Show.

Set new timing, while rehearsing ……………… key is press. (a) Ctrl+T (b) T (c) M (d) O -Technology

Description : Set new timing, while rehearsing ……………… key is press. (a) Ctrl+T (b) T (c) M (d) O -Technology

Last Answer : (b) T key is used to set new timing while rehearsing.

What is the shortcut key to display the Microsoft PowerPoint shortcut menu? -Technology

Description : What is the shortcut key to display the Microsoft PowerPoint shortcut menu? -Technology

Last Answer : (c) Shift + F10 is the shortcut key to display the PowerPoint shortcut menu

F4 key is used to start a Slide Show. -Technology

Description : F4 key is used to start a Slide Show. -Technology

Last Answer : FalseF5 key is used to start a Slide Show.

The contents of a cell can be changed by pressing F2 key on keyboard. -Technology

Description : The contents of a cell can be changed by pressing F2 key on keyboard. -Technology

Last Answer : True F2 is a shortcut for making the cell editable.

Twisted pair cable is suitable for broadband application. -Technology

Description : Twisted pair cable is suitable for broadband application. -Technology

Last Answer : FalseTwisted pair cable has low bandwidth capabilities and broadband application requires high bandwidth.

What is the use of <tr> tag in an HTML table? Give a suitable example. -Technology

Description : What is the use of tag in an HTML table? Give a suitable example. -Technology

Last Answer : The tag creates a table row in an HTML table. A table must have atleast one row and also, it can have as many table rows as you want. A table row is divided into table cells. A table must have atleast one table cell per table row.e.g.CheadXtitle> TR Tag

Briefly explain the two broad categories of a newspaper format giving suitable examples. -Technology

Description : Briefly explain the two broad categories of a newspaper format giving suitable examples. -Technology

Last Answer : The analysis of newspaper content suggests two broad categories of newspaper formatBroadsheet Press (quality or serious press)…. Explanation with examplesTabloid Press (Popular or sensational press)… Explanation with examples

Discuss the five fundamental categories, PMEST, with the help of suitable example. -Technology

Description : Discuss the five fundamental categories, PMEST, with the help of suitable example. -Technology

Last Answer : P: Personality-the facet indicates the core point of the subject at handM: Matter-reflects substance or material of the subjectE: covers problem, action including methods, functioning, and other ... their subdivisions, continent, etc.Time: represents periods, like, years, decades, centuries, etc.