← Back to exam page

98-364 – Database Fundamentals

Loading demo links...

Showing 4–6 of 15 questions

Question 4

You work as a Database Designer for Tritech Inc.

You are designing a table named Info.

The table contains the following attributes:

Login and Password

Name

ContactNumber Address

Each new employee joining the company is assigned an E-mail Login and Password.

This E-mail Login and Password is used by each employee to access his account on the company’s Web site.

The value of both the attributes should be unique and cannot be NULL.

You design an artificial key EmpID in the Info table to serve as a primary key.

Which of the following factors lead you to define an artificial key for use as a primary key in the Info table? Each correct answer represents a part of the solution. (Choose all that apply.)

Select all that apply, then click Submit answer.

  • ○

    The value of the primary key cannot be NULL.
  • ○

    The value of the primary key must be persistent.
  • ○

    The natural key contains highly sensitive data
  • ○

    The value of the primary key must be unique.
Question 5

You are a Database Administrator of MySQL database.

Few days back, your server crashed. Now, it is up and online.

You need to check the integrity of various tables used in the database.

You need to issue the CHECK TABLE command.

For which of the following tables will this command work? Each correct answer represents a complete solution. (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    FEDERATED
  • ○

    MyISAM
  • ○

    MERGE
  • ○

    InnoDB
Question 6

Remo works as a Database Designer for Tech Inc.

He wants to create a table named Product.

He issues the following query to create the Product table:

CREATE Product (

ProductID Char (10) NOT NULL,

OrderID Char (10) NULL

ProductName Varchar NOT NULL,

Primary key (OrderID, ProductID))

What are the errors in the above query? Each correct answer represents a complete solution. (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    An attribute declared as a primary key cannot contain NULL values.
  • ○

    Each attribute should be defined as a primary key separately.
  • ○

    A table cannot have two primary keys.
  • ○

    ProductName is declared as Varchar without specifying the width of the column.