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
------------------------------------------------------------
Question Number 10
You are running a query against a relational database.
Referring to the scenario above, what clause or command do you use in the query to help 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
 |
07-20-2004, 12:57 PM
|
#1 |
|
Go4Expert Founder
 
Join Date: Jul 2004
Location: On Earth
Posts: 12,516
Thanks: 53
Thanked 276 Times in 215 Posts
Rep Power: 10    |
Multiple choice questions in RDBMS
__________________
MBA Forums | C, Win32, C++, MFC, C# forum | My Blog About Stocks | How to Make Money Online -- Go4Expert - Monthly Article Competition | Subscribe to Go4Expert Monthly Newsletter Last edited by shabbir; 07-20-2004 at 01:04 PM. |
|
|
|
05-18-2006, 03:49 PM
|
#2 |
|
Newbie Member
Join Date: May 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0 |
Re: Multiple choice questions in RDBMS
answers
|
|
|
|
|
05-18-2006, 06:29 PM
|
#3 | |
|
Team Leader
 
Join Date: Jul 2004
Posts: 466
Thanks: 2
Thanked 10 Times in 6 Posts
Rep Power: 7 |
Re: Multiple choice questions in RDBMSQuote:
|
|
|
|
|
|
07-28-2009, 04:17 PM
|
#4 |
|
Newbie Member
Join Date: Jul 2009
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0 |
Re: Multiple choice questions in RDBMS
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 ------------------------------------------------------------ Question Number 10 You are running a query against a relational database. Referring to the scenario above, what clause or command do you use in the query to help 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 [/quote] |
|
|
|
 |
|
More
|
«
Previous Thread
|
Next Thread
»
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
| Bookmarks | |
Linear Mode
|
|
|
|
|||||||||||||||||||||
All times are GMT +5.5. The time now is 05:37 AM.