MCQ | SQL – Auto Increment, Like, Commit and Rollback

by karimhani25
83
10

Sql programming

questions

Title
Which of the following is TRUE about SQL Auto Increment? Which of the following is TRUE about SQL Auto Increment? It increments the unique number automatically. It decrements the unique number automatically. It keeps the unique number constant None of the above discuss The answer is: A. It increments the unique number automatically.
Which of the following is the feature(s) of SQL Auto Increment? Which of the following is the feature(s) of SQL Auto Increment? In some cases you may not have any unique identifying characteristics in data; therefore, it makes sense to create a Primary Key. Explicitly initializing and modifying the auto-increment value is possible at any time. Record identifiers can easily be created that are unique to each record. All of the above discuss The answer is: D. All of the above
Which keyword is used in SQL Server to implement the auto increment? Which keyword is used in SQL Server to implement the auto increment? UNIQUE IDENTITY INCREMENT ADD discuss The answer is: B. IDENTITY
In SQL, Like is a __________operator In SQL, Like is a __________operator. Relational Logical Additional Unique discuss The answer is: B. Logical
SQL Like is NOT used with which of the following statement(s)? SQL Like is NOT used with which of the following statement(s)? DELETE SELECT UPDATE ALTER discuss The answer is: D. ALTER
The character(s) which are used independently or in conjunction with SQL Like Operator: The character(s) which are used independently or in conjunction with SQL Like Operator: % _ Both A. and B. None of the above discuss The answer is: C. Both A. and B.
Which of the following is/are transaction control commands in SQL? Which of the following is/are transaction control commands in SQL? Commit Rollback Both A. and B. None of the above discuss The answer is: C. Both A. and B.
A single unit of work for all commands executed consecutively is known as- A single unit of work for all commands executed consecutively is known as- Transaction Commit ROLLBACK Control discuss The answer is: A. Transaction
To get the table's previous permanent status, use the ____ command To get the table's previous permanent status, use the ____ command. COMMIT Transaction Rollback None of the above discuss The answer is: C. Rollback
In order to start the transaction, the command used is – In order to start the transaction, the command used is – Mysql > START COMMIT; Mysql > START TRANSACTION; Mysql > START ROLLBACK; None of the above discuss The answer is: B. Mysql > START TRANSACTION;

total MCQs: 10

MCQs

10

Views

83

Best Answers

299

Points

5