logo

CuriousTab

CuriousTab

Discussion


Home Technical Questions Database Comments

  • Question
  • Which of the following is the original purpose of SQL?


  • Options
  • A. To specify the syntax and semantics of SQL data definition language
  • B. To specify the syntax and semantics of SQL manipulation language
  • C. To define the data structures
  • D. All of the above.

  • Correct Answer
  • All of the above. 

    Explanation

    SQL is a domain-specific language used in programming and designed for managing data held in a relational database management system, or for stream processing in a relational data stream management system.

     

    Purpose of SQL are ::

    * To define the data structures

    * To specify the syntax and semantics of SQL manipulation language

    * To specify the syntax and semantics of SQL data definition language

  • Tags: Analyst, Database Administrator, IT Trainer

    Database problems


    Search Results


    • 1. ________ is an open source DBMS product that runs on UNIX, Linux and Windows.

    • Options
    • A. MySQL
    • B. JSP/SQL
    • C. JDBC/SQL
    • D. Sun ACCESS
    • Discuss
    • 2. A goal of data mining includes which of the following?

    • Options
    • A. To explain some observed event or condition
    • B. To analyze data for expected relationships
    • C. To confirm that data exists
    • D. To create a new data warehouse
    • Discuss
    • 3. A DBMS that combines a DBMS and an application generator is ________ .

    • Options
    • A. Microsoft's SQL Server
    • B. Microsoft's Access
    • C. IBM's DB2
    • D. Oracle Corporation's Oracle
    • Discuss
    • 4. ON UPDATE CASCADE ensures which of the following?

    • Options
    • A. Normalization
    • B. Data Integrity
    • C. Materialized Views
    • D. All of the above.
    • Discuss
    • 5. If no multivalued attributes exist and no partial dependencies exist in a relation, then the relation is in what normal form?

    • Options
    • A. First normal form
    • B. Second normal form
    • C. Third normal form
    • D. Fourth normal form
    • Discuss
    • 6. For what purposes are views used?

    • Options
    • A. To hide rows only
    • B. To hide columns only
    • C. To hide complicated SQL statements only
    • D. All of the above are uses for SQL views.
    • Discuss
    • 7. What are the notations used in Evaluation of Arithmetic Expressions using prefix and postfix forms?

    • Options
    • A. Polish
    • B. Reverse Polish
    • C. Both A and B
    • D. None of the above
    • Discuss
    • 8. The different classes of relations created by the technique for preventing modification anomalies are called:

    • Options
    • A. normal forms.
    • B. functional dependencies.
    • C. referential integrity constraints.
    • D. None of the above is correct.
    • Discuss
    • 9. The following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T ;

    • Options
    • A. Equi-join
    • B. Natural join
    • C. Outer join
    • D. Cartesian join
    • Discuss


    Comments

    There are no comments.

Enter a new Comment