Database System – Set 4

Computer Operator

Dear ! This is Database System – Set 4 Quiz and it contains 50 questions.

Happy Learning!

1 / 50

1. The level of data abstraction describes how the data is actually stored is ?

Physical level

Conceptual level

Storage level

File level

2 / 50

2. The physical location of a record is determined by a mathematical formula that transform a file key into a record location is :

B-Tree File

Hashed File

Indexed File

Sequential

3 / 50

3. The ……….. operator is used to compare a value to a list of literals values that have been specified

BETWEEN

ANY

ALL

4 / 50

4. A data dictionary is a special file that contains:

The name of all fields in all files

The width of all fields in all files

The data type of all fields in all files

All of these

5 / 50

5. In DBMS , Data is presented as a collection of ……….

Relation

Table

Attribute

Entity

6 / 50

6. Which of the following is record based logical model ?

Network Model

Object oriented model

E-R model

None of these

7 / 50

7. What rows will this select statement return ? SELECT * FROM product WHERE order number > = 1000

All rows in the products table whose order number is greatest than or equal to 1000

All rows in the products table whose order number is less than or equal to 1000

The first 1000 rows of the product table

All rows in the products table whose order number is greater than 1000

8 / 50

8. The overall design of a database is called

Schema of the database

The screen of database

Structure of the database

View of the database

9 / 50

9. The tables generated on compilation of data definition language are stored in ?

Data abstraction

Data dictionary

Data file

Meta data

10 / 50

10. The DBMS acts as an interface between what two components of an enterprise- class database system?

Database application and the database

Data and the database

The user and the database application

Database application and SQL

11 / 50

11. The minimal set of super key is called

Primary key

Secondary key

Candidate key

Foreign key

12 / 50

12. Which of the following is a comparison operator in SQL ?

BETWEEN

All of these

13 / 50

13. The DBMS utility, ………. allows to reconstruct the correct state of database from the backup and history of transactions

Backup

Recovery

Monitering

Scankdisk

14 / 50

14. A ……….. Norma form normalization will be needed where all attributes in a relation tuple are not functionally dependent only on the key attribute.

First

Second

Third

Fourth

15 / 50

15. ……….. is a full form of SQL

Standered Query language

Strured query language

Serial query language

None

16 / 50

16. Most popular commercial database

Oracle

My SQL

MY Access

PHP

17 / 50

17. DBMS is a collection of ………. that enables user to create and maintain a database

Key

Program

Translator

None

18 / 50

18. ……… is a virtual table that draws its data from the result of an SQL SELECT statement .

View

Synonym

Sequence

transaction

19 / 50

19. Which of the operations constitute a basic set of operations for manipulating relational data ?

Predicate calculus

Relational calculus

Relational algebra

None of these

20 / 50

20. A table joined with itself is called

Join

Self Join

other join

Equi join

21 / 50

21. Which SQL command can be used to delete columns from a table ?

MODIFY TABLE TableName DROP ColumnName

MODIFY TABLE TableName Drop ColumnName

ALTER TABLE TableName DROP COLUMN ColumnName

ALTER TABLE TableName DROP ColumnName

22 / 50

22. …….. defines the structure of a relation which consists of a fixed set of attribute- domain pairs .

Schema

Program

Instance

None

23 / 50

23. A field or a combination of fields that has a unique value is called:

Foreign key

Secondary key

Primary key

Alternate key

24 / 50

24. A key more than one attribute is called

Composite key

Primary key

Candidate key

None

25 / 50

25. It is possible to define a scheme completely using

VDL and DDL

DDL and DML

SDL and DDL

VDL and DML

26 / 50

26. In the ………… Norma form , a composite attribute is converted to individual attributes

First

Second

Third

Fourth

27 / 50

27. Which of the following products was the first to implement true relational algebra in a pc DBMS ?

Oracle

R:base

IDMS

dBase-II

28 / 50

28. Objects based data models are used in describing the abstraction of the following levels ?

Conceptual and view

Only physical

Physical and conceptual

Only conceptual

29 / 50

29. An association of several structures of data base can be expressed graphically by ?

Tuple

Record

Relationships

Field

30 / 50

30. Which one of the following is a direct benefit of database normalization?

Higher query processing efficiency

Smaller number of tables

Reduced I/O for most queries

Reduced data redundancy

31 / 50

31. What SQL command will allow you to change the table STUDENT to add the constraint named Grade Check that states that the values of the Grade column must be greater than 0 ?

ALTER TABLE STUDENT ALTER CONSTRAINT GradeCheck (Grade > 0 );

ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck (Grade > 0) ;

ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck CHECK (Grade > 0)

None of these is correct

32 / 50

32. The level of abstraction describes only part of the entire database is called?

Conceptual level

View level

Procedural level

None of these

33 / 50

33. In E-R Diagram relationship type is represented by

Ellipse

Dashed ellipse

Rectangle

Triangle

34 / 50

34. Related fields in a database are grouped to form?

Data field

Data Record

Bank

35 / 50

35. Most popular commercial database

Oracle

My SQL

MY Access

PHP

36 / 50

36. To select all columns from the table the syntax is :

Select all from table_ name

Select * from table_name

Select from table_name

None

37 / 50

37. ………. is a special type of stored procedure that is automatically invoked whenever the data in the table is modified

Procedure

Trigger

Cursor

None

38 / 50

38. Referential integrity control relationships between:

Attributes in a table

Operations of an object

Instances of a class

Table in a database

39 / 50

39. A transparent DBMS ?

Keeps its physical structure hidden from users

Keep its logical structure hidden from users

Cannot hide sensitive information from users

None

40 / 50

40. A file manipulation command that extracts some of the records from a file is called

SELECT

PROJECT

JOIN

PRODUCT

41 / 50

41. An attribute or set of attributes that uniquely identifies an entity is called

Super key

Primary key

Candidate key

None

42 / 50

42. In an ER model , ………. is described in the database by storing its data .

Entity

Attribute

Relationship

Notation

43 / 50

43. A primary key is combined with a foreign key creates

Parent – child relationship between the tables that connect them

Many to Many relationship between the tables that connect them

Network model between the tables that connect them

None of these

44 / 50

44. In a relational schema , each tuple is divided into fields called

Relation

Domain

Query

All

45 / 50

45. In E-R Diagram relationship type is represented by

Ellipse

Dashed ellipse

Rectangle

Diamand

46 / 50

46. To drop a column that is used as a foreign key , first :

Drop the primary key

Drop the table containing the foreign key

Drop the foreign key constraint

All of the above must be done

47 / 50

47. It is better to use files than a DBMS when there are

Stringent real- time requirements

Multiple users wish to access the data

Complex relationships among data

All of these

48 / 50

48. Tree structures are used to store data in

Network model

Relational model

Hierarchical model

File based system

49 / 50

49. A DBMS query language is designed to

Support end users who use English – like commands.

Support in the development of complex application software.

Specify the structure of a database.

All of these

50 / 50

50. ………. requires that data should be made available to only authorized users.

Security

Data integrity

Privacy

None

Your score is

Exit

Happy Learning!

Share this Quiz with your friends!

Follow Us @