Fresher DBA Placements papers

Fresher DBA Placements papers

Which prefix for the data dictionary views indicate that the contents of the view belong to the current user?
Which data dictionary view shows information about the status of a procedure?
How do you correct a procedure that has become invalid when one of the tables it is referring to was altered to drop a constraint?
Which event trigger from the following cannot be created at the database level?
How many data files can be specified in the DATAFILE clause when creating a database?
Who owns the data dictionary?
What is the default password for the SYS user?
Which data dictionary view provides information on the version of the database and installed components?
What is the prefix for dynamic performance views?
Which clauses in the CREATE DATABASE command specify limits for the database?
Which clauses in the CREATE DATABASE command specify limits for the database?
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)?
What is the best method to rename a control file?
What piece of information is not available in the control file?
When you create a control file, the database has to be:
Which data dictionary view provides the names of the control files?
The initialization parameter file has LOG_CHECKPOINT_INTERVAL = 60; What does this mean?
Which data dictionary view shows that the database is in ARCHIVELOG mode?
What is the biggest advantage of having the control files on different disks?
Which file is used to record all changes made to the database and is used only when performing an instance recovery?
What will happen if ARCn could not write to a mandatory archive destination?
How many ARCn processes can be associated with an instance?
What are the valid status codes in the V$LOGFILE view?
If you have two redo log groups with four members each, how many disks does Oracle recommend to keep the redo log files?
What happens if you issue the following command? ALTER DATABASE ADD LOGFILE ('/logs/file1′ REUSE, '/logs/file2′ REUSE)
Which two parameters cannot be used together to specify the archive destination?
What packages are associated with the LogMiner utility?
Querying which view will show whether automatic archiving is enabled?
If you need to have your archive log files named with the log sequence numbers as arch_0000001, arch_0000002, and so on (zero filled, fixed width), what should be the value of the LOG_ARCHIVE_FORMAT parameter?
List the steps needed to rename a redo log file.
Which parameter is used to limit the number of dirty buffers in the buffer cache, thereby limiting the time required for instance recovery?
Create a statement that will add a member /logs/redo22.log to log file group 2.
When does the SMON process automatically coalesce the tablespaces?
Which operation is permitted on a read – only tablespace?
How would you drop a tablespace if the tablespace were not empty?
Which command is used to enable the auto-extensible feature for a file, if the file is already part of a tablespace?
13. The database block size is 4KB. You created a tablespace using the following command. CREATE TABLESPACE USER_DATA DATAFILE 'C:/DATA01.DBF'; If you create an object in the database without specifying any storage parameters, what will be the size of the third extent that belongs to the object?
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.
Which statement is true regarding the SYSTEM tablespace? A. Can be me made read only. B. Can be offline. T C. Data files can be renamed. D. Data files cannot be resized
What are the recommended INITIAL and NEXT values for a temporary tablespace, to reduce fragmentation?
How would you determine how much sort space is used by a user session?
19. If you issue ALTER TABLESPACE USERS OFFLINE IMMEDIATE, which of the following statements is true? A. All data files belonging to the tablespace must be online. B. Does not ensure that the data files are available. C. Need not doe media recovery when bringing the tablespace online. D. Need to do media recovery when bringing the tablespace online.
Place the following logical storage structures in order-from the smallest logical storage unit to the largest. A. Segment B. Block C. Tablespace D. Extent
When a table is updated, where is the before image information (which can be used for undoing the changes) stored?
Which parameter specifies the number of transaction slots in a data block?
What happens if you create a rollback segment in the same tablespace where application data is stored? Choose the best answer. A. The tablespace will be fragmented. B. Performance improves, because when changes are made, undo information can be written to the same tablespace. C. There should be a minimum of two data files associated with the tablespaces when rollback segments are created. D. None of the above is true.
5. Which storage parameter is applicable only to rollback segments? A. PCTINCREASE B. MAXEXTENTS C. TRANASACTIONS D. None of the above.
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.
Which data dictionary view would you query to see the free extents in a tablespace?
What is the minimum number of extents a rollback segment can have?
Which portion of the data block stores information about the table having rows in this block?