Answer the following questions based on the database given below: Prod_Id Prod_Name Category -Technology

1 Answer

Answer :

1. The primary key of the given table Product will be Prod _Id because no two products have the same Product_Id. So, it will be uniquely identified for each record in the table.2. The suitable data type for the field Unit_Cost is Number because this field in the table contains the value in numbers only.3. Crayons.4. By setting the Required property to Yes.5. To add the details of the new product the user should add a record. The steps are as follows:Step 1 Open the database.Step 2 Open the table in which you want to add a record in a Datasheet View.Step 3 If you open the table, a new blank record will automatically appear at the end of the table.Step 4 Type the data into the fields.Step 5 Save the table.6. By setting the property Default Value which is to be set as 1.7. Records = 8, Fields = 88. The data type OLE Object is suitable for adding the photograph of the product to the table.

Related questions

Description : Consider the following dataframe, and answer the questions given below: -Technology

Last Answer : (i) print(df.mean(axis = 1, skipna = True)) print(df.mean(axis = 0, skipna = True))(ii) print(df.sum(axis = 1, skipna = True))(iii) print(df.median())

Description : The director of a company uses a database to store data about job title. This is a part of the database given below: -Technology

Last Answer : 1. 62. 63. Secretary4. Finance department and their Payroll Numbers are A621 and M502.

Description : Below is the list of various types of application softwares: A. Database B. Desktop publishing C. Drawing -Technology

Last Answer : 1. Drawing2. Word processing3. Desktop publishing4. Spreadsheet5. Database

Description : In a Bank’s database, there are two tables ‘Customer’ and ‘Transaction’ as shown below. -Technology

Last Answer : (i)Acc_No, Cust_Phone(ii)All the columns having capability to become Primary Key are known as Candidate Keys.(iii)Acc_No(iv)Trans_Id

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.

Description : A query is used to retrieve data from the database based on one or more criteria. -Technology

Last Answer : False Because MS-Access 2007 supports the database object query.

Description : Look at the given table called ‘Item’ and answer the questions. ItemId ItemName ItemStock ItemDOP Quanity Purchased -Technology

Last Answer : 1. ItemID —> TextItemName —> TextItemStock —> NumberItemDOP —> DateQuantityPurchased —> Number2. ItemID and ItemName can act as primary key.

Description : Which among the below specified illustrations belongs to the category of GUI based user agents? a. mail b. pine c. Outlook & Netscape d. All of the above

Last Answer : c. Outlook & Netscape

Description : Which among the below specified illustrations belongs to the category of GUI based user agents? A. mail B. pine C. Outlook D. All of the above

Last Answer : C. Outlook

Description : Decision to stop testing should be based upon A. Successful use of specific test case design methodologies B. A percentage of coverage for each coverage category C. Rate of error detection falls below a specified threshold D. All of the above

Last Answer : D. All of the above

Description : Write command for the operations (i) to (iii) based on the spreadsheet below: -Technology

Last Answer : 1. At cell F2, type =D2*E2 and then copy this formula using mouse Fill handle onto range F3: F5.2. At cell G2, type =IF(C2=”Consumable”, F2*0.07, F2*0.11) and then copy this formula using mouse Fill handle onto range G3: G5.3. At cell G6, type =SUM(G2: G5).

Description : Mention the services which are provided by transactional category of an E_banking. -Technology

Last Answer : There are no geographical barriers and the services that can be offered at a minimum cost. Through Internet banking, you can check your transactions at any time and as many times as you want to. ... transaction. e.g. a customer login to his or her bank account by accessing the bank Website.

Description : Shri wants to search about computer vendor in Meerut excluding Dell category. -Technology

Last Answer : (c) Computer vendor + Meerut – Dell

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 : A category of software that spies of your computer activities is -Technology

Last Answer : (b) Spyware is a category of software that spies computer activities.

Description : In Excel chart, text displayed at data points to indicate the specific category is called …………….. -Technology

Last Answer : (c) Text displayed at data points to indicate the specific category is called data label.

Description : A database of information that is maintained by human editors and lists websites by category and subcategory with categorization is known as: 1. A search directory 2. Automated voice response (AVR) 3. Apps 4. Search Engine Optimization (SEO

Last Answer : A search directory

Description : Observe the following code carefully and answer the questions that follow: -Technology

Last Answer : The output of the above code will be:The Dos and Don'ts of network securityAs per the output it is evident that the list elements specified as li have been displayed in Lower case due to :text-transform: ... Also, there is a space of 10 pixels between each letter due to : letter-spacing : 10 px ;

Description : Carefully observe the following labeled screenshot and answer the questions that follow: -Technology

Last Answer : (a) Form element labeled as 1 is a Textbox and Form element labeled as 2 is a Textarea.(b)Text areas are the fields that display multiple text lines at a time hence it has been used to ... of items.To highlight one item in a dropdown box , selected clause is used in theEg:SINGAPOREJAPAN MALAYSIA

Description : Consider the following tables PATIENT and TEST and answer the questions that follow : -Technology

Last Answer : Primary key in PATIENT and TEST tables are PCODE and TESTID respectively. Because primary key of a relational table uniquely identifies each record.Foreign key in PATIENT table is TESTID whose value is derived from the primary key (TESTID) of another table (TEST).

Description : Consider the following DataFrame df and answer questions. rollno name UT1 UT2 UT3 UT4 1 Prerna Singh 24 24 20 22 -Technology

Last Answer : (i) (b)print(df.max())(ii) (a)df1=df[df[‘rollno’]==4]print(df1)(d)df1=df[df.rollno==4]print(df1)(iii)(a)both (i) and (ii)(iv)(d) both (i) and (ii)(v)(b)df [‘Grade’]=[’A’,’B’,’A’,’A’,’B’,’A’]

Description : What is part of a database that holds only one type of information? -Technology

Last Answer : Field. Record. is the answer

Description : A software that searches through a database of Web pages for particular information is known as (a) domain -Technology

Last Answer : (d) Search engine searches a software through a database of Web pages for particular information.

Description : Give any one use of database. -Technology

Last Answer : A database is used to store logically related information in the table.

Description : Explain Database Management. What are the features of DBMS? -Technology

Last Answer : It refers to the software that is responsible for storing, maintaining and utilising a database. It enables a user to define, create and maintain the database and provide controlled access on it. A ... Data security e.g. MS-Access, Corel Paradox, Lotus Approach, MySQL, OpenOffice.org Base etc.

Description : What is database? Give example. -Technology

Last Answer : A collection of related information organized as tables is known as the database, e.g. INGRES, MySQL etc.

Description : Write the relationship between a database and a table. -Technology

Last Answer : A database contains multiple tables whereas, a table cannot exist outside a database.

Description : Write any two advantages of using database. -Technology

Last Answer : 1. Can ensure data security.2. Reduces the data redundancy.

Description : What is field in database? Give an example. -Technology

Last Answer : A field is an area, reserved for a specific piece of data. It is also known as an attribute, e.g. Customer_Name.

Description : Give any two disadvantages of the database. -Technology

Last Answer : 1. High complexity2. Database failure

Description : Write any two uses of database management system. -Technology

Last Answer : 1. DBMS is used to store data at a centralized location.2. It is used to minimize data redundancy and data inconsistency.

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.

Description : What is the default extension of OO.o not zero BASE database? -Technology

Last Answer : The default extension of OO.o BASE database is .odb.

Description : What are the main purposes of a database system? -Technology

Last Answer : • Storage of information.• Retrieval of information quickly.• Sorting, selecting data that satisfies certain criteria (filtering).• Produce the report in some standardized and readable format.

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.

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.

Description : Discuss the components of a database. -Technology

Last Answer : A database consists of several components. Each component plays an important role in the database system environment.The major components of the database are as follows:DataIt is raw numbers, ... perform different operations on the database by inserting, deleting etc., through menus or forms.

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.

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 : Consider the following database Student:Roll No. First Name Last Name Class Marks Obtained(%) Scholarship Awarded -Technology

Last Answer : 1. 95.42. Mohan Garg and scholarship awarded is 50000.3. 54. 6

Description : Which of the following is not an example of database? (a) Cross knot game -Technology

Last Answer : (c) Numeric calculator because it is used to calculate the numeric numbers only as it is unable to store data.

Description : Database is a combination of (a) hardware and software -Technology

Last Answer : (a) A database consists of several components. These are data, software, hardware, and user.

Description : Operations performed on a database are controlled by (a) user (b) hardware -Technology

Last Answer : (a) Users are those persons, who need the information from the database to perform operations.

Description : Database is made up of all the following components except (a) tables (b) queries -Technology

Last Answer : (d) A database is made up of tables, queries, and forms.

Description : All the information about a thing or a person is known as a (a) database (b) file -Technology

Last Answer : (d) A record refers to a raw of data, which represents a complete set of information in a table.

Description : Which of the following is not the main building block of a database? -Technology

Last Answer : (a) The main building blocks of database are tables, queries, forms and reports.

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 : DBMS is a program that controls the creation, maintenance and use of database. Here, DBMS referred to -Technology

Last Answer : (c) Here, DBMS stands for Database Management System.

Description : RDBMS provides relational operators to manipulate the data. Here, RDBMS refers to (a) Record Database Management System -Technology

Last Answer : (b) RDBMS stands for Relational Database Management System, which provides the operator to manipulate the data stored in the database table.

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.