Describe the three levels of data abstraction?

1 Answer

Answer :

There are three levels of abstraction:
∙ Physical level: The lowest level of abstraction describes how data are stored. ∙ Logical level: The next higher level of abstraction, describes what data are stored in  database and what relationship among those data.
∙ View level: The highest level of abstraction describes only part of entire database.

Related questions

Description : Describe the three levels of data abstraction with diagram. 

Last Answer : Three levels of data abstraction are:  Physical level: This is the lowest level of data abstraction. It describes how data is actually stored in database. The complex data structure details ... highest level of data abstraction. This level describes the user interaction with database system.

Description : Describe following terms: Inheritance, data abstraction, data encapsulation, dynamic binding.

Last Answer : Inheritance: 1. Inheritance is the process by which objects of one class acquire the properties of objects of another class. 2. It supports the concept of hierarchical classification. It also provides the ... with a given procedure call is not known until the time of the call at run-time.

Description : What are the different Levels of Auditing ?

Last Answer : Statement Auditing, Privilege Auditing and Object Auditing.

Description : The process of removing detail from a given state representation is called ______ a) Extraction b) Abstraction c) Information Retrieval d) Mining of data

Last Answer : b) Abstraction

Description : What is Data Abstraction? How is it implemented in Java?

Last Answer : A: Act of representing only essential features without including its background details is called Abstraction. Data Abstraction can also be defined as the process of hiding the implementation details and showing ... Java, it is implemented by the use of interfaces or by making the class abstract.

Description : Explain data encapsulation and data abstraction.

Last Answer : Data encapsulation: The wrapping up of data and function into a single unit (called class) is known as encapsulation. The data is not accessible to the outside world, and only those functions ... as they hold information. The functions that operate on these data are called as member functions.

Description : Define the following terms: (i) Data abstraction (ii) Class (iii) Dynamic binding (iv) Polymorphism

Last Answer : (i) Data abstraction: Abstraction refers to the act of representing essential features without including the background details or explanation. Data abstraction is the process of defining a data type, often ... more than one form at different instances depending on the type or number of arguments. 

Description : Define (i) Data Abstraction, (ii) Data Redundancy.

Last Answer : Data abstraction is defined as  *Suppression of details of data organization and storage  *Highlighting of the essential features for an improved understanding of data  *The characteristic that allow ... of data abstraction. This level describes the user interaction with database system. 

Description : Describe what redo logs are.

Last Answer : Redo logs are logical and physical structures that are designed to hold all the changes made to a database and are intended to aid in the recovery of a database.

Description : Describe Referential Integrity ?

Last Answer : A rule defined on a column (or set of columns) in one table that allows the insert or update of a row only if the value for the column or set of columns (the dependent value) matches a value ... data and the action to be performed on dependent data as a result of any action on referenced data.

Description : Describe two phases of Two-phase commit ?

Last Answer : Prepare phase - The global coordinator (initiating node) ask a participants to prepare (to promise to commit or rollback the transaction, even if there is a failure) Commit - Phase - If ... , if all participants cannot prepare, the coordinator asks all nodes to roll back the transaction.

Description : Why abstraction in java is called as a mathematical entity?

Last Answer : answer:Abstract data classes are analogous to mathematical constructions. In Euclidean geometry, for example, the axioms would be like the methods in an abstract Java class. Since the terms in the axioms ... allow you to work with types that really are undefined and that have to be instantiated.

Description : The seals, cords, labels and bags required to be preserved in connection with investigation into a case of loss or abstraction in the RMS should be preserved in the personal custody of the: (A) Head Sorting Assistant (B) Record Officer (C) Office Supervisor of the Superintendent’s office

Last Answer : (B) Record Officer

Description : Which of the following is a tool in design phase ? Abstraction Refinement Information Hiding All of Above

Last Answer : All of Above

Description : Point out the wrong statement. a) Abstraction enables the key benefit of cloud computing: shared, ubiquitous access b) Virtualization assigns a logical name for a physical resource and then provides a ... their resources into pools that can be assigned on demand to users d) All of the mentioned

Last Answer : All cloud computing applications combine their resources into pools that can be assigned on demand to users

Description : Cloud computing is an abstraction based on the notion of pooling physical resources and presenting them as a ________ resource. a) real b) virtual c) cloud d) none of the mentioned

Last Answer : virtual

Description : Which of the following cloud concept is related to pooling and sharing of resources? a) Polymorphism b) Abstraction c) Virtualization d) None of the mentioned

Last Answer : Virtualization

Description : Which of the following is essential concept related to Cloud? a) Reliability b) Productivityc) Abstraction d) All of the mentioned

Last Answer : Abstraction

Description : The program which provide partitioning, isolation or abstraction is called? A. virtualization hypervisor B. software hypervisor C. hardware hypervisor D. system hypervisor

Last Answer : virtualization hypervisor

Description : Which of the following should be replaced with the question mark in the following figure? a) Abstraction b) Virtualization c) Mobility Pattern d) All of the mentioned

Last Answer : Virtualization

Description : Point out the wrong statement. a) Abstraction enables the key benefit of cloud computing: shared, ubiquitous access b) Virtualization assigns a logical name for a physical resource and then provides a ... their resources into pools that can be assigned on demand to users d) All of the mentioned

Last Answer : All cloud computing applications combine their resources into pools that can be assigned on demand to users

Description : Which of the following should be replaced with the question mark in the following figure? a) Abstraction b) Virtualization c) Mobility Pattern d) All of the mentioned

Last Answer : Virtualization

Description : Point out the wrong statement. a) Abstraction enables the key benefit of cloud computing: shared, ubiquitous access b) Virtualization assigns a logical name for a physical resource and then provides a ... their resources into pools that can be assigned on demand to users d) All of the mentioned

Last Answer : All cloud computing applications combine their resources into pools that can be assigned on demand to users

Description : Cloud computing is an abstraction based on the notion of pooling physical resources and presenting them as a ________ resource. a) real b) virtual c) cloud d) none of the mentioned

Last Answer : virtual

Description : Which of the following cloud concept is related to pooling and sharing of resources? a) Polymorphism b) Abstraction c) Virtualization d) None of the mentioned

Last Answer : Virtualization

Description : Which of the following should be replaced with the question mark in the following figure? a) Abstraction b) Virtualization c) Mobility Pattern d) All of the mentioned

Last Answer : Virtualization

Description : Point out the wrong statement. a) Abstraction enables the key benefit of cloud computing: shared, ubiquitous access b) Virtualization assigns a logical name for a physical resource and then provides a ... their resources into pools that can be assigned on demand to users d) All of the mentioned

Last Answer : All cloud computing applications combine their resources into pools that can be assigned on demand to users

Description : _______ is the essential concept related to cloud? a) Reliability b) Abstraction c) Productivity d) None of the above

Last Answer : Abstraction

Description : Which of the following cloud concept is related to pooling and sharing of resources? a) Polymorphism b) Abstraction c) Virtualization d) None of the mentioned

Last Answer : Virtualization

Description : What is difference between Encapsulation And Abstraction?

Last Answer : Ans. 1.Abstraction solves the problem at design level while encapsulation solves the problem at implementation level 2.Abstraction is used for hiding the unwanted data and giving relevant data. ... and Display Screen are connect with each other using different circuits , it explains Encapsulation.

Description : Define abstraction.

Last Answer : Ans. Abstraction means displaying only essential information and hiding the background details of the implementation. Real Life Example of Abstraction in Java. Abstraction shows only important things to the user and ... how it work? And also we do not know the internal functionality of a bike.

Description : What is abstraction?

Last Answer : Abstraction is of the process of hiding unwanted details from the user.

Description : Which phase is not available in software life cycle? (A) Coding (B) Testing (C) Maintenance (D) Abstraction

Last Answer : (D) Abstraction

Description : In windows 2000 operating system all the processor-dependent code is isolated in a dynamic link library called (A) NTFS file system (B) Hardware abstraction layer (C) Microkernel (D) Process Manager

Last Answer : (B) Hardware abstraction layer

Description : A Design concept Refinement is a: (A) Top-down Approach (B) Complementary of Abstraction concept (C) Process of elaboration (D) All of the above

Last Answer : (D) All of the above

Description : Module design is used to maximize cohesion and minimize coupling. Which of the following is the key to implement this rule? (A) Inheritance (B) Polymorphism (C) Encapsulation (D) Abstraction

Last Answer : (C) Encapsulation

Description : Cohesion is an extension of: (A) Abstraction concept (B) Refinement concept (C) Information hiding concept (D) Modularity

Last Answer : (C) Information hiding concept 

Description : Abstraction and encapsulation are fundamental principles that underlie the object oriented approach to software development. What can you say about the following two statements? I. Abstraction allows us to focus on what something ... and II are correct. (3) Only II is correct. (4) Only I is correct.

Last Answer : (1) Neither I nor II is correct.

Description : Can a repeating frame be created without a data group as a base?

Last Answer : No

Description : Can one resize tablespaces and data files? (for DBA)

Last Answer : One can manually increase or decrease the size of a datafile from Oracle 7.2 using the command. ALTER DATABASE DATAFILE 'filename2' RESIZE 100M; Because you can change the ... UNLIMITED DEFAULT STORAGE (INITIAL 10240 NEXT 10240 MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0) ONLINE PERMANENT;

Description : What view would you use to look at the size of a data file?

Last Answer : DBA_DATA_FILES

Description : How do you resize a data file?

Last Answer : ALTER DATABASE DATAFILE RESIZE ;

Description : How do you add a data file to a tablespace

Last Answer : ALTER TABLESPACE ADD DATAFILE SIZE

Description : Give the two types of tables involved in producing a star schema and the type of data they hold.

Last Answer : Fact tables and dimension tables. A fact table contains measurements while dimension tables will contain data that will help describe the fact tables.

Description : Explain the difference between a data block, an extent and a segment.

Last Answer : A data block is the smallest unit of logical storage for a database object. As objects grow they take chunks of additional storage that are composed of contiguous data blocks. These groupings ... that an object takes when grouped together are considered the segment of the database object.

Description : Is it possible to insert comments into sql statements return in the data model editor?

Last Answer : Yes

Description : The join defined by the default data link is an outer join yes or no?

Last Answer : Yes

Description : Can a field be used in a report without it appearing in any data group?

Last Answer : Yes

Description : For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame?

Last Answer : Yes

Description : What are the characteristics of data files?

Last Answer : A data file can be associated with only one database. Once created a data file can't change size. One or more data files form a logical unit of database storage called a tablespace.