Database Management System Set 18

Database Management System

Questions  171 to 180

171.	State the effective way of using a relational data model. (a) Three-dimensional models must be created (b) There must be a minimum of four relationships (c) Flat files must be eliminated (d) Complex groupings of data must be streamlined (e) All of the above.
172.	What is the result of the following query? SELECT FLOOR(3.6) FROM DUAL? (a) 3.5 (b) 3.0 (c) 4.0 (d) 3.7 (e) 3.4.
173.	Guidelines for creating tables in a relational database include which of the following? (a) Only one table in the database needs a primary key (b) The primary key need not be unique (c) Attributes may appear in several tables (d) Data must be atomic (e) All of the above.
174.	What is the Duplicate data in multiple data files called? (a) Data redundancy (b) Always necessary in networked databases (c) Typical of the relational model (d) A characteristic of a hierarchy (e) Both (b) and (c) above.
175.	Which of the following best describes the internal level of the ANSI/SPARC three level architecture? (a) The internal level is concerned with the layout of records and their locations within disk blocks (b) The internal level is concerned with the data as seen by individuals internal to the enterprise (c) The internal level is concerned with the users’ view of the data (d) The internal level is concerned with the how stored fields are represented and which indices exist (e) The internal level provides a conceptual view of the data structure.
176.	State the three basic operations used to develop useful sets of data in a relational database? (a) Sort, select and report (b) Combine, relate and sort (c) Select, project and join (d) Project, combine and report (e) Join, relate and sort.
177.	State the data hierarchy which goes from bits and bytes to (a) Entities, attributes, fields and records (b) Fields, attributes, entities and records (c) Fields, records, files and databases (d) Records, entities, fields and databases (e) Attributes, entities, records and tuples.
178.	Which of the following keyword is used with Data Control Language (DCL) statements? (a) SELECT (b) INSERT (c) DELETE (d) GRANT (e) UPDATE.
179.	Which of the following SQL statements drop the primary key of Department relation? The fields in Employee should reflect the removal in Department table. (a) ALTER TABLE Department DROP PRIMARY KEY (b) ALTER TABLE Department DROP PRIMARY KEY(Dept_Code) (c) ALTER TABLE Department DROP PRIMARY KEY CASCADE (d) ALTER TABLE Department DROP PRIMARY KEY RESTRICT (e) DROP PRIMARY KEY Dept_Code FROM Department CAS.
180.	Embedded SQL means (a) Using the EMBED key word in a SQL statement (b) Writing a SQL statement to retrieve data from more than one relation (c) Writing SQL statements within codes written in a general programming language (d) Specifying a condition and action to be taken in case the given condition is satisfied in a trigger (e) Using SQL language constructs like revoke and grant respectively for revoking and granting privileges to users.

Answers

171.	d	The complex grouping of data in tables must be streamlined.
172.	d	The floor function rounds of to the nearest value.
173.	d	For the database to function efficiently, data must be atomic.
174.	a	duplication of data is called redundancy.
175.	c	The internal level is concerned with the users’ view of the data.
176.	c	Select, Project and Join are the fundamental operations that are used to develop useful datasets in relational database.
177.	c	Set of fields make up a record, set of records will make a files.
178.	d	GRANT is the keyword which is used with Data Control Language statements.
179.	c	ALTER TABLE Department DROP PRIMARY KEY CASCADE
180.	c	Embedded SQL means writing SQL statements within codes written in a general programming language.

<< Prev  1...  2...  3...  4...  5...  6...  7...  8...  9...  10...  11...  12...  13...  14...  15...  16...  17...  18...  19...  20...  21...  22...  23...  24...  25...  26...  27...  28...  29...  30...  31...  32...  33...  34...  35...  36...  Next >>