Which command allows the removal of all rows from a table but flushes a table more efficiently since no rollback information is retained:(a) TRUNCATE command(b) Create command(c) Drop table command(d) Alter table commandThe question was posed to me during an online interview.The origin of the question is DDL Command in section SQL Basics of Oracle

Which command allows the removal of all rows from a table but flushes

1.	Which command allows the removal of all rows from a table but flushes a table more efficiently since no rollback information is retained:(a) TRUNCATE command(b) Create command(c) Drop table command(d) Alter table commandThe question was posed to me during an online interview.The origin of the question is DDL Command in section SQL Basics of Oracle
Answer» Right choice is (a) TRUNCATE command Easy explanation: The SQL TRUNCATE TABLE command is USED to delete complete data from an EXISTING table.You can ALSO use DROP TABLE command to delete complete table but it would remove complete table structure form the database and you would need to re-create this table once again if you WISH you store some data.

Discussion

No Comment Found

Related InterviewSolutions

_________commands in SQL allow controlling access to data within database.(a) Database(b) Data(c) Data control(d) All of the MentionedThe question was asked by my college professor while I was bunking the class.I want to ask this question from DCL,TCL Command topic in division SQL Basics of Oracle
A Database Language Concerned With The Definition Of The Whole Database Structure And Schema Is ________(a) DCL(b) DML(c) DDL(d) All of the MentionedThis question was posed to me in a job interview.This question is from DCL,TCL Command in division SQL Basics of Oracle
To obtain the structure of an Oracle table, the command to use is:(a) STRUCTURE [TableName].(b) DESCRIBE [TableName].(c) DESCRIBE STRUCTURE [TableName].(d) DESC TABLE [TableName].The question was posed to me in class test.My query is from DCL,TCL Command in section SQL Basics of Oracle
The Database Language That Allows You To Access Or Maintain Data In A Database(a) DCL(b) DML(c) DDL(d) All of the MentionedThe question was asked in class test.I'm obligated to ask this question of DCL,TCL Command topic in portion SQL Basics of Oracle
A transaction completes its execution is said to be(a) Committed(b) Aborted(c) Rolled back(d) FailedThe question was posed to me in semester exam.This intriguing question originated from DCL,TCL Command topic in division SQL Basics of Oracle
Which of the following keyword is used with Data Control Language (DCL) statements?(a) SELECT(b) INSERT(c) DELETE(d) GRANTI have been asked this question in an online interview.This key question is from DCL,TCL Command in chapter SQL Basics of Oracle
DCL Provides Commands To Perform Actions Like _____________(a) Change The Structure Of Tables(b) Insert, Update Or Delete Records And Data Values(c) Authorizing Access And Other Control Over Database(d) None of the MentionedThe question was asked in my homework.This intriguing question comes from DCL,TCL Command in portion SQL Basics of Oracle
In an SQL statement, which of the following parts states the conditions for row selection?(a) Where(b) From(c) Order By(d) Group ByThis question was addressed to me in final exam.I would like to ask this question from DCL,TCL Command topic in chapter SQL Basics of Oracle
A type of query that is placed within a WHERE or HAVING clause of another query is called(a) Master query(b) Sub query(c) Super query(d) Multi-queryI had been asked this question in a job interview.This is a very interesting question from DML Command in chapter SQL Basics of Oracle
TCL stands for:(a) Transaction control languages(b) Transaction command languages(c) Transaction connect languages(d) None of the MentionedThis question was posed to me in an online quiz.My question is based upon DCL,TCL Command in section SQL Basics of Oracle

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment