Free Database Fundamentals 98-364 Exam Practice Test

You delete rows in a table named Order. The corresponding rows in the OrderItem table are automatically deleted. This process is an example of a/an:

• Inherited delete
  
• Cascade delete
  
• Functional delete
  
• Waterfall delete
  
• Domino delete
  

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
  

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.
  

First normal form requires that a database excludes:

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

You assign User1 a set of permissions that include the WITH GRANT OPTION.The WITH GRANT OPTION enables User1 to:

• request a log of permission use.
  
• delegate permissions to other users.
  
• create new database users.
  
• view other users' permissions.
  

This question requires that you evaluate the underlined text to determine if it is correct.You have two tables. Each table has three rows.Nine rows will be included in the Cartesian product of these two tables.Instructions: Review the underlined text. If it makes the statement correct, select 'No change is needed.' If the statement is incorrect, select the answer choice that makes the statement corrector.

• No change is needed
  
• Zero
  
• Three
  
• Six
  

What is one difference between an update statement and a delete statement?

• An update statement can change only one row.
  
• A delete statement cannot use a where clause.
  
• An update statement does not remove rows from a table.
  
• A delete statement works only within a stored procedure.
  

You have a table named Product. The Product table has columns for ProductDescription and ProductCategory.You need to change the ProductCategory value for all the spoons in the Product table to 43.Which statement should you use?

• Option
  

  

• Option
  

  

• Option
  

  

• Option
  

  

You need to add rows to a database table.Which Structured Query Language (SQL) keyword should you use?

• JOIN
  
• INSERT
  
• CREATE
  
• UPDATE
  

You need to populate a table named EmployeeCopy with data from an existing table named Employee.Which statement should you use?

• Option
  

  

• Option
  

  

• Option
  

  

• Option