Related Questions

In SQL, the ____ command is used to recompile a view
A COMPILE VIEW
B DEFINE VIEW
C AFTER VIEW
D CRFATE VIEW
Which of the following command(s) is(are) used to recompile a stored procedure in SQL?
A COMPILE PROCEDURE
B ALTER PROCEDURE
C MODIFY PROCEDURE id) All of the above
D None of the above
E None of the above
There are blank spaces in the following passage which have been numbered . These numbers are printed below the passage and against each some words are suggested . Find out the word that best fit the blank spaces. Global Strategies to control infective disease have historically included the erection of barriers to international travel and ___ (24) _______. Keeping people with such deadly disease outside national borders has ___ (25) _______ as an important public health policy in the human immunodeficiency virus (HIV) epidemic . Betwwn 29 and 50 countries ___ (26) _____ to have introduced border restrictions on HIV _ positive foreigners ,usually those planning an ___ (27) ___ stay in the country , such as students , workers or seamen.
A migration
B immigrate
C emigration
D immigration
You have linked SQL*Plus to an external text editor. To invoke the text editor for use within SQL*Plus, which command do you use?
A Open
B Show
C Alter
D Edit
SQL provides the AS keyword, which can be used to assign meaningful column names to the results of queries using the SQL built-in functions.
A True
B False
In SQL, which command is used to SELECT only one copy of each set of duplicable rows
A SELECT DISTINCT
B SELECT UNIQUE
C SELECT DIFFERENT
D All of the Mentioned
In SQL, which command is used to add new rows to a table?
A Alter Table
B Add row
C Insert
D Append
In SQL, which command is used to make permanent changes made by statements issue since the beginning of a transaction?
A ZIP
B PACK
C COMMIT
D SAVE
E None of the above
What SQL command can be used to delete columns from a table?
A MODIFY TABLE TableName DROP ColumnName
B MODIFY TABLE TableName DROP COLUMN ColumnName
C ALTER TABLE TableName DROP ColumnName
D ALTER TABLE TableName DROP COLUMN ColumnName
What SQL command can be used to add columns to a table?
A ALTER TABLE TableName ADD ColumnName
B ALTER TABLE TableName ADD COLUMN ColumnName
C MODIFY TABLE TableName ADD ColumnName
D MODIFY TABLE TableName ADD COLUMN ColumnName

Next steps