Define primary key with an example. -Technology

Define primary key with an example. -Technology
by

1 Answer

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.
by

Related questions

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.

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.

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.

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.

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

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

Last 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.

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.

…………. 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.

Define various alignments of align attribute with example. -Technology

Description : Define various alignments of align attribute with example. -Technology

Last Answer : There are some values of image alignment attribute as follows:Middle AlignmentThis alignment is different in both Internet Explorer and Mozilla Firefox. In Internet Explorer, this alignment aligns the image ... effect reproduction, usually by providing a mechanism for the union of sperm with eggs.

Define primary key and candidate key.

Description : Define primary key and candidate key.

Last Answer : Primary Key: A primary key is an attribute in Relation that uniquely identifies the rows in relation. A Primary key does not hold NULL values and duplicate values.  OR A key which is selected by the ... , Name) can be a candidate key if and only if Name and Rollno individually are not unique. 

Describe the use of primary key and unique key constraints with example?

Description : Describe the use of primary key and unique key constraints with example?

Last Answer : There are two Entity constraints: 1.Primary Key constraint 2. Unique Constraint 1. Primary Key constraint: It is use to avoid redundant/duplicate value entry within the row of specified column in ... TABLE PERSONS (P_ID NUM CONSTRAINT P_UK UNIQUE , FIRSTNAME VARCHAR(20), CITY VARCHAR(20) );

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.

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.

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.

Control Unit is called the ………….. of a computer system. (a) heart (b) nerve centre (c) primary memory (d) All of these -Technology

Description : Control Unit is called the ………….. of a computer system. (a) heart (b) nerve centre (c) primary memory (d) All of these -Technology

Last Answer : (b) Nerve centre because it controls the overall processing of a computer system.

…… memory is used to store large amount of information permanently. (a) RAM (b) ROM (c) Secondary (d) Primary -Technology

Description : …… memory is used to store large amount of information permanently. (a) RAM (b) ROM (c) Secondary (d) Primary -Technology

Last Answer : (c) Secondary memory is used to store large amount of information permanently.

Which of the following statement is false? (a) Secondary storage is faster (b) Primary storage is both volatile and non volatile in nature. -Technology

Description : Which of the following statement is false? (a) Secondary storage is faster (b) Primary storage is both volatile and non volatile in nature. -Technology

Last Answer : (a) Secondary memory is the slowest and cheapest form of memory. It cannot be processed directly by the CPU and it must be first copied into RAM.

State the primary goal of a DBMS. -Technology

Description : State the primary goal of a DBMS. -Technology

Last Answer : To provide a convenient and efficient environment in which we can store and retrieve information.

Name two possible primary keys for an Employee table. -Technology

Description : Name two possible primary keys for an Employee table. -Technology

Last Answer : Possible primary keys for an Employee table are emp code, emp phone number.

A table can have multiple primary keys. -Technology

Description : A table can have multiple primary keys. -Technology

Last Answer : False If we create multiple primary keys in a table, the primary key will be unable to find the unique key value.

What are the primary interest of online attackers in spyware? -Technology

Description : What are the primary interest of online attackers in spyware? -Technology

Last Answer : Primary interest of online attackers in spyware is using it to steal personal information for financial crimes such as carding and identity theft or to sell that information to someone else who then executes more traditional financial crimes.

Name the primary law in India dealing with cyber crime and electronic commerce. -Technology

Description : Name the primary law in India dealing with cyber crime and electronic commerce. -Technology

Last Answer : The primary law is Information Technology Act 2000.

An example of the risk involved in development is a) Key personnel may resign before the product is complete b) The manufacturer of critical components (e.g. the hardware associated with a real-time system) may go bankrupt c) Technology changes may render the product obsolete d) Competitors may market a fully functional lower-cost equivalent package e) All of these are risks involved in development.

Description : An example of the risk involved in development is a) Key personnel may resign before the product is complete b) The manufacturer of critical components (e.g. the hardware  associated with a ... a fully functional lower-cost  equivalent package e) All of these are risks involved in development.

Last Answer : e) All of these are risks involved in development.

Define a utility software. -Technology

Description : Define a utility software. -Technology

Last Answer : A utility software is a system software designed to help in the management and tuning of operating systems, computer hardwares and different application softwares.

Describe utility software and also define its types. -Technology

Description : Describe utility software and also define its types. -Technology

Last Answer : It is a system software designed to help in management and tuning of operating systems, computer hardwares and different application softwares.A single piece of utility software is usually called a ... file system which can be mounted by the operating system and treated as an individual drive.

Define the term DBMS. -Technology

Description : Define the term DBMS. -Technology

Last Answer : The full form of DBMS is a Database Management System. It is a computer based record keeping system.

Define query in the context of database. -Technology

Description : Define query in the context of database. -Technology

Last Answer : A query is an inquiry into the database using the SELECT statement. These statements give you filtered data according to your conditions and specifications indicating the fields, records, and summaries which a user wants to fetch from a database.

Define forms and what is the need of using them? -Technology

Description : Define forms and what is the need of using them? -Technology

Last Answer : In a database, a form is a window or a screen that contains numerous fields or spaces to enter data. Forms can be used to view and edit your data. It is an interface in the user-specified ... like a paper form. People generally prefer to enter data into a well-designed form, rather than a table.

Define RDBMS. -Technology

Description : Define RDBMS. -Technology

Last Answer : RDBMS is a type of DataBase Management System that stores data in the form of relations (tables). Relational databases are powerful, so they require few assumptions about how data is related or how, it will be extracted from the database.

Define database management system. Write two advantages of using database management system for school. -Technology

Description : Define database management system. Write two advantages of using database management system for school. -Technology

Last Answer : Database Management System (DBMS) is a collection of programs that enable users to create, maintain database and control all the access to the database. The primary goal of the DBMS is to ... centralized location.2. It provides security to the personal information of the school, stored in it.

Is it necessary to define a field type for a field in MS_Access? -Technology

Description : Is it necessary to define a field type for a field in MS_Access? -Technology

Last Answer : Yes, it is necessary to define a type of a field while entering data into a field.

Define the term Wi_Fi hotspot. -Technology

Description : Define the term Wi_Fi hotspot. -Technology

Last Answer : A hotspot is a site that offers Internet access over a WLAN via a router connected to a link from an Internet Service Provider (ISP).