logo

CuriousTab



Database (Technical Questions) Question and Answers-Page first

Database problems


  • 1. ON UPDATE CASCADE ensures which of the following?

  • Options
  • A. Normalization
  • B. Data Integrity
  • C. Materialized Views
  • D. All of the above.

  •           Discuss     

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

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

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

  • Tags: Analyst, Database Administrator, IT Trainer

  •           Discuss     

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

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

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

  • Tags: Database Administrator

  •           Discuss     

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

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


First 2 3 4 5 6 7 8 9