What is the special operator used to check whether an attribute value is within a range of values?

107 Questions  |  By Hai8179119111 | Last updated: Mar 21, 2022 | Total Attempts: 550

Feedback

During the Quiz End of Quiz

Difficulty

Sequential Easy First Hard First

.

• 1. 

  A database language enables the user to perform complex queries designed to transform the raw data into useful information.

  • A. 

    True

  • B. 

    False

• 2. 

  SQL is considered difficult to learn; its command set has a vocabulary of more than 300 words

  • A. 

    True

  • B. 

    False

• 3. 

  The COMMIT command does not permanently save all changes. In order to do that, you must use SAVE.

  • A. 

    True

  • B. 

    False

• 4. 

  All SQL commands must be issued on a single line.

  • A. 

    True

  • B. 

    False

• 5. 

  Although SQL commands can be grouped together on a single line, complex command sequences are best shown on separate lines, with space between the SQL command and the command’s components.

  • A. 

    True

  • B. 

    False

• 6. 

  An alias cannot be used when a table is required to be joined to itself in a recursive query.

  • A. 

    True

  • B. 

    False

• 7. 

  Comparison operators cannot be used to place restrictions on character-based attributes.

  • A. 

    True

  • B. 

    False

• 8. 

  11. String comparisons are made from left to right.

  • A. 

    True

  • B. 

    False

• 9. 

  13. SQL allows the use of logical restrictions on its inquiries such as OR, AND, and NOT.

  • A. 

    True

  • B. 

    False

• 10. 

  14. You cannot insert a row containing a null attribute value using SQL.

  • A. 

    True

  • B. 

    False

• 11. 

  16. The conditional LIKE must be used in conjunction with wildcard characters.

  • A. 

    True

  • B. 

    False

  • C. 

    Option 3

  • D. 

    Option 4

• 12. 

  19. The COUNT function is designed to tally the number of non-null "values" of an attribute, and is often used in conjunction with the DISTINCT clause.

  • A. 

    True

  • B. 

    False

  • C. 

    Option 3

  • D. 

    Option 4

• 13. 

  21. The SQL data manipulation command HAVING:

  • A. 

    restricts the selection of rows based on a conditional expression.

  • B. 

    restricts the selection of grouped rows based on a condition.

  • C. 

    modifies an attribute’s values in one or more table’s rows.

  • D. 

    groups the selected rows based on one or more attributes.

• 14. 

  22. The SQL command that allows a user to permanently save data changes is _____.

  • A. 

    INSERT

  • B. 

    SELECT

  • C. 

    COMMIT

  • D. 

    UPDATE

• 15. 

  23. The _____ command defines a default value for a column when no value is given.

  • A. 

    CHECK

  • B. 

    UNIQUE

  • C. 

    NOT NULL

  • D. 

    DEFAULT

• 16. 

  24. The _____ command restricts the selection of grouped rows based on a condition.

  • A. 

    DISPLAY

  • B. 

    HAVING

  • C. 

    FROM

  • D. 

    CONVERT

• 17. 

  25. A(n) _____ query specifies which data should be retrieved and how it should be filtered, aggregated, and displayed.

  • A. 

    INSERT

  • B. 

    SELECT

  • C. 

    COMMIT

  • D. 

    UPDATE

• 18. 

  26. A(n) _____ is an alternate name given to a column or table in any SQL statement.

  • A. 

    alias

  • B. 

    data type

  • C. 

    stored function

  • D. 

    trigger

• 19. 

  30. A(n) _____ join will select only the rows with matching values in the common attribute(s).

  • A. 

    Natural

  • B. 

    Outer

  • C. 

    Full

  • D. 

    Cross

• 20. 

  36. Which comparison operator indicates a value is not equal?

  • A. 

    <

  • B. 

    <=

  • C. 

    >=

  • D. 

    <>

• 21. 

  38. The special operator used to check whether an attribute value is within a range of values is _____.

  • A. 

    BETWEEN

  • B. 

    IS NULL

  • C. 

    LIKE 

  • D. 

    IN

• 22. 

  39. The special operator used to check whether an attribute value ro string pattern is _____.

  • A. 

    BETWEEN

  • B. 

    IS NULL

  • C. 

    LIKE

  • D. 

    IN

• 23. 

  40. The SQL aggregate function that gives the number of rows containing non-null values for a given column is _____.

  • A. 

    COUNT

  • B. 

    MIN

  • C. 

    MAX

  • D. 

    SUM

• 24. 

  41. A(n) _____ is a query that is embedded (or nested) inside another query.

  • A. 

    Alias

  • B. 

    operator

  • C. 

    Subquery

  • D. 

    View

• 25. 

  43. The special operator used to check whether a subquery returns any rows is _____.

  • A. 

    BETWEEN

  • B. 

    EXISTS

  • C. 

    LIKE

  • D. 

    IN

Below is a Relational Database Trivia Quiz! It is designed to help you understand how databases holding the same information are structured and maintained. Do you think that you have what it takes to tackle it based on what you...

Questions: 9  |  Attempts: 8715   |  Last updated: Mar 21, 2022

• Sample Question

  Which of the following makes it possible for entities toshare a relationship?

  Multi-valued attributes

  A foreign key

  A common attribute

  The same number of attributes

Ever wondered how much you know about DBMS, or the Database Management System? For this quiz, you should know what is responsible for authorizing access to the databases and obtaining software and hardware services, what is a...

Questions: 31  |  Attempts: 7781   |  Last updated: Mar 22, 2022

• Sample Question

  -------------------------------responsible for authorizing access to the database, for coordinating and monitoring its use, acquiring software, and hardware resources, controlling its use, andmonitoring efficiency of operations.

  Authorization Manager

  Storage Manager

  File Manager

  Transcation Manager

  Buffer Manager

Below is an important trivia quiz on the database. As a programmer or software developer, you need to know the basics surrounding databases, their creation, maintenance, and management. Take up this quiz and get to learn more...

Questions: 15  |  Attempts: 7694   |  Last updated: May 1, 2022

• Sample Question

  The Yellow Pages is an example of a paper-based database. True or false?

  True

  False

More Database Quizzes

• Binary Code Quizzes
• Computer Concept Quizzes
• Computer Essential Quizzes
• Computer Forensics Quizzes
• Computer Hardware Quizzes
• Computer Networking Quizzes
• Computer Parts Quizzes
• Computer Programming Quizzes
• Computer Science Quizzes
• Computer Security Quizzes
• Computer Shortcut Key Quizzes
• Computer Skills Quizzes
• Computer Virus Quizzes
• Cyber Security Quizzes
• Data Quizzes
• Data Security Quizzes
• Hacking Quizzes
• Hci Quizzes
• Internet Quizzes
• It Security Quizzes
• Malware Quizzes
• Microprocessor Quizzes
• Network Quizzes
• Operating System Quizzes
• Phishing Quizzes
• Programming Language Quizzes
• Server Quizzes
• Software Quizzes

+ Show more

What is the special operator used to check if an attribute is in a range?

What is the special operator used to check whether a subquery returns any rows?

Which comparison operator indicates a value is not equal?

Which command is used to restore the table's contents to their previous values?