|
Question |
Rating |
View Answer |
|
What is data block? |
|
View Answer |
|
Which keyword is not valid of the BUFFER_POOL parameter of the STORAGE clause? |
|
View Answer |
|
What is meant by redo log buffer ? |
|
View Answer |
|
Which memory structures are shared? Name two. |
|
View Answer |
|
When does Oracle stop adding rows to a block? |
|
View Answer |
|
Which priviledge do you need to connect to the database, if the database is started up by using STARTUP RESTRICT? |
|
View Answer |
|
What is the Subquery ? |
|
View Answer |
|
14 Which component is not part of the ROWID? A. Tablespace B. Data file number C. Object ID D. Block ID
|
|
View Answer |
|
Which SHUTDOWN option will wait for the users to complete their uncommitted transactions?
|
|
View Answer |
|
What is difference between Cartesian Join and Cross Join ? |
|
View Answer |
|
How does Oracle determine the extent sizes for a temporary segment?
A. From the initialization parameters B. From the tables involved in the sort operation C. Using the default storage parameters for the tablespace D. The database block size
|
|
View Answer |
|
What is the difference between a unique constraint and a primary key constraint? |
|
View Answer |
|
How would you determine how much sort space is used by a user session? |
|
View Answer |
|
How many types of Sql Statements are there in Oracle? |
|
View Answer |
|
Which is not a system privilege? a. SELECT b. UPDATE ANY c. EXECUTE ANY d. CREATE TABLE
|
|
View Answer |
|
Which data dictionary view shows statistical information from the ANALYZE INDEX VALIDATE STRUCTURE command?
|
|
View Answer |
|
1. Profiles cannot be used to restrict. a. CPU time used b. Total time connected to the database c. Maximum time a session can be inactive d. Time spent reading blocks
|
|
View Answer |
|
What is the function of redo log? |
|
View Answer |
|
To use the transportable tablespace feature, the block size of the target and source database should be a. 4KB b. Same size c. Not larger that 16KB d. Different size
|
|
View Answer |
|
What is component of sga? |
|
View Answer |