When you define a field for a table, which of the following parameters do Access always consider optional? -Technology

When you define a field for a table, which of the following parameters do Access always consider optional? -Technology
by

1 Answer

Answer :

(d) Description field of the table is optional, as it depends on the databasedesigner that he/she wants to describe a field or not.
by

Related questions

To display the details of all those students who have IP as their optional subject. -Technology

Description : To display the details of all those students who have IP as their optional subject. -Technology

Last Answer : (i) select * from student where optional=‟IP‟;(ii) select name, stream, optional from student where name like 'A%';(iii) update student set average=average+3 where stream=‟Humanities‟ and optional='Maths';(iv) select name from student where average>75;

Consider the following table: Employee EmpNo EmpName Designation -Technology

Description : Consider the following table: Employee EmpNo EmpName Designation -Technology

Last Answer : 1. EmpNo can be selected as a primary key.2. EmpName is having unique values, but there is no guarantee that if more employees are included then there would not be multiple people with similar names.So, in future, its values may be duplicate. Thus, it cannot be made as a primary key.

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

Consider the table ‘Employee’. -Technology

Description : Consider the table ‘Employee’. -Technology

Last Answer : SELECT DISTINCT (Location) FROM Employee ;

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 Stu table , -Technology

Description : Consider the Stu table , -Technology

Last Answer : The output is

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 Series object, S_amt Table 350 Chair 200 Sofa 800 Stool 150 i. Write the command which will display the name -Technology

Description : Consider the following Series object, S_amt Table 350 Chair 200 Sofa 800 Stool 150 i. Write the command which will display the name -Technology

Last Answer : i. print(S_amt[S_amt>250])ii. S_amt.name= 'Furniture'

Consider a table SALESMAN with the following data: SNO SNAME SALARY BONUS DATE OF JOIN A01 Beena Mehta 30000 45.23 29_10_2019 A02 K. L. -Technology

Description : Consider a table SALESMAN with the following data: SNO SNAME SALARY BONUS DATE OF JOIN A01 Beena Mehta 30000 45.23 29_10_2019 A02 K. L. -Technology

Last Answer : alternative answer

Which field properties are used in Office Access 2007? Give the purpose of each field property. -Technology

Description : Which field properties are used in Office Access 2007? Give the purpose of each field property. -Technology

Last Answer : Field PropertiesAfter you create a field and set its data types, you can also set additional field properties. Setting field properties can give the database extra flexibility and functionality.Some ... control.Text, Memo, Number,Date/Time, Currency,AutoNumber, Yes/No, OLEObject, Hyperlink.

Define the AutoNumber data type in MS_ Access. -Technology

Description : Define the AutoNumber data type in MS_ Access. -Technology

Last Answer : AutoNumber data type starts with a number for the first record and it automatically increases the number by a set of amount for each record.

Distinguish between a record and a field in a table, with an example. -Technology

Description : Distinguish between a record and a field in a table, with an example. -Technology

Last Answer : Distinguish between a record and a field in a table are as follows:RecordFieldIt is a collection of data items, which represent a complete unit of information about a thing or a person.It is an ... called a record.e.g. if Employeeis a table, then empId, empName, department, salary arethe fields.

Out of the following, which one is the most appropriate data field in context of employee table, if only one of these is required? -Technology

Description : Out of the following, which one is the most appropriate data field in context of employee table, if only one of these is required? -Technology

Last Answer : (b) Date of birth is the most appropriate data field in the context of the employee table.

A field in a table is also called as ………………… . -Technology

Description : A field in a table is also called as ………………… . -Technology

Last Answer : A field in a table is also called ascolumn.

Which of the following is not a part of a table structure in MS_Access? (a) Field Name (b) Field Type -Technology

Description : Which of the following is not a part of a table structure in MS_Access? (a) Field Name (b) Field Type -Technology

Last Answer : (d) From the given options Field Name, Field Type Primary Key are the part of a table.

What data type should you choose for a zipcode field in a table? (a) Text (b) Number -Technology

Description : What data type should you choose for a zipcode field in a table? (a) Text (b) Number -Technology

Last Answer : (b) Number data type should be chosen for a zip code field in a table.

Which field property helps in setting data validation in a table? -Technology

Description : Which field property helps in setting data validation in a table? -Technology

Last Answer : (d) Validation Rule property specifies a condition that must be met before the data is accepted into the database.

To store object like image, you need to create a field in a table, having field type as …………. . -Technology

Description : To store object like image, you need to create a field in a table, having field type as …………. . -Technology

Last Answer : To store object like image, you need to create a field in a table, having field type as OLE Object.

When an array is passed as parameter to a function, which of the following statements is correct ? (A) The function can change values in the original array. (B) In C, parameters are passed by value, the function cannot change the original value in the array. (C) It results in compilation error when the function tries to access the elements in the array. (D) Results in a run time error when the function tries to access the elements in the array.

Description : When an array is passed as parameter to a function, which of the following statements is correct ? (A) The function can change values in the original array. (B) In C, parameters are passed by value, ... . (D) Results in a run time error when the function tries to access the elements in the array.

Last Answer : (A) The function can change values in the original array.

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.

What parameters to consider for an air conditioner installation?

Description : What parameters to consider for an air conditioner installation?

Last Answer : We have listed a few reasons how regular servicing and maintaining your air conditioner can safeguard the air quality of your home giving you the necessary peace of mind.Save on electricity ... Within this time, you can avail practically free services which include any minor repairs that need

For Selecting MOSFET, what are the major parameters we have to consider in the datasheet?

Description : For Selecting MOSFET, what are the major parameters we have to consider in the datasheet?

Last Answer : In MOSFET datasheet, we have to focus on following parameters: Drain to Source Voltage VDSSOn state Drain to Source Resistance RDS(ON)Reverse Recovery Current IRRReverse Recovery Charge ... Charge QG Body Diode Characteristics ID at ambient temperature Channel power dissipation Channel temperature

What are the various parameters we have to consider, while selecting IGBT?

Description : What are the various parameters we have to consider, while selecting IGBT?

Last Answer : In IGBT datasheet, we have to focus on following parameters Collector to emitter voltage VCESCollector Current ICCollector Dissipation PCJunction Temperature Tj

Consider the following statements: For pure clay, the shear strength parameters will be 1. Cohesion c = 0; and angle of internal friction  will be maximum. 2. Cohesion c is maximum; and angle of internal friction  is also maximum. 3. Angle of internal friction  is zero, with some value of cohesion c. Which of these statements is/are correct? (a) 1, 2 & 3 (b) 1 only (c) 3 only (d) 2 only

Description : Consider the following statements: For pure clay, the shear strength parameters will be 1. Cohesion c = 0; and angle of internal friction  will be maximum. 2. Cohesion c is maximum; and angle of internal friction  is also maximum. ... is/are correct? (a) 1, 2 & 3 (b) 1 only (c) 3 only (d) 2 only

Last Answer : (c) 3 only

A butt weld has been made by MMA in a 50mm thick impact tested steel plate. The welding electrode used was a basic type, 5mm diameter. The measured welding parameters for one of the runs was 250 amps, 24 volts, using DC+ve polarity, and a ROL:of 180mm per min. What would be the arc energy? a) Insufficient information given to calculate the arc energy b) 1.9 kJ/mm c) 1.87 kJ/mm d) 2.0 kJ/mm

Description : A butt weld has been made by MMA in a 50mm thick impact tested steel plate. The welding electrode used was a basic type, 5mm diameter. The measured welding parameters for one of the runs was 250 amps, 24 volts, using DC ... given to calculate the arc energy b) 1.9 kJ/mm c) 1.87 kJ/mm d) 2.0 kJ/mm

Last Answer : d) 2.0 kJ/mm

Which technique can be used to achieve input and output coverage? It can be applied to human input, input via interfaces to a system, or interface parameters in integration testing. A. Error Guessing B. Boundary Value Analysis C. Decision Table testing D. Equivalence partitioning

Description : Which technique can be used to achieve input and output coverage? It can be applied to human input, input via interfaces to a system, or interface parameters in integration testing. A. Error Guessing B. Boundary Value Analysis C. Decision Table testing D. Equivalence partitioning

Last Answer : D. Equivalence partitioning

Which technique can be used to achieve input and output coverage? It can be applied to human input, input via interfaces to a system, or interface parameters in integration testing. a) Error Guessing b) Boundary Value Analysis c) Decision Table testing d) Equivalence partitioning

Description : Which technique can be used to achieve input and output coverage? It can be applied to human input, input via interfaces to a system, or interface parameters in integration testing. a) Error Guessing b) Boundary Value Analysis c) Decision Table testing d) Equivalence partitioning

Last Answer : d) Equivalence partitioning

Compare radiation and intersection methods of plane table surveying on any two parameters.

Description : Compare radiation and intersection methods of plane table surveying on any two parameters. 

Last Answer : Radiation method Intersection method 1. It requires the plane table to occupy a single station.  1. This method requires setting the table up at minimum of two stations.  ... for locating inaccessible points by the intersection of the rays drawn from two instruments stations. 

The Unix Kernel maintains two key data structures related to processes, the process table and the user structure. Which of following information is not the part of user structure? (A) File descriptor table (B) System call state (C) Scheduling parameters (D) Kernel stack

Description : The Unix Kernel maintains two key data structures related to processes, the process table and the user structure. Which of following information is not the part of user structure? (A) File descriptor table (B) System call state (C) Scheduling parameters (D) Kernel stack

Last Answer : (C) Scheduling parameters

1. Consider a circular loop of wire lying in the plane of the table. Let the current pass through the loop clockwise. Apply the right-hand rule to find out the direction of the magnetic field inside and outside the loop. -Physics-10

Description : 1. Consider a circular loop of wire lying in the plane of the table. Let the current pass through the loop clockwise. Apply the right-hand rule to find out the direction of the magnetic field inside and outside the loop. -Physics-10

Last Answer : Solution: For the downward direction of the current, the direction of the magnetic field will be as if emerging from the table outside the loop and merging with the table inside the loop. Similarly, ... the table outside the loop and merging with the table inside the loop, as shown in the figure.

When camping how much civilization or technology should one have access to before it is no longer camping?

Description : When camping how much civilization or technology should one have access to before it is no longer camping?

Last Answer : I swear I was at a campground once where a pizza was delivered to one of the campsites.

In Random Access Memory if current will be interrupted, data will not lost. -Technology

Description : In Random Access Memory if current will be interrupted, data will not lost. -Technology

Last Answer : FalseRandom Access Memory (RAM) is a volatile memory, if current is interrupted, data will lost.

A magnetic tape is a direct access storage device. -Technology

Description : A magnetic tape is a direct access storage device. -Technology

Last Answer : FalseIt is a non-volatile memory hence, it is not direcdy accessible by the CPU.

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.

What is database template? Give the description of five templates, used in Microsoft Access 2007. -Technology

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.

Microsoft Access is an example of (a) Computer -Technology

Description : Microsoft Access is an example of (a) Computer -Technology

Last Answer : (b) MS-Access is the DataBase Management System (DBMS) found in the Microsoft Office suite.

Microsoft Office Access 2007 includes a set of database ………… which are designed for specific business needs. -Technology

Description : Microsoft Office Access 2007 includes a set of database ………… which are designed for specific business needs. -Technology

Last Answer : Microsoft Office Access 2007 includes a set of database templates which are designed for specific business needs.

Which program do you need to write HTML code? (a) Spreadsheet (b) Access -Technology

Description : Which program do you need to write HTML code? (a) Spreadsheet (b) Access -Technology

Last Answer : (c) From the given options, Notepad is useful program to write HTML code.

……… is not covered under file management. (a) Secure files (b) Easy access to files (c) Schedule processes (d) Keep backup of files -Technology

Description : ……… is not covered under file management. (a) Secure files (b) Easy access to files (c) Schedule processes (d) Keep backup of files -Technology

Last Answer : (c) Because schedule processes comes under processor management.

………….. is a visual desktop experience which provides an easy way to access desktop. -Technology

Description : ………….. is a visual desktop experience which provides an easy way to access desktop. -Technology

Last Answer : Aero is a visual desktop experience which provides an easy way to access desktop.

A good way to safeguard access to your computer is to protect it. (a) Deadbolt -Technology

Description : A good way to safeguard access to your computer is to protect it. (a) Deadbolt -Technology

Last Answer : (d) Password is a good way to safeguard access to your computer to protect it.

Making backups, keeping passwords and having access control are used for ………….. (a) Data security -Technology

Description : Making backups, keeping passwords and having access control are used for ………….. (a) Data security -Technology

Last Answer : (a) Backups, access authorised are the techniques to secure data from damage and getting lost.

A good way to safeguard access to your computer is to _________ protect it. -Technology

Description : A good way to safeguard access to your computer is to _________ protect it. -Technology

Last Answer : A good way to safeguard access to your computer isPasswordto protect it.

Random Access Memory and Read Only Memory are examples of ____________. -Technology

Description : Random Access Memory and Read Only Memory are examples of ____________. -Technology

Last Answer : Random Access Memory and Read Only Memory are examples ofPrimary Memory.

To prevent unauthorized access to and / or from the network, a system known as ......., can be implemented -Technology

Description : To prevent unauthorized access to and / or from the network, a system known as ......., can be implemented -Technology

Last Answer : To prevent unauthorized access to and / or from the network, a system known as Firewall, can be implemented by hardware and / or software.

What do you think the world would look like if specifically high school was optional?

Description : What do you think the world would look like if specifically high school was optional?

Last Answer : The military would love it, tons of young men with no purpose? Shit here’s a rifle, go get that oil

Is suffering optional?

Description : Is suffering optional?

Last Answer : Yes, pretty much like choosing not to be offended. It’s choosing not to be bothered by the misfortune.

Should voting in the US be changed from an optional right to a mandatory requirement?

Description : Should voting in the US be changed from an optional right to a mandatory requirement?

Last Answer : Compulsory voting would only morally work if a “None of the Above” choice was available. Having to choose between two scoundrels is not a free choice.

What would happen if the death penalty was optional for anyone of sound mind facing an extended prison sentence?

Description : What would happen if the death penalty was optional for anyone of sound mind facing an extended prison sentence?

Last Answer : It wouldn’t work. If the convict is truly of sound mind then they would never opt to die.

Soil Test: which optional tests should I choose?

Description : Soil Test: which optional tests should I choose?

Last Answer : answer:Soluble salts - i.e. cations like Ca, Mg, Na. High levels can negatively impact plant growth as plants will not be able to uptake water due to osmosis. Nitrogen - is a major ... otherwise, I would be more interested in particle size. Would be interested to know what other people think.