INFOSYS Power Preperation
Home >> PlacementWeek Papers >> Dream Companies >> Infosys More Infosys Real Papers >>

 

 



INFOSYS POWER PREPARATION
 

 

RDBMS

1.     What is database?

2.     What is DBMS?

3.     What is a Database system?

4.    Advantages of DBMS?

5.    Disadvantage in File Processing System?

6.    Describe the three levels of data abstraction?

7.    Define the "integrity rules"

8.    What is extension and intension?

9.    What is System R? What are its two major subsystems?

10.  How is the data structure of System R different from the relational structure?

11.  What is Data Independence?

12.  What is a view? How it is related to data independence?

13.  What is Data Model?

14.  What is E-R model?

15.  What is Object Oriented model?

16.  What is an Entity?

17.  What is an Entity type?

18.  What is an Entity set?

19.  What is an Extension of entity type?

20.  What is Weak Entity set?

21.  What is an attribute?

22.  What is a Relation Schema and a Relation?

23.  What is degree of a Relation?

24.  What is Relationship?

25.  What is Relationship set?

26.  What is Relationship type?  

27.  What is degree of Relationship type?

25.  What is DDL (Data Definition Language)?

26.  What is VDL (View Definition Language)?

27.  What is SDL (Storage Definition Language)?

28.  What is Data Storage - Definition Language?

29.  What is DML (Data Manipulation Language)?

31.  What is DML Compiler?

32.  What is Query evaluation engine?

33.  What is DDL Interpreter?

34.  What is Record-at-a-time?

35.  What is Set-at-a-time or Set-oriented?

36.  What is Relational Algebra?

37.  What is Relational Calculus?

38.  How does Tuple-oriented relational calculus differ from domain-orientedrelational calculus

39.  What is normalization?

40.  What is Functional Dependency?  

41.  When is a functional dependency F said to be minimal?

42.  What is Multivalued dependency?

43.  What is Lossless join property?

44.  What is 1 NF (Normal Form)?

45. What is Fully Functional dependency?

46.  What is 2NF?

47.  What is 3NF?

48.  What is BCNF (Boyce-Codd Normal Form)?

49.  What is 4NF?

50.  What is 5NF?

51.  What is Domain-Key Normal Form?

52.  What are partial, alternate, artificial, compound and natural key?

53.  What is indexing and what are the different kinds of indexing?

54.  What is system catalog or catalog relation? How is better known as?

55.  What is meant by query optimization?

56.  What is join dependency and inclusion dependency?

57.  What is durability in DBMS?

58.  What do you mean by atomicity and aggregation?

59.  What is a Phantom Deadlock?

60.  What is a checkpoint and When does it occur?

61.  What are the different phases of transaction?

62.  What do you mean by flat file database?

63.  What is "transparent DBMS"?

64.  Brief theory of Network, Hierarchical schemas and their properties

65.  What is a query?

66.  What do you mean by Correlated subquery?

67.  What are the primitive operations common to all record management systems?

68.  Name the buffer in which all the commands that are typed in are stored

69.  What are the unary operations in Relational Algebra?

70.  Are the resulting relations of PRODUCT and JOIN operation the same?

71.  What is RDBMS KERNEL?

72.  Name the sub-systems of a RDBMS

73.  Which part of the RDBMS takes care of the data dictionary? How

74.  What is the job of the information stored in data-dictionary?

75.  How do you communicate with an RDBMS?

76.  Define SQL and state the differences between SQL and other conventional programming Languages

77.  Name the three major set of files on disk that compose a database in Oracle

78.  What is an Oracle Instance?

79.  What are the four Oracle system processes that must always be up and running for the database to be useable

80.  What are database files, control files and log files. How many of these files should a database have at least? Why?

81.  What is ROWID?

82. What is Oracle Block? Can two Oracle Blocks have the same address?

83.  What is database Trigger?

84. Name two utilities that Oracle provides, which are use for backup and recovery.

85.  What are stored-procedures? And what are the advantages of using them.

86.  What is Storage Manager?

87.  What is Buffer Manager?

88.  What is Transaction Manager?

89.  What is File Manager?

90.  What is Authorization and Integrity manager?

91.  What are stand-alone procedures?

92.  What are cursors give different types of cursors.

93. What are Armstrong rules?

94.  What do you understand by dependency preservation?

95.  What are the different types of JOIN operations?

 


 

 

 

Google
 
Web freshersworld.com

Defence Careers | GATE | GRE | MBA | Scholarships | Freshers Directory | Higher Studies | Build Resume | BPO jobs | Interview Tips

Contact US|Tell A Friend| Advertise with Us | FAQ| Sign Up | President's Note