|
Question |
Rating |
View Answer |
|
Which optional component in the database creation process sets up functions and procedures to store, access, and analyze data needed for Geographical Information Systems (GIS)? |
|
View Answer |
|
How can you Enforce Referential Integrity in snapshots ? |
|
View Answer |
|
I WANT TO BECOME A DBA ADMINISTRATOR. SO,FOR THAT WHAT CAN I PREPARE NOW? |
|
View Answer |
|
What is a sub query and what are the different types of subqueries? |
|
View Answer |
|
What are the system resources that can be controlled through Profile ? |
|
View Answer |
|
What are the steps involved in Database Startup ? |
|
View Answer |
|
What are Most Common types of Complex master-detail relationships? |
|
View Answer |
|
How many panes are there in the Enterprise Manager console? |
|
View Answer |
|
14. Which statement is false? A. Dictionary-managed temporary tablespace can be made permanent. B. The size of the locally managed temporary tablespace file cannot be changed. C. Once created, the extent management of a tablespace cannot be altered. D. A locally managed permanent tablespace cannot be made temporary.
|
|
View Answer |
|
6. Choose the statement used to manually de-allocate the extents used by a rollback segment. A. ALTER ROLLBACK SEGMENT R01 DEALLOCATE; B. ALTER ROLLBACK SEGMENT RO1 DROP EXTENTS; C. ALTER ROLLBACK SEGMENT RO1 SHRINK; D. ALTER ROLLBACK SEGMENT RO1 SIZE 10K.
|
|
View Answer |
|
Choose two NLS parameters that cannot be modified using the ALTER SESSION statement. a. NLS_CHARACTERSET b. NLS_SORT c. NLS_NCHAR_CHARACTERSET d. NLS_TERRITORY
|
|
View Answer |
|
How can you fix the MAXEXTENTS reached error for a rollback segment? |
|
View Answer |
|
What is Mirrored on-line Redo Log ? |
|
View Answer |
|
Which resource specifies the value in minutes? |
|
View Answer |
|
What is a Database instance ? Explain |
|
View Answer |
|
Does Oracle write to data files in begin/hot backup mode? |
|
View Answer |
|
What is difference between open_form and call_form? |
|
View Answer |
|
19. What is accomplished when you issue the following statement?
ALTER USER JOHN DEFAULT ROLE ALL;
a. John is assigned all the roles created in the database b. Future roles granted to John will not be default roles c. All of John’s roles are enabled, except the roles with passwords d. All of John’s roles are enabled when connecting to the database
|
|
View Answer |
|
What are the Various Block Coordination Properties |
|
View Answer |
|
What is BLOB datatype? |
|
View Answer |