List components of an Oracle instance?
http://www.coolinte rview.com/ interview/ 4611
Which background process and associated database component guarantees that committed data is saved even when the changes have not been recorded in the data files?
http://www.coolinte rview.com/ interview/ 4612
What is the maximum number of database writer processes allowed in an Oracle instance?http://www.coolinte rview.com/ interview/ 4613
Which background process is not started by default when you start up the Oracle instance?http://www.coolinte rview.com/ interview/ 4614
Describe a parallel server configuration.
http://www.coolinte rview.com/ interview/ 4615
Choose the right hierarchy, from largest to smallest, from this list of logical database structures.
http://www.coolinte rview.com/ interview/ 4616
Which component of the SGA contains the parsed SQL code?
http://www.coolinte rview.com/ interview/ 4617
Name the stages of processing a DML statement. What stages are part of processing a query?http://www.coolinte rview.com/ interview/ 4618
Which background process is responsible for writing the dirty buffers to the database files?http://www.coolinte rview.com/ interview/ 4619
Which component in the SGA has the dictionary cache?
http://www.coolinte rview.com/ interview/ 4620
When a server process is terminated abnormally, which background process is responsible for releasing the locks held by the user?
http://www.coolinte rview.com/ interview/ 4621
What is a dirty buffer?
http://www.coolinte rview.com/ interview/ 4622
If you are updating one row in a table using the ROWID in the WHERE clause (assume that the row is not already in the buffer cache), what will be the minimum amount of information read to the database buffer cache?
http://www.coolinte rview.com/ interview/ 4623
What happens next when a server process is not able to find enough free buffers to copy the blocks from disk?
http://www.coolinte rview.com/ interview/ 4624
Which memory structures are shared? Name two.
When a SELECT statement is issued, which stage checks the user’s privileges?http://www.coolinte rview.com/ interview/ 4626
Which memory structure records all database changes made to the instance?http://www.coolinte rview.com/ interview/ 4627
What is the minimum number of redo log files required in a database?
http://www.coolinte rview.com/ interview/ 4628
When are the system change numbers assigned?
http://www.coolinte rview.com/ interview/ 4629
Name the parts of the database buffer pool.
http://www.coolinte rview.com/ interview/ 4630
List all the valid database start-up option?
http://www.coolinte rview.com/ interview/ 4631
Which two values from the V$SESSION view are used to terminate a user session? http://www.coolinte rview.com/ interview/ 4632
To use operating system authentication to connect the database as an administrator, what should the value of the parameter REMOTE_LOGIN_ PASSWORDFILE be set to?http://www.coolinte rview.com/ interview/ 4633
What information is available in the alert log files?
http://www.coolinte rview.com/ interview/ 4634
Which parameter value is use to set the directory path where the alert log file is written? http://www.coolinte rview.com/ interview/ 4635
Which SHUTDOWN option requires instance recovery when the database is started the next time?http://www.coolinte rview.com/ interview/ 4636
Which SHUTDOWN option will wait for the users to complete their uncommitted transactions? http://www.coolinte rview.com/ interview/ 4637
How do you make a database read-only?
http://www.coolinte rview.com/ interview/ 4638
Which role is created by default to administer databases?
http://www.coolinte rview.com/ interview/ 4639
Which parameter in the ORAPWD utility is optional?
http://www.coolinte rview.com/ interview/ 4640
Which priviledge do you need to connect to the database, if the database is started up by using STARTUP RESTRICT?
http://www.coolinte rview.com/ interview/ 4641
At which stage of the database start-up is the control file opened?
http://www.coolinte rview.com/ interview/ 4642
13. User SCOTT has opened a SQL * Plus session and left for lunch. When you queired the V$SESSION view, the STATUS was INACTVE. You terminated SCOTT’s session in V$SESSION?
http://www.coolinte rview.com/ interview/ 4643
Which command will “bounce” the database-that is, shut down the database and start up the database in a single command?
http://www.coolinte rview.com/ interview/ 4644
15. When performing the command SHUTDOWN TRANASACTIONAL, Oracle performs the following tasks in what order?
http://www.coolinte rview.com/ interview/ 4645
How many panes are there in the Enterprise Manager console?
http://www.coolinte rview.com/ interview/ 4646
Using SQL*Plus, list two options which show the value of the parameter DB_BLOCK_SIZE?http://www.coolinte rview.com/ interview/ 4647
When you issue the command ALTER SYSTEM ENABLE RESTRICTED SESSION, what happens to the users who are connected to the database?
http://www.coolinte rview.com/ interview/ 4648
Which view has information about users who are ghranted SYSDBA or SYSOPER privilege?http://www.coolinte rview.com/ interview/ 4649
Which DB administration tools are included in the DBA Studio Pack?
http://www.coolinte rview.com/ interview/ 4650
How many control files are required to create a database?
http://www.coolinte rview.com/ interview/ 4651
Which environment variable or registry entry variable is used to represent the instance name?http://www.coolinte rview.com/ interview/ 4652
. What is the recommended configuration for control files?
http://www.coolinte rview.com/ interview/ 4653
You have specified the LOGFILE clause in the CREATE DATABASE command as follows. What happens if the size of the log file redo0101.log, which already exists, is 10MB?http://www.coolinte rview.com/ interview/ 4654
Which command should be issued before you can execute the CREATE DATABASE command?http://www.coolinte rview.com/ interview/ 4655
Which initialization parameter cannot be changed after creating the database?http://www.coolinte rview.com/ interview/ 4656
What does OFA stand for?
http://www.coolinte rview.com/ interview/ 4657
When creating a database, where does Oracle find information about the control files that need to be created? http://www.coolinte rview.com/ interview/ 4658
Which script creates the data dictionary views?
http://www.coolinte rview.com/ interview/ 4659
Which prefix for the data dictionary views indicate that the contents of the view belong to the current user?
http://www.coolinte rview.com/ interview/ 4660
Which data dictionary view shows information about the status of a procedure?http://www.coolinte rview.com/ interview/ 4661
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?
http://www.coolinte rview.com/ interview/ 4662
Which event trigger from the following cannot be created at the database level?http://www.coolinte rview.com/ interview/ 4663
How many data files can be specified in the DATAFILE clause when creating a database?http://www.coolinte rview.com/ interview/ 4664
Who owns the data dictionary?
http://www.coolinte rview.com/ interview/ 4666
What is the default password for the SYS user?
http://www.coolinte rview.com/ interview/ 4667
Which data dictionary view provides information on the version of the database and installed components?
http://www.coolinte rview.com/ interview/ 4668
What is the prefix for dynamic performance views?
http://www.coolinte rview.com/ interview/ 4669
Which clauses in the CREATE DATABASE command specify limits for the database?http://www.coolinte rview.com/ interview/ 4670
Which clauses in the CREATE DATABASE command specify limits for the database?http://www.coolinte rview.com/ interview/ 4671
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)?http://www.coolinte rview.com/ interview/ 4672
What is the best method to rename a control file?
http://www.coolinte rview.com/ interview/ 4673
What piece of information is not available in the control file?
http://www.coolinte rview.com/ interview/ 4674
When you create a control file, the database has to be:
http://www.coolinte rview.com/ interview/ 4675
Which data dictionary view provides the names of the control files?
http://www.coolinte rview.com/ interview/ 4676
The initialization parameter file has LOG_CHECKPOINT_ INTERVAL = 60; What does this mean?http://www.coolinte rview.com/ interview/ 4677
Which data dictionary view shows that the database is in ARCHIVELOG mode?http://www.coolinte rview.com/ interview/ 4678
What is the biggest advantage of having the control files on different disks?
http://www.coolinte rview.com/ interview/ 4679
Which file is used to record all changes made to the database and is used only when performing an instance recovery?
http://www.coolinte rview.com/ interview/ 4680
What will happen if ARCn could not write to a mandatory archive destination?http://www.coolinte rview.com/ interview/ 4681
How many ARCn processes can be associated with an instance?
http://www.coolinte rview.com/ interview/ 4682
What are the valid status codes in the V$LOGFILE view?
http://www.coolinte rview.com/ interview/ 4683
If you have two redo log groups with four members each, how many disks does Oracle recommend to keep the redo log files?
http://www.coolinte rview.com/ interview/ 4684
What happens if you issue the following command? ALTER DATABASE ADD LOGFILE (‘/logs/file1’ REUSE, ‘/logs/file2’ REUSE)
http://www.coolinte rview.com/ interview/ 4685
Which two parameters cannot be used together to specify the archive destination? http://www.coolinte rview.com/ interview/ 4686
What packages are associated with the LogMiner utility?
http://www.coolinte rview.com/ interview/ 4687
Querying which view will show whether automatic archiving is enabled?
http://www.coolinte rview.com/ interview/ 4688
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?
http://www.coolinte rview.com/ interview/ 4689
List the steps needed to rename a redo log file.
http://www.coolinte rview.com/ interview/ 4690
Which parameter is used to limit the number of dirty buffers in the buffer cache, thereby limiting the time required for instance recovery?
http://www.coolinte rview.com/ interview/ 4691
Create a statement that will add a member /logs/redo22. log to log file group 2.http://www.coolinte rview.com/ interview/ 4692
When does the SMON process automatically coalesce the tablespaces?
http://www.coolinte rview.com/ interview/ 4693
Which operation is permitted on a read – only tablespace?
http://www.coolinte rview.com/ interview/ 4694
How would you drop a tablespace if the tablespace were not empty?
http://www.coolinte rview.com/ interview/ 4695
Which command is used to enable the auto-extensible feature for a file, if the file is already part of a tablespace?
http://www.coolinte rview.com/ interview/ 4696
Monday, March 12, 2007
Subscribe to:
Posts (Atom)
