0
Want this question answered?
Be notified when an answer is posted
Add your answer:
Earn +20 pts
What is a one-to-many relationship?
It is a term from computer databases. A relational database can have a one-to-many relationship in its data. For example, if you have a customer order database, one table will contain customer names and another will contain their orders. Each customer will only be listed once, but each customer can make many orders. So one customer can be related to many orders. Incorporating that into a database requires the creation of a one to many relationship.
How many maximum Redo Logfiles one can have in a Database?
In a database we can create 255 maximum redo log files Depends on what you specified for MAXLOGFILES during database creation (manually) or what you specified for "Maximum no. of redo log files" with DBCA. sri
Difference between database file and flat file in DBMS?
Database file is one that is stored on a server and it is in the format that the database needs to read it. It is also stored in the database catalog. A flat file is one that is dumped from a database to import or export into another database or program. A flat file is fields of data separated by delimiters, which keep the fields separated for export/import.
What are the disadvantages of normalizing a table in a database?
All databases tend to be normalized to some degree; in fact, a relational database almost must adhere to a minimum of 1NF to be useful. However, the more a database is normalized, the greater the impact of processing time of queries is likely to be. For one thing, higher levels of normalization results in larger numbers of decode tables and the like, requiring more table joins in retrieval queries and more referential integrity overhead.
Which one of the following is the most efficient way to retrieve data from an MS SQL database?
SqlDataReader
How many Access database can you have open at one time?
as many as you want
What is single-user database?
Single-user database support only one user at a time
What is the typical language for database management?
The typical language for database management is SQL. This is one of many programming languages, but this is the predominate one for database management.
What is the Difference between instance and physical database?
The terms instance and database are closely related, but don't refer to the same thing. The database is the set of files where application data (the reason for a database) and meta data is stored. An instance is the software (and memory) that Oracle uses to manipulate the data in the database. In order for the instance to be able to manipulate that data, the instance must open the database. A database can be opened (or mounted) by more than one instance, however, an instance can open at most one database.
When working in Excel you can only have one woorkbook opened at a time true or false?
False. You can have many workbooks open at the same time.
How many tables are required in access database?
one
What is a one-to-many relationship?
It is a term from computer databases. A relational database can have a one-to-many relationship in its data. For example, if you have a customer order database, one table will contain customer names and another will contain their orders. Each customer will only be listed once, but each customer can make many orders. So one customer can be related to many orders. Incorporating that into a database requires the creation of a one to many relationship.
What database object allows you to select specific information from one or many tables?
You are referring to the Microsoft Access Database. This allows you the ability to select specific information from one or many tables.
Which database object is used to view individual records one at a time?
SB
Which database application is better for one time operating business either single user or multiple user?
Access is a great database application that can be used for both single and multiple uses of a one time operating business.
What is a paper based database?
One paper-based database I can readily think of is a phone book. Paper based database is database that consists of many papers, not a e-database! Paper-based communicaton is anything written, drawn or printed.
Can one gmail be opened at the same time from different computers?
no its not possible
