1. Question: Which of the following is not a SQL operator?

    A
    Between..and..

    B
    Like

    C
    In

    D
    Is null

    E
    Having

    F
    Not in

    Note: Not available
    1. Report
  2. Question: Which of the following is not a feature of SQL?

    A
    SQL is a non-procedural language

    B
    SQL processes sets of records rather than a single record at a time

    C
    SQL can be used by a range of users including DBA's, application programmers, management personnel and many other types of end users

    D
    Procedures and functions can be written with SQL

    E
    SQL provides commands for a variety of tasks including querying data and inserting, updating and deleting data

    F
    SQL can retrieve data from more than one table

    Note: Not available
    1. Report
  3. Question: How can data be accessed by users who do not have direct access to the tables?

    A
    By creating views

    B
    By creating triggers

    C
    By creating stored procedures

    D
    None of these above

    Note: Not available
    1. Report
  4. Question: The simplest query must include at least________ and _________.

    A
    A select clause

    B
    A where clause

    C
    A from clause

    D
    A group by clause

    E
    A having clause

    F
    An order by clause

    Note: Not available
    1. Report
  5. Question: Every Boyce-Codd Normal Form(BCNF)is in:

    A
    First Normal Form

    B
    Second Normal Form

    C
    Third Normal Form

    D
    None of the above

    Note: Not available
    1. Report
  6. Question: Identify the incorrect statement/s regarding constraints.

    A
    A primary key constraint can be disabled

    B
    Information about the constraints on a table can be retrieved from the data dictionary

    C
    Information about the columns on which the constraints have been applied can be retrieved from the data dictionary

    D
    There can be only one unique key in a table

    E
    If a column has null values then the not null constraint cannot be applied to that column

    F
    There can be more than one primary key

    Note: Not available
    1. Report
  7. Question: Which of the following is not the benefits of views?

    A
    Restricting access to database

    B
    Allowing users to make simple queries to retrieve the results from complicated queries

    C
    Providing data independence for adhoc users and application programs

    D
    Faster retrieval of records

    E
    Views allow the same data to be seen by different users in different ways

    Note: Not available
    1. Report
  8. Question: _________ is the operation that displays certain columns from the table.

    A
    Restriction

    B
    Intersection

    C
    Join

    D
    Union

    E
    Projection

    F
    Selection

    G
    Extraction

    H
    SubQuery

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