Question
a.
Define, Create
b.
Drop, Comment
c.
Insert, Update, Delete
d.
Select, Commit
Posted under Transactions DBMS
Engage with the Community - Add Your Comment
Confused About the Answer? Ask for Details Here.
Know the Explanation? Add it Here.
Q. What are the different events in Triggers?
Similar Questions
Discover Related MCQs
Q. The SQL statement SELECT SUBSTR(‘123456789’, INSTR(‘abcabcabc’,’b’), 4) FROM EMP; prints
View solution
Q. Which of the following SQL command can be used to modify existing data in a database table?
View solution
Q. When SQL statements are embedded inside 3GL, we call such a program as
View solution
Q. _______________ provides option for entering SQL queries as execution time, rather than at the development stage.
View solution
Q. Each modification done in database transaction are first recorded into the
View solution
Q. _______ means that data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.
View solution
Q. Which of the following is not a state in transaction ?
View solution
Q. _______________ joins are SQL server default
View solution
Q. The ________________ is essentially used to search for patterns in target string.
View solution
Q. Which of the following is/are the Database server functions?
i) Data management ii) Transaction management
iii) Compile queries iv) Query optimization
View solution
Q. To delete a database ___________ command is used
View solution
Q. ____________ is a combination of two of more attributes used as a primary key
View solution
Q. Which of the following is not the function of client?
View solution
Q. ____________ is a special type of stored procedure that is automatically invoked whenever the data in the table is modified.
View solution
Q. ______________ requires that data should be made available to only authorized users.
View solution
Q. Some of the utilities of DBMS are _____________
i) Loading ii) Backup iii) File organization iv) Process Organization
View solution
Q. ____________ allows individual row operation to be performed on a given result set or on the generated by a selected by a selected statement.
View solution
Q. Which is essential a business problem not a data problem:
View solution
Q. Which is primarily the result of a thorough understanding of information about an enterprise:
View solution
Q. McFadden has defined normalization in his which book___________
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!
