SQL questions

Question 5

1. A user view in which the WHERE line of the SELECT statement used to create the view contains some predicate is called

	A.	value-dependent
	B.	static
	C.	value-independent
	D.	dynamic

0.5 points

Question 6

1. Which of the following records are normally kept in a security log?

	A.	all access to the database
	B.	only successful security violations
	C.	all attempted security violations
	D.	all updates to the database

Question 8

1. A database driver is software that lets the

	a.	data access model communicate with the application program
	b.	application program communicate with the data access model
	c.	application program communicate with the database
	d.	data access model communicate with the database

Question 20

1. The statement SELECT * FROM T1, T2 produces a(n) ____ join.

	a.	full
	b.	cross
	c.	natural
	d.	equi-

Question 23

1. The Oracle isolation level that guarantees transaction-level consistency for all transactions is

	A.	write only
	B.	read committed
	C.	serializable
	D.	read only

0.5 points

Question 27

1.

You have created the update_emp package in your database and want to access the procedures and functions

present inside the package.

Which statement correctly describes the characteristics of a package?

	a.	A package specification cannot exist without a package body.
	b.	A package body cannot exist without a package specification.
	c.	A package body and package specification are stored together.
	d.	A package body and package specification must be declared together.

Question 35

1. All of the following signal an end of an Oracle transaction EXCEPT

	A.	a DDL command
	B.	a ROLLBACK statement
	C.	a SAVEPOINT
	D.	a COMMIT statement