Data Manipulation Language (DML)

DML...
View Complete Description
×

Topic Summary

DML Statements and Examples
38
Questions
Question Type Legends

Easy

Medium

Difficult

Multiple Choice Questions for Data Manipulation Language (DML)

  • 1 Which of the following keyword is used while replacing the values of the column.
    1. Set
    2. Alter
    3. Edit
    4. Sets

  • 2 To remove the record of an employee with id 0333 the SQL query will be: "_____ * From Employee where id="0333"; "
    1. DELETE
    2. Query has issue
    3. DELETE ALL
    4. None

  • 3 Complete this query: "UPDATE Employee ______ Name=[Ali] Where Name _____ [%Ali%]; "
    1. SETS, =
    2. SET, LIKE
    3. LIKE, SET
    4. EDIT, LIKE

  • 4 Which of the following is used to create a complex predicate (condition(s)) in SQL Query?
    1. >, <, =, >=, <>, <=
    2. AND, OR, NOT
    3. Both a & b
    4. None

  • 5 How to make it sure that a column will accept only unique value?
    1. Make it Primary Key
    2. Append column with UNIQUE
    3. Use UNIQUE anywhere after column name
    4. All of Above

  • 6 A column have data type as "Date", which of the following value will not be accepted by the column?
    1. 12-15-2016
    2. 15-12-2016
    3. 12/15/2015
    4. 12/3/2015

  • 7 In SQL, which of the following is not a data Manipulation Language Commands?
    1. Delete
    2. Truncate
    3. Update
    4. Create

  • 8 Which SQL keyword is used to retrieve only unique values?
    1. DINSTINCT
    2. INSERT
    3. ADD
    4. MOVE

  • 9 The sql statement “ Insert into studentsTable ( name, age) values ( ‘ Ali ’ ) ”, contains error. Which one best option of the following can be applied to remove the error, and to save the value(s) in studentsTable?
    1. Remove age field
    2. Add value of age in values
    3. Both of above
    4. None of above

  • 10 If a doctor has one or more specializations which type of attribute is needed to store data of specializations of a single doctor?
    1. Simple attribute
    2. Composite attribute
    3. Multi-valued attribute
    4. Derived attribute

  • 11 To display data from four tables which have linked records through primary key and foreign key relationships in the database, what exact number of join conditions are needed in the query?
    1. 4 join conditions
    2. 3 join conditions
    3. 2 join conditions
    4. None of above

  • 12 A Null value can be:
    1. An exceptional data
    2. Currently unknown value
    3. Not applicable value for the current field
    4. All of above

  • 13 Which SQL statement is used to insert new data in a database?
    1. INSERT NEW
    2. INSERT IN
    3. INSERT INTO
    4. INSERT TO

  • 14 Which of the following strategy of existence constraints ensure that all child records will also be deleted if the parent record is deleted?
    1. CASCADE
    2. SET NULL
    3. SET DEFAULT
    4. NO CHECK

Contact Us

support@subexpert.com
Write to Us View Help
Subject Expert Logo

Subject Expert

Learn and Evaluate

Follow Us
© 2020 - Subject Expert