DATA PROCESSING NECO 2020 OBJ AND ESSAY QUESTIONS AND ANSWERS EXPO
Monday 16th November 2020
Paper III & II: Objective & Essay – Data Processing
2:00pm – 5:00pm
Data base management system
What is DBMS?
DBMS software primarily functions as an interface between the end user and the database, simultaneously managing the data, the database engine, and the database schema in order to facilitate the organization and manipulation of data.
Though functions of DBMS vary greatly, general-purpose DBMS features and capabilities should include: a user accessible catalog describing metadata, DBMS library management system, data abstraction and independence, data security, logging and auditing of activity, support for concurrency and transactions, support for authorization of access, access support from remote locations, DBMS data recovery support in the event of damage, and enforcement of constraints to ensure the data follows certain rules.
A database schema design technique that functions to increase clarity in organizing data is referred to as normalization. Normalization in DBMS modifies an existing schema to minimize redundancy and dependency of data by splitting a large table into smaller tables and defining the relationship between them. DBMS Output is a built-in package SQL in DBMS that enables the user to display debugging information and output, and send messages from subprograms, packages, PL/SQL blocks, and triggers. Oracle originally developed the DBMS File Transfer package, which provides procedures to copy a binary file within a database or to transfer a binary file between databases.
A database management system functions through the use of system commands, first receiving instructions from a database administrator in DBMS, then instructing the system accordingly, either to retrieve data, modify data, or load existing data from the system. Popular DBMS examples include cloud-based database management systems, in-memory database management systems (IMDBMS), columnar database management systems (CDBMS), and NoSQL in DBMS.
Transitions in presentation package; are the signposts that help the audience navigate their way through your presentation. They can help divide information up into sub-sections, link different aspects of your talk and show progression through your topic.
(i)Great analytical skills.
(ii)Paying attention to details.
(iii)Commitment to work and self-development.
(iv)Communication skills on point.
Collation information; This includes gathering, arranging, and annotating related information; drawing tentative conclusions about the relationship of “facts” to each other and their signiﬁcance; evaluating the accuracy and reliability of each item; grouping items into logical categories; critically examining the information source.
Analysis of information; is a process of collecting, transforming, cleaning, and modeling data with the goal of discovering the required information. The results so obtained are communicated, suggesting conclusions, and supporting decision-making.
Computer virus can be defined as the set of instruction or program written by a computer programmer to disrupt the smooth of a computer system
-Slow response time
-Presence of tiny dots
-Improper display of VDU
-Incomplete saving of file