Multiple choice questions in RDBMS

shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
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

Last edited by shabbir; 20Jul2004 at 13:04..
0
sundeep's Avatar
Newbie Member
answers
0
coderzone's Avatar, Join Date: Jul 2004
Team Leader
Quote:
Originally Posted by sundeep
answers
Try it yourself.
0
santhosh krishna's Avatar, Join Date: Jul 2009
Newbie Member
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