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

#	Quiz
1 Discuss	Cross Join The default extension for an Oracle SQL*Plus file is: 1] .txt 2] .ora 3] .pls 4] .sql Solution
2 Discuss	Cross Join Triggers __________ enabled or disabled. 1] Cannot be 2] Can be 3] Ought to be 4] Always Solution
3 Discuss	Cross Join To include integrity constraint in a existing relation use : 1] Create table 2] Alter table 3] Modify table 4] Any of the above Solution
4 Discuss	Cross Join 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. Solution
5 Discuss	Cross Join 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 Solution
6 Discuss	Cross Join 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 Solution
7 Discuss	Cross Join The SQL statement to create a view is 1] CREATE VIEW 2] MAKE VIEW 3] SELECT VIEW 4] INSERT VIEW Solution
8 Discuss	Cross Join 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 Solution
9 Discuss	Cross Join Which of the following is NOT a type of SQL constraint? 1] PRIMARY KEY 2] ALTERNATE KEY 3] UNIQUE 4] FOREIGN KEY Solution
10 Discuss	Cross Join 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 Solution
11 Discuss	Cross Join 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 Solution
12 Discuss	Cross Join What is an SQL virtual table that is constructed from other tables? 1] Just another table 2] View 3] Relation 4] Query results Solution
13 Discuss	Cross Join 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 Solution
#	Quiz