Oracle DB/Oracle DB Mcq Question Set 3 Sample Test,Sample questions

Question:
 A Key which is a set of one or more columns that can identify a record uniquely is called?

1.Natural key

2.Candidate key

3.Not Null key

4. Alternate key


Question:
 A ____ normal form normalization will be needed where all attributes in a relation tuple are not functionally dependent only on the key attribute.

1.First

2.Second

3.Third

4.Third


Question:
 E-R model uses this symbol to represent weak entity set ?

1. Dotted rectangle

2.Diamond

3.Doubly outlined rectangle

4.None of the mentioned


Question:
 Identify the criteria for designing database from the point of view of user

1.No redundancy

2.No inapplicable attributes

3.Uniformity in naming & definitions of the data items

4.All of the Mentioned


Question:
 The three language components of a database management system (DBMS) like DDL, DCL, DML.
Two different types of people (users and practitioners) are concerned with them. Which of them do users of a DBMS usually deal with?

1.DDL

2.DML

3.DDL and DCL

4.DCL and DML


Question:
A Foreign key is combined with a foreign key creates

1.Parent child relationship between the tables that connect them

2.Many-Many relationship between the tables that connect them

3.Network model between the tables that connect them

4.None of the Mentioned


Question:
A relational database developer refers to a record as

1. A criteria

2. A relation

3. A tuple

4.An attribute


Question:
A table is in 3NF if it is in 2NF and if it has no ______

1.Functional Dependencies

2.Transitive Dependencies

3.Trivial Functional Dependency

4.Multivalued Dependencies


Question:
A table is in BCNF if it is in 3NF and if every determinant is a ______ key.

1.Dependent

2.Normal

3.Candidate

4.Both Normal and Candidate


Question:
A table that displays data redundancies yields ________anomalies.

1. Update

2. Insertion

3. Deletion

4. All of the mentioned


Question:
A transaction completes its execution is said to be

1.Committed

2.Aborted

3.Rolled back

4. Failed


Question:
A type of query that is placed within a WHERE or HAVING clause of another query is called

1.Master query

2.Sub query

3. Super query

4.Multi-query


Question:
A ____ key is a minimal super key

1.Primary

2.Foreign

3.Candidate

4.Non-Prime


Question:
A ___________ is an indirect functional dependency, one in which X->Z only by virtue of X->Y and Y->Z.

1.Multivalued Dependencies

2.Join Dependency

3.Trivial Functional Dependency

4.Transitive Dependencies


Question:
An aggregation association is drawn using which symbol:

1.a line which loops back onto the same table

2.small closed diamond at the end of a line connecting two tables

3.small open diamond at the end of a line connecting two tables

4.small triangle at the end of a line connecting the aggregated item and multiple component items


Question:
An n-array relationship is drawn using which symbol:

1.A diamond

2.A line with arrows showing direction

3.A line without arrows showing direction

4.A rectangle


Question:
Anomalies are avoided by splitting the offending relation into multiple relations, is also known as

1.Accupressure

2.Decomposition

3.Precomposition

4. Both Decomposition and Precomposition


Question:
By default, which key creates Clustered index?

1.Foreign Key

2.Unique Key

3.Primary Key

4.None of the mentioned


Question:
DCL stands for :

1. Data Control Language

2.Data Console Language

3.Data Console Level

4. Data Control Level


Question:
Every constraint on the table is a logical consequence of the table’s

1. Fourth normal form

2.Fifth normal form

3.Domain/key normal form

4.None of the mentioned


Question:
Every time attribute A appears, it is matched with the same value of attribute B, but not the same value of attribute C. Therefore, it is true that:

1.A -> B

2.A -> C

3.A -> (B,C)

4. (B,C) -> A


Question:
How can a SQL developer add a key on a table?

1.While creating a table

2. With Alter table command

3.With SQL server Properties window

4.All of the Mentioned


Question:
In a database, a foreign key is ?

1. A data element/attribute within a data field of a data record that is not unique, and cannot be used to distinguish one data record in a database from another data record within a database table

2.A data element/attribute within a data field of a data record within a database table that is a secondary key in another database table

3.A data element/attribute within a data field of a data record within a database table that is a primary key in another database table

4.A data element/attribute within a data field of a data record that enables a database to uniquely distinguish one data record in a database from another data record within a database table


Question:
In a given relationship R, if an attribute A uniquely defines all other attributes, then the attribute A is a key attribute which is also known as the _________ key.

1. Candidate

2. Join

3.Functional

4.None of the mentioned


Question:
In an E-R diagram an entity set is represent by a

1. Rectangle

2.Ellipse

3.Diamond box

4.Circle


Question:
In an SQL statement, which of the following parts states the conditions for row selection?

1. Where

2. From

3.Order By

4.Group By


Question:
In SQL, which command is used to add new rows to a table?

1.Alter Table

2.Add row

3.Insert

4.Append


Question:
In SQL, which command(s) is(are) used to change a table’s storage characteristics?

1. ALTER TABLE

2.MODIFY TABLE

3.CHANGE TABLE

4.All of the Mentioned


Question:
In SQL, which of the following is not a data definition language commands?

1.RENAME

2.REVOKE

3.GRANT

4.Update


Question:
In SQL, which of the following is not a data Manipulation Language Commands?

1. Delete

2.Truncate

3.Update

4.Create


Question:
SQL has how many main commands for DDL:

1.1

2.2

3.3

4.4


Question:
Stack is also called _____

1.First In First Out (LIFO)

2.Last In First Out (FIFO)

3. First In Last Out (FILO)

4. First Come First Served (FCFS)


Question:
TCL stands for:

1.Transaction control languages

2.Transaction command languages

3.Transaction connect languages

4.Transaction connect languages


Question:
The language used application programs to request data from the DBMS is referred to as _____

1.DML

2. DDL

3.Query language

4. All of the mentioned


Question:
The relational model feature is that there

1. is no need for primary key data

2. is much more data independence than some other database models

3.are explicit relationships among records

4.are tables with many dimensions


Question:
The relational model is based on the concept that data is organized and stored in two-dimensional tables called _______

1.Fields

2.Records

3.Relations

4.Keys


Question:
The ____ normalization introduced by Chris Date, Hugh Darwen, and Nikos Lorentzos.

1.Third

2.Fourth

3.Fifth

4. Sixth


Question:
TRUNCATE statement in SQL is a –

1.DML statement

2.DDL statement

3.DCL statement

4.TCL statement


Question:
What is the full form of SQL?

1.Structured Query Language

2. Structured Query List

3. Simple Query Language

4.None of the Mentioned


Question:
What is true about Unique and primary key?

1.Unique can have multiple NULL values but Primary can’t have.

2.Unique can have single NULL value but Primary can’t have even single.

3.Both can have duplicate values

4. none of the mentioned


Question:
When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n):

1. Transitive Dependency

2.Insertion Anomaly

3.Referential Integrity Constraint

4.Normal Form


Question:
Which command allows the removal of all rows from a table but flushes a table more efficiently since no rollback information is retained:

1. TRUNCATE command

2.Create command

3. Drop table command

4.Alter table command


Question:
Which command defines its columns, integrity constraint in create table:

1.Create command

2. Drop table command

3.Alter table command

4.All of the mentioned


Question:
Which command is used for removing a table and all its data from the database:

1. Create command

2.Drop table command

3.Alter table command

4.All of the Mentioned


Question:
Which key accepts multiple NULL values?

1. Foreign Key

2. Unique Key

3.Primary Key

4.None of the mentioned


Question:
Which of the following is not a restriction for a table to be a relation?

1.The cells of the table must contain a single value

2.All of the entries in any column must be of the same kind

3.The columns must be ordered

4.No two rows in a table may be identical


Question:
Which of the following statements is not correct?

1. The primary key must be unique for a given table

2.Specifying a zero (0) for the lower bound for the association multiplicity on a class diagram indicates that the item is required

3.Specifying a one (1) for the lower bound for the association multiplicity on a class diagram indicates that the item is required

4.Most databases allow multiple records that are identical


Question:
_____clause is an additional filter that is applied to the result.

1. Select

2.Group-by

3.Having

4.Order by


Question:
______ defines rules regarding the values allowed in columns and is the standard mechanism for enforcing database integrity.

1.Column

2. Constraint

3. Index

4. Trigger


Question:
______commands in SQL allow controlling access to data within database.

1.Database

2.Data

3.Data control

4. All of the mentioned


More MCQS

  1. Oracle DB Mcq Question Set 1
  2. Oracle DB Mcq Question Set 2
  3. Oracle DB Mcq Question Set 3
  4. Oracle DB Mcq Question Set 4
  5. Oracle DB Mcq Question Set 5
  6. Oracle DB Mcq Question Set 6
Search
R4R Team
R4Rin Top Tutorials are Core Java,Hibernate ,Spring,Sturts.The content on R4R.in website is done by expert team not only with the help of books but along with the strong professional knowledge in all context like coding,designing, marketing,etc!