Question - 1
Which is the below language is not present in DBMS?
Answer- C
Question - 2
What are the ACID properties in DBMS?
- Atomicity, Consistency, Isolation, Durability
- Atomicity, Concurrent, Isolation, Durability
- Atutomatic, Concurrent, Isolation, Durability
- None of the above
Solutions
Answer- A
Question - 3
What does ACID do in DBMS?
- transaction
- rollback
- locking the rows
- None of these above
Solutions
Answer- A
Question - 4
What does First Normal Form (1NF) do in DBMS?
- No repeating groups within rows
- Every non-key (supporting) column value is dependent on the whole primary key.
- Dependent solely on the primary key and no other non-key (supporting) column value.
- None of these
Solutions
Answer- A
Question - 5
- The unique key is similar to the primary key, but allows NULL values in the column
- The unique key is similar to the primary key, but does not allows NULL values in the column
- The unique key is similar to the primary key, but does not allows 0 values in the column
- None of the above
Solutions
Answer- A
Question - 6
‘AS’ clause is used in SQL for
- Selection operation
- Rename operation
- Join operation
- Projection operation
Solutions
Answer- B
Question - 7
An attribute that is not part of any candidate key is known as
- sub-prime attribute
- sub-candidate key
- non-prime attribute
- non-candidate key
Solutions
Answer- C
Question - 8
- Object Database Connectivity
- Open Database Connectivity
- Oracle Database Connectivity
- None of the above
Solutions
Answer- B
Question - 9
Which of the follow is not the degree of relationship?
- Binary
- Single
- Ternary
- n-ary
Solutions
Answer- B
Question - 10
Architecture of the database can be viewed as
- two levels
- two levels
- three levels
- four levels
Solutions
Answer- C
Question - 11
How many rules in 'CODD’S RULES of Relational Model of database systems?
Answer- B
Question - 12
In a relational model, relations are termed as
- Tuples
- Attributes
- Tables
- Rows
Solutions
Answer- C
Question - 13
Every attribute has some predefined value scope that is called
- Tuple
- Tables
- Attribute domain
- Relation schema
Solutions
Answer- C
Question - 14
The database schema is written in
- DDL
- DML
- DCL
- None of the above
Solutions
Answer- A
Question - 15
An attribute of a table cannot hold multiple values is the property of
- First normal form (1NF)
- Second normal form (2NF)
- Third normal form (3NF)
- Fourth normal form (4NF)
Solutions
Answer- A
Question - 16
In the architecture of a database system external level is the
- view level
- conceptual level
- logical level
- physical level
Solutions
Answer- A
Question - 17
In hierarchical model, data is organized into
- logical structure
- physical structure
- tree like structure
- none of the above
Solutions
Answer- C
Question - 18
An entity set that does not have sufficient attributes to form a primary key is a
- weak entity set
- simple entity set
- primary entity set
- strong entity set
Solutions
Answer- A
Question - 19
The key selected from the sets of candidate keys by database designer is called
- Primary key
- Secondary Key
- Foreign key
- Super key
Solutions
Answer- A
Question - 20
In an E-R diagram attributes are represented by
- rectangle
- square
- ellipse
- triangle
Solutions
Answer- C
Practice more set questions