Similar Collections

    No collections found

questions

Title
Types of SQL Commands are –

Types of SQL Commands are –

  1. DDL
  2. DML
  3. DCL
  4. All of the above
discuss
Full form of DDL is –

Full form of DDL is –

  1. Data Describe Language
  2. Definition Data Language
  3. Data Definition Language
  4. Data Distinct Language
discuss
Commands that comes under DDL is/are –

Commands that comes under DDL is/are –

  1. CREATE
  2. DROP
  3. TRUNCATE
  4. All of the above
discuss
Full form of DML is –

Full form of DML is –

  1. Data Multiplication Language
  2. Data Manipulation Language
  3. Data Modify Language
  4. Data Mapping Language
discuss
Which of the following is/are TRUE about DDL command?

Which of the following is/are TRUE about DDL command?

  1. Our data is stored in a table that is described by the schema, thus DDL commands deal with the schema.
  2. With the DDL commands, any structural changes can be made to the table, including creation, deletion, and alteration.
  3. Both A. and B.
  4. None of the above
discuss
Command that comes under DML is/are –

Command that comes under DML is/are –

  1. ROLLBACK
  2. GRANT
  3. UPDATE
  4. All of the above
discuss
Select the correct statement

Select the correct statement.

  1. With the DDL commands, any structural changes can be made to the table, including creation, deletion, and alteration.
  2. With the DML commands, any structural changes can be made to the table, including creation, deletion, and alteration.
  3. With the DCL commands, any structural changes can be made to the table, including creation, deletion, and alteration.
  4. With the TCL commands, any structural changes can be made to the table, including creation, deletion, and alteration.
discuss
Full form of DCL is -

Full form of DCL is -

  1. Data Control Language
  2. Data Commit Language
  3. Data Common Language
  4. Data Concatenate Language
discuss
Command that comes under DCL is/are -

Command that comes under DCL is/are -

  1. GRANT
  2. REVOKE
  3. Both A. and B.
  4. None of the above
discuss
Full form of TCL is -

Full form of TCL is -

  1. Transaction Common Language
  2. Transaction Commit Language
  3. Transaction Concatenate Language
  4. Transaction Control Language
discuss
Commands that come under TCL is/are -

Commands that come under TCL is/are -

  1. COMMIT
  2. ROLLBACK
  3. SAVEPOINT
  4. All of the above
discuss
What is TRUE about SAVEPOINT?

What is TRUE about SAVEPOINT?

  1. Following the completion of a transaction, it must be executed to save all the operations performed in the transaction.
  2. A transaction can be rolled back to its last saved state.
  3. A specific part of a transaction can be given a name
  4. None of the above
discuss
Following the completion of a transaction, it must be executed to save all the operations performed in the transaction. Here we are talking about which command?

Following the completion of a transaction, it must be executed to save all the operations performed in the transaction. Here we are talking about which command?

  1. REVOKE
  2. COMMIT
  3. ROLLBACK
  4. SAVE
discuss
Difference between GRAND & REVOKE command is/are?

Difference between GRAND & REVOKE command is/are?

  1. The GRANT command can be used to grant a user access to databases and tables whereas The REVOKE command can be used to revoke all access privileges already assigned to the user.
  2. The REVOKE command can be used to grant a user access to databases and tables whereas The GRANT command can be used to revoke all access privileges already assigned to the user.
  3. A transaction can be rolled back to its last saved state.
  4. None of the above
discuss
Which of the following statement(s) is/are TRUE about DCL?

Which of the following statement(s) is/are TRUE about DCL?

  1. The DCL commands in SQL allow us to control which users have access to the data stored in SQL tables.
  2. There will be certain privileges that each user has; consequently, the data can be accessed by them.
  3. The DCL commands in SQL allow us to grant privileges to a user on the SQL database and its table(s), or revoke privileges that have already been granted.
  4. All of the above
discuss
The table records can be retrieved using which command?

The table records can be retrieved using which command?

  1. RETRIEVE
  2. SELECT
  3. CREATE
  4. ALTER
discuss
Which command will remove the records from the table, but not affect the structure of the table?

Which command will remove the records from the table, but not affect the structure of the table?

  1. REMOVE
  2. DELETE
  3. DROP
  4. TRUNCATE
discuss
The records and structure of a table may be removed or deleted from the database using which command?

The records and structure of a table may be removed or deleted from the database using which command?

  1. REMOVE
  2. DELETE
  3. DROP
  4. TRUNCATE
discuss
Select the correct statement

Select the correct statement.

  1. DDL consist of 4 commands
  2. DCL consist of 2 commands
  3. TCL consist of 5 commands
  4. DML consist of 3 commands
discuss
Which of the following is TRUE about TCL?

Which of the following is TRUE about TCL?

  1. Transactions can be saved to the database and rolled back with the help of TCL commands in SQL.
  2. There will be certain privileges that each user has; consequently, the data can be accessed by them using TCL.
  3. Our data is stored in a table that is described by the schema, thus TCL commands deal with the schema.
  4. SQL TCL commands can be used to perform any kind of retrieval or manipulation of the data present in SQL tables.
discuss
total MCQs: 20

MCQs

20

Views

127

Best Answers

299

Points

5