Oracle Interview - Technical Articles (2)

Oracle Interview - Technical Articles (2)

21. How to determine the time zone of the database? Solution: Select DBTIMEZONE from Dual; 22. Explaining Global_Names Use to True Use: Global_Names specifies the way the join database. If this parameter is set to true, the remote database 23 must be connected with the same name when establishing the database link. How to encrypt the PL / SQL program? Answer: Wrap24. Explaining Function, Procedure, and Package Differences: Function and Procedure are the collection of PL / SQL code, usually in order to complete a task. Procedure does not need to return any values ​​and Function will return a value in another, and Package is a collection of Function and Proceudre for completing a business function. 25. Explanation of Table Function: Table Function is returned by PL / SQL logic A set of records for ordinary table / views. They also used for the Pipeline and ETL processes. 26. cited three kinds of answers can collect three advisory statistics:. Buffer Cache Advice, Segment Level Statistics, Timed Statistics27 Audit trace which is stored in the directory structure oracle answered:?. Unix $ ORACLE_HOME / rdbms / audit Windows the event viewer28 explain materialized Views' role of answers: Materialized Views is used to reduce the number of information for those summaries, collections, and grouping. They are usually suitable for data warehouses and DSS systems. 29. When the user's process is wrong, which background process is responsible for cleaning it: PMON30. Which background process refreshes materialIzed Views? Answer: The Job Queue Processes.31. How to determine which session is connecting and the resources they wait? Answer: V $ session / v $ session_wait32. Description What is Redo Logs: Redo logs is a physical and logical structure for storing database data changes. Can be used to repair the database .33. How to force log switch? Solution: ALTER system switch logfile; 34. Have two methods for judging DDL changes? Answer: What do you have to use Logminer or streams35. Coalescing? Answer: Coalescing For the tableSpace for the dictionary, Coalescing is fragmented, and the adjacent small extents merges into a single large extent.36. Temporary TableSpace and Permanent TableSpace are the difference? Solution: A Temporary TableSpace is used for temporary objects such as sorting structure and Permanent TableSpaces is used to store those objects (such as tables, rollback segments, etc.) 37. Create a database automatically established TableSpace name? Answer: System TableSpace.38. When you create a user, you need to give new users what permissions can make it on the database.

Answer: Connect39. How do I add data files in TableSpace? Answer: ALTER TABLESPACE Add DataFile size 40. How to change the size of the data file? Answer: Alter Database DataFile Resize ; 41. Which view is used to check the size of the data file? Answer: DBA_DATA_FILES42. Which VIEW is used to determine the remaining space of TableSpace: DBA_FREE_SPACE43. How to determine who adds a record in the table? Answer: Auditing 44. How to reconstruct an index? Answer: Alter Index rebuild; 45. Explain what is partitioning and its advantages. Answer: Partition divides a large table and index into a smaller and easy management partition. 46. ​​You have just compiled a PL / SQL Package but there is an error report, how to display error information? Answer: Show Errors47. How do I collect the various status data of the table? Answer: Analyzethe Analyze Command.48. How to start the session level: dbms_session.set_sql_trace alter session set sql_trace = true; 49. IMPORT and SQL * LOADER These 2 tools of these 2 tools: These two Oracle tools are used To import data into the database. The difference is that the import tool can only process the data generated by another Oracle tool Export. And SQL * Loader can import data source 50 in different ASCII formats. 2 files for network connections? Answer: TNSNAMES.ORA and SQLNET.ORABLACK_SNAIL

Ligang1000@hotmail.com