Oracle Interview Questions : Realistic interview questions !!!

Thread: Oracle Interview Questions : Realistic interview questions !!!

Search this list only Search all lists
Oracle Interview Questions : Realistic interview questions !!!
United States	2007-10-19 07:10:20

Interview Questions Home \| Ask Questions \| Interview Success Kit Oracle Interview Questions Welcome to the exciting world of New Interview Questions. Here, you can read the existing answers, provide your own answers, ask new questions, save your favorite questions and do much more! w hat is difference between procedure and stored procedure? http://www.newinterviewquestions.com/interview/11349 Sql Query in not comming in reort text file while using spreport in STATSPACK. Why? http://www.newinterviewquestions.com/interview/11356 1)how we retrive the records which is in column wise to view the records in row wise? 2)if table A having 10,000 records and if table B having 5000 records.then how and what way we join the table and retrive records so that the execution will be faster? http://www.newinterviewquestions.com/interview/11404 HOW CAN I DELETE THE DUPLICATE ROW FROM A TABLE? http://www.newinterviewquestions.com/interview/11421 What are the differences between oracle 8i and oracle 9i? http://www.newinterviewquestions.com/interview/11482 What is oracle structure? http://www.newinterviewquestions.com/interview/11507 what is mean by E-R MODELLING? http://www.newinterviewquestions.com/interview/11514 diff bet ms-access and oracle http://www.newinterviewquestions.com/interview/11559 2.Difference between SUBSTR and INSTR ? http://www.newinterviewquestions.com/interview/11587 How do I eliminate the duplicate rows ? http://www.newinterviewquestions.com/interview/11591 To view installed Oracle version information ? http://www.newinterviewquestions. com/interview/11595 What is a Non Query Record Group? http://www.newinterviewquestions.com/interview/11598 *1 select from dual 2 select 2+nvl from dual give the ans of above 2 q http://www.newinterviewquestions.com/interview/11600 what is the defference from right & full right join http://www.newinterviewquestions.com/interview/11601 Who is the owner of oracle software http://www.newinterviewquestions.com/interview/11663 What is the difference between truncate and delete? http://www.newinterviewquestions.com/interview/11670 Difference between table and views http://www.newinterviewquestions.com/interview/11698 how many types of trigger ? many site give the ans but all ar e diffr. because all tell tree type five types or 12 types,etc. clerify pls. http://www.newinterviewquestions.com/interview/11719 List components of an Oracle instance? http://www.newinterviewquestions.com/interview/4612 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.newinterviewquestions.com/interview/4613 What is the maximum number of database writer processes allowed in an Oracle instance? http://www.newinterviewquestions.com/interview/4614 Which backgrou nd process is not started by default when you start up the Oracle instance? http://www.newinterviewquestions.com/interview/4615 Describe a parallel server configuration. http://www.newinterviewquestions.com/interview/4616 Choose the right hierarchy, from largest to smallest, from this list of logical database structures. http://www.newinterviewquestions.com/interview/4617 Which component of the SGA contains the parsed SQL code? http://www.newinterviewquestions.com/interview/4618 Name the stages of processing a DML statement. What stages are part of processing a query? http://www.newinterviewquestions.com/interview/4619 Which backgrou nd process is responsible for writing the dirty buffers to the database files? http://www.newinterviewquestions.com/interview/4620 Which component in the SGA has the dictionary cache? http://www.newinterviewquestions.com/interview/4621 When a server process is terminated abnormally, which background process is responsible for releasing the locks held by the user? http://www.newinterviewquestions.com/interview/4622 What is a dirty buffer? http://www.newinterviewquestions.com/interview/4623 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.newinterviewquestions.com/interview/4624 What happens next when a server process is not able to find enough free buffers to copy the blocks from disk? http://www.newinterviewquestions.com/interview/4625 Which memory structures are shared? Name two. http://www.newinterviewquestions.com/interview/4626 When a SELECT statement is issued, which stage checks the user’s privileges? http://www.newinterviewquestions.com/interview/4627 Which memory structure records all database changes made to the instance? http://www.newinterviewquestions.com/interview/4628 What is the minimum number of redo log files required in a database? http://www.newinterviewquestions.com/interview/4629 When are the system change numbers assigned? http://www.newinterviewquestions.com/interview/4630 Name the parts of the database buffer pool. http://www.newinterviewquestions.com/interview/4631 List all the valid database start-up option? http://www.newinterviewquestions.com/interview/4632 Which two values from the V$SESSION view are used to terminate a user session? http://www.newinterviewquestions.com/interview/4633 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.newinterviewquestions.com/interview/4634 What information is available in the alert log files? http://www.newinterviewquestions.com/interview/4635 Which parameter value is use to set the directory path where the alert log file is written? http://www.newinterviewquestions.com/interview/4636 Which SHUTDOWN option requires instance recovery when the database is started the next time? http://www.newinterviewquestions.com/interview/4637 Which SHUTDOWN option will wait for the users to complete their uncommitted transactions? http://www.newinterviewquestions.com/interview/4638 How do you make a database read-only? http://www.newinterviewquestions.com/interview/4639 Which role is created by default to administer databases? http://www.newinterviewquestions.com/interview/4640 Which parameter in the ORAPWD utility is optional? http://www.newinterviewquestions.com/interview/4641 Which priviledge do you need to connect to the database, if the database is started up by using STARTUP RESTRICT? http://www.newinterviewquestions.com/interview/4642 < b>At which stage of the database start-up is the control file opened? http://www.newinterviewquestions.com/interview/4643 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.newinterviewquestions.com/interview/4644 Which command will “bounce” the database-that is, shut down the database and start up the database in a single command? http://www.newinterviewquestions.com/interview/4645 15. When performing the command SHUTDOWN TRANASACTIONAL, Oracle performs the following tasks in what order? http://www.newinterviewquestions.com/interview/4646 How many panes are there in the Enterprise Manager console? http://www.newinterviewquestions.com/interview/4647 Using SQLPlus, list two options which show the value of the parameter DB_BLOCK_SIZE?* http://www.newinterviewquestions.com/interview/4648 When you issue the command ALTER SYSTEM ENABLE RESTRICTED SESSION, what happens to the users who are connected to the database? http://www.newinterviewquestions.com/interview/4649 Which view has information about users who are ghranted SYSDBA or SYSOPER privilege? http://www.newinterviewquestions.com/interview/4650 Which DB administration tools are included in the DBA Studio Pack? http://www.newinterviewquestions.com/interview/4651 How many control files are required to create a database? http://www.newinterviewquestions.com/interview/4652 Which environment variable or registry entry variable is used to represent the instance name? http://www.newinterviewquestions.com/interview/4653 . What is the recommended configuration for control files? http://www.newinterviewquestions.com/interview/4654 You have specified the LOGFILE clause in the CREATE DATABASE command as follows. What happens if the size of the log fi le redo0101.log, which already exists, is 10MB? http://www.newinterviewquestions.com/interview/4655 Which command should be issued before you can execute the CREATE DATABASE command? http://www.newinterviewquestions.com/interview/4656 Which initialization parameter cannot be changed after creating the database? http://www.newinterviewquestions.com/interview/4657 What does OFA stand for? http://www.newinterviewquestions.com/interview/4658 When creating a database, where does Oracle find information about the control files that need to be created? http://www.newinterviewquestions.com/interview/4659 Which script creates the d ata dictionary views? http://www.newinterviewquestions.com/interview/4660 Which prefix for the data dictionary views indicate that the contents of the view belong to the current user? http://www.newinterviewquestions.com/interview/4661 Which data dictionary view shows information about the status of a procedure? http://www.newinterviewquestions. com/interview/4662 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.newinterviewquestions.com/interview/4663 Which event trigger from the following cannot be created at the database level? http://www.newinterviewquestions.com/interview/4664 Who owns the data dictionary? http://www.newinterviewquestions.com/interview/4666 Who owns the data dictionary? http://www.newinterviewquestions.com/interview/4667 What is the default password for the SYS user? http://www.newinterviewquestions.com/interview/4668 Which data dictionary view provides information on the version of the database and installed components? http://www.newinterviewquestions.com/interview/4669 What is the prefix for dynamic performance views? http://www.newinterviewquestions.com/interview/4670 Which clauses in the CREATE DATABASE command specify limits for the database? http://www.newinterviewquestions.com/interview/4671 Which clauses in the CREATE DATABASE command specify limits for the database? http://www.newinterviewquestions.com/interview/4672 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.newinterviewquestions.com/interview/4673 What is the best method to rename a control file? http://www.newinterviewquestions.com/interview/4674 What piece of information is not available in the control file? http://www.newinterviewquestions.com/interview/4675 When you create a control file, the database has to be: http://www.newinterviewquestions.com/interview/4676 Which data dictionary view provides the names of the control files? http://www.newinterviewquestions.com/interview/4677 The initialization parameter file has LOG_CHECKPOINT_INTERVAL = 60; What does this mean? http://www.newinterviewquestions.com/interview/4678 < b>Which data dictionary view shows that the database is in ARCHIVELOG mode? http://www.newinterviewquestions.com/interview/4679 What is the biggest advantage of having the control files on different disks? http://www.newinterviewquestions.com/interview/4680 Which file is used to record all changes made to the database and is used only when performing an instance recovery? http://www.newinterviewquestions.com/interview/4681 What will happen if ARCn could not write to a mandatory archive destination? http://www.newinterviewquestions.com/interview/4682 How many ARCn processes can be associated with an instance? http://www.newinterviewquestions.com/interview/4683 What are the valid status codes in the V$LOGFILE view? http://www.newinterviewquestions.com/interview/4684 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.newinterviewquestions.com/interview/4685 What happens if you issue the following command? ALTER DATABASE ADD LOGFILE (‘/logs/file1’ REUSE, ‘/logs/file2’ REUSE) http://www.newinterviewquestions.com/interview/4686 Which two parameters cannot be used together to specify the archive destination? http://www.newinterviewquestions.com/interview/4687 What packages are associated with the LogMiner utility? http://www.newinterviewquestions.com/interview/4688 Querying which view will show whether automatic archiving is enabled? http://www.newinterviewquestions.com/interview/4689 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.newinterviewquestions.com/interview/4690 List the steps needed to rename a redo log file. http://www.newinterviewquestions.com/interview/4691 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.newinterviewquestions.com/interview/4692 Create a statement that will add a member /logs/redo22.log to log file group 2. http://www.newinterviewquestions.com/interview/4693 When does the SMON process automatically coalesce the tablespaces? http://www.newinterviewquestions.com/interview/4694 Cheers, Team, New Interview Questions.com http://www.newinterviewquestions.com Send instant messages to your online friends http://uk.messenger.yahoo.com __._,_.___ Messages in this topic (1) Reply (via web post) \| Start a new topic . __,_._,___

[1]

about | contact Other archives ( Real Estate discussion Medical topics )