SQL
 

  1. 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

  2. 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

  3. 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

  4. 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

  5. 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

  6. 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

  7. 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

  8. 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

  9. Question: If E1 and E2 are relational algebra expressions, then which of the following is NOT a relational algebra expression?

    A
    E1 U E2

    B
    E1 / E2

    C
    E1 - E2

    D
    E1 x E2

    Note: Not available
    1. Report

  10. Question: Which one of the following correctly selects rows from the table myTable that have null in column column1?

    A
    SELECT * FROM myTable WHERE column1 is null

    B
    SELECT * FROM myTable WHERE column1 = null

    C
    SELECT * FROM myTable WHERE column1 EQUALS null

    D
    SELECT * FROM myTable WHERE column1 NOT null

    E
    SELECT * FROM myTable WHERE column1 CONTAINS null

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