Description : How do you communicate with an RDBMS?
Last Answer : You communicate with an RDBMS using Structured Query Language (SQL)
Description : Name the sub-systems of a RDBMS
Last Answer : I/O, Security, Language Processing, Process Control, Storage Management, Logging and Recovery, Distribution Control, Transaction Control, Memory Management, Lock Management
Description : What is RDBMS KERNEL?
Last Answer : Two important pieces of RDBMS architecture are the kernel, which is the software, and the data dictionary, which consists of the system-level data structures used by the kernel to manage ... ; dispatches and schedules user requests; and manages space usage within its table-space structures.
Description : Where the integrity constraints are stored in Data Dictionary ?
Last Answer : The integrity constraints are stored in USER_CONSTRAINTS.
Description : What is the job of the information stored in data-dictionary?
Last Answer : The information in the data dictionary validates the existence of the objects, provides access to them, and maps the actual physical storage location.
Description : What is dictionary cache ?
Last Answer : Dictionary cache is information about the databse objects stored in a data dictionary table.
Description : What are the dictionary tables used to monitor a database space?
Last Answer : DBA_FREE_SPACE DBA_SEGMENTS DBA_DATA_FILES.
Description : What are the dictionary tables used to monitor a database spaces ?
Description : In which view can you find information about every view and table of oracle dictionary
Last Answer : DICT or DICTIONARY
Description : Data is stored in RDBMS in the form of (a) table (b) query -Technology
Last Answer : (a) Relational Database Management System stores data in the form of relation. As we know, relations are known as table.
Description : RDBMS provides relational operators to manipulate the data. Here, RDBMS refers to (a) Record Database Management System -Technology
Last Answer : (b) RDBMS stands for Relational Database Management System, which provides the operator to manipulate the data stored in the database table.
Description : RDBMS means: a) Relational Data Base Management System b) Reliable Data Base Management System c) Relational Document Base Management System d) None of These
Last Answer : a) Relational Data Base Management System
Description : In RDBMS, Data is presented as a collection of ............ A) Table B) Attributes C) Relations D) Entities
Last Answer : C) Relations
Description : Will RMAN takes backups of read-only tablespaces?
Last Answer : No
Description : Define RDBMS. -Technology
Last Answer : RDBMS is a type of DataBase Management System that stores data in the form of relations (tables). Relational databases are powerful, so they require few assumptions about how data is related or how, it will be extracted from the database.
Description : What is the full form of RDBMS ?
Last Answer : The full form of RDBMS is: Relational Data Base Management System.
Description : What is RDBMS ?
Last Answer : Relation DataBase Management System to complete RDBMS . RDBMS is the sum of the interrelated information and the complex programming required to review that information .
Description : What is Relation Database Management System ( RDBMS) ?
Last Answer : RDBMS refers to the relationship between multiple tables in a database based on a specific field (primary and foreign keys) . For example: Oracle , MySql , Ms -Sql, Microsoft Access, Microsoft Access, FoxPro , etc. Inventor : Dr. Edger Codd in 1960 .
Last Answer : A database consisting of related data tables is called RDBMS .
Description : The RDBMS terminology for a row is (A) tuple. (B) relation. (C) attribute. (D) degree.
Last Answer : (A) tuple
Description : In RDBMS, the constraint that no key attribute (column) may be NULL is referred to as: (A) Referential integrity (B) Multi-valued dependency (C) Entity Integrity (D) Functional dependency
Last Answer : (C) Entity Integrity
Description : Which one is correct w.r.t. RDBMS? (1) primary key ⊆ super key ⊆ candidate key (2) primary key ⊆ candidate key ⊆ super key (3) super key ⊆ candidate key ⊆ primary key (4) super key ⊆ primary key ⊆ candidate key
Last Answer : Answer: 2
Description : Expansion of RDBMS is (1) Repairable Database Management System (2) Relational Database Management System (3) Relational Database Memory System (4) Recurring Database Memory System
Last Answer : Relational Database Management System
Description : Can a repeating frame be created without a data group as a base?
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?
Description : Can a field be used in a report without it appearing in any data group?
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?
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.
Description : What is a data segment?
Last Answer : Each non-clustered table has a data segment. All of the table's data is stored in the extents of its data segment. Each cluster has a data segment. The data of every table in the cluster is stored in the cluster's data segment.
Description : How to define data block size?
Last Answer : A data block size is specified for each Oracle database when the database is created. A database users and allocated free database space in Oracle data blocks. Block size is specified in init.ora file and cannot be changed latter.
Description : What is data block?
Last Answer : Oracle database's data is stored in data blocks. One data block corresponds to a specific number of bytes of physical database space on disk.
Description : Physical Storage of the Data
Last Answer : The finest level of granularity of the data base are the data blocks. Data Block :: One Data Block correspond to specific number of physical database space Extent :: Extent is the number of ... Index has index segment that stores data c) Roll Back Segment :: Temporarily store 'undo' information
Description : Table Space,Data Files,Parameter File, Control Files
Last Answer : Table Space :: The table space is useful for storing the data in the database.When a database is created two table spaces are created. a) System Table space :: This data file stores all the tables ... They contain the Db name, name and location of dbs, data files ,redo log files and time stamp.
Description : What are the data types allowed in a table ?
Last Answer : CHAR,VARCHAR2,NUMBER,DATE,RAW,LONG and LONG RAW.
Description : Difference between NO DATA FOUND and %NOTFOUND?
Last Answer : NO DATA FOUND is an exception raised only for the SELECT....INTO statements when the where clause of the querydoes not match any rows. When the where clause of the explicit cursor does not match any rows the %NOTFOUND attribute is set to TRUE instead.
Description : What should be the return type for a cursor variable.Can we use a scalar data type as return type?
Last Answer : The return type for a cursor must be a record type.It can be declared explicitly as a user-defined or %ROWTYPE can be used. eg TYPE t_studentsref IS REF CURSOR RETURN students%ROWTYPE
Description : It is possible to use raw devices as data files and what is the advantages over file. system files ?
Last Answer : Yes. The advantages over file system files. I/O will be improved because Oracle is bye-passing the kernnel which writing into disk. Disk Corruption will be very less.
Description : What are the two ways by which data can be generated for a parameters list of values?
Last Answer : 1. Using static values. 2. Writing select statement.
Description : Why is it preferable to create a fewer no. of queries in the data model?
Last Answer : Because for each query, report has to open a separate cursor and has to rebind, execute and fetch data.
Description : Atleast how many set of data must a data model have before a data model can be base on it?
Last Answer : Four
Description : Can you pass data parameters to forms?
Description : Do user parameters appear in the data modal editor in 2.5?