Which of the following is NOT the valid data type in SQL?

• A) Money
• B) Text
• C) Smallint
• D) Capitalint

Which of the following is NOT related to partitioning and placement in database?

• A) Balance workload
• B) Speed up the rate of useful work
• C) Speed up data transmission
• D) Reduce workload

In vertical partitioning if we divide a table into two vertical partitions, then efficiency of those applications which __________ will be reduced .

• A) Access data from second vertical partition
• B) Access data from first vertical partition.
• C) Access data from both the vertical partitions.
• D) Access data from relations

SQL stand for?

• A) Standard query language
• B) Structure query list
• C) Standard query list
• D) Structure query language

Denormalization is required to enhance _________.

• A) Sharing of data
• B) Performance
• C) Data communication
• D) Data transmission

Which of the following is a correct syntax of selecting all the columns from a table called PERSONS?

• A) SELECT WHERE * Persons
• B) SELECT * WHERE Persons
• C) SELECT * FROM Persons
• D) SELECT FROM * Persons

Identify the language which is used to specify database schema.

• A) DCL
• B) DDL
• C) DML
• D) TCL

Which of the following is NOT the purpose of SQL?

• A) Read information
• B) Remove information
• C) Transmission of information
• D) Write information

In vertical partitioning which of the following key is repeated in all vertical partitions of a table, to get the original table?

• A) Unique key
• B) Foreign key
• C) Primary key
• D) Secondary key

General reasoning for horizontal or vertical partitioning is _________.

• A) Decreasing the query response time
• B) Increase data communication
• C) Increasing the consistency
• D) Smaller tables are more efficient to process as compared to the larger tables.

The maximum length for an identifier can be __________.

• A) 192 characters
• B) 128 characters
• C) 256 characters
• D) 512 characters

Replication is the form of_______.

• A) Relational calculus
• B) Partitioning
• C) Normalization
• D) Denormalization

Indexes are built on _________to improve query performance.

• A) Tables
• B) Columns
• C) Relationships
• D) Records

Which of the following is NOT related to data manipulation language?

• A) Insertion of information
• B) Retrieval of information
• C) Modification to the information
• D) Control access to the information

A fully normalized database schema can fail to provide applicable system response time due to ________.

• A) Removal of redundant data
• B) Excessive table join operations
• C) Excessive query execution
• D) Use of sub queries

Which of the following is one of the purposes of using DDL commands?

• A) creating and destroying databases
• B) updating records into databases
• C) manipulating databases
• D) inserting records into databases

Denormalization process is applied for developing a physical data model from_______.

• A) A semantic data model
• B) A conceptual form
• C) A logical data model
• D) An object oriented data model

In which of the following situation clustering is more suitable _______.

• A) Relatively dynamic situations
• B) Relatively static situations
• C) Where efficiency does not matter
• D) Access of data is not frequent

Which of the following is NOT the type of horizontal partitioning?

• A) List Petitioning
• B) Limit partitioning
• C) Range Petitioning
• D) Hash Petitioning

There are -------------- types of user interfaces.

• A) One
• B) three
• C) two
• D) four