Related Questions

Which command is used to remove an index from the database in SQL?
A DELETE INDEX
B DROP INDEX
C REMOVE INDEX
D ROLL BACK INDEX
E None of the above
Which command is used to remove a table from the database in SQL?
A DELETE TABLE
B DROP TABLE
C ERASE TABLE
D UNATTACH TABLE
E None of the above
In an enterprise-class database system, business users interact directly with database applications, which directly access the database data.
A True
B False
In an Enterprise-class database system, business users interact directly with database applications that interact with the DBMS, which directly accesses the database data.
A True
B False
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
In SQL, which command(s) is(are) used to enable/disable a database trigger?
A MODIFY USER
B CHANGE USER
C ALTER TRIGGER
D All of the above
E None of the above
In SQL, which command is used to create a database user?
A ADD USER TO DATABASE
B MK USER
C CREATE USER
D All of the above
E None of the above
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
To remove duplicate rows from the results of an SQL SELECT statement , the __ qualifier specified must be included.
A ONLY
B DISTINCT
C UNIQUE
D SINGLE
Read the paragraph and answer the question-photosynthesis is a process in which radiant energy from sun is stored as chemical energy , which in turn is used to decompose carbon dioxide and water. The product of their decomposition are recombined into a new compound which successively builds, up into more and more complex organic substances like sugars, starches and cellulose that comprise the plant.The word stored in the paragraph is closest in morning to
A specified
B retained
C converted
D discovered

Next steps