Question Number 1 STUDENT ======= STUDENT ID STUDENT Name COURSE ID COURSES ============ Course ID Course Name What type of relationship exists between the Student table and the Course table? Choice 1 Product - Many Manufacturer - Many Choice 2 Product - One or Many Manufacturer - One or Many Choice 3 Product - Many Manufacturer - One Choice 4 Product - One Manufacturer - One Choice 5 Product - One Manufacturer - Many ------------------------------------------------------------ Question Number 2 If you do not want your developers to view the table structures but still allow update operations what type of structure will you deploy? Choice 1 Cursor table Choice 2 Table filter Choice 3 Dynamic procedure Choice 4 View Choice 5 Summary table ------------------------------------------------------------ Question Number 3 What Does ACID stand for? Choice 1 atomicity, constant, isolation, durability Choice 2 atomicity, consistency, isolation, duration Choice 3 atomicity, consistency, isolation, durability Choice 4 atomicity, consistency, indexing, durability Choice 5 atomicity, constant, indexing, durability ------------------------------------------------------------ Question Number 4 In a Left Outer Join what will be the output when there is NO match between the tables? Choice 1 The left table will return ALL rows. Choice 2 The left table will return NULL. Choice 3 Both tables will return NULL. Choice 4 The right table will return ALL rows. Choice 5 The right table will return NULL. ------------------------------------------------------------ Question Number 5 What is tuple? Choice 1 Database Structure Choice 2 A record in table Choice 3 Table Structure Choice 4 Operation on Table Choice 5 Table's Unique Key ------------------------------------------------------------ Question Number 6 Which one of the following is NOT a characteristic of metadata? Choice 1 Data about data Choice 2 Describes a data dictionary Choice 3 Self-describing Choice 4 Includes user data Choice 5 Supports its own structure ------------------------------------------------------------ Question Number 7 What capabilities do you expect in an RDBMS? Choice 1 Encryption key management Choice 2 Graphical User Interface Widgets Choice 3 Thread creation, execution, & coordination Choice 4 Network socket creation/operation Choice 5 If/Then, for, do/while statements ------------------------------------------------------------ Question Number 8 What one to one relationship indicate? Choice 1 More entities are needed. Choice 2 The model should be denormalized. Choice 3 The tables are not properly indexed. Choice 4 The model cannot be implemented physically. Choice 5 More attributes are needed. ------------------------------------------------------------ Question Number 9 For de-normalization you have implemented redundant columns. Which RDBMS feature you should implement to prevent repeated columns from getting out of sync? Choice 1 Cursors Choice 2 Constraints Choice 3 Views Choice 4 Stored procedures Choice 5 Trigger ------------------------------------------------------------ Question Number 10 What clause or command you should use in the query to avoid a costly tablescan? Choice 1 GROUP BY clause Choice 2 INDEX command Choice 3 HAVING clause Choice 4 FROM clause Choice 5 WHERE clause
Friend ,validate the answers..if any mistakes, let me know...Answers are given in Red color: Question Number 1 PRODUCT ======= Product ID Product Description Manufacturer ID MANUFACTURER ============ Manufacturer ID Manufacturer Name Referring to the above table, what type of relationship exists between the Product table and the Manufacturer table? Choice 1 Product - Many Manufacturer - Many Choice 2 Product - One or Many Manufacturer - One or Many Choice 3 Product - Many Manufacturer - One Choice 4 Product - One Manufacturer - One Choice 5 Product - One Manufacturer - Many ------------------------------------------------------------ Question Number 2 You are writing a database application to run on your DBMS. You do not want your users to be able to view the underlying table structures. At the same time you want to allow certain update operations. Referring to the above scenario, what structure will you deploy? Choice 1 Cursor table Choice 2 Table filter Choice 3 Dynamic procedure Choice 4 View Choice 5 Summary table ------------------------------------------------------------ Question Number 3 You are defining the operational process of your RDBMS. Referring to the scenario above, which one of the following is a valid ongoing "operational process?" Choice 1 OS requirement Choice 2 User analysis Choice 3 Performance monitoring Choice 4 Data dictionary specification Choice 5 System requirement ------------------------------------------------------------ Question Number 4 You have been asked to construct a query in the company's RDBMS. You have deployed a Right Outer Join operation. Referring to the scenario above, what will happen to the final results when there is NO match between the tables? Choice 1 The right table will return ALL rows. Choice 2 The right table will return NULL. Choice 3 Both tables will return NULL. Choice 4 The left table will return ALL rows. Choice 5 The left table will return NULL. ------------------------------------------------------------ Question Number 5 Which phase of the data modeling process contains security review? Choice 1 Structure Choice 2 Design issue Choice 3 Data source Choice 4 Storage issue Choice 5 Operational process ------------------------------------------------------------ Question Number 6 Which one of the following is NOT a characteristic of metadata? Choice 1 Data about data Choice 2 Describes a data dictionary Choice 3 Self-describing Choice 4 Includes user data Choice 5 Supports its own structure ------------------------------------------------------------ Question Number 7 Which one of the following capabilities do you expect to see in a majority of RDBMS extensions to ANSI SQL-92? Choice 1 Encryption key management Choice 2 Graphical User Interface Widgets Choice 3 Thread creation, execution, & coordination Choice 4 Network socket creation/operation Choice 5 If/Then, for, do/while statements ------------------------------------------------------------ Question Number 8 What can a mandatory one to one relationship indicate? Choice 1 More entities are needed. Choice 2 The model should be denormalized. Choice 3 The tables are not properly indexed. Choice 4 The model cannot be implemented physically. Choice 5 More attributes are needed. ------------------------------------------------------------ Question Number 9 For performance, you denormalize your database design and create some redundant columns. Referring to the scenario above, what RDBMS construct can you use to automatically prevent the repeated columns from getting out of sync? Choice 1 Cursors Choice 2 Constraints Choice 3 Views Choice 4 Stored procedures Choice 5 Trigger
