Database Normalization Questions PDF

1 Database normalization is a systematic approach of decomposing tables of eliminates data redundancy. 2 There are total four types of functional dependencies. 3 Anomalies are error prone situation arising when we process the tables. 4 Data definition language (DDL) used to creates an...

1 Database normalization is a systematic approach of decomposing tables of eliminates data redundancy. 2 There are total four types of functional dependencies. 3 Anomalies are error prone situation arising when we process the tables. 4 Data definition language (DDL) used to creates and modifies the data structure of the database object. 5 DCL stands for Data Control Language. 6 Database/tables are created using create command. 7 GRANT command is used to provide access or privileges on the database objects to the users. 8 The Order by clause is used to order results either ascendingly or descendingly. 9 A view is a virtual table in the database. 10 Join combines data from two more tables in a database. 11 A right outer join fetches all the record from the right table and non-matching record from th 12 The process of choosing an effective execution stratergy for analysing the query is known as Query optimization_ 13 The Active state is the initial state when the transaction has just commenced its execution. 14 A Transaction timeline is refers to the chronological sequence of a transaction. 15 A deadlock is process or situation occurs when a resource is holding a process and waiting for the process which is being holded by the another resource. 16 SQL stands for Structured Query Language. 17 The process of decomposing larger relationships into smaller relationships are known as normalization 18 A →B, B →C then A →C represents transitive functional dependency. 19 An Update anomaly exist when one or more instances of duplicated data are updated, but not a 20 To view the structure of the created table, Describe (DESC) command is used. 21 A table and all of its record can be deleted with the DROPcommand. 22 Select statement inn SQL is used query or retrieve data from the table in the database. 23 Count function returns the number of rows. 24 Aggregate function are used to perform mathematical operations on relationa database. 25 NULL values represents missing or unknown data. 26 A Trigger is PL/SQL block structure which is fired when a DML statement is exceuted on a da 27 Inner joins only returns those record from both the joined tables satifying join condition. 28 The process of extracting data from a database is called data retrieval 29 A work or set of logical work perform on database data is called as transaction