I want to ask some questions about DATABASE

1.The most important development in the database field during the past decade is the development of relational databases.

True

False

2.You have created a QUERY_DEPT procedure that references the public synonym dept that is created on the

adam.departments view. You have decided to create a table dept with the same name and structure as the

departments view in your schema. The user ADAM accidentally drops the departments view in his schema.

In the given scenario, which statement is true for the QUERY_DEPT procedure?

	a.	The procedure will become invalid
	b.	The procedure will remain unaffected.
	c.	The procedure will be recompiled successfully the first time it is invoked.
	d.	The procedure will be recompiled successfully the second time it is invoked.

3.You want to retrieve all the rows and columns from the employee table, store them in a variable, and process

them in a PL/SQL block.

Which type of variable should you create in the PL/SQL block to retrieve all the rows and columns by using a

single SELECT statement from the employee table?

	a.	a PL/SQL record
	b.	a %ROWTYPE variable
	c.	a PL/SQL table of records
	d.	a PL/SQL table of scalar values

4.In the E-R model, the number of entities that can map to one another under a relationship is called the

	A.	degree of the relationship
	B.	order of the relationship
	C.	descriptor of the relationship
	D.	cardinality of the relationship

5.In the E-R model, if the value of an attribute is null, it often means

	A.	the value is unknown
	B.	the value is a blank string
	C.	the attribute is incorrect
	D.	the value is zero

6.Which of the following is another term for the system data dictionary?

	A.	ALL view
	B.	DBA view
	C.	system catalog
	D.	CONSTRAINTS

7.Which of the following is an example of a semantic model?

	A.	hierarchical
	B.	network
	C.	entity-relationship
	D.	structured

.8.All of the following are examples of data standards EXCEPT

	A.	data naming conventions
	B.	update procedures
	C.	query optimization
		D.documentation rules