logo

CuriousTab

CuriousTab

Discussion


Home Technical Questions Database Comments

  • Question
  • 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

  • Correct Answer
  • Second normal form 


  • Database problems


    Search Results


    • 1. 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.
    • Discuss
    • 2. ________ 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
    • 3. 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
    • 4. 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
    • 5. ON UPDATE CASCADE ensures which of the following?

    • Options
    • A. Normalization
    • B. Data Integrity
    • C. Materialized Views
    • D. All of the above.
    • 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
    • 10. 88%of 370 +24% of 210-x =118 find x
    • Discuss


    Comments

    There are no comments.

Enter a new Comment