DML

  1. Question: Why we can use LIKE commands?

    A
    To connect data

    B
    To conjunction data

    C
     To looking data

    D
    Matching data

    Note: Not available
    1. Report

  2. Question: Views enable database administrators to limit access to database tables to only the data that is intended to be used.

    A
    True

    B
    False

    Note: Not available
    1. Report

  3. Question: To Displaying Results Vertically

    A
    mysql>select * from (db name)\G

    B
    mysql>select * from (db name)\G;

    C
    mysql>select * from (db name)\g

    D
    mysql>select * from (db name)\g;

    Note: Not available
    1. Report

  4. Question: To determine which engines are available to your MySQL server, we execute the command as mysql> ______ ;

    A
    show engines

    Note: Not available
    1. Report

  5. Question: What is the proper syntax used to insert data into a table?

    A
    INSERT INTO tablename VALUES ();

    B
    INSERT VALUES () INTO tablename ();

    C
    INSERT VALUES () INTO tablename;

    D
    INSERT INTO tablename () VALUES ();

    Note: Not available
    1. Report

  6. Question: Which of the following syntax examples will cause an error?

    A
    SELECT column1, column2, column2 FROM tablename;

    B
    SELECT * FROM tablename WHERE columnname LIKE '%keyword%';

    C
    SELECT * FROM tablename WHERE column1 LIKE 'keyword' AND column2 LIKE 'keyword';

    D
    SELECT DISTINCT column1 FROM tablename ORDER BY column1;

    E
    SELECT * FROM pets COUNT(*);

    Note: Not available
    1. Report

  7. Question: What three things need to be specified during an UPDATE statement?

    A
    Database & Table, row

    B
    Database, Column & New Update

    C
    Table, Column & New Data

    Note: Not available
    1. Report

  8. Question: Which SQL statement is used to update data in a database?

    A
    MODIFY

    B
    SAVE AS

    C
    UPDATE

    D
    SAVE

    Note: Not available
    1. Report

  9. Question: Which SQL statement is used to delete data from a database?

    A
    DELETE

    B
    REMOVE

    C
    COLLAPSE

    Note: Not available
    1. Report

  10. Question: Can I define multiple unique constraints on a table?

    A
    Yes

    B
    No

    Note: Not available
    1. Report
First12Last
/2
Copyright © 2024. Powered by Intellect Software Ltd