|Hypertext Markup LanguageCascading Style SheetsExtensible Markup LanguageJava ScriptjQueryAngularJSOracle SQLOracle PL/SQLOracle D2K FormsOracle D2K ReportsOracle DatabaseJavaJava Database ConnectivityJava ServletJava Server PagesHibernateApache TomcatCC++PHPMy-SqlUnix/LinuxMS-DOSHR Interviews|
|What are the components of Logical database structure of ORACLE database?|
|Tablespaces and the Database's Schema Objects.|
Thanks for your comment.!
Write a comment(Click here) ...
|What are the components of Physical database structure of Oracle Database?|
|ORACLE database is comprised of three types of files. One or more Data files, two are more Redo Log files, and one or more Control files.|
|What is a Tablespace?|
|A database is divided into Logical Storage Unit called tablespaces. A tablespace is used to grouped related logical structures together.|
|What is SYSTEM tablespace and When is it Created?|
|Every ORACLE database contains a tablespace named SYSTEM, which is automatically created when the database is created. The SYSTEM tablespace always contains the data dictionary tables for the entire database. Explain the relationship among Database, Tablespace and Data file. Each databases logically divided into one or more tablespaces One or more data files are explicitly created for each tablespace.|
|What is schema?|
|A schema is collection of database objects of a User.|
|What are Schema Objects ?|
|Schema objects are the logical structures that directly refer to the database's data. Schema objects include tables,views,sequences,synonyms, indexes, clusters, database triggers, procedures, functions packages and database links.|
|Can objects of the same Schema reside in different tablespaces.?|
|Can a Tablespace hold objects from different Schemes ?|
|What is Data Block?|
|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.|
|How to define Data Block size?|
|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 datablocks. Block size is specified in INIT.ORA file and cann't be changed latter.|
|What is Row Chaining?|
|In Circumstances, all of the data for a row in a table may not be able to fit in the same data block. When this occurs, the data for the row is stored in a chain of data block (one or more) reserved for that segment.|
|What is an Extent?|
|An Extent is a specific number of contiguous data blocks, obtained in a single allocation, used to store a specific type of information.|
|What is a Segment?|
|A segment is a set of extents allocated for a certain logical structure.|
|What are the different types of Segments?|
|Data Segment, Index Segment, Rollback Segment and Temporary Segment.|
|What is a Data Segment?|
|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.|
|What is an Index Segment?|
|Each Index has an Index segment that stores all of its data.|
|What is Rollback Segment?|
|A Database contains one or more Rollback Segments to temporarily store undo information.|
Swapnil start from his home and walked 35 km towards east, after that he turned to his right and walked 20 km. He again turned to his right and walks 35 km. Finally, he turned to his left and walked 20 km and reached his office. How far is his office from his home?
How many 2 digit numbers are divisible by 6?
|HCF and LCM|
Find the smallest square number which is exactly divisible by 3, 5, 15, 18, 20 and 24?
HCF and LCM of two numbers are 82 and 574 respectively. if one of the numbers is 287, find the second number?
How many numbers between 1200 to 1500 are multiple of 13?
Find the total number of terms in the series : -3, 1, 5, 9,............., 101 ?
Find the sum of the first 20 terms of the series : 8, -3, 11, -6, 14, -12, 17, -24,....... ?
Find the missing term in the given series - 101, 120, 145, 168, (?), 224
Find the missing term in the given series - 11A13, 17E19, (?), 31O37, 41U43
Find the missing term in the given series - 2,4,8,3,9,27,4,16,(?),5,25,125
Which gas is fixed by Rhizobium bacteria present in the root nodules of a pea plant ?
The formation of sulphurous acid involves ?
The acid present in soft drinks is ?
The cathode of a dry cell is made of ?
The number of atoms present in the molecule of an element is known as its?
If the angle of incidence formed by a ray of light on a plane mirror is 37°, then the angle of refraction is?
A dynamo converts ?
If the time taken for hearing the echo of a girl's voice after reflection from a cliff is 6 seconds, calculate the distance of the girl from cliff ?
Institute of Banking Personnel Selection (IBPS) - CRP SPL-IX - 1163 Posts - 26/11/2019 Last date
Reserve Bank of India (RBI) - 199 Posts - 11/10/2019 Last date
Life Insurance Corporation of India (LIC) - 7942 Posts - 01/10/2019 Last date
State Bank of India (SBI) - CRPD/APPR - 700 Posts - 06/10/2019 Last date
|Jobs in Jharkhand|
Jharkhand Staff Selection Commission (JSSC) -JANMCE - 1985 Posts - 04/10/2019 Last date
|Jobs in Madhya Pradesh|
National Health Mission (NHM) - 1392 Posts - 05/10/2019 Last date
|Jobs in Bihar|
Bihar Vidhan Parishad - 136 Posts - 11/10/2019 Last date
NABARD - 91 Posts - 02/10/2019 Last date
Institute of Banking Personnel Selection (IBPS) - CRP Clerks-IX - 12075 Posts - 09/10/2019 Last date
Haryana State Cooperative Apex Bank Ltd - 978 Posts - 31/08/2019 Last date