Database System – Set 4

Computer Operator

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

Happy Learning!

1 / 50

1. Most popular commercial database

Oracle

My SQL

MY Access

PHP

2 / 50

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

BETWEEN

ANY

ALL

3 / 50

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

Procedure

Trigger

Cursor

None

4 / 50

4. 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

5 / 50

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

Standered Query language

Strured query language

Serial query language

None

6 / 50

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

Conceptual and view

Only physical

Physical and conceptual

Only conceptual

7 / 50

7. A transparent DBMS ?

Keeps its physical structure hidden from users

Keep its logical structure hidden from users

Cannot hide sensitive information from users

None

8 / 50

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

Data field

Data Record

Bank

9 / 50

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

Key

Program

Translator

None

10 / 50

10. 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

11 / 50

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

Security

Data integrity

Privacy

None

12 / 50

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

Schema

Program

Instance

None

13 / 50

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

Ellipse

Dashed ellipse

Rectangle

Triangle

14 / 50

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

First

Second

Third

Fourth

15 / 50

15. A key more than one attribute is called

Composite key

Primary key

Candidate key

None

16 / 50

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

Super key

Primary key

Candidate key

None

17 / 50

17. The minimal set of super key is called

Primary key

Secondary key

Candidate key

Foreign key

18 / 50

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

Select all from table_ name

Select * from table_name

Select from table_name

None

19 / 50

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

Oracle

R:base

IDMS

dBase-II

20 / 50

20. Tree structures are used to store data in

Network model

Relational model

Hierarchical model

File based system

21 / 50

21. 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

22 / 50

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

Predicate calculus

Relational calculus

Relational algebra

None of these

23 / 50

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

View

Synonym

Sequence

transaction

24 / 50

24. 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

25 / 50

25. Most popular commercial database

Oracle

My SQL

MY Access

PHP

26 / 50

26. 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

27 / 50

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

Physical level

Conceptual level

Storage level

File level

28 / 50

28. 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

29 / 50

29. 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

30 / 50

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

Relation

Table

Attribute

Entity

31 / 50

31. 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

32 / 50

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

Entity

Attribute

Relationship

Notation

33 / 50

33. 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

34 / 50

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

Backup

Recovery

Monitering

Scankdisk

35 / 50

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

Tuple

Record

Relationships

Field

36 / 50

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

Ellipse

Dashed ellipse

Rectangle

Diamand

37 / 50

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

Data abstraction

Data dictionary

Data file

Meta data

38 / 50

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

Conceptual level

View level

Procedural level

None of these

39 / 50

39. It is possible to define a scheme completely using

VDL and DDL

DDL and DML

SDL and DDL

VDL and DML

40 / 50

40. Referential integrity control relationships between:

Attributes in a table

Operations of an object

Instances of a class

Table in a database

41 / 50

41. 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

42 / 50

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

Network Model

Object oriented model

E-R model

None of these

43 / 50

43. The overall design of a database is called

Schema of the database

The screen of database

Structure of the database

View of the database

44 / 50

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

BETWEEN

All of these

45 / 50

45. A table joined with itself is called

Join

Self Join

other join

Equi join

46 / 50

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

SELECT

PROJECT

JOIN

PRODUCT

47 / 50

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

Relation

Domain

Query

All

48 / 50

48. 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

49 / 50

49. 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

50 / 50

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

Foreign key

Secondary key

Primary key

Alternate key

Your score is

Exit

Happy Learning!

Share this Quiz with your friends!

Follow Us @