Q. Which of the following command(s) is(are) used to recompile a stored procedure in SQL?

View solution

Q. Which command(s) is(are) used to redefine a column of the table in SQL ?

View solution

Q. Which command(s) is(are) used to enable/disable/drop an integrity constraint in SQL?

View solution

Q. In SQL, the ALTER TABLESPACE command is used

View solution

Q. In SQL, which command(s) is(are) used to create a synonym for a schema object?

View solution

Q. In SQL, which of the following is not a data Manipulation Language Commands?

View solution

Q. In SQL, the CREATE VIEW command is used

View solution

Q. In SQL, which command is used to create a database user?

View solution

Q. In SQL, which command(s) is(are) used to redefine an index's future storage allocation

View solution

Q. In SQL, which command is used to select data in rows and column from one or more tables?

View solution

Q. The _____ command is used to allocates an extent for the table in SQL

View solution

Q. In SQL, the _____ command is used to recompile a view

View solution

Q. Which language has recently become the de-facto standard for interfacing application programs with relational database system?

View solution

Q. In SQL, the CREATE TABLE is used

View solution

Q. In SQL, which command is used to select only one copy of each set of duplicable rows

View solution

Q. Which command is used to select distinct subject (SUB) from the table (BOOK)?

View solution

Q. In SQL, the CREATE TABLESPACE is used

View solution

Q. In SQL, which command is used to remove a stored function from the database?

View solution

Q. A command that lets you change one or more fields in a record is

View solution

Q. In SQL, the command(s) is(are) used to create an index for a table or cluster

View solution