SQL -Structured Query Language - SQL Joins - Cross Join Quiz

The default extension for an Oracle SQL*Plus file is:

• 1]

  .txt

• 2]

  .ora

• 3]

  .pls

• 4]

  .sql

Triggers __________ enabled or disabled.

• 1]

  Cannot be

• 2]

  Can be

• 3]

  Ought to be

• 4]

  Always

To include integrity constraint in a existing relation use :

• 1]

  Create table

• 2]

  Alter table

• 3]

  Modify table

• 4]

  Any of the above

A _________ is a stored program that is attached to a table or a view.

• 1]

  pseudofile

• 2]

  trigger

• 3]

  embedded SELECT statement

• 4]

  None of the above is correct.

The DROP TABLE statement:

• 1]

  deletes the table structure only

• 2]

  deletes the table structure along with the table data

• 3]

  works whether or not referential integrity constraints would be violated

• 4]

  is not an SQL statement

SQL views can be used to hide

• 1]

  columns and rows only

• 2]

  complicated SQL syntax only

• 3]

  both of the above can be hidden by an SQL view

• 4]

  None of the above is correct

The SQL statement to create a view is

• 1]

  CREATE VIEW

• 2]

  MAKE VIEW

• 3]

  SELECT VIEW

• 4]

  INSERT VIEW

To update an SQL view, the DBMS must be able to associate the column(s) to be updated with

• 1]

  a particular column in a particular underlying table

• 2]

  a particular column in a particular row

• 3]

  a particular row in a particular underlying table

• 4]

  None of the above is correct

Which of the following is NOT a type of SQL constraint?

• 1]

  PRIMARY KEY

• 2]

  ALTERNATE KEY

• 3]

  UNIQUE

• 4]

  FOREIGN KEY

A _________ is a program that performs some common action on database data and that is stored in the database

• 1]

  trigger

• 2]

  stored procedure

• 3]

  pseudofile

• 4]

  None of the above

For what purposes are views used?

• 1]

  To hide columns only

• 2]

  To hide rows only

• 3]

  To hide complicated SQL statements only

• 4]

  All of the above

What is an SQL virtual table that is constructed from other tables?

• 1]

  Just another table

• 2]

  View

• 3]

  Relation

• 4]

  Query results

When using the SQL INSERT statement

• 1]

  rows can be modified according to criteria only

• 2]

  rows cannot be copied in mass from one table to another only

• 3]

  rows can be inserted into a table only one at a time only

• 4]

  rows can either be inserted into a table one at a time or in groups