Databases - Upwork
 

  1. Question: Which of the following statements are true?

    A
    With DDL you can create and remove tables, schemas, domains, indexes and views

    B
    Select, Insert and Update are DCL commands

    C
    Grant and Revoke are DML commands

    D
    Commit and Rollback are DCL commands

    Note: Not available
    1. Report

  2. Question: Which logical operator can reverse the result?

    A
    AND

    B
    OR

    C
    NOT

    D
    ANY

    Note: Not available
    1. Report

  3. Question: What is the collection of information stored in a database at a particular moment called?

    A
    Schema

    B
    Instance

    C
    Table

    D
    Cluster

    E
    View

    F
    Index

    G
    None of these above

    Note: Not available
    1. Report

  4. Question: What is the order of precedence among the following operators? 1 IN 2 NOT 3 AND 4 OR

    A
    1,2,3,4

    B
    2,3,4,1

    C
    1,2,4,3

    D
    1,4,3,2

    E
    4,3,2,1

    F
    4,1,2,3

    G
    4,2,1,3

    H
    3,2,1,4

    Note: Not available
    1. Report

  5. Question: Which of the following date function(s) are invalid in Oracle SQL?

    A
    NEXT_DAY

    B
    NEXT_MONTH

    C
    MONTHS_BETWEEN

    D
    DAYS_BETWEEN

    Note: Not available
    1. Report

  6. Question: Which of the following are aggregate functions in SQL?

    A
    Avg

    B
    Select

    C
    Order By

    D
    Sum

    E
    Union

    F
    Group by

    G
    Having

    Note: Not available
    1. Report

  7. Question: Which of the following is not a relational operation?

    A
    Restriction

    B
    Extraction

    C
    Projection

    D
    Intersection

    E
    Union

    Note: Not available
    1. Report

  8. Question: The level of abstraction which describes only part of the entire database is called?

    A
    Conceptual level

    B
    View level

    C
    Procedural level

    D
    None of these above

    Note: Not available
    1. Report

  9. Question: Consider the following tables:
    Books
    BookId
    BookName
    AuthorId
    SubjectId
    PopularityRating
    Language
    (the popularity of the book on a scale of 1 to 10) (Language such as French, English, German etc)
    Subjects
    SubjectId
    Subject
    (such as History, Geography, Mathematics etc)
    Authors
    AuthorId
    AuthorName
    Country
    What is the query to determine how many books, with a popularity rating of more than 7, have been written on each subject?

    A
    select subject,count(*) as Books from books,subjects where books.popularityrating > 7 group by subjects.subject

    B
    select subject,count(*) as Books from books,subjects where books. authorid=subjects. authorid and books. popularityrating > 7 group by subjects.subject

    C
    select subject,count(*) as Books from books,subjects where books.subjectid=subjects.subjectid and books.popularityrating = 7 group by subjects.subject

    D
    select subject,count(*) as Books from books,subjects where books.subjectid=subjects.subjectid and books.popularityrating > 7 group by subjects.subject

    Note: Not available
    1. Report

  10. Question: The overall logical structure of a database can be expressed graphically by:

    A
    Data Flow Chart

    B
    Flow Chart

    C
    Directed Chart

    D
    Entity-Relationship Diagram

    E
    None of these above

    Note: Not available
    1. Report
First3233343536Last
/90
Copyright © 2025. Powered by Intellect Software Ltd