RDBMS

Question 1 of 73

1. Question

5 points

Match the following terms in the given sequence

i-Batch processing	a. collection of files contain related data
ii-Flat files	b. same information repeated in multiple files
iii-Redundancy	c. transaction are collected and processed together
iv-Database	d. traditional method of storage

i-c ii-d iii-a iv-b
1-c ii-d iii-b iv-a
i-d ii-c iii-b iv-a
i-d ii-c iii-a iv-b

Question 2 of 73

2. Question

5 points

Various services provided by a DBMS are

i-Transaction support	a. multiple users can do the operations at the same time
ii-Concurrency control	b. support in case of database failure
iii-Recovery	c. data dictionary
iv-Data definition	d. to do all the steps of a work as one unit

i-a ii-b iii-c iv-d
i-d ii-a iii-b iv-c
i-d ii-a iii-c iv-b
i-a ii-d iii-b iv-c

Question 3 of 73

3. Question

5 points

Match the following

i-Writing programs to retrieve data from the database	a. database designer
ii-users using the application	b. end users
iii-Monitoring performance & enforcing security	c. DBA
iv-Making the blueprint of the database	d. application programmer

i-a ii-b iii-c iv-d
i-d ii-b iii-c iv-a
i-b ii-d iii-c iv-a
i-b ii-d iii-a iv-c

Question 4 of 73

4. Question

5 points

What is not true about the hierarchical model of DBMS

consists of parent child relationship
it is depicted by an upside-down tree
provides a physical structure view
provides a logical structure view

Question 5 of 73

5. Question

5 points

What is not true about network model of DBMS

data can be accessed quickly
data can be accessed from any table
only records represent its structure
it has an upside-down tree structure

Question 6 of 73

6. Question

5 points

Match the following in the given sequence

i-Tuple	a. a group of tuples
ii-Domain	b. characteristics of an entity
iii-Relation	c. a table row representing a group of data values
iv-Attribute	d. range of values eligible for input

i-c ii-d iii-a iv-b
i-c ii-d iii-b iv-a
i-d ii-c iii-a iv-b
i-d ii-c iii-b iv-a

Question 7 of 73

7. Question

5 points

Match the following

i-Super key	a. Not part of any primary or candidate key
ii-Candidate key	b. by default combination of all the attributes
iii-Primary key	c. one of the candidate keys
iv-Non-key	d. a single or combination of keys to define uniqueness with irreducibility

i-b ii-d iii-c iv-a
i-b ii-d iii-a iv-c
i-d ii-b iii-a iv-c
i-d ii-b iii-c iv-a

Question 8 of 73

8. Question

5 points

Match the following in the given sequence

i-that can be divided into smaller sub parts	a. Composite attribute
ii-possible to have one value at a time	b. Derived attribute
iii-cannot be subdivided	c. Single-valued attribute
iv-can have many values	d. multi-valued attribute
v- value can be calculated from other attributes	e. simple attribute

i-a ii-b iii-c iv-d v-e
i-e ii-d iii-c iv-b v-a
i-a ii-c iii-e iv-d v-b
i-a ii-c iii-e iv-b v-d

Question 9 of 73

9. Question

5 points

Match the following in the given sequence

i-Degree	a. no of entities involved
ii-cardinality	b. minimum and maximum value of connectivity
iii-Regular entity	c. has its own key attribute
iv-Weak entity	d. depends on other entity for existence

i-a ii-b iii-c iv-d
i-b ii-a iii-c iv-d
i-a ii-b iii-d iv-c
i-b ii-a iii-d iv-c

Question 10 of 73

10. Question

5 points

in case of a single department in the relation of Employee and Head of Department

Employee and department have partial relationship
Employee and department have total relationship
Employee has partial and department has total relationship
Employee has total and department has partial relationship

Question 11 of 73

11. Question

5 points

Match the following

i-Entity	a. Rectangle
ii-Attribute	b. diamond
iii-relationship	c. ellipse

i-a ii-b iii-c
i-b ii-c iii-a
i-b ii-a iii-c
i-a ii-c iii-b

Question 12 of 73

12. Question

5 points

Match the following

i-key column	a. underlined
ii-Multivalued	b. double lined eclipse
ii-Composite attribute	c. eclipse from eclipse
iv-partial relationship	d. double lining
v-total relationship	e. single lining

i-a ii-b iii-c iv-d v-e
i-b ii-a iii-c iv-d v-e
i-a ii-b iii-c iv-e v-d
i-a ii-c iii-b iv-d v-e

Question 13 of 73

13. Question

5 points

Which is not true about DBMS

Multiple users can work concurrently onto the same table
One viewer can be accommodated by database at one time
A description of the database structure is in the database system
Provides security at different levels

Question 14 of 73

14. Question

5 points

Match the following

i-DDL	a. DELETE
ii-DML	b. DROP
iii-DCL	c. ROLLBACK

i-a ii-b iii-c
i-b ii-c iii-a
i-b ii-a iii-c
i-c ii-b iii-a

Question 15 of 73

15. Question

5 points

To delete a table EMP including the table structure the correct command is

DROP EMP
DROP EMP TABLE
DROP TABLE EMP
DELETE TABLE EMP

Question 16 of 73

16. Question

5 points

What are the reasons for performing Normalization techniques

to eliminate data redundancy
to provide more storage space
to eliminate insertion, deletion and updation anomalies
to ensure data recovery is successful

Question 17 of 73

17. Question

5 points

Which are true statements out of the following about ER model

The basic objects of an ER model are entities
The particular properties used to describe entities are attributes
Entities and attributes have implicit relationship between them
Attributes describe the interaction between entities

Question 18 of 73

18. Question

5 points

What is true for a column level constraint

you cannot create a constraint after you have created the column
if you fail to name the constraint the server will name it for you
NOT NULL constraint can not be enforced at column level
It must be identified with the column name

Question 19 of 73

19. Question

5 points

Match the following with the corresponding entries in the second column

i-Unique key	a. specifies a column that must contain unique values
ii-foreign key	b. specifies a condition that must be true
iii-check	c. Enforces referential integrity
iv.Primary key	d.defines a row in a table uniquely

i-a ii-c iii-d iv-b
i-a ii-c iii-b iv-d
i-c ii-a iii-b iv-d
i-c ii-a iii-d iv-b

Question 20 of 73

20. Question

5 points

Select a characteristic of table level constraint

It can be used to define the not null constraint
It applies to all columns in the table
It is defined separately at the end after creating columns in the table
It can only be named by the server not by the user

Question 21 of 73

21. Question

5 points

synonym
View
Index
Sequence

Question 22 of 73

22. Question

5 points

Select a statement that creates a placeholder in the current transaction

Save point
Commit
Rollback
Create

Question 23 of 73

23. Question

5 points

Identify the statement that makes all pending data changes permanent

Save point
Commit
Rollback
Update

Question 24 of 73

24. Question

5 points

Identify the properties of a view

are logical structures based another tables or views
can be used to restrict direct access to a database
are created automatically when you assign a foreign key
cannot contain columns from multiple tables

Question 25 of 73

25. Question

5 points

Match the following in the given sequence

i-Between	a. wildcard searches of valid search string values are performed
ii-In	b. unavailable, unassigned, unknown or inapplicable values are tested
iii-IS NULL	c. values in a specified list are tested
iv.Like	d.In between and inclusive values are tested

i-d ii-c iii-b iv-a
i-c ii-d iii-b iv-a
i-c ii-d iii-a iv-b
i-d ii-c iii-a iv-b

Question 26 of 73

26. Question

5 points

The dependant entity is represented by a double lined rectangle and the identifying relationship by a double lined diamond

True
False
----
----

Question 27 of 73

27. Question

5 points

An attribute B of a relation R is transitively dependent on attribute A of R if it is functionally dependent on an attribute C Which in turn is functionally dependent on A or any proper subset of A. it defines

Full Dependency
Partial Dependency
Transitive dependency
----

Question 28 of 73

28. Question

5 points

every non-prime attribute is non-transitively dependent on every key of R is property of

1NF
2NF
3NF
4NF

Question 29 of 73

29. Question

5 points

Reduction in degree of normalization is done for

Keeping tables large in size
To reduce the number of tables
To reduce complexity
To improve query performance

Question 30 of 73

30. Question

5 points

Identify the features of PL/SQL

Extension of SQL with design features of programming language
Enables data encapsulation
Fully supports SQL data types
Enables immediate resolution of operating system problems

Question 31 of 73

31. Question

5 points

A join without any condition is called

Self join
Left outer join
Right outer join
cross join

Question 32 of 73

32. Question

5 points

Create view Graders as select * from employee where grade =‘B’

Horizontal view
Vertical View
Grouped View
Joined View

Question 33 of 73

33. Question

5 points

Which of the following view is updatable

The query includes a group by or having
Distinct is specified in the query creating view
From clause specifies only one source table
The where class includes a sub query

Question 34 of 73

34. Question

5 points

one of the following is not an advantage of views

Security
Query Performance
Query simplicity
Structural simplicity

Question 35 of 73

35. Question

5 points

Find out the true statements about an index

Physical storage structure
Transparent to the user
Provides rapid access to rows of a table
To be updated after every insert operation

Question 36 of 73

36. Question

5 points

Which statement is false regarding Cursor in SQL

A kind of variable associated with a query. The value of this variable will be each row, in turn, of that query’s output.
It is used for solving nested queries
Needed for select queries which return multiple rows of output from DBMS
----

Question 37 of 73

37. Question

5 points

What is the correct sequence of Cursor

Declare fetch open close
Declare open fetch close
Open declare fetch close
Open fetch declare close

Question 38 of 73

38. Question

5 points

What is true about a transaction

Logical unit of program execution that takes a database from one consistent state to another consistent state
a transaction is a sequence of database actions which must either all be done, or none of them must be done
if only some of the actions of a transaction are carried out the database will be left in an inconsistent state
DBMS keeps track of the old value of a data so that if there is a transaction failure, the old value of the data is restored

Question 39 of 73

39. Question

5 points

To ensure that after successful transaction completion, all updates persist irrespective of system failures

Atomicity
Consistency
Isolation
Durability

Question 40 of 73

40. Question

5 points

Match the following items

i-Active	a. when normal execution can’t proceed
ii-failed	b. after rollback and restoration to previous state
iii-aborted	c. after successful completion
iv.committed	d.while executing

i-a ii-b iii-c iv-d
i-d ii-c iii-b iv-a
i-d ii-a iii-b iv-c
i-d ii-a iii-c iv-b

Question 41 of 73

41. Question

5 points

When we try to insert a row in child table, its foreign key value must be the same as one of the primary key values in parent table

True
False
----
----

Question 42 of 73

42. Question

5 points

Prevent the dept being deleted until all its employees are reallotted to some other dept

ON DELETE RESTRICT
ON DELETE SET NULL
ON DELETE SET DEFAULT
ON DELETE CASCADE

Question 43 of 73

43. Question

5 points

With a Grant command the permission can be granted to

Permission can be granted for all DML commands
Permission can be granted to a database/Table/View
Permission for further grants
Permission for insertion, deletion, updation of a table

Question 44 of 73

44. Question

5 points

When a transaction A reads a value from a table, another transaction B modifies that value and A again reads that value. Now A will find a different value than what it was before. It is the case of

Lost update
Dirty Read
Phantom Records
Nonrepeatable read

Question 45 of 73

45. Question

5 points

A transaction A may read some data updated by another transaction B might not have yet committed. If B fails and gets aborted, the data as read by A would not exist. It is the case of

Lost update
Dirty Read
Phantom Records
Nonrepeatable read

Question 46 of 73

46. Question

5 points

When one transaction updates a table and before it commits, another transaction reads the value (old value) and makes some updates based on that. It is the case of

Lost update
Dirty Read
Phantom Records
Nonrepeatable read

Question 47 of 73

47. Question

5 points

Which locking is not practically being used because of the high overhead involved

Field level
Row Level
Table Level
Table space level

Question 48 of 73

48. Question

5 points

In the growing phase of the transaction

the locks can be acquired and released
the locks can be acquired and not released
the locks can be released but not acquired
the locks can not be released or acquired

Question 49 of 73

49. Question

5 points

Indicates whether a buffer has been modified or not

In place updation
Dirty Bit
Cache Buffer
Pin-Unpin Bit

Question 50 of 73

50. Question

5 points

writes the cache buffer back to the same disk location

In place updation
Dirty Bit
Cache Buffer
Pin-Unpin Bit

Question 51 of 73

51. Question

5 points

writing the buffer to a different location on the disk is associated with one of the following

After image
Dirty Bit
Shadowing
Before image

Question 52 of 73

52. Question

5 points

Which of the following holds the data base blocks in the primary memory for achieving speedier transaction execution

In place updation
Dirty Bit
Cache Buffer
Pin-Unpin Bit

Question 53 of 73

53. Question

5 points

Transaction identifier, Data item identifier, Old value, New value of data are maintained in

Database
Table
Cache Buffer
Log File

Question 54 of 73

54. Question

5 points

The transactions are allowed to perform any updates while the checkpoints are in progress.

True
False
----
----

Question 55 of 73

55. Question

5 points

SQL is called

System Query Language
Sequel Query Language
Standard Query Language
structured query language

Question 56 of 73

56. Question

5 points

A command that extracts some of the records from a table is called

Select
Project
Join
create

Question 57 of 73

57. Question

5 points

Match the following in the given sequence

i-GET	a. Writes the contents of a SQL buffer to the file
ii-EDIT	b. Leaves the SQL * PLUS environment
iii-EXIT	c. invokes a tool used to revise the saved file
iv.SAVE	d.Writes the contents of a file to the SQL Buffer

i-d ii-c iii-b iv-a
i-c ii-d iii-b iv-a
i-c ii-d iii-a iv-b
i-d ii-c iii-a iv-b

Question 58 of 73

58. Question

5 points

The operator of SQL which is executed at the end

≥
LIKE
BETWEEN
OR

Question 59 of 73

59. Question

5 points

Match the following in the given sequence

i-Interval Day to Second	a. stores period of time in terms of days, hours, minutes and seconds
ii-Date	b.Stores values in DD-MON-RR format
iii-Timestamp	c.Stores year, month, day, hour minute & fractional second values
iv.Timestamp with Time Zone	d.stores time zone displacement between Local time & UTC

i-a ii-b iii-c iv-d
i-a ii-b iii-d iv-c
i-b ii-a iii-c iv-d
i-b ii-a iii-d iv-c

Question 60 of 73

60. Question

5 points

Identify the features of NUMBER data type

a. stores variable length numeric data
b. accepts precision and scale parameters
c. uses precision to enter total number of digits
d. uses scale to enter the total no. of digits to the right of decimal place
e. precision ranges from 1 to 38

abd
abde
abcde
ace

Question 61 of 73

61. Question

5 points

Match the following in the given sequence

i-A multiple row sub query	a. is executed only once and returns one or more value pairs
ii-A correlated sub query	b.is executed only once and returns a single value
iii-A multiple column sub query	c.is executed only once for each row considered by outer query
iv.A single row sub query	d.is executed only once and returns one or more rows

i-a ii-b iii-c iv-d
i-d ii-c iii-a iv-b
i-d ii-c iii-b iv-a
i-c ii-d iii-a iv-b

Question 62 of 73

62. Question

5 points

What is the sequence of operations in case of single row sub query

a. Execution of inner query
b. Execution of outer query
c. Evaluation of condition in where clause
d. return of a value to where clause

adbc
adcb
dacb
dabc

Question 63 of 73

63. Question

5 points

Identify the rules that must be followed when using set operators in compound queries

The order by clause is specified at the end of the compound query
The select statements are executed from bottom to top
The order by clause can contain names only from the last query
The column names from the first query are displayed in the result

Question 64 of 73

64. Question

5 points

What is not true about time stamping

It is based on system clock
It ensures serialization
It ensures conflicting transactions to proceed on time ordering
Increases the possibility of deadlocks

Question 65 of 73

65. Question

5 points

Match the following in the given sequence

i-Logical error	a. overflow
ii-System error	b.head crash
iii-System crash	c.hardware problem
iv.Disk failure	d.deadlock

i-a ii-d iii-c iv-b
i-a ii-d iii-b iv-c
i-d ii-a iii-c iv-b
i-d ii-a iii-b iv-c

Question 66 of 73

66. Question

5 points

Which of the following statements is false

The WRITE operation is deferred until a transaction Commits
A transaction is said to be partially committed when it completes its final action
Before the actual updates on the database begins, it must be ensured that all log records are written to the stable storage
Once all the updates are done on the database the transaction enters the committed state.

Question 67 of 73

67. Question

5 points

In case of SIX locking which of the following is true

S gives share access to the requested node and all descendents of the requested node
S gives share access to the requested node and all ascendants of the requested node
S gives share access to the requested node and no other lock can be permitted
S gives share access to the requested node and other transactions can get S,IS,IX lock

Question 68 of 73

68. Question

5 points

In case of SIX locking which of the following is true

X gives exclusive access to the requested node and other transactions can have IS lock.
X gives exclusive access to the requested node and other transactions can have IX lock.
X gives exclusive access to the requested node and other transactions can have S and IS lock.
X gives exclusive access to the requested node and other transactions can not have any lock.

Question 69 of 73

69. Question

5 points

In case of SIX locking which of the following is true

IS gives intention share access to requested node and allow requester to explicitly lock descendants of node in S , IS mode only
IX gives intention exclusive access to requested node and allow requester to explicitly lock descendants of node in IS or IX mode only
IS gives intention share access to requested node and allow requester to explicitly lock descendants of node in IS or IX mode only
IX gives intention exclusive access to requested node and allow requester to explicitly lock the descendants in S or IS mode only

Question 70 of 73

70. Question

5 points

If a node is having SIX lock in SIX locking technique the another lock allowed is

S
IS
IX
X

Question 71 of 73

71. Question

5 points

Find out the false statement

If a deadlock occurs one of the offending transactions must be rolled back to allow the other to proceed
If a deadlock occurs both transactions must be rolled back to proceed
There are schemes for preventing deadlock. But, most DBMSs allow them to occur and resolve when they are detected
There are methods for choosing which transaction to roll back when deadlock is detected e.g. data updated, data remaining to update

Question 72 of 73

72. Question

5 points

A Graphical technique for understanding and organizing the data independent of the actual database implementation

DFD
ER Modelling
Flowchart
Decision table

Question 73 of 73

73. Question

5 points

Which of the following clauses in a SELECT statement allow you to sort the output

Select By
Order BY
Sort By
List By

Quiz-summary

Information

Results

Categories

1. Question

2. Question

3. Question

4. Question

5. Question

6. Question

7. Question

8. Question

9. Question

10. Question

11. Question

12. Question

13. Question

14. Question

15. Question

16. Question

17. Question

18. Question

19. Question

20. Question

21. Question

22. Question

23. Question

24. Question

25. Question

26. Question

27. Question

28. Question

29. Question

30. Question

31. Question

32. Question

33. Question

34. Question

35. Question

36. Question

37. Question

38. Question

39. Question

40. Question

41. Question

42. Question

43. Question

44. Question

45. Question

46. Question

47. Question

48. Question

49. Question

50. Question

51. Question

52. Question

53. Question

54. Question

55. Question

56. Question

57. Question

58. Question

59. Question

60. Question

61. Question

62. Question

63. Question

64. Question

65. Question

66. Question

67. Question

68. Question

69. Question

70. Question

71. Question

72. Question

73. Question

Newsletter