Olete.in – MCQs, Mock Tests & Government Job Prep | Oracle DB Oracle DB Mcq Question Set 3

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

✅ Correct Answer: 3

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

1. Third
2. Fourth
3. Fifth
4. Sixth

✅ Correct Answer: 4

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

✅ Correct Answer: 2

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

✅ Correct Answer: 3

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

✅ Correct Answer: 4

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

✅ Correct Answer: 1

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

✅ Correct Answer: 2

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

✅ Correct Answer: 1

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

✅ Correct Answer: 3

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

✅ Correct Answer: 3

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

✅ Correct Answer: 4

A ____ key is a minimal super key

1. Primary
2. Foreign
3. Candidate
4. Non-Prime

✅ Correct Answer: 3

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

✅ Correct Answer: 2

By default, which key creates Clustered index?

1. Foreign Key
2. Unique Key
3. Primary Key
4. None of the mentioned

✅ Correct Answer: 3

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

✅ Correct Answer: 2

Which key accepts multiple NULL values?

1. Foreign Key
2. Unique Key
3. Primary Key
4. None of the mentioned

✅ Correct Answer: 1

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

✅ Correct Answer: 1

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

✅ Correct Answer: 2

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

✅ Correct Answer: 3

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

1. Rectangle
2. Ellipse
3. Diamond box
4. Circle

✅ Correct Answer: 1

A relational database developer refers to a record as

1. A criteria
2. A relation
3. A tuple
4. An attribute

✅ Correct Answer: 3

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

✅ Correct Answer: 2

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

✅ Correct Answer: 3

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

✅ Correct Answer: 3

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

✅ Correct Answer: 4

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

✅ Correct Answer: 2

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

✅ Correct Answer: 3

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

✅ Correct Answer: 1

What is the full form of SQL?

1. Structured Query Language
2. Structured Query List
3. Simple Query Language
4. None of the Mentioned

✅ Correct Answer: 1

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

✅ Correct Answer: 1

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

1. RENAME
2. REVOKE
3. GRANT
4. Update

✅ Correct Answer: 1

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

1. Select
2. Group-by
3. Having
4. Order by

✅ Correct Answer: 3

______ 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

✅ Correct Answer: 2

SQL has how many main commands for DDL:

1. 1
2. 2
3. 3
4. 4

✅ Correct Answer: 3

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

✅ Correct Answer: 1

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

✅ Correct Answer: 2

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

✅ Correct Answer: 1

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

✅ Correct Answer: 1

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

1. Delete
2. Truncate
3. Update
4. Create

✅ Correct Answer: 2

TRUNCATE statement in SQL is a –

1. DML statement
2. DDL statement
3. DCL statement
4. TCL statement

✅ Correct Answer: 2

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

1. Alter Table
2. Add row
3. Insert
4. Append

✅ Correct Answer: 3

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)

✅ Correct Answer: 3

A table that displays data redundancies yields ________anomalies.

1. Update
2. Insertion
3. Deletion
4. All of the mentioned

✅ Correct Answer: 4

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

✅ Correct Answer: 2

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

✅ Correct Answer: 2

DCL stands for :

1. Data Control Language
2. Data Console Language
3. Data Console Level
4. Data Control Level

✅ Correct Answer: 1

TCL stands for:

1. Transaction control languages
2. Transaction command languages
3. Transaction connect languages
4. Transaction connect languages

✅ Correct Answer: 1

______commands in SQL allow controlling access to data within database.

1. Database
2. Data
3. Data control
4. All of the mentioned

✅ Correct Answer: 3

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

✅ Correct Answer: 1

A transaction completes its execution is said to be

1. Committed
2. Aborted
3. Rolled back
4. Failed

✅ Correct Answer: 1