In a relational schema, each tuple is divided into fields called

Question

In a relational schema, each tuple is divided into fields called

A. Relations

B. Queries

C. Domains

D. All of the above

Share this question with your friends

Show all DBMS MCQ

Comment

Manager salary details are hidden from the employee .This is

A. Conceptual level data hiding.

B. External level data hiding.

C. Physical level data hiding.

D. None of these.

Discuss this answer

_____is a full form of SQL.

A. Standard query language

B. Sequential query language

C. Structured query language

D. Server side query language

Discuss this answer

A _____ is a logical unit of database processing that includes one or more data access operations that can include insertion, deletion, modification or retrieval operations.

A. Database

B. Data

C. Transaction

D. Record

Discuss this answer

E-R Modeling is achieved by using ____ diagrams

A. DFD

B. Flowcharts

C. Gantt Charts

D. E-R

Discuss this answer

_____ is a utility to capture a continuous record of server activity and provide auditing capability.

A. SQL server Profile

B. SQL server wizard.

C. SQL server service manager

D. SQL server setup

Discuss this answer

Shadow paging has

A. no redo

B. no undo

C. redo but no undo

D. neither redo nor undo

Discuss this answer

The _______ is a set of programs to use and / or modify this data.

A. DBMS

B. System

C. Program

D. Software

Discuss this answer

The cost of reading and writing temporary files while evaluating a query can be reduced by

A. building indices

B. pipelining

C. join ordering

D. none of the above

Discuss this answer

If two relations R and S are joined, then the non matching tuples of both R and S are ignored in

A. left outer join

B. right outer join

C. full outer join

D. inner join

Discuss this answer

Employees in a company are each assigned their own office, i.e. for each employee there exists a unique office and for each office there exists a unique employee; This statement is an example of ____ type of relation.

A. 1:1

B. 1: Many

C. Many: One

D. Many : Many

Discuss this answer

Which of the following is not a consequence of non-normalized database?

A. Update Anomaly

B. Insertion Anomaly

C. Redundancy

D. Lost update problem

Discuss this answer

DBMS helps achieve

A. Centralized control of data

B. Data independence

C. Both A and B

D. Neither A nor B

Discuss this answer

What are the desirable properties of a decomposition

A. Partition constraint.

B. Dependency preservation.

C. Redundancy.

D. Security.

Discuss this answer

Checkpoints are a part of

A. Recovery measures.

B. Security measures.

C. Concurrency measures.

D. uthorization measures.

Discuss this answer

Relational Algebra does not have

A. Selection operator.

B. Projection operator.

C. Aggregation operators.

D. Division operator.

Discuss this answer

Which of the syntax is correct for insert statement?
i) insert into values
ii) insert into (column list) values

A. i-only

B. ii-only

C. Both of them

D. None of them

Discuss this answer

The normal form that is not necessarily dependency preserving is

A. 2NF

B. 3NF

C. BCNF

D. 4NF

Discuss this answer

In E-R Diagram total participation is represented by

A. Double lines

B. Single line

C. Dashed lines

D. Triangle

Discuss this answer

A DBMS is a ____ user if at most one user can use the system and is mostly restricted to personal computer systems.

A. None

B. Multi

C. Single

D. Concurrent

Discuss this answer

The rule that a value of a foreign key must appear as a value of some specific table is called a

A. Referential constraint.

B. Index.

C. Integrity constraint.

D. Functional dependency.

Discuss this answer

Between DRAM and magnetic disk storage another form of memory, called ______ memory is becoming common because it is non volatile.

A. RAM

B. Flash

C. Hard Disk

D. Secondary

Discuss this answer

Change Staff table by removing default of Assistant for position column

A. ALTER TABLE Staff ALTER position DROP DEFAULT;

B. ALTER TABLE Staff ALTER position DEFAULT;

C. ALTER TABLE Staff ALTER DROP DEFAULT;

D. MODIFY Staff ALTER position DROP DEFAULT;

Discuss this answer

The ____ operator joins two or more conditions and displays rows only if that rows data satisfies all conditions specified.

A. OR

B. AND

C. NOT

D. ALL

Discuss this answer

Precedence graphs help to find a

A. Serializable schedule.

B. Recoverable schedule.

C. Deadlock free schedule.

D. Cascadeless schedule.

Discuss this answer

A weak entity has an ______ dependency on its owner entity, which can be used for both ON UPDATE and ON DELETE.

A. Direct

B. Indirect

C. Existence

D. No

Discuss this answer

Data items grouped together for storage purposes are called a

A. record

B. string

C. title

D. list

Discuss this answer

The clause in SQL that specifies that the query result should be sorted in ascending or descending order based on the values of one or more columns is

A. View

B. Order by

C. Group by

D. Having

Discuss this answer

In SQL, testing whether a subquery is empty is done using

A. DISTINCT

B. UNIQUE

C. NULL

D. EXISTS

Discuss this answer

Tree structures are used to store data in

A. Network model.

B. Relational model.

C. Hierarchical model.

D. File based system.

Discuss this answer

The normalization was first proposed by .

A. Code

B. Codd

C. Boyce Codd

D. Boyce

Discuss this answer

Accepted Answer

A. Relations

In a relational schema, each tuple is divided into fields called

Correct Answer :

Show all DBMS MCQ

Related Questions

Manager salary details are hidden from the employee .This is

_____is a full form of SQL.

A _____ is a logical unit of database processing that includes one or more data access operations that can include insertion, deletion, modification or retrieval operations.

E-R Modeling is achieved by using ____ diagrams

_____ is a utility to capture a continuous record of server activity and provide auditing capability.

Shadow paging has

The _______ is a set of programs to use and / or modify this data.

The cost of reading and writing temporary files while evaluating a query can be reduced by

If two relations R and S are joined, then the non matching tuples of both R and S are ignored in

Employees in a company are each assigned their own office, i.e. for each employee there exists a unique office and for each office there exists a unique employee; This statement is an example of ____ type of relation.

Which of the following is not a consequence of non-normalized database?

DBMS helps achieve

What are the desirable properties of a decomposition

Checkpoints are a part of

Relational Algebra does not have

Which of the syntax is correct for insert statement?
i) insert into values
ii) insert into (column list) values

The normal form that is not necessarily dependency preserving is

In E-R Diagram total participation is represented by

A DBMS is a ____ user if at most one user can use the system and is mostly restricted to personal computer systems.

The rule that a value of a foreign key must appear as a value of some specific table is called a

Between DRAM and magnetic disk storage another form of memory, called ______ memory is becoming common because it is non volatile.

Change Staff table by removing default of Assistant for position column

The ____ operator joins two or more conditions and displays rows only if that rows data satisfies all conditions specified.

Precedence graphs help to find a

A weak entity has an ______ dependency on its owner entity, which can be used for both ON UPDATE and ON DELETE.

Data items grouped together for storage purposes are called a

The clause in SQL that specifies that the query result should be sorted in ascending or descending order based on the values of one or more columns is

In SQL, testing whether a subquery is empty is done using

Tree structures are used to store data in

The normalization was first proposed by .

Also checkout

In a relational schema, each tuple is divided into fields called

Correct Answer :

Show all DBMS MCQ

Related Questions

Manager salary details are hidden from the employee .This is

_____is a full form of SQL.

A _____ is a logical unit of database processing that includes one or more data access operations that can include insertion, deletion, modification or retrieval operations.

E-R Modeling is achieved by using ____ diagrams

_____ is a utility to capture a continuous record of server activity and provide auditing capability.

Shadow paging has

The _______ is a set of programs to use and / or modify this data.

The cost of reading and writing temporary files while evaluating a query can be reduced by

If two relations R and S are joined, then the non matching tuples of both R and S are ignored in

Employees in a company are each assigned their own office, i.e. for each employee there exists a unique office and for each office there exists a unique employee; This statement is an example of ____ type of relation.

Which of the following is not a consequence of non-normalized database?

DBMS helps achieve

What are the desirable properties of a decomposition

Checkpoints are a part of

Relational Algebra does not have

Which of the syntax is correct for insert statement? i) insert into values ii) insert into (column list) values

The normal form that is not necessarily dependency preserving is

In E-R Diagram total participation is represented by

A DBMS is a ____ user if at most one user can use the system and is mostly restricted to personal computer systems.

The rule that a value of a foreign key must appear as a value of some specific table is called a

Between DRAM and magnetic disk storage another form of memory, called ______ memory is becoming common because it is non volatile.

Change Staff table by removing default of Assistant for position column

The ____ operator joins two or more conditions and displays rows only if that rows data satisfies all conditions specified.

Precedence graphs help to find a

A weak entity has an ______ dependency on its owner entity, which can be used for both ON UPDATE and ON DELETE.

Data items grouped together for storage purposes are called a

The clause in SQL that specifies that the query result should be sorted in ascending or descending order based on the values of one or more columns is

In SQL, testing whether a subquery is empty is done using

Tree structures are used to store data in

The normalization was first proposed by .

Also checkout

Which of the syntax is correct for insert statement?
i) insert into values
ii) insert into (column list) values