<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:georss='http://www.georss.org/georss' xmlns:gd='http://schemas.google.com/g/2005' xmlns:thr='http://purl.org/syndication/thread/1.0'><id>tag:blogger.com,1999:blog-7332367523697889934</id><updated>2011-11-27T15:49:57.520-08:00</updated><category term='Pictures'/><category term='Unix'/><category term='SQL Server 2005'/><category term='Visual Studio'/><category term='Visual Basic.Net'/><category term='Microsoft'/><category term='Interview Questions'/><category term='ASP.Net'/><category term='Other'/><category term='Java'/><category term='General .Net'/><title type='text'>vbmade2007's Programming Blog</title><subtitle type='html'></subtitle><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://vbmade2007.blogspot.com/feeds/posts/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/7332367523697889934/posts/default?max-results=100'/><link rel='alternate' type='text/html' href='http://vbmade2007.blogspot.com/'/><link rel='hub' href='http://pubsubhubbub.appspot.com/'/><author><name>vbmade2000</name><uri>http://www.blogger.com/profile/08530715708520984049</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>15</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>100</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-7332367523697889934.post-6983644954232790809</id><published>2008-07-11T22:40:00.000-07:00</published><updated>2008-07-11T22:43:53.950-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='ASP.Net'/><title type='text'>BC30456: 'InitializeCulture' is not a member of XXX</title><content type='html'>Recenly I was developing my first ASP.Net app which was in ASp.Net 3.5.&lt;br /&gt;After completing the app and uploading to server i found that i got error saying that "&lt;b style=""&gt;BC30456: 'InitializeCulture' is not a member of xxx".Bcoz i m beginner i could not find the source of this error so &lt;span style="font-weight: bold;"&gt;I had searched a lot on the net and found&lt;/span&gt; this solution which really worked for me.&lt;br /&gt;&lt;br /&gt;&lt;/b&gt;&lt;b style=""&gt; &lt;/b&gt;If you use Visual studio to publish your site, during the publishing stage on framework 2.0 uncheck the "allow this precompiled site to be updatable".&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/7332367523697889934-6983644954232790809?l=vbmade2007.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://vbmade2007.blogspot.com/feeds/6983644954232790809/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=7332367523697889934&amp;postID=6983644954232790809' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/7332367523697889934/posts/default/6983644954232790809'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/7332367523697889934/posts/default/6983644954232790809'/><link rel='alternate' type='text/html' href='http://vbmade2007.blogspot.com/2008/07/bc30456-initializeculture-is-not-member.html' title='BC30456: &apos;InitializeCulture&apos; is not a member of XXX'/><author><name>vbmade2000</name><uri>http://www.blogger.com/profile/08530715708520984049</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-7332367523697889934.post-1124843145289434165</id><published>2008-05-12T06:20:00.000-07:00</published><updated>2008-05-12T06:42:57.175-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='ASP.Net'/><title type='text'>Return ArrayList from Web Service</title><content type='html'>Recently i have tried to return an ArrayList collection from a Web Service.I had to face lots of difficulties.&lt;br /&gt;Whenever i tried to return an ArrayList from my simple web service i got an error saying&lt;br /&gt;"Value of Type '1-dimensional array of Object cannot be converted to System.Collections.ArrayList".&lt;br /&gt;I searched a lot on the internet but found nothing.Then I posted my problem to some forums.&lt;br /&gt;One expert from one forum gave me the solution.and This really works fine for me.&lt;br /&gt;&lt;br /&gt;So i m puting the solution here for others&lt;br /&gt;&lt;br /&gt;  Here is the method code of my simple web service.&lt;br /&gt;&lt;br /&gt; &lt;br /&gt;  &lt;webmethod&gt; _&lt;br /&gt;  &lt;system.xml.serialization.xmlinclude(gettype(string))&gt; _&lt;br /&gt;  Public Function Test() As ArrayList&lt;br /&gt;  &lt;br /&gt;    Dim lst As New ArrayList&lt;br /&gt;  &lt;br /&gt;    lst.Add("Abc")&lt;br /&gt;    lst.Add("bca")&lt;br /&gt;    lst.Add("ahy")&lt;br /&gt;    lst.Add("fkc")&lt;br /&gt;&lt;br /&gt;    Return lst&lt;br /&gt;&lt;br /&gt;  End Sub&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;and Below is a code for consuming web Service.&lt;br /&gt;&lt;br /&gt;  Dim ws As New localhost.Service&lt;br /&gt;&lt;br /&gt;  Dim aList As New ArrayList(ws.Test)&lt;br /&gt;&lt;br /&gt;  ListBox1.DataSource = aList&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/7332367523697889934-1124843145289434165?l=vbmade2007.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://vbmade2007.blogspot.com/feeds/1124843145289434165/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=7332367523697889934&amp;postID=1124843145289434165' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/7332367523697889934/posts/default/1124843145289434165'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/7332367523697889934/posts/default/1124843145289434165'/><link rel='alternate' type='text/html' href='http://vbmade2007.blogspot.com/2008/05/return-arraylist-from-web-service.html' title='Return ArrayList from Web Service'/><author><name>vbmade2000</name><uri>http://www.blogger.com/profile/08530715708520984049</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-7332367523697889934.post-6293110227856905899</id><published>2008-05-02T10:19:00.000-07:00</published><updated>2008-05-02T10:20:35.725-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='General .Net'/><title type='text'>Fifteen Cool Features in WPF 3.5</title><content type='html'>re's a non-exhaustive list of improvements: &lt;ul&gt;&lt;li&gt;&lt;strong&gt;Performance&lt;/strong&gt;&lt;/li&gt;&lt;ul&gt;&lt;li&gt;Fixed animation glitching issues.  &lt;/li&gt;&lt;li&gt;Layered windows are now hardware accelerated.  &lt;/li&gt;&lt;li&gt;Many other fixes to improve cold start, data binding, etc. &lt;/li&gt;&lt;/ul&gt;&lt;li&gt;&lt;strong&gt;Data Binding&lt;/strong&gt;&lt;/li&gt;&lt;ul&gt;&lt;li&gt;Support for XLINQ binding.  &lt;/li&gt;&lt;li&gt;Improved data validation on binding (ValidatesOnDataErrors and ValidatesOnExceptions binding properties).  &lt;/li&gt;&lt;li&gt;Much better debugging (PresentationTraceSources.TraceLevel can be set on bindings or providers). &lt;/li&gt;&lt;/ul&gt;&lt;li&gt;&lt;strong&gt;Graphics and Text&lt;/strong&gt;&lt;/li&gt;&lt;ul&gt;&lt;li&gt;UIElement3D (enables interactive 2D content on 3D surfaces).  &lt;/li&gt;&lt;li&gt;Improved support for IMEs (input method editors).  &lt;/li&gt;&lt;li&gt;Indic script support.  &lt;/li&gt;&lt;li&gt;TextBox now supports a limited undo history.  &lt;/li&gt;&lt;li&gt;RichTextBox now fully supports inline elements (e.g. a Button). &lt;/li&gt;&lt;/ul&gt;&lt;li&gt;&lt;strong&gt;XBAPs&lt;/strong&gt;&lt;/li&gt;&lt;ul&gt;&lt;li&gt;Introduced support for the Firefox browser.  &lt;/li&gt;&lt;li&gt;WCF now operates in partial-trust mode.  &lt;/li&gt;&lt;li&gt;Can now read/write HTTP cookies. &lt;/li&gt;&lt;/ul&gt;&lt;li&gt;&lt;strong&gt;App Model&lt;/strong&gt;&lt;/li&gt;&lt;ul&gt;&lt;li&gt;System.AddIn provides support for isolated visual and non-visual add-ins, allowing for discovery, versioning, activation and lifecycle management.&lt;/li&gt;&lt;/ul&gt;&lt;/ul&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/7332367523697889934-6293110227856905899?l=vbmade2007.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://vbmade2007.blogspot.com/feeds/6293110227856905899/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=7332367523697889934&amp;postID=6293110227856905899' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/7332367523697889934/posts/default/6293110227856905899'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/7332367523697889934/posts/default/6293110227856905899'/><link rel='alternate' type='text/html' href='http://vbmade2007.blogspot.com/2008/05/fifteen-cool-features-in-wpf-35.html' title='Fifteen Cool Features in WPF 3.5'/><author><name>vbmade2000</name><uri>http://www.blogger.com/profile/08530715708520984049</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-7332367523697889934.post-8557755751951396449</id><published>2008-05-02T04:05:00.000-07:00</published><updated>2008-05-02T04:07:59.882-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='SQL Server 2005'/><title type='text'>Fix : Error 18452 Login failed for user ‘(null)’. The user is not associated with a trusted SQL Server connection.</title><content type='html'>&lt;em&gt;Recently i have faced this error.&lt;br /&gt;I have searched a lot on the net and got this solution which is really working.&lt;br /&gt;&lt;br /&gt;Error: 18452 Login failed for user ‘(null)’. The user is not associated with a trusted SQL Server connection.&lt;br /&gt;&lt;br /&gt;&lt;/em&gt;&lt;p&gt;&lt;strong&gt;Fix/Solution/Workaround:&lt;/strong&gt;&lt;br /&gt;Change the Authentication Mode of the SQL server from “Windows Authentication Mode (Windows Authentication)”&lt;br /&gt;to “Mixed Mode (Windows Authentication and SQL Server Authentication)”.&lt;/p&gt; &lt;p&gt;Run following script in SQL Analyzer to change the authentication&lt;/p&gt; &lt;pre&gt;&lt;code style="font-size: 12px;"&gt;&lt;span style="color: blue;"&gt;ALTER &lt;/span&gt;&lt;span style="color: black;"&gt;LOGIN sa ENABLE&lt;br /&gt;GO&lt;br /&gt;&lt;/span&gt;&lt;span style="color: blue;"&gt;ALTER &lt;/span&gt;&lt;span style="color: black;"&gt;LOGIN sa &lt;/span&gt;&lt;span style="color: blue;"&gt;WITH &lt;/span&gt;&lt;span style="color: black;"&gt;PASSWORD &lt;/span&gt;&lt;span style="color: blue;"&gt;= &lt;/span&gt;&lt;span style="color: red;"&gt;‘&lt;password&gt;’&lt;br /&gt;&lt;/span&gt;&lt;span style="color: black;"&gt;GO&lt;br /&gt;&lt;/span&gt;&lt;/code&gt; &lt;/pre&gt; &lt;p align="center"&gt;&lt;em&gt;OR&lt;/em&gt;&lt;/p&gt; &lt;p&gt;In Object Explorer, expand Security, expand Logins, right-click sa, and then click Properties. On the General page, you may have to create and confirm a password for the sa login. On the Status page, in the Login section, click Enabled, and then click OK.&lt;/p&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/7332367523697889934-8557755751951396449?l=vbmade2007.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://vbmade2007.blogspot.com/feeds/8557755751951396449/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=7332367523697889934&amp;postID=8557755751951396449' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/7332367523697889934/posts/default/8557755751951396449'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/7332367523697889934/posts/default/8557755751951396449'/><link rel='alternate' type='text/html' href='http://vbmade2007.blogspot.com/2008/05/fix-error-18452-login-failed-for-user.html' title='Fix : Error 18452 Login failed for user ‘(null)’. The user is not associated with a trusted SQL Server connection.'/><author><name>vbmade2000</name><uri>http://www.blogger.com/profile/08530715708520984049</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-7332367523697889934.post-1075320766153863672</id><published>2008-03-19T19:00:00.000-07:00</published><updated>2008-05-02T04:26:04.421-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='General .Net'/><title type='text'>.Net PE File Format</title><content type='html'>&lt;p&gt;Microsoft's &lt;a href="http://en.wikipedia.org/wiki/.NET_Framework" title=".NET Framework"&gt;.NET Framework&lt;/a&gt; has extended the PE format with features which support the &lt;a href="http://en.wikipedia.org/wiki/Common_Language_Runtime" title="Common Language Runtime"&gt;Common Language Runtime&lt;/a&gt; (an implementation of the .NET &lt;a href="http://en.wikipedia.org/wiki/Virtual_machine" title="Virtual machine"&gt;virtual machine&lt;/a&gt;). Among the additions are a CLR Header and CLR Data section. Upon loading a binary, the OS loader yields execution to the CLR via a reference in the PE/COFF IMPORT table. The CLR VM then loads the CLR Header and Data sections.&lt;/p&gt; &lt;p&gt;The CLR Data section contains two important segments: Metadata and Intermediate Language (IL) code:&lt;/p&gt; &lt;ul&gt;&lt;li&gt;Metadata contains information relevant to the assembly, including the assembly manifest. A manifest describes the assembly in detail including unique identification (via a hash, version number, etc.), data on exported components, extensive type information (supported by the Common Type System (CTS)), external references, and a list of files within the assembly. The CLR environment makes extensive use of metadata.&lt;/li&gt;&lt;li&gt;Intermediate Language (IL) code is abstracted, language independent code that satisfies the .NET CLR's &lt;a href="http://en.wikipedia.org/wiki/Common_Intermediate_Language" title="Common Intermediate Language"&gt;Common Intermediate Language&lt;/a&gt; (CIL) requirement. The term "Intermediate" refers to the nature of IL code being cross-language and cross-platform compatible. This intermediate language, similar to &lt;a href="http://en.wikipedia.org/wiki/Bytecode" title="Bytecode"&gt;bytecode&lt;/a&gt; in &lt;a href="http://en.wikipedia.org/wiki/Java_%28programming_language%29" title="Java (programming language)"&gt;Java&lt;/a&gt;, allows platforms and languages to support the common .NET CLR. IL supports &lt;a href="http://en.wikipedia.org/wiki/Object-oriented_programming" title="Object-oriented programming"&gt;object-oriented programming&lt;/a&gt; (polymorphism, inheritance, abstract types, etc.), exceptions, events, and various data structures. IL code is assembled into a .NET PE for execution by the CLR.&lt;/li&gt;&lt;/ul&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/7332367523697889934-1075320766153863672?l=vbmade2007.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='related' href='http://vbmade2007.blogspot.com/' title='.Net PE File Format'/><link rel='replies' type='application/atom+xml' href='http://vbmade2007.blogspot.com/feeds/1075320766153863672/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=7332367523697889934&amp;postID=1075320766153863672' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/7332367523697889934/posts/default/1075320766153863672'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/7332367523697889934/posts/default/1075320766153863672'/><link rel='alternate' type='text/html' href='http://vbmade2007.blogspot.com/2008/03/net-pe-file-format.html' title='.Net PE File Format'/><author><name>vbmade2000</name><uri>http://www.blogger.com/profile/08530715708520984049</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-7332367523697889934.post-4188692724598985465</id><published>2008-02-20T02:54:00.000-08:00</published><updated>2008-05-02T04:26:40.068-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='General .Net'/><title type='text'>Types of JIT ( Just In Time Compiler )</title><content type='html'>(1) PRE JIT Compiler।&lt;br /&gt;(2) ECONO JIT Compiler.&lt;br /&gt;(3) NORMAL JIT compiler.&lt;br /&gt;&lt;br /&gt;(1) PRE JIT Compiler :&lt;br /&gt;&lt;br /&gt;            Pre-JIt  compiler compiles complete source(MSIL)code to Native code in a single Compilation.&lt;br /&gt;&lt;br /&gt;(1) ECONO JIT Compiler :&lt;br /&gt;&lt;br /&gt;             This compiler compiles only MSIL code of those methods that are called at Runtime.&lt;br /&gt;&lt;br /&gt;3) NORMAL JIT compiler:&lt;br /&gt;&lt;br /&gt;              This compiler compiles only MSIL code of those methods that are called at Runtime and that converted (native) code is stored in Cache.This happens beccause,when these methods called again it will retrieve code from cache itself without sending request to CLR.Thus,inturn saves much of Executiom time&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/7332367523697889934-4188692724598985465?l=vbmade2007.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://vbmade2007.blogspot.com/feeds/4188692724598985465/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=7332367523697889934&amp;postID=4188692724598985465' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/7332367523697889934/posts/default/4188692724598985465'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/7332367523697889934/posts/default/4188692724598985465'/><link rel='alternate' type='text/html' href='http://vbmade2007.blogspot.com/2008/02/types-of-jit-just-in-time-compiler.html' title='Types of JIT ( Just In Time Compiler )'/><author><name>vbmade2000</name><uri>http://www.blogger.com/profile/08530715708520984049</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-7332367523697889934.post-9032445523242891071</id><published>2008-02-01T08:18:00.000-08:00</published><updated>2008-03-03T00:21:26.738-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='Java'/><title type='text'>A Little biography of James Gosling - The Creator of java Language</title><content type='html'>&lt;span style="font-weight: bold;"&gt;                                        Something about James goslings - &lt;/span&gt; &lt;span style="font-weight: bold;"&gt;                                                         The Creator of Java&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://farm2.static.flickr.com/1161/821707233_27011c647c.jpg?v=0"&gt;&lt;img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 320px;" src="http://farm2.static.flickr.com/1161/821707233_27011c647c.jpg?v=0" alt="" border="0" /&gt;&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;/span&gt;In the early 1990s, James Gosling understood the need for a universal       computer programming &lt;a href="http://www.blogger.com/post-create.g?blogID=7332367523697889934"&gt;Language: A vocabulary and set of grammatical rules to instruct a computer to perform specific tasks.')"&gt;language&lt;/a&gt; , a language that would allow for       communication between all sorts of machines. He mustered his talents and       went to work, emerging with Oak, the precursor to Java.        &lt;p class="content"&gt;       Years later, Java, the first general purpose programming language, was       born. Java’s success was quick and lasting, and since it has been       introduced to the market, Gosling has gained enormous recognition.&lt;/p&gt;        &lt;p class="content"&gt;       One of three children, James Gosling was born in 1955, just outside of       Calgary. Electronically proficient at an unusually young age, it should       not be surprising that he has advanced the world of computing so       profoundly. When he was 12, his parents found him constructing an electric       tic-tac-toe game from spare parts taken from a telephone and television.       Deciding to encourage this burgeoning interest, family friends took       Gosling to the computer lab at the University of Calgary—he was 14. &lt;/p&gt;        &lt;p class="content"&gt;       A major turning point in his life, Gosling found himself participating       less in his high school classes and spending more time in the computer lab       at the university. After graduating from high school, Gosling began       studying at the University of Calgary. While earning his Bachelor of       Science degree, he developed a text editor called Emacs, which became the       most widely used UNIX text editor in the world. He continued his education       at the University of Alberta, achieving a Master’s degree before he moved       to Pittsburgh to obtain his doctoral degree at Carnegie Mellon University.&lt;/p&gt;        &lt;p class="content"&gt;       His first job out of university was writing software at IBM. Though he       remained with the company for a number of years, they never produced any       of his work. So, in 1984, when Sun Microsystems Inc. offered Gosling a       position, he accepted their offer. Today, almost 20 years later, he is a       vice-president in the company.&lt;/p&gt;        &lt;p class="content"&gt;       Gosling admits he is the sort of person who gets terribly excited with new       technology, but he also knows that success is driven by the market and its       customers. He understands people will buy a product if it solves a problem       and improves their life in some way. That said, Gosling takes pride in       being able to deliver technology, such as Java, as it does its job without       the user being aware of it.&lt;/p&gt;        &lt;p class="content"&gt;       Gosling currently lives in Redwood City, California with his wife Judy and       their two daughters, Kate and Kelsey. Although he has lived in the United       States for over 20 years, Gosling continues to feel Canadian and returns       often to visit the rest of his family.&lt;/p&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/7332367523697889934-9032445523242891071?l=vbmade2007.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://vbmade2007.blogspot.com/feeds/9032445523242891071/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=7332367523697889934&amp;postID=9032445523242891071' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/7332367523697889934/posts/default/9032445523242891071'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/7332367523697889934/posts/default/9032445523242891071'/><link rel='alternate' type='text/html' href='http://vbmade2007.blogspot.com/2008/02/little-biography-of-james-gosling.html' title='A Little biography of James Gosling - The Creator of java Language'/><author><name>vbmade2000</name><uri>http://www.blogger.com/profile/08530715708520984049</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-7332367523697889934.post-6781368805792622019</id><published>2008-01-29T07:31:00.001-08:00</published><updated>2008-05-02T04:27:19.951-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='Pictures'/><title type='text'>Some Unknown Pictures of Bill Gates</title><content type='html'>&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://uploads.neowin.net/forum/post-59416-1106163459_thumb.jpg"&gt;&lt;img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 320px;" src="http://uploads.neowin.net/forum/post-59416-1106163459_thumb.jpg" alt="" border="0" /&gt;&lt;/a&gt;&lt;br /&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://uploads.neowin.net/forum/post-59416-1105987532.jpg"&gt;&lt;img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 320px;" src="http://uploads.neowin.net/forum/post-59416-1105987532.jpg" alt="" border="0" /&gt;&lt;/a&gt;&lt;br /&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://uploads.neowin.net/forum/post-59416-1105987549.jpg"&gt;&lt;img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 320px;" src="http://uploads.neowin.net/forum/post-59416-1105987549.jpg" alt="" border="0" /&gt;&lt;/a&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/7332367523697889934-6781368805792622019?l=vbmade2007.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://vbmade2007.blogspot.com/feeds/6781368805792622019/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=7332367523697889934&amp;postID=6781368805792622019' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/7332367523697889934/posts/default/6781368805792622019'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/7332367523697889934/posts/default/6781368805792622019'/><link rel='alternate' type='text/html' href='http://vbmade2007.blogspot.com/2008/01/some-unknown-pictures-of-bill-gates.html' title='Some Unknown Pictures of Bill Gates'/><author><name>vbmade2000</name><uri>http://www.blogger.com/profile/08530715708520984049</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-7332367523697889934.post-8530291955329216290</id><published>2008-01-18T07:13:00.000-08:00</published><updated>2008-05-02T04:28:55.599-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='Microsoft'/><title type='text'>Bill Gates’ last day at Microsoft</title><content type='html'>&lt;object height="373" width="425"&gt;&lt;param name="movie" value="http://www.youtube.com/v/v5uw07iEkjU&amp;amp;rel=1&amp;amp;border=1"&gt;&lt;param name="wmode" value="transparent"&gt;&lt;embed src="http://www.youtube.com/v/v5uw07iEkjU&amp;amp;rel=1&amp;amp;border=1" type="application/x-shockwave-flash" wmode="transparent" height="373" width="425"&gt;&lt;/embed&gt;&lt;/object&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/7332367523697889934-8530291955329216290?l=vbmade2007.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://vbmade2007.blogspot.com/feeds/8530291955329216290/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=7332367523697889934&amp;postID=8530291955329216290' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/7332367523697889934/posts/default/8530291955329216290'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/7332367523697889934/posts/default/8530291955329216290'/><link rel='alternate' type='text/html' href='http://vbmade2007.blogspot.com/2008/01/bill-gates-last-day-at-microsoft.html' title='Bill Gates’ last day at Microsoft'/><author><name>vbmade2000</name><uri>http://www.blogger.com/profile/08530715708520984049</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-7332367523697889934.post-7717017342393682454</id><published>2008-01-18T06:59:00.000-08:00</published><updated>2008-05-02T04:29:24.466-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='Other'/><title type='text'>Laptop Battery Fire</title><content type='html'>&lt;object height="355" width="425"&gt;&lt;param name="movie" value="http://www.youtube.com/v/WeWq6rWzChw&amp;amp;rel=1"&gt;&lt;param name="wmode" value="transparent"&gt;&lt;embed src="http://www.youtube.com/v/WeWq6rWzChw&amp;amp;rel=1" type="application/x-shockwave-flash" wmode="transparent" height="355" width="425"&gt;&lt;/embed&gt;&lt;/object&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/7332367523697889934-7717017342393682454?l=vbmade2007.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://vbmade2007.blogspot.com/feeds/7717017342393682454/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=7332367523697889934&amp;postID=7717017342393682454' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/7332367523697889934/posts/default/7717017342393682454'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/7332367523697889934/posts/default/7717017342393682454'/><link rel='alternate' type='text/html' href='http://vbmade2007.blogspot.com/2008/01/laptop-battery-fire.html' title='Laptop Battery Fire'/><author><name>vbmade2000</name><uri>http://www.blogger.com/profile/08530715708520984049</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-7332367523697889934.post-355011194495340529</id><published>2007-10-28T18:53:00.000-07:00</published><updated>2008-05-02T04:29:57.934-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='Visual Studio'/><title type='text'>New Features in Visual Studio 2008 (code-named Orcas)</title><content type='html'>&lt;ul&gt;&lt;li&gt; &lt;div&gt;LINQ (Language Integrated Query) new versions of C# and VB languages ,&lt;/div&gt;&lt;/li&gt;&lt;li&gt; &lt;div&gt;WPF(Windows Presentation Foundation) visual designer ,&lt;/div&gt;&lt;/li&gt;&lt;li&gt; &lt;div&gt;A new HTML/CSS editor influenced by Microsoft Expression Web &lt;/div&gt;&lt;/li&gt;&lt;li&gt; &lt;div&gt;Default configures compiled assemblies to run on .NET Framework 3.5 &lt;/div&gt;&lt;/li&gt;&lt;li&gt; &lt;div&gt;XAML based designer (codenamed Cider) &lt;/div&gt;&lt;/li&gt;&lt;li&gt; &lt;div&gt;Workflow designer &lt;/div&gt;&lt;/li&gt;&lt;li&gt; &lt;div&gt;LINQ to SQL designer &lt;/div&gt;&lt;/li&gt;&lt;li&gt; &lt;div&gt;XSLT debugger &lt;/div&gt;&lt;/li&gt;&lt;li&gt; &lt;div&gt;XSD designer &lt;/div&gt;&lt;/li&gt;&lt;li&gt; &lt;div&gt;JavaScript Intellisense support &lt;/div&gt;&lt;/li&gt;&lt;li&gt; &lt;div&gt;JavaScript Debugging support &lt;/div&gt;&lt;/li&gt;&lt;li&gt; &lt;div&gt;support for UAC manifests &lt;/div&gt;&lt;/li&gt;&lt;li&gt; &lt;div&gt;An enhanced set of UI widgets, both for WinForms and WPF &lt;/div&gt;&lt;/li&gt;&lt;li&gt; &lt;div&gt;J# will not be included &lt;/div&gt;&lt;/li&gt;&lt;/ul&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/7332367523697889934-355011194495340529?l=vbmade2007.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://vbmade2007.blogspot.com/feeds/355011194495340529/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=7332367523697889934&amp;postID=355011194495340529' title='1 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/7332367523697889934/posts/default/355011194495340529'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/7332367523697889934/posts/default/355011194495340529'/><link rel='alternate' type='text/html' href='http://vbmade2007.blogspot.com/2007/10/new-features-in-visual-studio-2008-code.html' title='New Features in Visual Studio 2008 (code-named Orcas)'/><author><name>vbmade2000</name><uri>http://www.blogger.com/profile/08530715708520984049</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-7332367523697889934.post-2033697520171680827</id><published>2007-10-28T18:25:00.000-07:00</published><updated>2008-05-02T04:34:01.541-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='Interview Questions'/><title type='text'>Interview and Viva Questions for Oracel</title><content type='html'>Which command should be issued before you can execute the CREATE DATABASE command?&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4655" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4655&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;How many control files are required to create a database?&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4651" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4651&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;If you have two redo log groups with four members each, how many disks does Oracle recommend to keep the redo log files?&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4684" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4684&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;What is the difference between groupby and orderby?&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/8560" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/8560&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;What does OFA stand for?&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4657" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4657&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;Which SHUTDOWN option will wait for the users to complete their uncommitted transactions?&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4637" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4637&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;If the application is running very slow? At what points you need to go about the database in order to improve the performance?&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/10944" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/10944&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;Which is not a system privilege? a. SELECT b. UPDATE ANY c. EXECUTE ANY d. CREATE TABLE &lt;script&gt;&lt;!-- D(["mb","\u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4800\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4800\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\n15. Which keyword should be used in the CREATE INDEX command to create a function –based index? A. CREATE FUNCTION INDEX… B. CREATE INDEX … ORGANIZATION INDEX C. CREATE INDEX… FUNCTION BASED … D. None of the above \u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4782\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4782\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nWhich of the following statements may require a temporary segment? a. CREATE TABLE b. CREATE INDEX c. UPDATE d. CREATE TABLESPACE \u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4773\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4773\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nWhat are the recommended INITIAL and NEXT values for a temporary tablespace, to reduce fragmentation?\u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4700\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4700\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nWhat are the valid status codes in the V$LOGFILE view?\u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4683\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4683\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nHow many ARCn processes can be associated with an instance?\u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4682\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4682\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nWhat is the biggest advantage of having the control files on different disks?\u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4679\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4679\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nWhich data dictionary view provides information on the version of the database and installed components?",1] );  //--&gt;&lt;/script&gt;&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4800" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4800&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;15. Which keyword should be used in the CREATE INDEX command to create a function –based index? A. CREATE FUNCTION INDEX… B. CREATE INDEX … ORGANIZATION INDEX C. CREATE INDEX… FUNCTION BASED … D. None of the above&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4782" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4782&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;Which of the following statements may require a temporary segment? a. CREATE TABLE b. CREATE INDEX c. UPDATE d. CREATE TABLESPACE&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4773" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4773&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;What are the recommended INITIAL and NEXT values for a temporary tablespace, to reduce fragmentation?&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4700" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4700&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;What are the valid status codes in the V$LOGFILE view?&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4683" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4683&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;How many ARCn processes can be associated with an instance?&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4682" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4682&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;What is the biggest advantage of having the control files on different disks?&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4679" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4679&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;Which data dictionary view provides information on the version of the database and installed components?&lt;script&gt;&lt;!-- D(["mb","\u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4668\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4668\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nWho owns the data dictionary?\u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4666\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4666\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nHow many data files can be specified in the DATAFILE clause when creating a database?\u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4664\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4664\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nHow do you correct a procedure that has become invalid when one of the tables it is referring to was altered to drop a constraint?\u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4662\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4662\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nWhich script creates the data dictionary views?\u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4659\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4659\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nWhen creating a database, where does Oracle find information about the control files that need to be created? \u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4658\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4658\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nWhich view has information about users who are ghranted SYSDBA or SYSOPER privilege?\u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4649\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4649\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\n13. 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? \u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4643\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;",1] );  //--&gt;&lt;/script&gt;&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4668" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4668&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;Who owns the data dictionary?&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4666" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4666&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;How many data files can be specified in the DATAFILE clause when creating a database?&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4664" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4664&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;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?&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4662" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4662&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;Which script creates the data dictionary views?&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4659" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4659&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;When creating a database, where does Oracle find information about the control files that need to be created?&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4658" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4658&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;Which view has information about users who are ghranted SYSDBA or SYSOPER privilege?&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4649" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4649&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;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?&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4643" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;&lt;script&gt;&lt;!-- D(["mb","http://www.coolinterview.com\u003cWBR\&gt;/interview/4643\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nI WANT TO BECOME A DBA ADMINISTRATOR. SO,FOR THAT WHAT CAN I PREPARE NOW?\u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/11583\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/11583\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nWhat is Trigger at one Line?\u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/11340\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/11340\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nExplaint the nvl2 function \u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/10943\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/10943\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nWhat is the process of upgrading oracle forms /reports from older version to new versions? \u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/8559\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/8559\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nHow many codds rule should oracle satisfies \u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/8558\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/8558\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nWhat is the difference between object library and pl/sql library \u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/8557\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/8557\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nList out differences between Oracle Server 9i and Oracle Server 10g. \u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/8556\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/8556\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nExplain truncate with restore option with example \u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/8555\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/8555\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;",1] );  //--&gt;&lt;/script&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4643&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;I WANT TO BECOME A DBA ADMINISTRATOR. SO,FOR THAT WHAT CAN I PREPARE NOW?&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/11583" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/11583&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;What is Trigger at one Line?&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/11340" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/11340&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;Explaint the nvl2 function&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/10943" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/10943&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;What is the process of upgrading oracle forms /reports from older version to new versions?&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/8559" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/8559&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;How many codds rule should oracle satisfies&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/8558" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/8558&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;What is the difference between object library and pl/sql library&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/8557" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/8557&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;List out differences between Oracle Server 9i and Oracle Server 10g.&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/8556" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/8556&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;Explain truncate with restore option with example&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/8555" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/8555&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;&lt;script&gt;&lt;!-- D(["mb","\nWhat is the difference between Anonymous Block and subprogram? Can we call a procedure from Anonymous PL/SQL block? \u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/8554\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/8554\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nHow to get a calender in date field in oracle forms? \u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/8553\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/8553\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nI have a server with 2GB RAM.Who is the optimal size for the shared pool size The shared pool reserved size is 1/10 to shared pool size Is there a mathematic type for compute the shared pool size ? \u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/8552\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/8552\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nI want to know that..is there any special way to login into oracle SQL*PLUS Editor directly..Rather than every time u have enter user,password,host string...what should i do with login.sql script.. i Put it in /Bin directory..but not working.. \u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/8551\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/8551\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nExplaint the nvl2 function \u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/8550\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/8550\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nWhen transporting a tablespace from one database to another, it should be a. Read-only. b. Offline. c. Online. d. Tablespace status does not matter. \u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4817\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4817\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nWhich NLS parameter can be specified only as an environment variable? a. NLS_LANGUAGE b. NLS_LANG c. NLS_TERRIROTY d. NLS_SORT ",1] );  //--&gt;&lt;/script&gt; What is the difference between Anonymous Block and subprogram? Can we call a procedure from Anonymous PL/SQL block?&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/8554" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/8554&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;How to get a calender in date field in oracle forms?&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/8553" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/8553&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;I have a server with 2GB RAM.Who is the optimal size for the shared pool size The shared pool reserved size is 1/10 to shared pool size Is there a mathematic type for compute the shared pool size ?&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/8552" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/8552&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;I want to know that..is there any special way to login into oracle SQL*PLUS Editor directly..Rather than every time u have enter user,password,host string...what should i do with login.sql script.. i Put it in /Bin directory..but not working..&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/8551" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/8551&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;Explaint the nvl2 function&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/8550" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/8550&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;When transporting a tablespace from one database to another, it should be a. Read-only. b. Offline. c. Online. d. Tablespace status does not matter.&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4817" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4817&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;Which NLS parameter can be specified only as an environment variable? a. NLS_LANGUAGE b. NLS_LANG c. NLS_TERRIROTY d. NLS_SORT &lt;script&gt;&lt;!-- D(["mb","\u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4816\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4816\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nWhich parameter in the export file is used to specify a structure –only export (no rows)? a. ROWS b. TABLE c. NODATA d. DIRECT \u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4815\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4815\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nWhat does the parameter DIRECT\u003dY in the export parameter file signify? a. When exporting table data, bypass the SQL buffer cache and read the data blocks directly form the disk to the export file. b. When exporting table data, bypass the SQL processing layer and read data from disk to the buffer cache, and copy them directly to the export files c. When importing data using the export file create, write data blocks directly to the file, rather than going through the buffer. d. To perform a direct import, the export file must be created sing the direct method. \u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4814\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4814\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nChoose the statement that is not true. Direct-path load a. Disables insert triggers on the table and enables them after the load completes. b. Disables referential integrity constraints and enables them after the load completes. c. Disables unique constraints and enables them after the load completes. d. Does not disable any constraints or triggers. \u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4813\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4813\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nWhich utility would you use to refresh the test table with production data? a. SQL*Loader conventional path b. SQL * Loader direct path c. Export/import d. SQL * Plus direct-load insert \u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4812\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;",1] );  //--&gt;&lt;/script&gt;&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4816" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4816&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;Which parameter in the export file is used to specify a structure –only export (no rows)? a. ROWS b. TABLE c. NODATA d. DIRECT&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4815" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4815&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;What does the parameter DIRECT=Y in the export parameter file signify? a. When exporting table data, bypass the SQL buffer cache and read the data blocks directly form the disk to the export file. b. When exporting table data, bypass the SQL processing layer and read data from disk to the buffer cache, and copy them directly to the export files c. When importing data using the export file create, write data blocks directly to the file, rather than going through the buffer. d. To perform a direct import, the export file must be created sing the direct method.&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4814" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4814&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;Choose the statement that is not true. Direct-path load a. Disables insert triggers on the table and enables them after the load completes. b. Disables referential integrity constraints and enables them after the load completes. c. Disables unique constraints and enables them after the load completes. d. Does not disable any constraints or triggers.&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4813" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4813&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;Which utility would you use to refresh the test table with production data? a. SQL*Loader conventional path b. SQL * Loader direct path c. Export/import d. SQL * Plus direct-load insert&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4812" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;&lt;script&gt;&lt;!-- D(["mb","http://www.coolinterview.com\u003cWBR\&gt;/interview/4812\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nTo use the transportable tablespace feature, the block size of the target and source database should be a. 4KB b. Same size c. Not larger that 16KB d. Different size \u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4811\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4811\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nIf you run the ALTER SESSION SET NLS_DATE_FORMAT + ‘DDMMYY” statement, which dictionary view would you query to see the value of the parameter? a. V$SESSION_PARAMETERS b. NLS_SESSION_PARAMETERS c. NLS_DATABASE_PARAMETERS d. V$SESSION \u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4810\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4810\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nChoose two reasons why you would use a direct –path load instead of a conventional-path load. a. To restrict users from performing b. To perform parallel loads c. To disable the generation of redo log entries if the database is in ARCHIVELOG mode. d. The table has many indexes, and the temporary tabelspace is small. \u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4809\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4809\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nWhich two parameters must you specify when importing the metadata information into the target database while transporting tablespaces? a. DATAFILES b. TABLESPACES c. TRANSPORT_TABLESPACE d. TTS_OWNERS \u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4808\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4808\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nChoose 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 \u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4807\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com",1] );  //--&gt;&lt;/script&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4812&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;To use the transportable tablespace feature, the block size of the target and source database should be a. 4KB b. Same size c. Not larger that 16KB d. Different size&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4811" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4811&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;If you run the ALTER SESSION SET NLS_DATE_FORMAT + ‘DDMMYY” statement, which dictionary view would you query to see the value of the parameter? a. V$SESSION_PARAMETERS b. NLS_SESSION_PARAMETERS c. NLS_DATABASE_PARAMETERS d. V$SESSION&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4810" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4810&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;Choose two reasons why you would use a direct –path load instead of a conventional-path load. a. To restrict users from performing b. To perform parallel loads c. To disable the generation of redo log entries if the database is in ARCHIVELOG mode. d. The table has many indexes, and the temporary tabelspace is small.&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4809" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4809&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;Which two parameters must you specify when importing the metadata information into the target database while transporting tablespaces? a. DATAFILES b. TABLESPACES c. TRANSPORT_TABLESPACE d. TTS_OWNERS&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4808" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4808&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;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&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4807" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;script&gt;&lt;!-- D(["mb","\u003cWBR\&gt;/interview/4807\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\n20. Which command is used to define CONNECT and RESOURCE as the default roles for user JAMES? a. ALTER USER b. ALTER ROLE c. SET ROLE d. SET PRIVILEGE \u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4806\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4806\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\n19. 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 \u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4805\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4805\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\n18. How do you enable a role? a. ALTER ROLE b. ALTER USER c. SET ROLE d. ALTER SESSION \u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4804\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4804\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nWhich role in the following list is not a predefined role from Oracle? a. SYSDBA b. CONNECT c. IMP_FULL_DATABASE d. RESOURCE \u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4803\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4803\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\n16. To grant the SELECT privilege on the table CUSTOMER to all users in the database, which statement would you use? a. GRANT SELECT ON CUSTOMER TO ALL USERS; b. GRANT ALL ON CUSTOMER TO ALL; c. GRANT SELECT ON CUSTOMER TO ALL; d. GRANT SELECT ON CUSTOMER TO PUBLIC; \u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4802\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4802\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nWhich data dictionary view can be queried to see whether a user has the EXECUTE privilege on a procedure? a. DBA_SYS_PRIVS b. DBA_TAB_PRIVS c. DBA_PROC_PRIVS d. SESSION_PRIVS ",1] );  //--&gt;&lt;/script&gt;&lt;wbr&gt;/interview/4807&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;20. Which command is used to define CONNECT and RESOURCE as the default roles for user JAMES? a. ALTER USER b. ALTER ROLE c. SET ROLE d. SET PRIVILEGE&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4806" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4806&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;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&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4805" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4805&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;18. How do you enable a role? a. ALTER ROLE b. ALTER USER c. SET ROLE d. ALTER SESSION&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4804" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4804&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;Which role in the following list is not a predefined role from Oracle? a. SYSDBA b. CONNECT c. IMP_FULL_DATABASE d. RESOURCE&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4803" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4803&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;16. To grant the SELECT privilege on the table CUSTOMER to all users in the database, which statement would you use? a. GRANT SELECT ON CUSTOMER TO ALL USERS; b. GRANT ALL ON CUSTOMER TO ALL; c. GRANT SELECT ON CUSTOMER TO ALL; d. GRANT SELECT ON CUSTOMER TO PUBLIC;&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4802" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4802&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;Which data dictionary view can be queried to see whether a user has the EXECUTE privilege on a procedure? a. DBA_SYS_PRIVS b. DBA_TAB_PRIVS c. DBA_PROC_PRIVS d. SESSION_PRIVS &lt;script&gt;&lt;!-- D(["mb","\u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4801\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4801\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nWhich clause should be specified to enable the grantee to grant the system privilege to other users? a. WITH GRANT OPTION b. WITH ADMIN OPTION c. CASCADE d. WITH MANAGE OPTION \u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4799\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4799\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nWhich view would you query to see whether John has the CREATE TABLE privilege? a. DBA_SYS_PRIVS b. DBA_USER_PRIVS c. DBA_ROLE_PRIVS d. DBA_TAB_PRIVS \u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4798\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4798\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nUser JAMES has a table named JOBS created on the tablespace USERS. When you issue the following statement, what effect will it have on the JOBS table? ALTER USER JAMES QUOTA 0 ON USERS; a. No more rows can be added to the JOBS table b. No blocks can be allocated to the JOBS table c. No new extents can be allocated to the JOBS table d. The table JOBS cannot be accessed \u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4797\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4797\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nWhich clause in the CREATE USER command can be used to specify no limits on the space allowed in tablespace APP_DATA? \u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4796\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4796\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nWhich dictionary view shows the password expiration date for a user?\u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4795\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4795\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nWhich password parameter in the profile definitions can restrict the user from using the old password for 90 days?",1] );  //--&gt;&lt;/script&gt;&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4801" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4801&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;Which clause should be specified to enable the grantee to grant the system privilege to other users? a. WITH GRANT OPTION b. WITH ADMIN OPTION c. CASCADE d. WITH MANAGE OPTION&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4799" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4799&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;Which view would you query to see whether John has the CREATE TABLE privilege? a. DBA_SYS_PRIVS b. DBA_USER_PRIVS c. DBA_ROLE_PRIVS d. DBA_TAB_PRIVS&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4798" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4798&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;User JAMES has a table named JOBS created on the tablespace USERS. When you issue the following statement, what effect will it have on the JOBS table? ALTER USER JAMES QUOTA 0 ON USERS; a. No more rows can be added to the JOBS table b. No blocks can be allocated to the JOBS table c. No new extents can be allocated to the JOBS table d. The table JOBS cannot be accessed&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4797" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4797&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;Which clause in the CREATE USER command can be used to specify no limits on the space allowed in tablespace APP_DATA?&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4796" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4796&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;Which dictionary view shows the password expiration date for a user?&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4795" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4795&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;Which password parameter in the profile definitions can restrict the user from using the old password for 90 days?&lt;script&gt;&lt;!-- D(["mb","\u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4794\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4794\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nWhich resource specifies the value in minutes?\u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4793\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4793\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\n6. When a new user is created, and you do not specify a profile, a. Oracle prompts you for a profile name. b. No profile is assigned to the user. c. THE DEFAULT profile is assigned. \u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4792\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4792\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nWhat is the maximum number of profiles that can be assigned to a user? \u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4791\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4791\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\n4. Choose the option that is not true. a. Oracle creates a profile named DEFAULT when the database is created. b. Profiles cannot be renamed. c. DEFULT is a valid name for a profile resource. d. The SESSIONS_PER_USER resource in the DEFAULT profile initially has a value of 5. \u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4790\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4790\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\n3. Which resource is not used to calculate the COMPOSITE_LIMIT? a. PRIVATE_SGA b. CPU_PER_SESSION c. CONNECT_TIME d. LOGICAL_READS_PER_CALL \u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4789\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4789\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\n2. Which command is used to assign a profile to an existing use? a. ALTER PROFILE b. ALTER USER c. SET PROFILE d. The profile should be specified when creating the user; it cannot be changed. ",1] );  //--&gt;&lt;/script&gt;&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4794" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4794&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;Which resource specifies the value in minutes?&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4793" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4793&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;6. When a new user is created, and you do not specify a profile, a. Oracle prompts you for a profile name. b. No profile is assigned to the user. c. THE DEFAULT profile is assigned.&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4792" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4792&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;What is the maximum number of profiles that can be assigned to a user?&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4791" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4791&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;4. Choose the option that is not true. a. Oracle creates a profile named DEFAULT when the database is created. b. Profiles cannot be renamed. c. DEFULT is a valid name for a profile resource. d. The SESSIONS_PER_USER resource in the DEFAULT profile initially has a value of 5.&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4790" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4790&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;3. Which resource is not used to calculate the COMPOSITE_LIMIT? a. PRIVATE_SGA b. CPU_PER_SESSION c. CONNECT_TIME d. LOGICAL_READS_PER_CALL&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4789" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4789&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;2. Which command is used to assign a profile to an existing use? a. ALTER PROFILE b. ALTER USER c. SET PROFILE d. The profile should be specified when creating the user; it cannot be changed. &lt;script&gt;&lt;!-- D(["mb","\u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4788\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4788\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\n1. Profiles cannot be used to restrict. a. CPU time used b. Total time connected to the database c. Maximum time a session can be inactive d. Time spent reading blocks \u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4787\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4787\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nWhat is the difference between a unique constraint and a primary key constraint? \u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4786\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4786\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nWhich script creates the CHAINED_ROWS table? A. catproc.sql B. catchain.sql C. utlchain.sql D. No script is necessary: ANALYZE TABLE LIST CHAINED ROWS creates the table. \u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4785\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4785\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nA constraint is created with the DEFERRABLE INITIALLY IMMEDIATE CLAUSE. What does this mean?\u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4784\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4784\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nWhich data dictionary view shows statistical information from the ANALYZE INDEX VALIDATE STRUCTURE command? \u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4783\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4783\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\n14 Which component is not part of the ROWID? A. Tablespace B. Data file number C. Object ID D. Block ID \u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4781\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4781",1] );  //--&gt;&lt;/script&gt;&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4788" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4788&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;1. Profiles cannot be used to restrict. a. CPU time used b. Total time connected to the database c. Maximum time a session can be inactive d. Time spent reading blocks&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4787" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4787&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;What is the difference between a unique constraint and a primary key constraint?&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4786" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4786&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;Which script creates the CHAINED_ROWS table? A. catproc.sql B. catchain.sql C. utlchain.sql D. No script is necessary: ANALYZE TABLE LIST CHAINED ROWS creates the table.&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4785" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4785&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;A constraint is created with the DEFERRABLE INITIALLY IMMEDIATE CLAUSE. What does this mean?&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4784" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4784&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;Which data dictionary view shows statistical information from the ANALYZE INDEX VALIDATE STRUCTURE command?&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4783" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4783&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;14 Which component is not part of the ROWID? A. Tablespace B. Data file number C. Object ID D. Block ID&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4781" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4781&lt;script&gt;&lt;!-- D(["mb","\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\n13. Which line in the following code has an error? 1. ALTER TABEL MY_TABLE 2. STORAGE ( 3. MINEXTENTS 4 4. NEXT 512K) 5. NOLOGGING; \u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4780\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4780\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nWhat clause is in the ALTER TABLE command is used to reorganize a table?\u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4779\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4779\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nWhich keyword is not valid of the BUFFER_POOL parameter of the STORAGE clause?\u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4778\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4778\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nWhen validating a constraint, why would you specify the EXCEPTIONS clause?\u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4777\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4777\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nA table is created with an INITRANS value of 2. Which value would you choose for INITRANS of an index created on this table?\u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4776\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4776\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nFill in the blank: The parameter MAXTRANS specifies the maximum number of concurrent transactions per ___________________.\u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4775\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4775\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nHow does Oracle determine the extent sizes for a temporary segment? A. From the initialization parameters B. From the tables involved in the sort operation C. Using the default storage parameters for the tablespace D. The database block size \u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4774\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;",1] );  //--&gt;&lt;/script&gt;&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;13. Which line in the following code has an error? 1. ALTER TABEL MY_TABLE 2. STORAGE ( 3. MINEXTENTS 4 4. NEXT 512K) 5. NOLOGGING;&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4780" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4780&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;What clause is in the ALTER TABLE command is used to reorganize a table?&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4779" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4779&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;Which keyword is not valid of the BUFFER_POOL parameter of the STORAGE clause?&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4778" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4778&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;When validating a constraint, why would you specify the EXCEPTIONS clause?&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4777" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4777&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;A table is created with an INITRANS value of 2. Which value would you choose for INITRANS of an index created on this table?&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4776" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4776&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;Fill in the blank: The parameter MAXTRANS specifies the maximum number of concurrent transactions per ___________________.&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4775" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4775&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;How does Oracle determine the extent sizes for a temporary segment? A. From the initialization parameters B. From the tables involved in the sort operation C. Using the default storage parameters for the tablespace D. The database block size&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4774" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;&lt;script&gt;&lt;!-- D(["mb","http://www.coolinterview.com\u003cWBR\&gt;/interview/4774\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nWhich two initialization parameters are used by ORACLE to determine the number of rollback segments required for an instance? a. ROLLBACK_SEGMENTS b. TRANSACTIONS c. TRANSACTIONS_PER_ROLLBACK\u003cWBR\&gt;_SEGMENT d. PROCESSES \u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4772\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4772\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nWhat can cause the Snapshot too old error?\u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4771\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4771\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nWhat is row migration? \u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4770\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4770\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nWhich data dictionary view can be queried to see the OPTIMAL value for a rollback segment? A. DBA_ROLLBACK_SEGS B. V$ROLLSTAT C. DBA_SEGMENTS D. V$ROLLNAME \u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4717\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4717\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nWhat is the default value of PCTFREE? \u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4716\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4716\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nHow can you fix the MAXEXTENTS reached error for a rollback segment? \u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4715\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4715\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nWhat type of rollback segment is used if a tablespace containing an active transactions taken offline? \u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4714\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4714\u003c/a\&gt;\u003cbr\&gt;",1] );  //--&gt;&lt;/script&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4774&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;Which two initialization parameters are used by ORACLE to determine the number of rollback segments required for an instance? a. ROLLBACK_SEGMENTS b. TRANSACTIONS c. TRANSACTIONS_PER_ROLLBACK&lt;div&gt;&lt;wbr&gt;_SEGMENT d. PROCESSES&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4772" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4772&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;What can cause the Snapshot too old error?&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4771" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4771&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;What is row migration?&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4770" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4770&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;Which data dictionary view can be queried to see the OPTIMAL value for a rollback segment? A. DBA_ROLLBACK_SEGS B. V$ROLLSTAT C. DBA_SEGMENTS D. V$ROLLNAME&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4717" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4717&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;What is the default value of PCTFREE?&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4716" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4716&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;How can you fix the MAXEXTENTS reached error for a rollback segment?&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4715" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4715&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;What type of rollback segment is used if a tablespace containing an active transactions taken offline?&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4714" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4714&lt;/a&gt;&lt;br /&gt;&lt;script&gt;&lt;!-- D(["mb","\n\u003cbr\&gt;\nWhen does Oracle stop adding rows to a block?\u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4713\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4713\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nWhich portion of the data block stores information about the table having rows in this block?\u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4712\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4712\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nWhat is the minimum number of extents a rollback segment can have?\u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4711\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4711\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nWhich data dictionary view would you query to see the free extents in a tablespace?\u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4710\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4710\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\n6. 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. \u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4709\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4709\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\n5. Which storage parameter is applicable only to rollback segments? A. PCTINCREASE B. MAXEXTENTS C. TRANASACTIONS D. None of the above. \u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4708\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4708\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nWhat 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. ",1] );  //--&gt;&lt;/script&gt;&lt;br /&gt;When does Oracle stop adding rows to a block?&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4713" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4713&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;Which portion of the data block stores information about the table having rows in this block?&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4712" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4712&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;What is the minimum number of extents a rollback segment can have?&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4711" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4711&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;Which data dictionary view would you query to see the free extents in a tablespace?&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4710" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4710&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;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.&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4709" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4709&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;5. Which storage parameter is applicable only to rollback segments? A. PCTINCREASE B. MAXEXTENTS C. TRANASACTIONS D. None of the above.&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4708" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4708&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;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. &lt;script&gt;&lt;!-- D(["mb","\u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4707\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4707\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nWhich parameter specifies the number of transaction slots in a data block?\u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4706\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4706\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nWhen a table is updated, where is the before image information (which can be used for undoing the changes) stored?\u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4705\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4705\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nPlace the following logical storage structures in order-from the smallest logical storage unit to the largest. A. Segment B. Block C. Tablespace D. Extent \u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4704\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4704\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\n19. 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. \u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4703\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4703\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nHow would you determine how much sort space is used by a user session?\u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4702\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4702\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\nWhich 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 ",1] );  //--&gt;&lt;/script&gt;&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4707" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4707&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;Which parameter specifies the number of transaction slots in a data block?&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4706" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4706&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;When a table is updated, where is the before image information (which can be used for undoing the changes) stored?&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4705" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4705&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;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&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4704" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4704&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;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.&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4703" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4703&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;How would you determine how much sort space is used by a user session?&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4702" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4702&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;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 &lt;script&gt;&lt;!-- D(["mb","\u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4699\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4699\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\n14. 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. \u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4698\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4698\u003c/a\&gt;\u003cbr\&gt;\n\u003cbr\&gt;\n13. 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? \u003cbr\&gt;\n\u003ca href\u003d\"http://www.coolinterview.com/interview/4697\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://www.coolinterview.com\u003cWBR\&gt;/interview/4697\u003c/a\&gt;\u003cbr\&gt;\n ______________________________\u003cWBR\&gt;____________________\u003cbr\&gt;\nDo You Yahoo!?\u003cbr\&gt;\nTired of spam?  Yahoo! Mail has the best spam protection around \u003cbr\&gt;\n\u003ca href\u003d\"http://mail.yahoo.com\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;http://mail.yahoo.com\u003c/a\&gt;           \u003c/div\&gt; \n    \u003cdiv\&gt;\n      \u003cdiv\&gt;\n        \u003ca href\u003d\"#115e6d1a08324c58_toc\"\&gt;\n          Back to top        \u003c/a\&gt;\n      \u003c/div\&gt;                         \u003ca href\u003d\"mailto:smitaarora82@yahoo.com?Subject\u003dRe%3A%3D%3D%3E%20Top%20Interview%20Questions%20%26%20Viva%20Questions%20for%20Oracle\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;\n            Reply to \u003cspan\&gt;sender\u003c/span\&gt;\n          \u003c/a\&gt; |\n          \u003ca href\u003d\"mailto:jobsassist@yahoogroups.com?Subject\u003d+Re%3A%3D%3D%3E%20Top%20Interview%20Questions%20%26%20Viva%20Questions%20for%20Oracle\" target\u003d\"_blank\" onclick\u003d\"return top.js.OpenExtLink(window,event,this)\"\&gt;",1] );  //--&gt;&lt;/script&gt;&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4699" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4699&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;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.&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4698" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4698&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;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?&lt;br /&gt;&lt;a href="http://www.coolinterview.com/interview/4697" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"&gt;http://www.coolinterview.com&lt;wbr&gt;/interview/4697&lt;/a&gt;&lt;/div&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/7332367523697889934-2033697520171680827?l=vbmade2007.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://vbmade2007.blogspot.com/feeds/2033697520171680827/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=7332367523697889934&amp;postID=2033697520171680827' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/7332367523697889934/posts/default/2033697520171680827'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/7332367523697889934/posts/default/2033697520171680827'/><link rel='alternate' type='text/html' href='http://vbmade2007.blogspot.com/2007/10/interview-and-viva-questions-for-oracel.html' title='Interview and Viva Questions for Oracel'/><author><name>vbmade2000</name><uri>http://www.blogger.com/profile/08530715708520984049</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-7332367523697889934.post-774652697094767315</id><published>2007-10-09T04:14:00.000-07:00</published><updated>2008-05-02T04:33:21.978-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='General .Net'/><title type='text'>Interview questions for .Net for Freshers</title><content type='html'>&lt;b&gt; What is Class&lt;br /&gt;&lt;/b&gt;&lt;i&gt;A user-defined data structure that groups properties and methods.  Class doesn’t occupies memory.&lt;br /&gt;&lt;br /&gt;&lt;/i&gt;&lt;b&gt; What is Object &lt;span style="text-decoration: underline;"&gt;&lt;br /&gt;&lt;/span&gt; &lt;/b&gt;&lt;i&gt;Instance of Class is called object.  An object is created in memory using keyword “new”.&lt;br /&gt;&lt;br /&gt;&lt;/i&gt;&lt;b&gt; What is .Net Platform? &lt;a href="http://dng-dotnetframework.blogspot.com/" target="_blank"&gt;&lt;/a&gt;&lt;/b&gt;&lt;i&gt;&lt;br /&gt;Microsoft .NET is a software development platform based on virtual machine architecture.   &lt;/i&gt;&lt;ul&gt;&lt;lh&gt;&lt;i&gt;Dot Net Platform is: &lt;/i&gt;&lt;li&gt;&lt;i&gt;Language Independent – dot net application can be developed different languages (such as C#, VB, C++, etc.) &lt;/i&gt;&lt;/li&gt;&lt;li&gt;&lt;i&gt;Platform Independent – dot net application can be run on any operating system which has .net framework installed. &lt;/i&gt;&lt;/li&gt;&lt;li&gt;&lt;i&gt;Hardware Independent – dot net application can run on any hardware configuration &lt;lh&gt;It allows us to build windows based application, web based application, web service, mobile application, etc. &lt;/lh&gt;&lt;/i&gt;&lt;/li&gt;&lt;/lh&gt;&lt;/ul&gt;&lt;b&gt; What is .Net Framework?&lt;br /&gt;&lt;/b&gt;&lt;i&gt;.Net Framework provides a foundation upon which .net application and xml webservices are built and executed.&lt;br /&gt;&lt;br /&gt;&lt;/i&gt;&lt;b&gt; Two main Components of .Net Framework &lt;a href="http://dng-dotnetframework.blogspot.com/" target="_blank"&gt;&lt;/a&gt; &lt;/b&gt;                               &lt;i&gt; &lt;/i&gt;&lt;ul&gt;&lt;li&gt;&lt;i&gt;1. Common Language Runtime &lt;/i&gt;&lt;/li&gt;&lt;li&gt;&lt;i&gt;2. Base Class Library. &lt;/i&gt;&lt;/li&gt;&lt;/ul&gt;&lt;br /&gt;&lt;b&gt; Difference between Struct and Class &lt;a href="http://dng-oops.blogspot.com/" target="_blank"&gt;&lt;/a&gt; &lt;/b&gt;                               &lt;i&gt; &lt;/i&gt;&lt;ul&gt;&lt;li&gt;&lt;i&gt;Struct are Value type and are stored on stack, while Class are Reference type and are stored on heap. &lt;/i&gt;&lt;/li&gt;&lt;li&gt;&lt;i&gt;Struct “do not support” inheritance, while class supports inheritance.  However struct can implements interface. &lt;/i&gt;&lt;/li&gt;&lt;li&gt;&lt;i&gt;Struct should be used when you want to use a small data structure, while Class is better choice for complex data structure.&lt;/i&gt;&lt;/li&gt;&lt;/ul&gt;&lt;br /&gt;&lt;b&gt; What is the difference between instantiating structures with and without using the new keyword? &lt;span style="text-decoration: underline;"&gt;&lt;br /&gt;&lt;/span&gt; &lt;/b&gt;&lt;i&gt;When a structure is instantiated using the new keyword, a constructor (no-argument or custom, if provided) is called which initializes the fields in the structure. When a structure is instantiated without using the new keyword, no constructor is called. Hence, one has to explicitly initialize all the fields of the structure before using it when instantiated without the new keyword.&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;/i&gt;&lt;table style="width: 677px; height: 66px;" align="center" border="0" cellpadding="0" cellspacing="0"&gt;&lt;tbody&gt;&lt;tr&gt;&lt;td class="firstrow" align="left"&gt;&lt;b&gt; What do you mean Encapsulation in oops  &lt;/b&gt;        &lt;/td&gt;       &lt;/tr&gt;       &lt;tr&gt;        &lt;td colspan="2" class="secondrow"&gt; &lt;i&gt; Wrapping up of data and function into a single unit is known as Encapsulation.&lt;br /&gt;Example of encapsulation: class.&lt;br /&gt;&lt;br /&gt;&lt;/i&gt;&lt;b&gt; How to use Properties in .Net&lt;br /&gt;&lt;/b&gt; &lt;i&gt;Attribute of object is called properties.  Eg1:- A car has color as property.&lt;br /&gt;Example: &lt;pre&gt;private string m_Color;;&lt;br /&gt;&lt;br /&gt;public string Color&lt;br /&gt;{&lt;br /&gt;get&lt;br /&gt;{&lt;br /&gt; return m_Color;&lt;br /&gt;}&lt;br /&gt;set&lt;br /&gt;{&lt;br /&gt; m_Color = value;&lt;br /&gt;}&lt;br /&gt;}&lt;br /&gt;&lt;br /&gt;Car Maruti = new Car();&lt;br /&gt;Maruti.Color= “White”;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;Console.Write(Maruti.Color);&lt;br /&gt;&lt;/pre&gt; &lt;/i&gt;&lt;br /&gt;&lt;i&gt;&lt;br /&gt;&lt;/i&gt;&lt;/td&gt;       &lt;/tr&gt;     &lt;tr&gt;     &lt;td&gt;&lt;br /&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/tbody&gt;&lt;/table&gt;&lt;b&gt; Isn't it better to make a field public than providing its property with both set { } and get { } block? After all the property will allow the user to both read and modify the field so why not use public field instead? Motivate your answer.&lt;br /&gt;&lt;br /&gt;&lt;/b&gt; &lt;i&gt;Not always! Properties are not just to provide access to the fields; rather, they are supposed to provide controlled access to the fields of our class. As the state of the class depends upon the values of its fields, using properties we can assure that no invalid (or unacceptable) value is assigned to the fields.&lt;br /&gt;Example: &lt;pre&gt;private int age;&lt;br /&gt;&lt;br /&gt;public int Age&lt;br /&gt;{&lt;br /&gt;get&lt;br /&gt;{&lt;br /&gt;     return age;&lt;br /&gt;}&lt;br /&gt;set&lt;br /&gt;{&lt;br /&gt;     if(value &lt;&gt; 100)&lt;br /&gt; //throw exception&lt;br /&gt;    else&lt;br /&gt;    age = value;&lt;br /&gt;}&lt;br /&gt;}&lt;br /&gt;&lt;br /&gt;Note : All these questions are taken from &lt;span style="font-weight: bold;"&gt;dailyfreecode.com&lt;/span&gt;&lt;br /&gt;&lt;/pre&gt; &lt;/i&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/7332367523697889934-774652697094767315?l=vbmade2007.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://vbmade2007.blogspot.com/feeds/774652697094767315/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=7332367523697889934&amp;postID=774652697094767315' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/7332367523697889934/posts/default/774652697094767315'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/7332367523697889934/posts/default/774652697094767315'/><link rel='alternate' type='text/html' href='http://vbmade2007.blogspot.com/2007/10/interview-questions-for-net-for.html' title='Interview questions for .Net for Freshers'/><author><name>vbmade2000</name><uri>http://www.blogger.com/profile/08530715708520984049</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-7332367523697889934.post-6144517959375663613</id><published>2007-10-03T01:23:00.000-07:00</published><updated>2008-05-02T04:32:36.768-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='Unix'/><title type='text'>Source code of cat command of Unix</title><content type='html'>/*    $OpenBSD: cat.c,v 1.14 2002/07/04 04:26:39 deraadt Exp $    */&lt;br /&gt;/*    $NetBSD: cat.c,v 1.11 1995/09/07 06:12:54 jtc Exp $    */&lt;br /&gt;&lt;br /&gt;/*&lt;br /&gt;* Copyright (c) 1989, 1993&lt;br /&gt;*    The Regents of the University of California.  All rights reserved.&lt;br /&gt;*&lt;br /&gt;* This code is derived from software contributed to Berkeley by&lt;br /&gt;* Kevin Fall.&lt;br /&gt;*&lt;br /&gt;* Redistribution and use in source and binary forms, with or without&lt;br /&gt;* modification, are permitted provided that the following conditions&lt;br /&gt;* are met:&lt;br /&gt;* 1. Redistributions of source code must retain the above copyright&lt;br /&gt;*    notice, this list of conditions and the following disclaimer.&lt;br /&gt;* 2. Redistributions in binary form must reproduce the above copyright&lt;br /&gt;*    notice, this list of conditions and the following disclaimer in the&lt;br /&gt;*    documentation and/or other materials provided with the distribution.&lt;br /&gt;* 3. All advertising materials mentioning features or use of this software&lt;br /&gt;*    must display the following acknowledgement:&lt;br /&gt;*    This product includes software developed by the University of&lt;br /&gt;*    California, Berkeley and its contributors.&lt;br /&gt;* 4. Neither the name of the University nor the names of its contributors&lt;br /&gt;*    may be used to endorse or promote products derived from this software&lt;br /&gt;*    without specific prior written permission.&lt;br /&gt;*&lt;br /&gt;* THIS SOFTWARE IS PROVIDED BY THE REGENTS AND CONTRIBUTORS ``AS IS'' AND&lt;br /&gt;* ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE&lt;br /&gt;* IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE&lt;br /&gt;* ARE DISCLAIMED.  IN NO EVENT SHALL THE REGENTS OR CONTRIBUTORS BE LIABLE&lt;br /&gt;* FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL&lt;br /&gt;* DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS&lt;br /&gt;* OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION)&lt;br /&gt;* HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT&lt;br /&gt;* LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY&lt;br /&gt;* OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF&lt;br /&gt;* SUCH DAMAGE.&lt;br /&gt;*/&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;#ifndef lint&lt;br /&gt;static char copyright[] =&lt;br /&gt;"@(#) Copyright (c) 1989, 1993\n\&lt;br /&gt; The Regents of the University of California.  All rights reserved.\n";&lt;br /&gt;#endif /* not lint */&lt;br /&gt;&lt;br /&gt;#ifndef lint&lt;br /&gt;#if 0&lt;br /&gt;static char sccsid[] = "@(#)cat.c    8.2 (Berkeley) 4/27/95";&lt;br /&gt;#else&lt;br /&gt;static char rcsid[] = "$OpenBSD: cat.c,v 1.14 2002/07/04 04:26:39 deraadt Exp $";&lt;br /&gt;#endif&lt;br /&gt;#endif /* not lint */&lt;br /&gt;&lt;br /&gt;#include &amp;lt;sys/param.h&amp;gt;&lt;br /&gt;#include &amp;lt;sys/stat.h&amp;gt; &lt;br /&gt;&lt;br /&gt;#include &amp;lt;ctype.h&amp;gt;      &lt;br /&gt;#include &amp;lt;err.h&amp;gt;   &lt;br /&gt;#include &amp;lt;errno.h&amp;gt;   &lt;br /&gt;#include &amp;lt;fcntl.h&amp;gt;   &lt;br /&gt;#include &amp;lt;locale.h&amp;gt;   &lt;br /&gt;#include &amp;lt;stdio.h&amp;gt;   &lt;br /&gt;#include &amp;lt;stdlib.h&amp;gt;   &lt;br /&gt;#include &amp;lt;string.h&amp;gt;   &lt;br /&gt;#include &amp;lt;unistd.h&amp;gt;     &lt;stdio.h&gt;&lt;sys h=""&gt;&lt;sys h=""&gt;&lt;ctype.h&gt;&lt;err.h&gt;&lt;errno.h&gt;&lt;fcntl.h&gt;&lt;locale.h&gt;&lt;stdio.h&gt;&lt;stdlib.h&gt;&lt;string.h&gt;&lt;unistd.h&gt;&lt;br /&gt;&lt;br /&gt;extern char *__progname;&lt;br /&gt;&lt;br /&gt;int bflag, eflag, nflag, sflag, tflag, vflag;&lt;br /&gt;int rval;&lt;br /&gt;char *filename;&lt;br /&gt;&lt;br /&gt;void cook_args(char *argv[]);&lt;br /&gt;void cook_buf(FILE *);&lt;br /&gt;void raw_args(char *argv[]);&lt;br /&gt;void raw_cat(int);&lt;br /&gt;&lt;br /&gt;int&lt;br /&gt;main(int argc, char *argv[])&lt;br /&gt;{&lt;br /&gt; int ch;&lt;br /&gt;&lt;br /&gt; setlocale(LC_ALL, "");&lt;br /&gt;&lt;br /&gt; while ((ch = getopt(argc, argv, "benstuv")) != -1)&lt;br /&gt;     switch (ch) {&lt;br /&gt;     case 'b':&lt;br /&gt;         bflag = nflag = 1;    /* -b implies -n */&lt;br /&gt;         break;&lt;br /&gt;     case 'e':&lt;br /&gt;         eflag = vflag = 1;    /* -e implies -v */&lt;br /&gt;         break;&lt;br /&gt;     case 'n':&lt;br /&gt;         nflag = 1;&lt;br /&gt;         break;&lt;br /&gt;     case 's':&lt;br /&gt;         sflag = 1;&lt;br /&gt;         break;&lt;br /&gt;     case 't':&lt;br /&gt;         tflag = vflag = 1;    /* -t implies -v */&lt;br /&gt;         break;&lt;br /&gt;     case 'u':&lt;br /&gt;         setbuf(stdout, NULL);&lt;br /&gt;         break;&lt;br /&gt;     case 'v':&lt;br /&gt;         vflag = 1;&lt;br /&gt;         break;&lt;br /&gt;     default:&lt;br /&gt;         (void)fprintf(stderr,&lt;br /&gt;             "usage: %s [-benstuv] [-] [file ...]\n", __progname);&lt;br /&gt;         exit(1);&lt;br /&gt;         /* NOTREACHED */&lt;br /&gt;     }&lt;br /&gt; argv += optind;&lt;br /&gt;&lt;br /&gt; if (bflag || eflag || nflag || sflag || tflag || vflag)&lt;br /&gt;     cook_args(argv);&lt;br /&gt; else&lt;br /&gt;     raw_args(argv);&lt;br /&gt; if (fclose(stdout))&lt;br /&gt;     err(1, "stdout");&lt;br /&gt; exit(rval);&lt;br /&gt;}&lt;br /&gt;&lt;br /&gt;void&lt;br /&gt;cook_args(char **argv)&lt;br /&gt;{&lt;br /&gt; FILE *fp;&lt;br /&gt;&lt;br /&gt; fp = stdin;&lt;br /&gt; filename = "stdin";&lt;br /&gt; do {&lt;br /&gt;     if (*argv) {&lt;br /&gt;         if (!strcmp(*argv, "-"))&lt;br /&gt;             fp = stdin;&lt;br /&gt;         else if ((fp = fopen(*argv, "r")) == NULL) {&lt;br /&gt;             warn("%s", *argv);&lt;br /&gt;             rval = 1;&lt;br /&gt;             ++argv;&lt;br /&gt;             continue;&lt;br /&gt;         }&lt;br /&gt;         filename = *argv++;&lt;br /&gt;     }&lt;br /&gt;     cook_buf(fp);&lt;br /&gt;     if (fp != stdin)&lt;br /&gt;         (void)fclose(fp);&lt;br /&gt; } while (*argv);&lt;br /&gt;}&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;void&lt;br /&gt;cook_buf(FILE *fp)&lt;br /&gt;{&lt;br /&gt; int ch, gobble, line, prev;&lt;br /&gt;&lt;br /&gt; line = gobble = 0;&lt;br /&gt; for (prev = '\n'; (ch = getc(fp)) != EOF; prev = ch) {&lt;br /&gt;     if (prev == '\n') {&lt;br /&gt;         if (sflag) {&lt;br /&gt;             if (ch == '\n') {&lt;br /&gt;                 if (gobble)&lt;br /&gt;                     continue;&lt;br /&gt;                 gobble = 1;&lt;br /&gt;             } else&lt;br /&gt;                 gobble = 0;&lt;br /&gt;         }&lt;br /&gt;         if (nflag &amp;amp;&amp;amp; (!bflag || ch != '\n')) {&lt;br /&gt;             (void)fprintf(stdout, "%6d\t", ++line);&lt;br /&gt;             if (ferror(stdout))&lt;br /&gt;                 break;&lt;br /&gt;         }&lt;br /&gt;     }&lt;br /&gt;     if (ch == '\n') {&lt;br /&gt;         if (eflag &amp;amp;&amp;amp; putchar('$') == EOF)&lt;br /&gt;             break;&lt;br /&gt;     } else if (ch == '\t') {&lt;br /&gt;         if (tflag) {&lt;br /&gt;             if (putchar('^') == EOF || putchar('I') == EOF)&lt;br /&gt;                 break;&lt;br /&gt;             continue;&lt;br /&gt;         }&lt;br /&gt;     } else if (vflag) {&lt;br /&gt;         if (!isascii(ch)) {&lt;br /&gt;             if (putchar('M') == EOF || putchar('-') == EOF)&lt;br /&gt;                 break;&lt;br /&gt;             ch = toascii(ch);&lt;br /&gt;         }&lt;br /&gt;         if (iscntrl(ch)) {&lt;br /&gt;             if (putchar('^') == EOF ||&lt;br /&gt;                 putchar(ch == '\177' ? '?' :&lt;br /&gt;                 ch | 0100) == EOF)&lt;br /&gt;                 break;&lt;br /&gt;             continue;&lt;br /&gt;         }&lt;br /&gt;     }&lt;br /&gt;     if (putchar(ch) == EOF)&lt;br /&gt;         break;&lt;br /&gt; }&lt;br /&gt; if (ferror(fp)) {&lt;br /&gt;     warn("%s", filename);&lt;br /&gt;     rval = 1;&lt;br /&gt;     clearerr(fp);&lt;br /&gt; }&lt;br /&gt; if (ferror(stdout))&lt;br /&gt;     err(1, "stdout");&lt;br /&gt;}&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;void&lt;br /&gt;raw_args(char **argv)&lt;br /&gt;{&lt;br /&gt; int fd;&lt;br /&gt;&lt;br /&gt; fd = fileno(stdin);&lt;br /&gt; filename = "stdin";&lt;br /&gt; do {&lt;br /&gt;     if (*argv) {&lt;br /&gt;         if (!strcmp(*argv, "-"))&lt;br /&gt;             fd = fileno(stdin);&lt;br /&gt;         else if ((fd = open(*argv, O_RDONLY, 0)) &lt; rval =" 1;" filename =" *argv++;" wfd =" fileno(stdout);" buf ="=" bsize =" MAX(sbuf.st_blksize," buf =" malloc((u_int)bsize))" nr =" read(rfd,"&gt; 0)&lt;br /&gt;     for (off = 0; nr; nr -= nw, off += nw)&lt;br /&gt;         if ((nw = write(wfd, buf + off, nr)) &lt; rval =" 1;"&gt;&lt;/unistd.h&gt;&lt;/string.h&gt;&lt;/stdlib.h&gt;&lt;/stdio.h&gt;&lt;/locale.h&gt;&lt;/fcntl.h&gt;&lt;/errno.h&gt;&lt;/err.h&gt;&lt;/ctype.h&gt;&lt;/sys&gt;&lt;/sys&gt;&lt;/stdio.h&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/7332367523697889934-6144517959375663613?l=vbmade2007.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://vbmade2007.blogspot.com/feeds/6144517959375663613/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=7332367523697889934&amp;postID=6144517959375663613' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/7332367523697889934/posts/default/6144517959375663613'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/7332367523697889934/posts/default/6144517959375663613'/><link rel='alternate' type='text/html' href='http://vbmade2007.blogspot.com/2007/10/source-code-of-cat-command-of-unix.html' title='Source code of cat command of Unix'/><author><name>vbmade2000</name><uri>http://www.blogger.com/profile/08530715708520984049</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-7332367523697889934.post-7284163775756599772</id><published>2007-10-03T01:04:00.000-07:00</published><updated>2008-05-02T04:31:01.277-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='Visual Basic.Net'/><title type='text'>Some difference between VB.Net and C#</title><content type='html'>Make your case&lt;br /&gt;&lt;br /&gt;In my opinion, the biggest difference (by far) between VB.NET and C# is the fact that C# is case-sensitive. This can be a problem for former Visual Basic or current VB.NETers to grasp as they move to C#. After all, the following is legal in C#:&lt;br /&gt;&lt;br /&gt;stringfirstName;&lt;br /&gt;&lt;br /&gt;string FirstName;&lt;br /&gt;&lt;br /&gt;string Firstname;&lt;br /&gt;&lt;br /&gt;These three variables are unique with no problems, but the same (or similar) VB.NET code will not compile since each variable is seen as having the same name:&lt;br /&gt;&lt;br /&gt;Dim firstName As String&lt;br /&gt;&lt;br /&gt;dim FirstName As String&lt;br /&gt;&lt;br /&gt;Dim Firstname As string&lt;br /&gt;&lt;br /&gt;Other languages like JavaScript and Java are case-sensitive, so this isn't an anomaly—rather developers may view VB.NET's lack of case-sensitive support as out-of-the-ordinary.&lt;br /&gt;&lt;br /&gt;Delimiters&lt;br /&gt;&lt;br /&gt;Another major difference in the languages is line termination and code blocks. VB.NET uses a carriage return at the end of each line, so lines of code are contained on their own line. On the other hand, C# code lines use the semi-colon at the end of each line of code. Each line of code does not need to be on its own line, but it must end with a semi-colon. If you forget a semi-colon, you'll encounter a code error.&lt;br /&gt;&lt;br /&gt;A block of code is a collection of statements. Examples include a class, its methods, loops, and so forth. C# marks a code block with curly braces (the starting brace { and the ending brace }) while VB.NET ends code blocks with statements (such as End If, Next, and End Sub). The following C# code snippet declares a class with a constructor with the curly braces defining the groups:&lt;br /&gt;&lt;br /&gt;public class TestClass {&lt;br /&gt;&lt;br /&gt;public TestClass() {&lt;br /&gt;&lt;br /&gt;// Constructor&lt;br /&gt;&lt;br /&gt;}&lt;br /&gt;&lt;br /&gt;~TestClass() {&lt;br /&gt;&lt;br /&gt;// Destructor&lt;br /&gt;&lt;br /&gt;}&lt;br /&gt;&lt;br /&gt;public void DoSomething() { }&lt;br /&gt;&lt;br /&gt;public intDoSomethingElse() {}&lt;br /&gt;&lt;br /&gt;}&lt;br /&gt;&lt;br /&gt;And, VB.NET uses end statements to delineate a code block:&lt;br /&gt;&lt;br /&gt;Class TestClass&lt;br /&gt;&lt;br /&gt;Public Sub New()&lt;br /&gt;&lt;br /&gt;' Constructor&lt;br /&gt;&lt;br /&gt;End Sub&lt;br /&gt;&lt;br /&gt;Protected Overrides Sub Finalize()&lt;br /&gt;&lt;br /&gt;REM Destructor&lt;br /&gt;&lt;br /&gt;End Sub&lt;br /&gt;&lt;br /&gt;Public Sub DoSomething()&lt;br /&gt;&lt;br /&gt;End Sub&lt;br /&gt;&lt;br /&gt;Public Function DoSomethingElse() As Integer&lt;br /&gt;&lt;br /&gt;End Function&lt;br /&gt;&lt;br /&gt;End Class&lt;br /&gt;&lt;br /&gt;These code snippets demonstrate the approach to blocks of code—most notably, a class declared with two methods. Actually, the code demonstrates a few other points. Each class declares constructor and destructor methods as well as two methods. The first method (DoSomething) does not return a value, while the second method (DoSomethingElse) does. You'll notice that VB.NET uses Sub for methods that return no values and Function for its counterpart. C# uses void for no return value and specifies the return value otherwise. The code also uses comments.&lt;br /&gt;&lt;br /&gt;The C# comments are single-line with the double backslashes (//); multi-line comments may be used as well—they are enclosed as a group between backslash and asterisk combinations (/* and */). VB.NET only supports single-line comments denoted with either the apostrophe (') or REM statement.&lt;br /&gt;&lt;br /&gt;Data types&lt;br /&gt;&lt;br /&gt;The two languages support the same data types with a few differences in syntax. The following table provides an overview.&lt;br /&gt;&lt;br /&gt;VB.NET&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;C#&lt;br /&gt;&lt;br /&gt;Boolean&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;bool&lt;br /&gt;&lt;br /&gt;Byte&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;byte, sbyte&lt;br /&gt;&lt;br /&gt;Char&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;char&lt;br /&gt;&lt;br /&gt;Short, Integer, Long&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;short, ushort, int, unit, long, ulong&lt;br /&gt;&lt;br /&gt;Single, Double&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;float, double&lt;br /&gt;&lt;br /&gt;Decimal&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;decimal&lt;br /&gt;&lt;br /&gt;Date&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;DateTime&lt;br /&gt;&lt;br /&gt;Object&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;object&lt;br /&gt;&lt;br /&gt;String&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;string&lt;br /&gt;&lt;br /&gt;You may notice a big difference where C# supports unsigned values while VB.NET does not. Variable declaration presents differences as well. VB.NET uses the dim statement to declare (or dimension) a variable, and the as keyword is used to assign a type as the following lines demonstrate:&lt;br /&gt;&lt;br /&gt;Dim i As Integer&lt;br /&gt;&lt;br /&gt;Dim first As String&lt;br /&gt;&lt;br /&gt;On the other hand, C# starts with the type followed by the name:&lt;br /&gt;&lt;br /&gt;int I;&lt;br /&gt;&lt;br /&gt;string first;&lt;br /&gt;&lt;br /&gt;When working with variables and objects, you will often work with arrays where another syntax difference arises.&lt;br /&gt;&lt;br /&gt;Brackets&lt;br /&gt;&lt;br /&gt;One of the language differences that always seem to trip me up is the use of brackets by C# for accessing individual elements of an array or collection of values. On the flip side, VB.NET uses parentheses in the same situations. The following code declares and populates an array of integer values:&lt;br /&gt;&lt;br /&gt;int[] test = {1,2,3,4,5};&lt;br /&gt;&lt;br /&gt;for (int x=0; x &lt; test.Length; x++) { Console.WriteLine(test[x]); };&lt;br /&gt;&lt;br /&gt;Here's the equivalent VB.NET code:&lt;br /&gt;&lt;br /&gt;Dim test() As Integer = {1, 2, 3, 4, 5}&lt;br /&gt;&lt;br /&gt;For i As Integer = 0 To (test.Length - 1)&lt;br /&gt;Console.WriteLine(test(i))&lt;br /&gt;&lt;br /&gt;Next i&lt;br /&gt;&lt;br /&gt;The code demonstrates the different syntax of the for loop as well.&lt;br /&gt;&lt;br /&gt;Equality&lt;br /&gt;&lt;br /&gt;The final discrepancy between the languages that I'd like to cover is the syntax for determining the equality of two values. This is a common misstep for developers new to C# (and JavaScript coders as well), as C# uses the double equals sign (==) to test for equality, while VB.NET uses the single equals sign (=). The following code samples demonstrate testing equality—beginning with C# that determines if an integer is equal to a value and displays text accordingly:&lt;br /&gt;&lt;br /&gt;if (i == 2) { Console.WriteLine("They are equal"); }&lt;br /&gt;&lt;br /&gt;else { Console.WriteLine("They are not equal"); }&lt;br /&gt;&lt;br /&gt;Here's the VB.NET equivalent:&lt;br /&gt;&lt;br /&gt;Dim i As Integer&lt;br /&gt;&lt;br /&gt;If (i = 2) Then&lt;br /&gt;Console.WriteLine("They are equal")&lt;br /&gt;&lt;br /&gt;Else&lt;br /&gt;Console.WriteLine("They are not equal")&lt;br /&gt;&lt;br /&gt;End If&lt;br /&gt;&lt;br /&gt;The frustrating aspect of this difference is it is not caught during compilation, so using the single equals sign in C# will assign the value instead of determining equality and thus logic problems that requires debugging.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/7332367523697889934-7284163775756599772?l=vbmade2007.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://vbmade2007.blogspot.com/feeds/7284163775756599772/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=7332367523697889934&amp;postID=7284163775756599772' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/7332367523697889934/posts/default/7284163775756599772'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/7332367523697889934/posts/default/7284163775756599772'/><link rel='alternate' type='text/html' href='http://vbmade2007.blogspot.com/2007/10/some-difference-between-vbnet-and-c.html' title='Some difference between VB.Net and C#'/><author><name>vbmade2000</name><uri>http://www.blogger.com/profile/08530715708520984049</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry></feed>
