Free Database Fundamentals 98-364 Exam Practice Test

Data in a database is stored in:

• Tables
  
• Queries
  
• Data types
  
• Stored procedures
  

You have two tables named Salesperson and Sales.You need to ensure that each record in the Sales table has a valid associated salesperson record in the Salesperson table.Which database object should you add to the Sales table?

• Nonclustered index
  
• Primary key
  
• Foreign key
  
• Clustered index
  

You have a table named Customer. You need to add a new column named District.Which statement should you use?

• Option
  

  

• Option
  

  

• Option
  

  

• Option
  

  

What are three valid data manipulation language (DML) commands? (Choose three.)

• INSERT
  
• COMMIT
  
• DELETE
  
• OUTPUT
  
• UPDATE
  

First normal form requires that a database excludes:

• Foreign keys
  
• Composite keys
  
• Duplicate rows
  
• Repeating groups
  

You need to enable a new employee to authenticate to your database.Which command should you use?

• ALLOW USER
  
• CREATE USER
  
• ADD USER
  
• INSERT USER
  
• ALTER USER
  

Which statement should you use to remove a foreign key?

• ALTER TABLE
  
• DELETE TABLE
  
• DELETE FOREIGN KEY
  
• ALTER FOREIGN KEY
  

One difference between a function and a stored procedure is that a function:

• Must be called from a trigger.
  
• Must return a value.
  
• Cannot contain a transaction.
  
• Cannot accept parameters.
  

You are creating a table to store customer data. The AccountNumber column uses values that always consist of one letter and four digits. Which data type should you use for the AccountNumber column?

• CHAR
  
• BYTE
  
• DOUBLE
  
• SMALLINT
  

You need to remove a view named EmployeeView from your database.Which statement should you use?

• DELETE VIEW EmployeeView
  
• DELETE EmployeeView
  
• DROP EmployeeView
  
• DROP VIEW EmployeeView