Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
How is the database organised in Oracle?
Database organized within Oracle in terms of table and table holds attributes and values.
A database consists of one or more logical units known as table spaces. Each table space within turn, consists of one or more physical structures known as data files. These might be either, files managed through the operating system or raw devices.
Oracle database consists of subsequent table spaces.
(i) System (ii) Table spaces to store user data (iii) Temporary table spaces.
The space in table space is separated into units, called segments, that each contains data for a specific data structure. These are four kinds of segments:
(i) Data segments (ii) Index segments (iii) Temporary segments (iv) Rollback segments
Sparse and Dense Indexes These indexes in principle are the similar as that of indexes used at the back of the book. The key facts of the indexes are: They are arranged
What are the advantages of creating a table from existing table?
Explain what is DDL? DDL - Data Definition Language: statements used to define the database structure or schema. Some examples: CREATE - to create objects in the database ALT
What is Specialization? Specialization: Specialization permits you to describe new types of information (new structural types or latest domains of information), although reusin
What is ICR? A. ICR (Intelligent Character Recognition) is a technology that gives scanning and imaging systems the ability to identify images of hand-printed or script charact
sql is relationally complete-justify
Why, generally does an object-oriented system use the relational DBMS? The reasons for using relational DBMS for OO systems could be any combination of following: a. Many or
What is a view in SQL? When can views be updated? A view is a virtual table which consists of columns from one or more tables. Through it is same to a table; it is stored in
Creating views with Read only option : In the view definition this option is used to make sure that no DML operations can be done on the view.
Explain the Natural join Natural join is a binary operator which is written as (R* S) in which R and S are relations. The effect of the natural join is the set of all combinati
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +91-977-207-8620
Phone: +91-977-207-8620
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd