GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Peoplesoft  >  PS Mixed
Go To First  |  Previous Question  |  Next Question 
 PS Mixed  |  Question 77 of 200    Print  
What are destructive statements in SQL?
b) Recreate a Table d) Recreate a View


  
Total Answers and Comments: 1 Last Update: December 13, 2005   
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
December 13, 2005 12:50:03   #1  
priya        

RE: What are destructive statements in SQL
recreate a table ofcourse. A view is just a SQL query stored and is executed everytime you access it. it does not store any values just retieves them from the tables in the query. Where as table acutally has values stored so if recreated with data present it is destructive. If no data present then go ahead and recreate it.
 
Is this answer useful? Yes | No

 Related Questions

Latest Answer : Sql: - Insert, update, create, delete. Meta Sql: - %Bind, %Execute Edits, %Select, %Selectinit, %Sql, %Table, %Truncate Table. Sql statements are platform dependent where as meta sql statements r platform independent. ...

b) Recreate a Table d) Recreate a View 
Latest Answer : recreate a table ofcourse. A view is just a SQL query stored and is executed everytime you access it. it does not store any values, just retieves them from the tables in the query. Where as table acutally has values stored so if recreated with data present ...

Pub Broker is invoked after Pub Contractor Handler evaluates routing rules and writes contract(s)  


 Sponsored Links

 
Related Articles

C++ Decision Making Statements

C Decision Making Statements In this C tutorial you will learn about decision making statements if statement if… else statement switch statement conditional operator along with syntax and examples mosgoogle center Decision making is an important concept in any programming language and to
 

exit and return statements

  How does the exit () and return () differ exit () is used to exit the program as a whole. In other words it returns control to the operating system. After exit () all memory and temporary storage areas are all flushed out and control goes out of program. In contrast, the return () stateme
 

The Interview Snafu

How to turn someone else’s mistake to your advantage Your dream job is about to become reality. A recruiter gave you the heads up about the perfect position at Humungous Conglomerate, Inc. You went through five interviews as well as a battery of psychological tests mandated by their HR de
 

Winning a Job Interview with a Winning Resume

Does your resume unlock your potential, take your skills to the highest level and win you the interview and the job you want now? The job market today is highly competitive and even if you think you have what it takes to get an interview you won’t get over the line without a polished, prof
 

Importance of Proper English during Job Interview

Importance of Proper English during Job Interview Your job interview is crucially important and it will determine whether or not you will get the job Depending on the type of job you re going for it is very important for you to use proper English In most cases jobs which offer higher salaries will h
 

JavaScript Conditional Statements Part 2

JavaScript Conditional Statements Part 2 In continuation of JavaScript Conditional Statements Part 1 this tutorial will help you learn about remaining conditional statements in JavaScript if else if else statement and switch statement mosgoogle if else if else statement If there are many branching o
 

JavaScript Conditional Statements Part 1

JavaScript Conditional Statements Part 1 In this JavaScript tutorial you will learn about the conditional statements available in JavaScript for decision making if statement and if else statement mosgoogle Just like any other programming language conditional statements in JavaScript are used for de
 

HR Interview - HR Interview Mistakes You Will Want To Avoid

HR Interview Mistakes You Will Want To Avoid The job interview can be a stressful process This is especially true for those who are going after a competitive position Your nonverbal communication combined with the answers you give during the interview will determine if you are hired mosgoogle While
 

HR Interview - Behavioral HR Interviews

Behavioral HR Interviews As the name implies a behavioral interview is an interview that is held by a human resources department to determine if an applicant has the behaviors that are appropriate for a job The company must know how an applicant will behave in a certain situations mosgoogle The logi
 

HR Interview - How To Prepare For Your HR Interview

How To Prepare For Your HR Interview Before you begin thinking about how you are going to dress for the interview it is important to do your research first You should learn everything you can about the company you wish to work for When you have detailed information about your employer you will conve
 

About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape