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 properties of relations in database management?
1.each row must have unique(pk)in a relation.
2.database must have a unique name.
3.each column must have unique name.
What are the duties of database administrator?
A database administrator is a person who works in IT and who has a bachelor's degree in computer science, information technology or engineering. The duties involve designing and developing databases, improving performance of databases and system monitoring.
What does a sort mean in a database?
Sort refers to the action wherein the data fetched from a database table is ordered as per a specific criteria. The default order of sort is Ascending and the user can do a descending sort by using the keyword DESC after the order by keyword.
Ex: select * from employee_details order by employee_num desc
If the above statement is executed data will be displayed in descending order of employee numbers.
How do you manipulate a data in a database?
You can manipulate data in a database by using the DML - Data Manipulation Language statements. These include:
- Insert
- Update and
- Delete
By using these 3 statements you can manipulate the data in a database.
What are the measures to secure and maintain data integrity?
these are some measures to secure and main5ain data integrity Software Restrictions: passwords, encryption, virus protection,
firewall; physical access restrictions: biometric systems, guards,
locks; fire/water proof cabinets; archiving; backup and recovery
procedures; propriety data and software.
this cam from the cxc sullybus for 2011
List the importance of security and data verification?
- To make sure the source data are well defined, documented.
- To ensure data accuracy.
- To ensure data completeness.
- To ensure data consistency.
- To ensure the reliability of the data collected.
What are the advantages and disadvantages of binary trees?
1. This makes the Tree more complex.
as we need to keep the record of node's Predecessor and successor
2. Postorder traversal is too complex and there might be changes of errors when
both the child are not present & both values of nodes pointer to their
Predecessor.
-Snehal Javheri
Distinct features of queue and stack?
A stack is a data structure in which last item inserted is taken out first . That's why they are known as LIFO (last in first out). Inserting an item in stack is termed as push and taking an item out from stack I s termed as pop. Some applications of stack are : Polish notation, reversing string, backtracking , quick sort algorithm etc. The queue is a linear data structure where operations od insertion and deletion are performed at separate ends also known as front and rear. Queue is a FIFO structure that is first in first out. Whenever a new item is added to queue, rear pointer is used. and the front pointer is used when an item is deleted from the queue.
What is the difference between constraints and criteria?
A constraint has a limit as for criteria: to end a loop Excel Questions
Organizing.
Advantages and disadvantages of cost management system?
advantages of cost management in relation to finacial efficiency
transitive dependency
Do you report discontinued operations for a non public entity?
The only difference between the private and the nonprofit sector, where you find the government and private nonprofit entities, is that you do not have an equity section. A government does not have shareholders in the private sense. It is owned by its citizens as a commonwealth.
A private nonprofit does not have shareholders either because there is nothing to share. They receive donations, not revenues. However, they can run a small, revenue earning business. That would have to be accounted for separately from the actual operation of the nonprofit because running a store is not a charitable activity even when the merchandise is sold at cost.
An nonprofit organization can have different operations. It can allocate a budget to each and then incur expenses. When it eliminates any operation, it then has a discontinued operation. After all, you either list it as part of operations, or as discontinued this year and not at all in the next. Either way, an entity has to account for changes in operations. I already mentioned the store above. That is an operation. For a nonpublic entity, there is a limit to how much revenue it can generate. Above that amount, it may have to be spun off because it erodes the tax exempt status of the nonpublic, i.e. private nonprofit.
Because it uniquely identifies each record in that table, No two records can have the exact same entry in the field designated as the primary key.
What Are responsible to oversee the general operations of the database system?
database management systems
primary key is a column or set of columns (called composite primary key ) that identify the table & make every table unique .
value of a primary key can not duplicated & can not be NULL .
How do you display a subset of columns in SQL?
By putting only the columns that you want to display after the select clause. Example:
select colname1, colname2
from tablename;
There are several different types of data. Some include qualitative and quantitative. Qualitative is data that is not numeric and quantitative data is numerical.
What are the advantages and disadvantages of file based systems?
File-based systems are low cost and do not need external storage or somebody that is extremely knowledgeable in technology. Disadvantages include data duplication, lack of flexibility, and a lack of security.
What is the main advantage of the microkernel approach to system design?
Microkernels provide minimal process and memory management, in addition to a communication facility.
