Question
a.
to create a place in the database for storage of scheme objects, rollback segments, and naming the data files to comprise the tablespace
b.
to create a database trigger
c.
to add/rename data files, to change storage
d.
All of the above
Posted under DBMS
Engage with the Community - Add Your Comment
Confused About the Answer? Ask for Details Here.
Know the Explanation? Add it Here.
Q. In SQL, the CREATE TABLESPACE is used
Similar Questions
Discover Related MCQs
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
Q. In SQL, which command(s) is(are) used to recompile a stored function?
View solution
Q. Report generators are used to
View solution
Q. In SQL, which command(s) is(are) used to change a table's storage characteristics?
View solution
Q. In SQL, which of the following is not a data definition language commands?
View solution
Q. In SQL, which command(s) is(are) used to issue multiple CREATE TABLE, CREATE VIEW, and GRANT statements in a single transaction?
View solution
Q. With which type of SQL Server recovery model are all database changes logged except those that cause large log entries?
View solution
Q. Using SQL Server 2000, which of the following symbols is used to indicate parameters in stored procedures?
View solution
Q. What mode of authentication does SQL Server NOT provide?
View solution
Q. The strictest transaction isolation level provided by SQL Server is called:
View solution
Q. SQL Server program code that is executed instead of an SQL command that needs to be processed is called a(n):
View solution
Q. Which type of SQL Server cursor concurrency places an update lock on a row when the row is read?
View solution
Q. Which of the three possible types of triggers does SQL Server support?
View solution
Q. Which of the following is a way to create and modify tables using SQL Server?
View solution
Q. With which type of SQL Server recovery model, is no logging done?
View solution
Q. SQL Server 2000 stored procedures can:
View solution
Q. With this type of SQL Server cursor concurrency no lock is obtained until the user updates the data.
View solution
Q. An SQL Server 2000 language that adds programming elements like parameters, variables, IF, WHILE loops, and so forth, to the basic capabilities of SQL is called:
View solution
Suggested Topics
Are you eager to expand your knowledge beyond DBMS? We've curated a selection of related categories that you might find intriguing.
Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!
Software Engineering
Learn about the systematic approach to developing software with our Software...
Operating System
Dive deep into the core of computers with our Operating System MCQs. Learn about...
