0
Database Programming
Databases are collections of tables that maintain and display information, often collaboratively; this information can be used for interaction with an application or gaining general knowledge. Questions about database engines and modifying or using them belong in this category.
8,803 Questions
What are the advantages of predictive modeling?
Faith doesn't come when a person prays one or two rakat or fasts one day but rather imaan comes by striving against yourself and its desires
How disgraceful are its effects and how evil is it news?
And don't the sins come only in the situation of privacy and of inattention
Tell me who are you
And what is your knowledge
And to what level was your status raised
By Allah do you know the real person of you?
By Allah the real man is one who is alone with what he loves from the forbidden and things that come tight on him
He remembers Allah and knows that Allah sees and looks to the truth
And he becomes shy from his masters.
How does he disobey him and he sees him
How can you be free mixing acudubillah?
Beware of getting deceived by his hearing and generosity for it has gradually advanced many sinners and broken many tyrants.
When the person wants to sin then remembers Allah is looking.
Do not Allah be the most significant of those who look at you?
Be shy from the looking of your lord
For indeed he is the one who created the darkness sees me
If you believe that Allah does not see you then how great is your disbelief
Which of the decimal numbers corresponds to the binary number 00000111?
As per the 8421 rule the given binary number can be solved as :
0 0 0 0 0 1 1 1
0 0 0 0 0 4 2 1 i.e :
4+2+1 = 7
So the answer is 07 in decimal for 00000111 in binary
Is a database that is in third normal form automatically in first and second normal form?
Yes, each normal form builds upon the lower forms, such that a database in form N will also be in form N-1, N-2, etc. A database in fifth normal form, for example, will also be in first through fourth normal forms.
What are 5 examples of DBMS software and companies that are implementing this software?
ms access,foxpro,postgresql,firebird,mysql
What are the advantages of a paper based diary system?
· Can use and carry anywhere - you cant really carry a computer with you all the time, but you can carry a planner with you
· No computer skills required - you don't need 3 GCSE's to write in a planner, but you may need some to crate a spreadsheet or a paper diary in an electronic diary
· Can lose it because it doesn't break down or cant get a virus
· Cheap - if you lose it you wont need to pay a lot to replace it
· Easy to replace - you can easily get another paper diary, but an electronic diary may cost a lot to replace.
lol homework question i see
SQL
Briefly discuss the functions of management?
the planning is about a management to be manage by the person who conduct the business of his/her own
Entity instance is a single occurrence of an entity type. Also known as an instance. Unlike entity type, many instances of entity type may be represented by data stored in the database.
How do I convert 2003 access database to 2007?
Open the database in Access 2007 and save as Access 2007 format.
How does the round robin algorithm work?
There is a Queue of processes that need to work on and each process has it's time requirement to complete,
eg:
process processor time
A 3
B 8
C 6
D 4
if the processor give 1 processor time to each process , then A->B->C->D will run each taking 1 processor time and complete a cycle and each process that is not complete will add to the end of the queue, if a process is completed it will remove from the queue(not enqueueing).
This process will continue until all the process are completed and the queue is empty.
Above que will work as follows.
A->B->C->D->A->B->C->D->A->B->C->D>B->C->D->B->C->B->C->B->B-> Que is empty
in each highlighted position process that complete their process time remove from the queue and therefore the rest are processing according to queue.
The three level database architecture?
Three-Schema architecture is to separate the user applications and physical database.
- Internal level :- Describes the physical storage structure of the database.
- Conceptual level :- Describes the entities, data types, relationships, user operations, and constraints.
- External level :- It describes a particular user group is interested in and hides the rest of the database from that user group.
Which of the following formats means that users can view but not change data in a workbook?
read only
Consider a computing cluster consisting of two nodes running a database Describe two?
Consider the following two alternatives: asymmetric clustering and
parallel clustering.With asymmetric clustering, one host runs the
database application with the other host simply monitoring it. If the server
fails, the monitoring host becomes the active server. This is appropriate
for providing redundancy. However, it does not utilize the potential
processing power of both hosts.With parallel clustering, the database
application can run in parallel on both hosts.
Disadvantage
However, it does not utilize the potential
processing power of both hosts
The difficulty implementing
parallel clustering is providing some form of distributed locking
mechanism for files on the shared disk
What is back-end database testing?
It is a types of testing in which one will perform write query using sql statement whatever data you fill that data should be saved in back end .
for eaxmple my sql,sqlserver, oracle like that so on.
What is the prime attribute in a database?
It is an attribute that does not occur in some candidate key.
File accessing techniques in data management system?
Information is kept in files. Files reside on secondary storage. When this information is to be used, it has to be accessed and brought into primary main memory. Information in files could be accessed in many ways. It is usually dependent on an application.
Sequential Access: A simple access method, information in a file is accessed sequentially one record after another. To process the with record all the 1-1 records previous to 1 must be accessed. Sequential access is based on the tape model that is inherently a sequential access device. Sequential access is best suited where most of the records in a file are to be processed. For example, transaction files.
Direct Access: Sometimes it is not necessary to process every record in a file. It may not be necessary to process records in the order in which they are present. Information present in a record of a file is to be accessed only if some key value in that record is known. In all such cases, direct access is used. Direct access is based on the disk that is a direct access device and allows random access of any file block. Since a file is a collection of physical blocks, any block and hence the records in that block are accessed. For example, master files. Databases are often of this type since they allow query processing that involves immediate access to large amounts of information. All reservation systems fall into this category. Not all operating systems support direct access files. Usually files are to be defined as sequential or direct at the time of creation and accessed accordingly later. Sequential access of a direct access file is possible but direct access of a sequential file is not.
Indexed Sequential Access: This access method is a slight modification of the direct access method. It is in fact a combination of both the sequential access as well as direct access. The main concept is to access a file direct first and then sequentially from that point onwards. This access method involves maintaining an index. The index is a pointer to a block. To access a record in a file, a direct access of the index is made. The information obtained from this access is used to access the file. For example, the direct access to a file will give the block address and within the block the record is accessed sequentially. Sometimes indexes may be big. So hierarchies of indexes are built in which one direct access of an index leads to info to access another index directly and so on till the actual file is accessed sequentially for the particular record. The main advantage in this type of access is that both direct and sequential access of files is possible.
