Question collection of database part 2

-

1. Match the following terms and definitions:

……… Data ………..Repository ……….Metadata

……… Database Application ..……… Data Warehouse ……….Constraint

………. Database …………Information … ……User view

……….. Data independence

  1. data placed in a context or summarized
  2. application program(s)
  3. facts, text, graphics, images, etc
  4. integrated decision support database
  5. organized collection of related data
  6. includes data definitions and constraints
  7. centralized storehouse for all data definitions
  8. separation of data descriptions from programs
  9. a rule that cannot be violated
  10. logical description of portion of database

2. List any four significant differences between a file-processing system and a DBMS.

3. What are five main functions of a DBA.

4. Define Data Model with its types.

5. Explain the difference between physical and logical data independence.

Comments

Post a Comment

Popular posts from this blog

Opencart error: Notice: Trying to access array offset on value of type null in ..../vendor/scss.inc.php on line 1753

-
Image
If you see an error in opencart like below: Notice: Trying to access array offset on the value of type null in .../vendor/scss.inc.php on line 1753 then the solution is: Open the file  .../vendor/scss.inc.php and go to line as given in the above case it is 1753 where you will see code like below: foreach ($args as $arg) {     list($key, $value) = $arg;     $key = $key[1];     if (empty($key)) {         $posArgs[] = $value;     } else {         $keyArgs[$key] = $value;     } } Then change the line to the following, the changes done is in bold.  foreach ($args as $arg) {     list($key, $value) = $arg;     if (!empty($key[1])) {         $key = $key[1];     }     if (empty($key)) {         $posArgs[] = $value;     } else {         $keyArgs[$key] = $value;     } }    
Read more

Creating Class Templates

-
Image
Creating Class Templates Class templates are useful for creating abstract data types, which can then be used to create classes based on specific data types. For example, you can use a linked list template to parameterize the data that is held at each of the link list's nodes. You can use class templates to create collection templates, create new data types, and modify existing data types. This section includes the following topics: Class Template Syntax Class templates are composed of three elements: ® The template keyword ® A comma-delimited list of formal parameters, enclosed in angle brackets ( <> ) ® The class definition A class that is generated from a template is sometimes called a templated class. You can use class templates to modify existing classes. For example, you can define a class template that adds reference counting to an object as follows: template <class T> class TCount { int m_count; T m_type; public: TCount(
Read more

Fixed: Opencart installation error linux: warning: fopen(system/storage) failed to open stream: Permission denied

-
Image
Warning: fopen(/var/www/html/webocreation.com/system/storage/session/....): failed to open stream: Permission denied in /var/www/html/webocreation.com/system/library/session/file.php on line 29 Warning: flock() expects parameter 1 to be resource, bool given in /var/www/html/webocreation/system/library/session/file.php on line 31 Warning: fwrite() expects parameter 1 to be resource, bool given in /var/www/html/webocreation/system/library/session/file.php on line 33 Warning: fflush() expects parameter 1 to be resource, bool given in /var/www/html/webocreation/system/library/session/file.php on line 35 Warning: flock() expects parameter 1 to be resource, bool given in /var/www/html/webocreation/system/library/session/file.php on line 37 Warning: fclose() expects parameter 1 to be resource, bool given in /var/www/html/webocreation/system/library/session/file.php on line 39    These errors occurs because of the file permissions. In most of the forum, I found that they suggested to give full
Read more