tag:blogger.com,1999:blog-19929459248544175882024-03-13T08:56:48.503-07:00Oracle TutorPop's Worldhttp://www.blogger.com/profile/04964875113190825498noreply@blogger.comBlogger157125tag:blogger.com,1999:blog-1992945924854417588.post-41602235621999418342011-10-03T20:20:00.001-07:002011-10-03T20:20:54.413-07:00ER Diagram - Entity Keys<div style="text-align: justify; font-family: verdana;"><span style="font-size:85%;">Well... An entity is defined by its attributes. Furthermore, each entity occurrence can be uniquely identified, by using an attribute or a combination of attributes as a key.</span><br /><span style="font-size:85%;"> </span><br /><span style="font-size:85%;"> The primary key is the attribute (or group of attributes) that serve to uniquely identify each entity occurrence. Consider the problem that might arise if the name and address of an individual were used as the primary key for identifying the patients within a hospital. </span><br /><span style="font-size:85%;"> </span><br /><span style="font-size:85%;"> Take the example of a patient called David Smith living at 23 Acacia Avenue. He has a son also called David Smith living at the same address.</span><br /><span style="font-size:85%;"> </span><br /><span style="font-size:85%;"> Name and Address would not necessarily provide a unique identifier and confusion could easily arise, potentially creating a mix up with the patient records. </span><br /><span style="font-size:85%;"> </span><br /><span style="font-size:85%;"> For this reason, in a hospital system patients each have a Patient Number as their primary key. </span></div>Pop's Worldhttp://www.blogger.com/profile/04964875113190825498noreply@blogger.comtag:blogger.com,1999:blog-1992945924854417588.post-41449343364015160042011-10-03T20:19:00.000-07:002011-10-03T20:20:09.761-07:00ER Diagram - Entity Naming<div style="text-align: justify; font-family: verdana;"><span lang="en-gb"><span style="font-size:85%;"> Entity names are normally single words and the name chosen should be one familiar to the users. The entity name can include a qualifier in order to clarify their meaning. However, if different names are currently used to describe a given entity in different areas of the organization then a new one should be chosen that is original, unique and meaningful to all of the users. </span></span></div>Pop's Worldhttp://www.blogger.com/profile/04964875113190825498noreply@blogger.comtag:blogger.com,1999:blog-1992945924854417588.post-81792966436761275642011-10-03T20:18:00.000-07:002011-10-03T20:19:45.830-07:00ER Diagram - Notation Symbol<div style="text-align: justify; font-family: trebuchet ms;">Entity relationship diagramming uses a standard set of symbols to represent each of these defined data groups and then proceeds by establishing the relationships between them. The first of these symbols is the soft-box entity symbol. <br />An entity is something about which data will be stored within the system under consideration. In this example the data group invoice can be identified as a system entity.<br /><br />The other main component on a data model is the relationship line. A Relationship is an association between two entities to which all of the occurrences of those entities must conform.<br />The relationship is represented by a line that joins the two entities, to which it refers. This line represents two reciprocal relationships:That of the first entity with respect to the second, and that of the second entity with respect to the first.<br /><br />Entity relationship diagramming is all about identifying entities and their relationships and then drawing a diagram that accurately depicts the system. This applies equally to the design of a new system or the analysis of an existing one.<br /><br />The end result of entity relationship diagramming should be a clear picture of how information is stored and related within a proposed, or existing, system.<br /></div>Pop's Worldhttp://www.blogger.com/profile/04964875113190825498noreply@blogger.comtag:blogger.com,1999:blog-1992945924854417588.post-34104423618527530662011-10-03T20:17:00.000-07:002011-10-03T20:18:43.728-07:00What is Entity relationship diagram?<div style="text-align: justify;"><div style="text-align: center;"><span style="font-family: verdana; font-weight: bold;font-size:180%;" >What is Entity relationship diagram?</span><br /></div><br /><span style="font-family: verdana;font-size:100%;" >Entity relationship diagramming is a technique that is widely used in the world of business and information technology to show how information is, or should be, stored and used within a business system.</span><br /><br /><span style="font-family: verdana;font-size:100%;" >The success of any organization relies on the efficient flow and processing of information.</span><br /><br /><span style="font-family: verdana;font-size:100%;" ><br /></span></div>Pop's Worldhttp://www.blogger.com/profile/04964875113190825498noreply@blogger.comtag:blogger.com,1999:blog-1992945924854417588.post-71931060137510883802011-05-02T03:54:00.000-07:002011-05-02T03:56:10.368-07:00Creating Combined Queries in Oracle SQL<span style="font-family: courier new; font-weight: bold;">SQL queries are combined using the UNION operator. Using UNION, multiple SELECT statements can be specified, and their results can be combined into a single result set.</span><br /><br /><span style="font-family: courier new; font-weight: bold;">Using UNION</span><br /><span style="font-family: courier new; font-weight: bold;">Using UNION is simple enough. All you do is specify each SELECT statement and place the keyword UNION between each.</span><br /><br /><span style="font-family: courier new; font-weight: bold;">Let's look at an example. You need a report on all your customers in Illinois, Indiana, and Michigan. You also want to include all Fun4All locations, regardless of state. Of course, you can create a WHERE clause that will do this, but this time you'll use a UNION instead.</span><br /><br /><span style="font-family: courier new; font-weight: bold;">As I just explained, creating a UNION involves writing multiple SELECT statements. First look at the individual statements:</span><br /><br /><span style="font-family: courier new; font-weight: bold;">SELECT cust_name, cust_contact, cust_email</span><br /><br /><span style="font-family: courier new; font-weight: bold;">FROM Customers</span><br /><br /><span style="font-family: courier new; font-weight: bold;">WHERE cust_state IN ('IL','IN','MI');</span><br /><br /><br /><span style="font-family: courier new; font-weight: bold;">cust_name cust_contact cust_email</span><br /><br /><span style="font-family: courier new; font-weight: bold;">----------- ------------- ------------</span><br /><br /><span style="font-family: courier new; font-weight: bold;">Village Toys John Smith sales@villagetoys.com</span><br /><br /><span style="font-family: courier new; font-weight: bold;">Fun4All Jim Jones jjones@fun4all.com</span><br /><br /><span style="font-family: courier new; font-weight: bold;">The Toy Store Kim Howard NULL</span><br /><br /><br /><br /><span style="font-family: courier new; font-weight: bold;">Now Combne</span><br /><br /><br /><span style="font-family: courier new; font-weight: bold;">SELECT cust_name, cust_contact, cust_email</span><br /><br /><span style="font-family: courier new; font-weight: bold;">FROM Customers</span><br /><br /><span style="font-family: courier new; font-weight: bold;">WHERE cust_state IN ('IL','IN','MI')</span><br /><br /><span style="font-family: courier new; font-weight: bold;">UNION</span><br /><br /><span style="font-family: courier new; font-weight: bold;">SELECT cust_name, cust_contact, cust_email</span><br /><br /><span style="font-family: courier new; font-weight: bold;">FROM Customers</span><br /><br /><span style="font-family: courier new; font-weight: bold;">WHERE cust_name = 'Fun4All';</span><br /><br /><span style="font-family: courier new; font-weight: bold;">cust_name cust_contact cust_email</span><br /><br /><span style="font-family: courier new; font-weight: bold;">--------- ------------ ----------</span><br /><br /><span style="font-family: courier new; font-weight: bold;">Fun4All Denise L. Stephens dstephens@fun4all.com</span><br /><br /><span style="font-family: courier new; font-weight: bold;">Fun4All Jim Jones jjones@fun4all.com</span><br /><br /><span style="font-family: courier new; font-weight: bold;">Village Toys John Smith sales@villagetoys.com</span><br /><br /><span style="font-family: courier new; font-weight: bold;">The Toy Store Kim Howard NULL</span>Pop's Worldhttp://www.blogger.com/profile/04964875113190825498noreply@blogger.comtag:blogger.com,1999:blog-1992945924854417588.post-34819981028276358312011-05-02T03:52:00.000-07:002011-05-02T03:54:03.856-07:00what is Cursors in Oracle , Cursors and Web-Based Applications<div style="text-align: justify;"><span style="font-family: verdana;">SQL retrieval operations work with sets of rows known as result sets. The rows returned are all the rows that match a SQL statement—zero or more of them. Using simple SELECT statements, there is no way to get the first row, the next row, or the previous 10 rows. This is an integral part of how a relational DBMS worksDifferent DBMSs support different cursor options and features. Some of the more common ones are:</span><br /><br /><span style="font-family: verdana;">The capability to flag a cursor as read-only so that data can be read but not updated or deleted</span><br /><br /><span style="font-family: verdana;">The capability to control the directional operations that can be performed (forward, backward, first, last, absolute position, relative position, and so on)</span><br /><br /><span style="font-family: verdana;">The capability to flag some columns as editable and others as not editable</span><br /><br /><span style="font-family: verdana;">Scope specification so as to be able to make the cursor accessible to a specific request that created it (a stored procedure, for example) or to all requests</span><br /><br /><span style="font-family: verdana;">Instructing the DBMS to make a copy of the retrieved data (as opposed to pointing to the live data in the table) so that data does not change between the time the cursor is opened and the time it is accessed</span><br /><br /><span style="font-family: verdana;">Cursors and Web-Based Applications Cursors are rather useless when it comes to Web-based applications (ASP, ColdFusion, PHP, and JSP, for example). Cursors are designed to persist for the duration of a session between a client application and a server, but this client/server model does not fit in the Web application world because the application server is the database client, not the end user. As such, most Web application developers avoid the use of cursors and re-create the functionality themselves if needed.</span><br /><br /></div>Pop's Worldhttp://www.blogger.com/profile/04964875113190825498noreply@blogger.comtag:blogger.com,1999:blog-1992945924854417588.post-68119220408832425342011-05-02T03:50:00.000-07:002011-05-02T03:51:33.285-07:00chk_date Function in Oracle SQL<span style="font-size:130%;"><span style="font-family: courier new; font-weight: bold;">execute chk_date('14-jun-2000');</span><br /></span>Pop's Worldhttp://www.blogger.com/profile/04964875113190825498noreply@blogger.comtag:blogger.com,1999:blog-1992945924854417588.post-20459864263548569022011-04-11T21:37:00.000-07:002011-04-11T21:38:08.628-07:00Where SQL server user names and passwords are stored in SQL server?<table style="font-family: verdana;" bgcolor="#fff0f5" cellpadding="5" cellspacing="1"><tbody><tr bgcolor="white"><td valign="top"><table><tbody><tr><td style="font-style: italic;" valign="top"><br /></td><td style="font-style: italic;" valign="top"><span id="ContentPlaceHolder1_lblAnswer1" class="v11" style="color: DarkGreen; font-weight: bold;">They get stored in System Catalog Views sys.server_principals and sys.sql_logins </span></td></tr></tbody></table></td></tr> <tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><br /></td><td valign="top"><span id="ContentPlaceHolder1_lblAnswer2" class="v11" style="color: DarkBlue;"><br /></span></td></tr></tbody></table></td></tr> <tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><br /></td><td valign="top"><br /></td></tr></tbody></table></td></tr></tbody></table>Pop's Worldhttp://www.blogger.com/profile/04964875113190825498noreply@blogger.comtag:blogger.com,1999:blog-1992945924854417588.post-23111611356548997162011-04-11T21:36:00.000-07:002011-04-11T21:37:08.105-07:00If we have multiple AFTER Triggers on table how can we define the sequence of the triggers ?<table style="font-family: verdana;" bgcolor="#fff0f5" cellpadding="5" cellspacing="1"><tbody><tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption1" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption1" checked="checked" type="radio"></td><td valign="top"><span id="ContentPlaceHolder1_lblAnswer1" class="v11" style="font-weight: bold;color:DarkGreen;" >sp_settriggerorder <img src="http://www.dotnetspider.com/images/general/yes.jpg" /></span></td></tr></tbody></table></td></tr> <tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption2" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption2" type="radio"></td><td valign="top"> <span id="ContentPlaceHolder1_lblAnswer2" class="v11" style="color:DarkBlue;"><span style="color:red;"><b>sp_setorder</b></span> <span style="color:brown;"><br /></span></span></td></tr></tbody></table></td></tr> <tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption3" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption3" type="radio"></td><td valign="top"> <span id="ContentPlaceHolder1_lblAnswer3" class="v11" style="color:DarkBlue;">None</span></td></tr></tbody></table></td></tr></tbody></table>Pop's Worldhttp://www.blogger.com/profile/04964875113190825498noreply@blogger.comtag:blogger.com,1999:blog-1992945924854417588.post-8776335259025884812011-04-11T21:35:00.000-07:002011-04-11T21:36:10.685-07:00What is the maximum Storage Size of the Varchar Datatype?<table style="font-family: verdana;" bgcolor="#fff0f5" cellpadding="5" cellspacing="1"><tbody><tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption1" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption1" type="radio"></td><td valign="top"><span id="ContentPlaceHolder1_lblAnswer1" class="v11" style="color: DarkBlue;">4000 Bytes</span></td></tr></tbody></table></td></tr> <tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption2" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption2" type="radio"></td><td valign="top"> <span id="ContentPlaceHolder1_lblAnswer2" class="v11" style="color: DarkBlue;">7000 Bytes</span></td></tr></tbody></table></td></tr> <tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption3" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption3" checked="checked" type="radio"></td><td valign="top"> <span id="ContentPlaceHolder1_lblAnswer3" class="v11" style="color: DarkGreen; font-weight: bold;">8000 Bytes <img src="http://www.dotnetspider.com/images/general/yes.jpg" /></span></td></tr></tbody></table></td></tr> <tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption4" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption4" type="radio"></td><td valign="top"> <span id="ContentPlaceHolder1_lblAnswer4" class="v11" style="color: DarkBlue;">1000 Bytes</span></td></tr></tbody></table></td></tr></tbody></table>Pop's Worldhttp://www.blogger.com/profile/04964875113190825498noreply@blogger.comtag:blogger.com,1999:blog-1992945924854417588.post-18462442173839679632011-04-11T21:34:00.000-07:002011-04-11T21:35:30.010-07:00What are the two system stored procedures for creating the lnked server?<table style="font-family: verdana;" bgcolor="#fff0f5" cellpadding="5" cellspacing="1"><tbody><tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption1" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption1" checked="checked" type="radio"></td><td valign="top"><span id="ContentPlaceHolder1_lblAnswer1" class="v11" style="font-weight: bold;color:DarkGreen;" >sp_addlinkedserver,sp_addlinkedsrvlogin <img src="http://www.dotnetspider.com/images/general/yes.jpg" /></span></td></tr></tbody></table></td></tr> <tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption2" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption2" type="radio"></td><td valign="top"> <span id="ContentPlaceHolder1_lblAnswer2" class="v11" style="color:DarkBlue;"><span style="color:red;"><b>sp_addlinkedserver,sp_addlogin</b></span> <span style="color:brown;"><br /></span></span></td></tr></tbody></table></td></tr> <tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption3" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption3" type="radio"></td><td valign="top"> <span id="ContentPlaceHolder1_lblAnswer3" class="v11" style="color:DarkBlue;">sp_addlinkedsrv,sp_addlinkedsrvlogin</span></td></tr></tbody></table></td></tr> <tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption4" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption4" type="radio"></td><td valign="top"> <span id="ContentPlaceHolder1_lblAnswer4" class="v11" style="color:DarkBlue;">addlinkedsrv,sp_addsrvlogin</span></td></tr></tbody></table></td></tr></tbody></table>Pop's Worldhttp://www.blogger.com/profile/04964875113190825498noreply@blogger.comtag:blogger.com,1999:blog-1992945924854417588.post-17031627526758794092011-04-11T21:33:00.000-07:002011-04-11T21:34:24.247-07:00How can you find out the sqlserver last restarted date?<div style="text-align: center;"><span style="font-size:130%;"><span style="font-family: courier new; font-weight: bold;">SQL Query for sqlserver last restarted date.<br /><br /><br /></span></span><div style="text-align: left;"><span style="font-family: verdana; font-weight: bold;font-size:100%;color:brown;" >Select Answer:</span> <br /></div><br /> <table style="font-family: verdana;" bgcolor="#fff0f5" cellpadding="5" cellspacing="1"><tbody><tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption1" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption1" type="radio"></td><td valign="top"><span id="ContentPlaceHolder1_lblAnswer1" class="v11" style="color: DarkBlue;">select create_date from sys.databases where name='master'</span></td></tr></tbody></table></td></tr> <tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption2" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption2" checked="checked" type="radio"></td><td valign="top"> <span id="ContentPlaceHolder1_lblAnswer2" class="v11" style="color: DarkGreen; font-weight: bold;">select create_date from sys.databases where name='tempdb' <img src="http://www.dotnetspider.com/images/general/yes.jpg" /></span></td></tr></tbody></table></td></tr> <tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption3" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption3" type="radio"></td><td valign="top"> <span id="ContentPlaceHolder1_lblAnswer3" class="v11" style="color: DarkBlue;">select create_date from sys.databases where name='model'</span></td></tr></tbody></table></td></tr> <tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption4" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption4" type="radio"></td><td valign="top"> <span id="ContentPlaceHolder1_lblAnswer4" class="v11" style="color: DarkBlue;">select create_date from sys.databases where name='msdb'</span></td></tr></tbody></table></td></tr></tbody></table><br /></div>Pop's Worldhttp://www.blogger.com/profile/04964875113190825498noreply@blogger.comtag:blogger.com,1999:blog-1992945924854417588.post-87406926023532482102011-04-11T21:32:00.000-07:002011-04-11T21:33:11.801-07:00What is Full form of DMV?<table style="font-family: verdana;" bgcolor="#fff0f5" cellpadding="5" cellspacing="1"><tbody><tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption1" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption1" type="radio"></td><td valign="top"><span id="ContentPlaceHolder1_lblAnswer1" class="v11" style="color: DarkBlue;">Data Management version</span></td></tr></tbody></table></td></tr> <tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption2" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption2" checked="checked" type="radio"></td><td valign="top"> <span id="ContentPlaceHolder1_lblAnswer2" class="v11" style="color: DarkBlue;"><span style="color:red;"><b>Dynmaic Management version</b></span> </span></td></tr></tbody></table></td></tr> <tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption3" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption3" checked="checked" type="radio"></td><td valign="top"> <span id="ContentPlaceHolder1_lblAnswer3" class="v11" style="color: DarkGreen; font-weight: bold;">Dynamic Management View <img src="http://www.dotnetspider.com/images/general/yes.jpg" /></span></td></tr></tbody></table></td></tr> <tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption4" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption4" type="radio"></td><td valign="top"> <span id="ContentPlaceHolder1_lblAnswer4" class="v11" style="color: DarkBlue;">Data Management view</span></td></tr></tbody></table></td></tr></tbody></table>Pop's Worldhttp://www.blogger.com/profile/04964875113190825498noreply@blogger.comtag:blogger.com,1999:blog-1992945924854417588.post-63656709007574184322011-04-11T21:31:00.000-07:002011-04-11T21:32:19.819-07:00Which function is used for Identifying the numeric value?<table style="font-family: verdana;" bgcolor="#fff0f5" cellpadding="5" cellspacing="1"><tbody><tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption1" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption1" checked="checked" type="radio"></td><td valign="top"><span id="ContentPlaceHolder1_lblAnswer1" class="v11" style="font-weight: bold;color:DarkGreen;" >isnumeric <img src="http://www.dotnetspider.com/images/general/yes.jpg" /></span></td></tr></tbody></table></td></tr> <tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption2" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption2" type="radio"></td><td valign="top"> <span id="ContentPlaceHolder1_lblAnswer2" class="v11" style="color:DarkBlue;">isnumber</span></td></tr></tbody></table></td></tr> <tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption3" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption3" type="radio"></td><td valign="top"> <span id="ContentPlaceHolder1_lblAnswer3" class="v11" style="color:DarkBlue;">is_number</span></td></tr></tbody></table></td></tr> <tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption4" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption4" type="radio"></td><td valign="top"> <span id="ContentPlaceHolder1_lblAnswer4" class="v11" style="color:DarkBlue;"><span style="color:red;"><b>is_numeric</b></span> </span></td></tr></tbody></table></td></tr></tbody></table>Pop's Worldhttp://www.blogger.com/profile/04964875113190825498noreply@blogger.comtag:blogger.com,1999:blog-1992945924854417588.post-52387090794180232312011-04-11T21:28:00.000-07:002011-04-11T21:29:29.266-07:00How do you find out how many tables created today in particular database in SQL?<span style="font-family: verdana;" id="ContentPlaceHolder1_lblDescription"></span> <br /> <span style="font-family: verdana;font-size:100%;color:brown;" >Select Answer:</span> <br /><br /> <table style="font-family: verdana;" bgcolor="#fff0f5" cellpadding="5" cellspacing="1"><tbody><tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption1" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption1" type="radio"></td><td valign="top"><span id="ContentPlaceHolder1_lblAnswer1" class="v11" style="color: DarkBlue;">select count(*) from sys.tables where create_date=getdate()</span></td></tr></tbody></table></td></tr> <tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption2" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption2" checked="checked" type="radio"></td><td valign="top"> <span id="ContentPlaceHolder1_lblAnswer2" class="v11" style="color: DarkBlue;"><span style="color:red;"><b>select count(*) from sys.tables where create_date=convert(varchar,getdate(),101)</b></span> <span style="color:brown;">(Your selection was wrong)</span></span></td></tr></tbody></table></td></tr> <tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption3" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption3" type="radio"></td><td valign="top"> <span id="ContentPlaceHolder1_lblAnswer3" class="v11" style="color: DarkBlue;">select count(*) from sys.tables where convert(varchar,create_date,101)=getdate()</span></td></tr></tbody></table></td></tr> <tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption4" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption4" checked="checked" type="radio"></td><td valign="top"> <span id="ContentPlaceHolder1_lblAnswer4" class="v11" style="color: DarkGreen; font-weight: bold;">select count(*) from sys.tables where convert(varchar,create_date,101)=convert(varchar,getdate(),101) <img src="http://www.dotnetspider.com/images/general/yes.jpg" /></span></td></tr></tbody></table></td></tr></tbody></table>Pop's Worldhttp://www.blogger.com/profile/04964875113190825498noreply@blogger.comtag:blogger.com,1999:blog-1992945924854417588.post-62254922126581202232011-04-11T21:10:00.000-07:002011-04-11T21:12:15.416-07:00What is the difference between a Subquery and a Join?<table bgcolor="#fff0f5" cellpadding="5" cellspacing="1"><tbody><tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption1" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption1" checked="checked" type="radio"></td><td valign="top"><span id="ContentPlaceHolder1_lblAnswer1" class="v11" style="font-weight: bold;color:DarkGreen;" >Subquery will work without having relation between tables, where as join will not work <img src="http://www.dotnetspider.com/images/general/yes.jpg" /></span></td></tr></tbody></table></td></tr> <tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption2" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption2" type="radio"></td><td valign="top"> <span id="ContentPlaceHolder1_lblAnswer2" class="v11" style="color:DarkBlue;">Subquery will be used for more than one result set where Join is used for one result set</span></td></tr></tbody></table></td></tr> <tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption3" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption3" type="radio"></td><td valign="top"> <span id="ContentPlaceHolder1_lblAnswer3" class="v11" style="color:DarkBlue;"><span style="color:red;"><b>Join can be used for multiple tables, Where as Sub query cannot be used for multiple tables</b></span> </span></td></tr></tbody></table></td></tr> <tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption4" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption4" type="radio"></td><td valign="top"> <span id="ContentPlaceHolder1_lblAnswer4" class="v11" style="color:DarkBlue;">None of the above</span></td></tr></tbody></table></td></tr> <tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption5" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption5" type="radio"></td><td valign="top"> <span id="ContentPlaceHolder1_lblAnswer5" class="v11" style="color:DarkBlue;">All of the above</span></td></tr></tbody></table></td></tr></tbody></table>Pop's Worldhttp://www.blogger.com/profile/04964875113190825498noreply@blogger.comtag:blogger.com,1999:blog-1992945924854417588.post-51421306615253453842011-04-11T20:42:00.001-07:002011-04-11T20:42:33.495-07:00Which one of is following is a System defined stored proecdure in SQL Server?<table bgcolor="#fff0f5" cellpadding="5" cellspacing="1"><tbody><tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption1" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption1" type="radio"></td><td valign="top"><span id="ContentPlaceHolder1_lblAnswer1" class="v11" style="color: DarkBlue;">sp_test</span></td></tr></tbody></table></td></tr> <tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption2" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption2" type="radio"></td><td valign="top"> <span id="ContentPlaceHolder1_lblAnswer2" class="v11" style="color: DarkBlue;">sp_myuser</span></td></tr></tbody></table></td></tr> <tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption3" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption3" checked="checked" type="radio"></td><td valign="top"> <span id="ContentPlaceHolder1_lblAnswer3" class="v11" style="color: DarkBlue;"><span style="color:red;"><b>sp_who5</b></span> </span></td></tr></tbody></table></td></tr> <tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption4" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption4" checked="checked" type="radio"></td><td valign="top"> <span id="ContentPlaceHolder1_lblAnswer4" class="v11" style="color: DarkGreen; font-weight: bold;">sp_spaceused <img src="http://www.dotnetspider.com/images/general/yes.jpg" /></span></td></tr></tbody></table></td></tr> <tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption5" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption5" type="radio"></td><td valign="top"> <span id="ContentPlaceHolder1_lblAnswer5" class="v11" style="color: DarkBlue;">sp_gettriggers</span></td></tr></tbody></table></td></tr></tbody></table>Pop's Worldhttp://www.blogger.com/profile/04964875113190825498noreply@blogger.comtag:blogger.com,1999:blog-1992945924854417588.post-8721968936490901752011-04-11T20:41:00.002-07:002011-04-11T20:42:08.338-07:00What type Index is available in Sql server?<table style="font-family: verdana;" bgcolor="#fff0f5" cellpadding="5" cellspacing="1"><tbody><tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><br /></td><td valign="top"><span id="ContentPlaceHolder1_lblAnswer1" class="v11" style="color: DarkBlue;">Search index</span></td></tr></tbody></table></td></tr> <tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption2" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption2" checked="checked" type="radio"></td><td valign="top"> <span id="ContentPlaceHolder1_lblAnswer2" class="v11" style="color: DarkGreen; font-weight: bold;">Clustered Index <img src="http://www.dotnetspider.com/images/general/yes.jpg" /></span></td></tr></tbody></table></td></tr> <tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption3" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption3" type="radio"></td><td valign="top"> <span id="ContentPlaceHolder1_lblAnswer3" class="v11" style="color: DarkBlue;">Normalized index</span></td></tr></tbody></table></td></tr> <tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption4" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption4" type="radio"></td><td valign="top"> <span id="ContentPlaceHolder1_lblAnswer4" class="v11" style="color: DarkBlue;">All of the above</span></td></tr></tbody></table></td></tr> <tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption5" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption5" type="radio"></td><td valign="top"> <span id="ContentPlaceHolder1_lblAnswer5" class="v11" style="color: DarkBlue;">none of the above</span></td></tr></tbody></table></td></tr></tbody></table>Pop's Worldhttp://www.blogger.com/profile/04964875113190825498noreply@blogger.comtag:blogger.com,1999:blog-1992945924854417588.post-54360605103290289122011-04-11T20:41:00.001-07:002011-04-11T20:41:39.985-07:00What are the types of joins available in SQL Server?<table style="font-family: verdana;" bgcolor="#fff0f5" cellpadding="5" cellspacing="1"><tbody><tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><br /></td><td valign="top"><span id="ContentPlaceHolder1_lblAnswer1" class="v11" style="color: DarkBlue;">Inner join, Outer join, Cross join, Loop join</span></td></tr></tbody></table></td></tr> <tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption2" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption2" type="radio"></td><td valign="top"> <span id="ContentPlaceHolder1_lblAnswer2" class="v11" style="color: DarkBlue;">Cross Join, Inner Cross Join, Left outer Join, Right Outer Join</span></td></tr></tbody></table></td></tr> <tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption3" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption3" checked="checked" type="radio"></td><td valign="top"> <span id="ContentPlaceHolder1_lblAnswer3" class="v11" style="color: DarkBlue;"><span style="color:red;"><b>Inner Join, Outer Join, Cross Join, Inner Cross Join</b></span></span></td></tr></tbody></table></td></tr> <tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption4" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption4" type="radio"></td><td valign="top"> <span id="ContentPlaceHolder1_lblAnswer4" class="v11" style="color: DarkBlue;">Inner Join Outer Join, Left join, half join</span></td></tr></tbody></table></td></tr> <tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption5" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption5" checked="checked" type="radio"></td><td valign="top"> <span id="ContentPlaceHolder1_lblAnswer5" class="v11" style="color: DarkGreen; font-weight: bold;">Inner Join ,Outer Join, Cross Join, Self Join <img src="http://www.dotnetspider.com/images/general/yes.jpg" /></span></td></tr></tbody></table></td></tr></tbody></table>Pop's Worldhttp://www.blogger.com/profile/04964875113190825498noreply@blogger.comtag:blogger.com,1999:blog-1992945924854417588.post-28493759446406969282011-04-11T20:40:00.003-07:002011-04-11T20:40:59.781-07:00Declare @datalength varchar(50); set @datalength=' Dot net spider ' select datalength(@datalength),len(@datalength) What is the output for the followi<table bgcolor="#fff0f5" cellpadding="5" cellspacing="1"><tbody><tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><br /></td><td valign="top"><span id="ContentPlaceHolder1_lblAnswer1" class="v11" style="color: DarkBlue;">1)15,15</span></td></tr></tbody></table></td></tr> <tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption2" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption2" type="radio"></td><td valign="top"> <span id="ContentPlaceHolder1_lblAnswer2" class="v11" style="color: DarkBlue;">2)17,17</span></td></tr></tbody></table></td></tr> <tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption3" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption3" checked="checked" type="radio"></td><td valign="top"> <span id="ContentPlaceHolder1_lblAnswer3" class="v11" style="color: DarkBlue;"><span style="color:red;"><b>3)15,17</b></span> </span></td></tr></tbody></table></td></tr> <tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption4" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption4" checked="checked" type="radio"></td><td valign="top"> <span id="ContentPlaceHolder1_lblAnswer4" class="v11" style="color: DarkGreen; font-weight: bold;">4)17,15 <img src="http://www.dotnetspider.com/images/general/yes.jpg" /></span></td></tr></tbody></table></td></tr> <tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption5" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption5" type="radio"></td><td valign="top"> <span id="ContentPlaceHolder1_lblAnswer5" class="v11" style="color: DarkBlue;">4)17,16</span></td></tr></tbody></table></td></tr></tbody></table>Pop's Worldhttp://www.blogger.com/profile/04964875113190825498noreply@blogger.comtag:blogger.com,1999:blog-1992945924854417588.post-82699094841072341592011-04-11T20:40:00.001-07:002011-04-11T20:40:30.579-07:00What is the use of UPDATE_STATISTICS in SQL?<table style="font-family: verdana;" bgcolor="#fff0f5" cellpadding="5" cellspacing="1"><tbody><tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption1" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption1" type="radio"></td><td valign="top"><span id="ContentPlaceHolder1_lblAnswer1" class="v11" style="color: DarkBlue;">To Remove the indexes after modifying huge data</span></td></tr></tbody></table></td></tr> <tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption2" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption2" checked="checked" type="radio"></td><td valign="top"> <span id="ContentPlaceHolder1_lblAnswer2" class="v11" style="color: DarkGreen; font-weight: bold;">To update the indexes after modifying huge data <img src="http://www.dotnetspider.com/images/general/yes.jpg" /></span></td></tr></tbody></table></td></tr> <tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption3" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption3" type="radio"></td><td valign="top"> <span id="ContentPlaceHolder1_lblAnswer3" class="v11" style="color: DarkBlue;">To Create new indexes after modifying huge data</span></td></tr></tbody></table></td></tr></tbody></table>Pop's Worldhttp://www.blogger.com/profile/04964875113190825498noreply@blogger.comtag:blogger.com,1999:blog-1992945924854417588.post-60689944339783119062011-04-11T20:39:00.000-07:002011-04-11T20:40:05.519-07:00How much level Stored Procedure nesting is possible in SQL 2008?<table style="font-family: verdana;" bgcolor="#fff0f5" cellpadding="5" cellspacing="1"><tbody><tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption1" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption1" type="radio"></td><td valign="top"><span id="ContentPlaceHolder1_lblAnswer1" class="v11" style="color: DarkBlue;">28</span></td></tr></tbody></table></td></tr> <tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption2" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption2" type="radio"></td><td valign="top"> <span id="ContentPlaceHolder1_lblAnswer2" class="v11" style="color: DarkBlue;">30</span></td></tr></tbody></table></td></tr> <tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption3" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption3" checked="checked" type="radio"></td><td valign="top"> <span id="ContentPlaceHolder1_lblAnswer3" class="v11" style="color: DarkGreen; font-weight: bold;">32 <img src="http://www.dotnetspider.com/images/general/yes.jpg" /></span></td></tr></tbody></table></td></tr> <tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption4" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption4" type="radio"></td><td valign="top"> <span id="ContentPlaceHolder1_lblAnswer4" class="v11" style="color: DarkBlue;">None</span></td></tr></tbody></table></td></tr></tbody></table>Pop's Worldhttp://www.blogger.com/profile/04964875113190825498noreply@blogger.comtag:blogger.com,1999:blog-1992945924854417588.post-69255598600890723422011-04-11T20:38:00.000-07:002011-04-11T20:39:32.620-07:00What is a Linked SQL Server?<table bgcolor="#fff0f5" cellpadding="5" cellspacing="1"><tbody><tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption1" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption1" checked="checked" type="radio"></td><td valign="top"><span id="ContentPlaceHolder1_lblAnswer1" class="v11" style="color: DarkBlue;"><span style="color:red;"><b>It is concept to add a sql server to another sql server</b></span></span></td></tr></tbody></table></td></tr> <tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption2" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption2" type="radio"></td><td valign="top"> <span id="ContentPlaceHolder1_lblAnswer2" class="v11" style="color: DarkBlue;">It is used to create SP from one SQL Server to another</span></td></tr></tbody></table></td></tr> <tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption3" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption3" checked="checked" type="radio"></td><td valign="top"> <span id="ContentPlaceHolder1_lblAnswer3" class="v11" style="color: DarkGreen; font-weight: bold;">It is used to fetch data from two SQL Servers <img src="http://www.dotnetspider.com/images/general/yes.jpg" /></span></td></tr></tbody></table></td></tr> <tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption4" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption4" type="radio"></td><td valign="top"> <span id="ContentPlaceHolder1_lblAnswer4" class="v11" style="color: DarkBlue;">All of the above</span></td></tr></tbody></table></td></tr> <tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption5" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption5" type="radio"></td><td valign="top"> <span id="ContentPlaceHolder1_lblAnswer5" class="v11" style="color: DarkBlue;">None of the above</span></td></tr></tbody></table></td></tr></tbody></table>Pop's Worldhttp://www.blogger.com/profile/04964875113190825498noreply@blogger.comtag:blogger.com,1999:blog-1992945924854417588.post-4570749694785256082011-04-11T19:57:00.000-07:002011-04-11T20:38:46.311-07:00What is the use of sp_CONFIGURE command?<span style="font-family: verdana;font-size:100%;color:brown;" >Select Answer:</span> <br /><br /> <table style="font-family: verdana;" bgcolor="#fff0f5" cellpadding="5" cellspacing="1"><tbody><tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption1" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption1" type="radio"></td><td valign="top"><span id="ContentPlaceHolder1_lblAnswer1" class="v11" style="color: DarkBlue;">It is used to configure a table</span></td></tr></tbody></table></td></tr> <tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption2" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption2" type="radio"></td><td valign="top"> <span id="ContentPlaceHolder1_lblAnswer2" class="v11" style="color: DarkBlue;">It is used to configure a row</span></td></tr></tbody></table></td></tr> <tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption3" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption3" type="radio"></td><td valign="top"> <span id="ContentPlaceHolder1_lblAnswer3" class="v11" style="color: DarkBlue;">It is used to configure a stored procedure</span></td></tr></tbody></table></td></tr> <tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption4" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption4" type="radio"></td><td valign="top"> <span id="ContentPlaceHolder1_lblAnswer4" class="v11" style="color: DarkBlue;">It is used to configure a server-level settings</span></td></tr></tbody></table></td></tr> <tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption5" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption5" type="radio"></td><td valign="top"> <span id="ContentPlaceHolder1_lblAnswer5" class="v11" style="color: DarkBlue;">All of the above</span></td></tr></tbody></table></td></tr></tbody></table>Pop's Worldhttp://www.blogger.com/profile/04964875113190825498noreply@blogger.comtag:blogger.com,1999:blog-1992945924854417588.post-90931340205245532612011-04-11T10:01:00.000-07:002011-04-11T10:02:13.754-07:00What is policy management in SQL Server?<span style="font-family: verdana;font-size:100%;color:brown;" >Select Answer:</span> <br /><br /> <table style="font-family: verdana;" bgcolor="#fff0f5" cellpadding="5" cellspacing="1"><tbody><tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption1" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption1" type="radio"></td><td valign="top"><span id="ContentPlaceHolder1_lblAnswer1" class="v11" style="color: DarkBlue;">To define a policy for a Function</span></td></tr></tbody></table></td></tr> <tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption2" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption2" type="radio"></td><td valign="top"> <span id="ContentPlaceHolder1_lblAnswer2" class="v11" style="color: DarkBlue;">To define a policy for a Stored procedure</span></td></tr></tbody></table></td></tr> <tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption3" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption3" type="radio"></td><td valign="top"> <span id="ContentPlaceHolder1_lblAnswer3" class="v11" style="color: DarkBlue;">To define a policy for a enterprise</span></td></tr></tbody></table></td></tr> <tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption4" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption4" checked="checked" type="radio"></td><td valign="top"> <span id="ContentPlaceHolder1_lblAnswer4" class="v11" style="color: DarkGreen; font-weight: bold;">All of the above <img src="http://dotnetspider.com/images/general/yes.jpg" /></span></td></tr></tbody></table></td></tr> <tr bgcolor="white"><td valign="top"><table><tbody><tr><td valign="top"><input id="ContentPlaceHolder1_rdoOption5" name="ctl00$ContentPlaceHolder1$Answers" value="rdoOption5" type="radio"></td><td valign="top"> <span id="ContentPlaceHolder1_lblAnswer5" class="v11" style="color: DarkBlue;">None of the above</span></td></tr></tbody></table></td></tr></tbody></table>Pop's Worldhttp://www.blogger.com/profile/04964875113190825498noreply@blogger.com