gs gs117 Transactions - Transactions as SQL Statements - Quiz No.1
gs gs117 Database Management System Quiz
This quiz belongs to book/course code gs gs117 Database Management System of gs organization. We have 92 quizzes available related to the book/course Database Management System. This quiz has a total of 10 multiple choice questions (MCQs) to prepare and belongs to topic Transactions. NVAEducation wants its users to help them learn in an easy way. For that purpose, you are free to prepare online MCQs and quizzes.
NVAEducation also facilitates users to contribute in online competitions with other students to make a challenging situation to learn in a creative way. You can create one to one, and group competition on an topic of a book/course code. Also on NVAEducation you can get certifications by passing the online quiz test.
Question 1: Which of the following is a property of transactions?
Atomicity
Concurrency
Isolation
All of the mentioned
Question 2: SNAPSHOT is used for (DBA)
Synonym
Tablespace
System server
Dynamic data replication
Question 3: Isolation of the transactions is ensured by
Transaction management
Application programmer
Concurrency control
Recovery management
Question 4: Constraint checking can be disabled in existing _______________ and _____________ constraints so that any data you modify or add to the table is not checked against the constraint.
CHECK, FOREIGN KEY
DELETE, FOREIGN KEY
CHECK, PRIMARY KEY
PRIMARY KEY, FOREIGN KEY
Question 5: Problems occurs if we don’t implement a proper locking strategy
Dirty reads or Unrepeatable reads
Phantom reads
Lost updates
All of the mentioned
Question 6: Which of the following fixed database roles can add or remove user IDs?
db_accessadmin
db_securityadmin
db_setupadmin
db_sysadmin
Question 7: By default sql server has ___________ isolation level
READ COMMITTED
READ UNCOMMITTED
SERIALIZABLE
REPEATABLE READ
Question 8: Which of the following statements is/are not true for SQL profiler?
Enables you to monitor events
Check if rows are being inserted properly
Check the performance of a stored procedure
ALL of the mentioned
Question 9: Which of the following is the original purpose of SQL?
To specify the syntax and semantics of SQL data definition language
To specify the syntax and semantics of SQL manipulation language
To define the data structures
All of the mentioned
Question 10: SQL can be used to:
Create database structures only
Query database data only
Modify database data only
All of the mentioned
Online Quizzes of gs117 Database Management System
Indexing and Hashing - Bitmap Indices - Quiz No.1
gs gs117
Database Management System Online Quizzes
