Skip to main content

Posts

Showing posts with the label SQL Test upwork answers

SQL Test Upwork Answers 2019

1. Which are not DCL operations? Answers:   • Insert • Grant • Delete • Update • Revoke • Commit • Rollback 2. Which of the following is not a DML command? Answers:   • Set transaction • Explain plan • Update • Grant • Insert • Create • Alter • Revoke 3. Which of the following is not a DDL command? Answers:   • Drop • Create • Alter • Revoke • Explain plan • Insert • Update • Delete 4. Which of the following statements are not true regarding the primary key? Answers:   • There can only be one primary key in a table • An index is automatically generated upon creation of a primary key • A primary key can accept null values • A primary key can be composite • A primary key constraint can be either at the column level or at the table level • There can be more than one primary key in a table 5. Which of the following statements are wrong about primary keys? Answers:   • The pri...