Give any two disadvantages of the database. -Technology

Give any two disadvantages of the database. -Technology
by

1 Answer

Answer :

1. High complexity2. Database failure
by

Related questions

Give any one use of database. -Technology

Description : Give any one use of database. -Technology

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

What is database? Give example. -Technology

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.

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

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.

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 five names of database templates used in MS_Access 2007. -Technology

Description : Give five names of database templates used in MS_Access 2007. -Technology

Last Answer : Assets, Contacts, Events, Faculty and Issues.

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.

Write any two advantages of using database. -Technology

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

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

Write any two uses of database management system. -Technology

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.

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.

If a piece of data (field value) is stored in two places in the database, then storage space -Technology

Description : If a piece of data (field value) is stored in two places in the database, then storage space -Technology

Last Answer : False If a piece of data is stored in two places in the database, then storage space is wasted and changing the data in one spot will cause data inconsistency.

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

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

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.

Mention any two example of common Database Management System. -Technology

Description : Mention any two example of common Database Management System. -Technology

Last Answer : MySQL, Ingres, Postgres, Oracle etc.

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

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

Last Answer : Field. Record. is the answer

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

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.

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

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.

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

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.

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

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.

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

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.

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.

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

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

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.

Discuss the components of a database. -Technology

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.

Write the steps to design a database. -Technology

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.

Consider the following database Student:Roll No. First Name Last Name Class Marks Obtained(%) Scholarship Awarded -Technology

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

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

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.

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

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.

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

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.

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

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.

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

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.

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

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.

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

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.

Which of the following best describes a form? (a) Form enables people to enter or view data in a database easily -Technology

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.

DBMS is a program that controls the creation, maintenance and use of database. Here, DBMS referred to -Technology

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.

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

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.

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.

In database, all the data are stored at a ……………. location. -Technology

Description : In database, all the data are stored at a ……………. location. -Technology

Last Answer : In database, all the data are stored at acentralizedlocation.

What is the default extension of a MS_Access database? -Technology

Description : What is the default extension of a MS_Access database? -Technology

Last Answer : The default extension of an MS-Access database is .accdb.

The database is managed by a software package known as …………….. . -Technology

Description : The database is managed by a software package known as …………….. . -Technology

Last Answer : The database is managed by a software package known as DBMS.

Database is the collection of logically non_related data. -Technology

Description : Database is the collection of logically non_related data. -Technology

Last Answer : False A database is the collection of integrated and logically related data.

A database can have only one table. -Technology

Description : A database can have only one table. -Technology

Last Answer : False No, database does not have a limit on the number of tables. It depends on the disk space.

How will you create a blank database in MS_Access 2007? -Technology

Description : How will you create a blank database in MS_Access 2007? -Technology

Last Answer : Creating a Blank DatabaseTo create a new blank database, you need to perform the steps which are as follows:Step 1 Start Microsoft Access 2007, then Getting Started with Microsoft Office Access page will ... in the first empty cell in the Add New Field column as shown in the following figure:

A text field is initially 40 characters long and one record has an entry in this field in MS_Access database. -Technology

Description : A text field is initially 40 characters long and one record has an entry in this field in MS_Access database. -Technology

Last Answer : Since the new field length is 20 characters long. So, this field will contain only left 20 characters including spaces and the remaining data will be discarded. Thus, the data from the right side of the field will be lost.

In a MS_Access database, which component is not present? (a) Formula Bar (b) Tables -Technology

Description : In a MS_Access database, which component is not present? (a) Formula Bar (b) Tables -Technology

Last Answer : (a) MS-Access contains various components, i.e. Tables, Queries, Forms, Reports, Macros and Modules.

Consider the following database: Product Code Product Name Date of sale QtySold Customer Name Amount -Technology

Description : Consider the following database: Product Code Product Name Date of sale QtySold Customer Name Amount -Technology

Last Answer : 1. Qty Sold and Amount fields2. ProductCode field3. Date/Time data type4. ProductCode, ProductName and CustomerName fields5. 6 fields and 5 records6. Validation Rule

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

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

Last 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 ... = 88. The data type OLE Object is suitable for adding the photograph of the product to the table.

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.

When you open a database, the Ribbon appears on the left side of the MS_Access 2007 window. -Technology

Description : When you open a database, the Ribbon appears on the left side of the MS_Access 2007 window. -Technology

Last Answer : False Because ribbon appears on the top of the window.

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

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.

The refers to the database that stores the information related to the name and address of the recipients. (a) Main document -Technology

Description : The refers to the database that stores the information related to the name and address of the recipients. (a) Main document -Technology

Last Answer : (c) Data source is used to store the recipient’s information related to name and address while using mail merge.