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

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

1 Answer

Answer :

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

Related questions

Validation involves which of the following: i. Helps to check the Quality of the Built Product ii. Helps to check that we have built the right product. iii. Helps in developing the product iv. Monitoring tool wastage and obsoleteness. a) Options i, ii, iii, iv are true. b) ii is true and i, iii, iv are false c) i, ii, iii are true and iv is false d) iii is true and i, ii, iv are false

Description : Validation involves which of the following: i. Helps to check the Quality of the Built Product ii. Helps to check that we have built the right product. iii. Helps in developing the product iv. Monitoring tool wastage and ... , ii, iii are true and iv is false d) iii is true and i, ii, iv are false

Last Answer : b) ii is true and i, iii, iv are false

Which field property sets limits on the data that is entered? -Technology

Description : Which field property sets limits on the data that is entered? -Technology

Last Answer : Fixed Field Length or Field Size property sets the limits on the data entered.

Which field property specifies whether the field can be left empty when entering data into a record? -Technology

Description : Which field property specifies whether the field can be left empty when entering data into a record? -Technology

Last Answer : Required property.

Write one example of data field for which you would set the Required property to Yes? -Technology

Description : Write one example of data field for which you would set the Required property to Yes? -Technology

Last Answer : In a table, when we declare a field as a primary key, then the field’s Required property must be set to Yes because, in a primary key field, we need to enter data always.

The ………….. field property makes data entry compulsory, so that the field cannot be left blank. -Technology

Description : The ………….. field property makes data entry compulsory, so that the field cannot be left blank. -Technology

Last Answer : TheRequired field property makes data entry compulsory so that the field cannot be left blank.

In the rules attribute, the………… value helps to display a table border only between rows. -Technology

Description : In the rules attribute, the………… value helps to display a table border only between rows. -Technology

Last Answer : In the rules attribute, the rows value helps to display a table border only between rows.

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.

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.

What is the "LOV of Validation" Property of an item? What is the use of it?

Description : What is the "LOV of Validation" Property of an item? What is the use of it?

Last Answer : When LOV for Validation is set to True, Oracle Forms compares the current value of the text item to the values in the first column displayed in the LOV. Whenever the validation event occurs. If ... the LOV and uses the text item value as the search criteria to automatically reduce the list.

Write the order of precedence for validation of a column in a table ?

Description : Write the order of precedence for validation of a column in a table ?

Last Answer : I. done using Database triggers. ii. done using Integarity Constraints.?

Disk Cleaner helps to free (a) data (b) recycle bin (c) spaces (d) None of these -Technology

Description : Disk Cleaner helps to free (a) data (b) recycle bin (c) spaces (d) None of these -Technology

Last Answer : (c) Disk Cleaner helps to free spaces. So that, the free spaces can be utilised to store another file or folder.

Which data type helps you to handle input that is in boolean format? -Technology

Description : Which data type helps you to handle input that is in boolean format? -Technology

Last Answer : (c) Yes/No will allow boolean value.

“Information helps us in taking decisions”. What should be the characteristics of processed data in order to take meaningful decision? -Technology

Description : “Information helps us in taking decisions”. What should be the characteristics of processed data in order to take meaningful decision? -Technology

Last Answer : For the decision to be meaningful, the processed data (or information) must have the following characteristics:1. Time Information should be available when required.2. Accuracy Information should be accurate.3. Completeness Information should be complete in every aspect.

The attribute helps to align data vertical in a single cell. (a) align (b) valign -Technology

Description : The attribute helps to align data vertical in a single cell. (a) align (b) valign -Technology

Last Answer : (b) valign attribute is used to align data vertically in a single cell.

Describe what is meant by field-level validation and form-level validation.

Description : Describe what is meant by field-level validation and form-level validation.

Last Answer : Field-level validation is the process of validating each individual field as it is entered into a form. Form-level validation describes the process of validating all of the data on a form before submitting the form.

For which type of field, “Default Value” property is not applicable? -Technology

Description : For which type of field, “Default Value” property is not applicable? -Technology

Last Answer : Attachment, AutoNumber, OLE Object.

What is the purpose of Default Value field property? -Technology

Description : What is the purpose of Default Value field property? -Technology

Last Answer : If there is a situation when you want to enter the same value for all records. Then, to avoid typing the same thing many times, you can set as a Default Value property.

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.

Which property is used to add a label to the field to assist the user? (a) Default value (b) Caption (c) Format -Technology

Description : Which property is used to add a label to the field to assist the user? (a) Default value (b) Caption (c) Format -Technology

Last Answer : (b) Caption is used to add a label to the field for assisting to the user.

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.

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.

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

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

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

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.

What is Digital Forensic? A. Process of using scientific knowledge in analysis and presentation of evidence in court B. The application of computer science and investigative procedures for a legal purpose involving the analysis of digital evidence after proper search authority, chain of custody, validation with mathematics, use of validated tools, repeatability, reporting, and possible expert presentation C. A process where we develop and test hypotheses that answer questions about digital events D. Use of science or technology in the investigation and establishment of the facts or evidence in a court of law

Description : What is Digital Forensic? A. Process of using scientific knowledge in analysis and presentation of evidence in court B. The application of computer science and investigative procedures for a legal ... technology in the investigation and establishment of the facts or evidence in a court of law

Last Answer : B. The application of computer science and investigative procedures for a legal purpose involving the analysis of digital evidence after proper search authority, chain of custody, validation with mathematics, use of validated tools, repeatability, reporting, and possible expert presentation

What is Digital Forensic? a. Process of using scientific knowledge in analysis and presentation of evidence in court b. The application of computer science and investigative procedures for a legal purpose involving the analysis of digital evidence after proper search authority, chain of custody, validation with mathematics, use of validated tools, repeatability, reporting, and possible expert presentation c. A process where we develop and test hypotheses that answer questions about digital events d. Use of science or technology in the investigation and establishment of the facts or evidence in a court of law

Description : What is Digital Forensic? a. Process of using scientific knowledge in analysis and presentation of evidence in court b. The application of computer science and investigative procedures for a legal ... technology in the investigation and establishment of the facts or evidence in a court of law

Last Answer : b. The application of computer science and investigative procedures for a legal purpose involving the analysis of digital evidence after proper search authority, chain of custody, validation with mathematics, use of validated tools, repeatability, reporting, and possible expert presentation

What is Digital Forensic? (A) Process of using scientific knowledge in analysis and presentation of evidence in court (B) The application of computer science and investigative procedures for a legal purpose involving the analysis of digital evidence after proper search authority, chain of custody, validation with mathematics, use of validated tools, repeatability, reporting, and possible expert presentation (C) process where we develop and test hypotheses that answer questions about digital events (D) Use of science or technology in the investigation and establishment of the facts or evidence in a court of law

Description : What is Digital Forensic? (A) Process of using scientific knowledge in analysis and presentation of evidence in court (B) The application of computer science and investigative procedures for a ... or technology in the investigation and establishment of the facts or evidence in a court of law

Last Answer : (B) The application of computer science and investigative procedures for a legal purpose involving the analysis of digital evidence after proper search authority, chain of custody, validation with mathematics, use of validated tools, repeatability, reporting, and possible expert presentation

What is Digital Forensic? A. Process of using scientific knowledge in analysis and presentation of evidence in court B. The application of computer science and investigative procedures for a legal purpose involving the analysis of digital evidence after proper search authority, chain of custody, validation with mathematics, use of validated tools, repeatability, reporting, and possible expert presentation C. process where we develop and test hypotheses that answer questions about digital events D. Use of science or technology in the investigation and establishment of the facts or evidence in a court of law

Description : What is Digital Forensic? A. Process of using scientific knowledge in analysis and presentation of evidence in court B. The application of computer science and investigative procedures for a legal ... technology in the investigation and establishment of the facts or evidence in a court of law

Last Answer : B. The application of computer science and investigative procedures for a legal purpose involving the analysis of digital evidence after proper search authority, chain of custody, validation with mathematics, use of validated tools, repeatability, reporting, and possible expert presentation

An approach that designs test cases by looking at the allowable data values. a) Data coverage b) Code Coverage c) Debugging d) Validation

Description : An approach that designs test cases by looking at the allowable data values. a) Data coverage b) Code Coverage c) Debugging d) Validation

Last Answer : Answer: a Explanation: Data coverage is an approach that designs test cases by looking at the allowable data values. Code coverage is an approach that designs test cases by looking at the code

An approach that designs test cases by looking at the allowable data values. a) Maintenance b) Evaluation c) Data coverage d) Validation

Description : An approach that designs test cases by looking at the allowable data values. a) Maintenance b) Evaluation c) Data coverage d) Validation

Last Answer : Answer: c Explanation: Data coverage is the term used. It is responsible for designing the test cases

A document that specifies how many times and with what data the program must be run in order to thoroughly test it. a) addressing plan b) test plan c) validation plan d) verification plan

Description : A document that specifies how many times and with what data the program must be run in order to thoroughly test it. a) addressing plan b) test plan c) validation plan d) verification plan

Last Answer : Answer: b Explanation: Test plan is the A document that specifies how many times and with what data the program must be run in order to thoroughly test it. It comes under testing

Which of the following is an application of NN (Neural Network)? a) Sales forecasting b) Data validation c) Risk management d) All of the mentioned

Description : Which of the following is an application of NN (Neural Network)? a) Sales forecasting b) Data validation c) Risk management d) All of the mentioned

Last Answer : d) All of the mentioned

Which of the following is an application of NN (Neural Network)? a) Sales forecasting b) Data validation c) Risk management d) All of the mentioned

Description : Which of the following is an application of NN (Neural Network)? a) Sales forecasting b) Data validation c) Risk management d) All of the mentioned

Last Answer : d) All of the mentioned

A table named School (containing data of students of the whole school) is created -Technology

Description : A table named School (containing data of students of the whole school) is created -Technology

Last Answer : AdmissionNo should be set as the primary key because admission numbers are unique for each and every student of the school, which is not possible in the case with RollNo and Name.

Data is stored in RDBMS in the form of (a) table (b) query -Technology

Description : Data is stored in RDBMS in the form of (a) table (b) query -Technology

Last Answer : (a) Relational Database Management System stores data in the form of relation. As we know, relations are known as table.

………….. is the smallest part of a table in which one data item can be kept. -Technology

Description : ………….. is the smallest part of a table in which one data item can be kept. -Technology

Last Answer : Fieldis the smallest part of a table in which one data item can be kept.

For what, Memo data type is used? (a) To add table (b) To store objects created in other programs -Technology

Description : For what, Memo data type is used? (a) To add table (b) To store objects created in other programs -Technology

Last Answer : (c) As we know, Memo provides character upto 65536 so, it is used for long text entries.

Memo data type allows you to store character type values in a table. -Technology

Description : Memo data type allows you to store character type values in a table. -Technology

Last Answer : True Memo data type allows upto 65536 characters.

Memo data type allows you to store only 255 characters in the table. -Technology

Description : Memo data type allows you to store only 255 characters in the table. -Technology

Last Answer : False Memo data type is used when character size is more than 255.

The Datasheet View displays the data in a table in tabular format. -Technology

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.

Design View allows users to enter data in the table. -Technology

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.

The tag is used to specify the individual table data in a table. (a) <tr> (b) <td> -Technology

Description : The tag is used to specify the individual table data in a table. (a) (b) -Technology

Last Answer : (b)The tag is used to specify the individual table data in a table.

Which one of the following is not an option for aligning data in a table? (a) justify (b) right -Technology

Description : Which one of the following is not an option for aligning data in a table? (a) justify (b) right -Technology

Last Answer : (a) justify option is not used for aligning data in a table.

In the <td> tag, td stands for (a) Table Data (b) Table Time and Date -Technology

Description : In the tag, td stands for (a) Table Data (b) Table Time and Date -Technology

Last Answer : (a) td stands for Table Data.

What is data cell? Name the <table> tag, which is used as data cell. -Technology

Description : What is data cell? Name the tag, which is used as data cell. -Technology

Last Answer : The data cell defines a cell of a table that contains data. The table data cell is coded with tag of tag. Here, td stands for Table Data. The content in the table data cell is normal and left-aligned.

…………… tag is used to insert data into a table. -Technology

Description : …………… tag is used to insert data into a table. -Technology

Last Answer : tag is used to insert data into a table.

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)

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

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.

Write the code in python to read the contents of “number.csv” file consisting of data from a mysql table and print the data of the table -Technology

Description : Write the code in python to read the contents of “number.csv” file consisting of data from a mysql table and print the data of the table -Technology

Last Answer : f = open('numbers.csv', 'r') with f:reader = csv.reader(f)for row in reader:for e in row:print(e)

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