Home - Technical Questions - Database

Database Online Exam Quiz

Important questions about Database. Database MCQ questions with answers. Database exam questions and answers for students and interviews.

2. A proxy server is used for which of the following?

Options

A : To provide security against unauthorized users

B : To process client requests for Web pages

C : To process client requests for database access

D : To provide TCP/IP

3. The benefits of object-oriented modeling are which of the following?

Options

A : The ability to tackle more challenging problems

B : Reusability of analysis, design, and programming results

C : Improved communication between users, analysts, etc.

D : All of the above.

4. A collection of interrelated records is called a

Options

A : Datasheet

B : Spreadsheet

C : Database

D : Utility File

5. When mapping a supertype/subtype relationship which of the following is true?

Options

A : The supertype primary key is assigned to each subtype.

B : The subtype primary key is assigned to each supertype.

C : There is no link between the supertype/subtype entities.

D : There is no primary key/foreign key relationship between a supertype/subtype.

6. With this type of SQL Server cursor concurrency no lock is obtained until the user updates the data.

Options

A : READ_ONLY

B : SCROLL_LOCK

C : OPTIMISTIC

D : PESSIMISTIC

7. For every relationship, how many possible types of actions are there when enforcing minimum cardinalities?

Options

A : Two

B : Three

C : Four

D : Six

8. A shared database should:

Options

A : be accurate and available.

B : provide for backup and recovery.

C : be secure.

D : All of the above.

9. A transitive dependency is which of the following?

Options

A : A functional dependency between two or more key attributes.

B : A functional dependency between two or more nonkey attributes.

C : A relation that is in first normal form.

D : A relation that is in second normal form.

10. It is necessary to sort a file before searching a particular item

Options

A : True

B : False

C : May or may not be true

D : None of the above

1. Parenthesis is never required in Postfix or Prefix expressions

Options

A : TRUE

B : FALSE

C :

D :

2. Which type of entity is related to two or more associated entities that each contain specialized attributes that apply to some but not all of the instances of the entity?

Options

A : Supertype entity

B : Subtype entity

C : Archetype entity

D : Instance entity

3. To eliminate definition duplication, XML Schemas define:

Options

A : an intersection table.

B : global elements.

C : a normalized definition table.

D : None of the above is correct.

5. The HAVING clause does which of the following?

Options

A : Acts like a WHERE clause but is used for groups rather than rows.

B : Acts like a WHERE clause but is used for rows rather than columns.

C : Acts like a WHERE clause but is used for columns rather than groups.

D : Acts EXACTLY like a WHERE clause.

7. If a table has been normalized so that all determinants are candidate keys, then that table is in:

Options

A : 1NF

B : 2NF

C : 3NF

D : BCNF

9. Legacy data is which of the following?

Options

A : Data contained in a newly-installed system

B : Data rejected during the installation of a new system

C : Data contained in a file system

D : Data contained by a system used prior to the installation of a new system

10. The command to eliminate a table from a database is

Options

A : REMOVE TABLE CUSTOMER;

B : UPDATE TABLE CUSTOMER;

C : DELETE TABLE CUSTOMER;

D : DROP TABLE CUSTOMER;

1. Which of the following describes a relational database?

Options

A : It retrieves data related to its queries

B : It provides a relationship between floats

C : It provides a relationship between integers

D : It consists of separate tables or related data

2. An entity is a thing in the real world with an independent existence.

Options

A : TRUE

B : FALSE

C :

D :

3. In the relational model, relationships between relations or tables are created by using:

Options

A : composite keys.

B : determinants.

C : candidate keys.

D : foreign keys.

4. A transaction for which all committed changes are permanent is called:

Options

A : atomic.

B : consistent.

C : isolated.

D : durable.

Technical Questions more Online Exam Quiz

Copyright © 2021
Exam-GK-MCQ-Questions.Com | Contact Us | Privacy Policy | Terms of Use | Sitemap | 0.02016806602478