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
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
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
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
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
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
A relational database developer refers to a record as
1. A criteria
2. A relation
3. A tuple
4.An attribute
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
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
A table that displays data redundancies yields ________anomalies.
1. Update
2. Insertion
3. Deletion
4. All of the mentioned
A transaction completes its execution is said to be
1.Committed
2.Aborted
3.Rolled back
4. Failed
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
A ____ key is a minimal super key
1.Primary
2.Foreign
3.Candidate
4.Non-Prime
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
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
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
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
By default, which key creates Clustered index?
1.Foreign Key
2.Unique Key
3.Primary Key
4.None of the mentioned
DCL stands for :
1. Data Control Language
2.Data Console Language
3.Data Console Level
4. Data Control Level
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
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
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
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
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
In an E-R diagram an entity set is represent by a
1. Rectangle
2.Ellipse
3.Diamond box
4.Circle
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
In SQL, which command is used to add new rows to a table?
1.Alter Table
2.Add row
3.Insert
4.Append
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
In SQL, which of the following is not a data definition language commands?
1.RENAME
2.REVOKE
3.GRANT
4.Update
In SQL, which of the following is not a data Manipulation Language Commands?
1. Delete
2.Truncate
3.Update
4.Create
SQL has how many main commands for DDL:
1.1
2.2
3.3
4.4
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)
TCL stands for:
1.Transaction control languages
2.Transaction command languages
3.Transaction connect languages
4.Transaction connect languages
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
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
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
The ____ normalization introduced by Chris Date, Hugh Darwen, and Nikos Lorentzos.
1.Third
2.Fourth
3.Fifth
4. Sixth
TRUNCATE statement in SQL is a –
1.DML statement
2.DDL statement
3.DCL statement
4.TCL statement
What is the full form of SQL?
1.Structured Query Language
2. Structured Query List
3. Simple Query Language
4.None of the Mentioned
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
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
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
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
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
Which key accepts multiple NULL values?
1. Foreign Key
2. Unique Key
3.Primary Key
4.None of the mentioned
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
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
_____clause is an additional filter that is applied to the result.
1. Select
2.Group-by
3.Having
4.Order by
______ 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
______commands in SQL allow controlling access to data within database.
1.Database
2.Data
3.Data control
4. All of the mentioned