Quick Revision

GK One-Line Question & Answer

15541+ short questions with short answers, covering every category and sub-category on the site — no long articles to scroll through. Good for a fast recap before an exam, or a few minutes of daily practice.

Looking for exam process/strategy questions instead? Try the Exam Preparation FAQ →

DBMS → Data Models 3

Which of the following has each related entity set has its own schema and there is an additional schema for the relationship set?
A many-to-many relationship set
click to copy
Minimal Superkeys are called
candidate keys
click to copy
Data Manipulation Language (DML) is not to
create information table in the database
click to copy

DBMS → ER Model 3

Fifth Normal form is concerned with
Multivalued dependency
click to copy
Which of the following is not Modification of the Database
sorting
click to copy
Which of the following in true regarding Referential Integrity?
every foreign-key value must match a primary-key value in an associated table
click to copy

DBMS → Relational Model 3

n which of the following, a separate schema is created consisting of that attribute and the primary key of the entity set.
A multivalued attribute of an entity set
click to copy
Which of the following in not Outer join?
all of the options
click to copy
Which of the following option is use to retrieval of data?
query
click to copy

DBMS → Normalization 3

In 2NF
No multivalued dependencies (MVDs) exist
click to copy
Set of premitted values of each attribute is called
domain
click to copy
ODBC stands for ______
open database connection
click to copy

DBMS → Functional Dependency 2

Where is metadata stored in MySQL?
in the mysql database mysql
click to copy
Which of the following is true regarding Null Value?
null<>0
click to copy

DBMS → SQL Basics 2

What MySQL property is used to create a surrogate key in MySQL?
auto_increment
click to copy
Logical design of database is called
database schema
click to copy

DBMS → DDL Commands 2

A Database Management System (DBMS) is:
all options are correct
click to copy
Snapshot of the data in the database at a given instant of time is called
database instance
click to copy

DBMS → DML Commands 2

Which of the following is not a level of data abstraction?
critical level
click to copy
Which of the following is not Unary operation?
union
click to copy

DBMS → Joins 2

Disadvantages of File systems to store data is:
all options are correct
click to copy
Which of the following is not binary operation?
project
click to copy

DBMS → Views 2

In an Entity Relationship Diagram Rectangles represents
entity sets
click to copy
Which of the following is correct regarding Aggregate functions?
it takes a list of values and return a single values as result
click to copy

DBMS → Indexes 2

Which of the following is not a Storage Manager Component?
logical manager
click to copy
The Primary key must be
option a and b
click to copy

DBMS → Transactions 2

Data Manipulation Language enables users to
all the options are correct
click to copy
A command to remove a relation from an SQL database
drop table
click to copy

DBMS → Concurrency Control 2

Which of the following is not an Schema?
critical schema
click to copy
which of the following is not an Aggregate function?
select
click to copy

DBMS → Deadlock 2

Which of the following is Database Language?
all of the options
click to copy
The attribute that can be divided into other attributes is called
composite attribute
click to copy

DBMS → Database Security 2

Which of the following in not a function of DBA?
network maintenance
click to copy
What is ACID properties of Transactions?
atomicity, consistency, isolation, durability
click to copy

DBMS → PL/SQL 2

A Database Management System (DBMS) is
all of the options
click to copy
If every non-key attribute is functionally dependent on the primary key, the relation will be in
third normal form
click to copy

DBMS → Introduction to DBMS 2

Column header is refer as
attributes
click to copy
Database locking concept is used to solve the problem of
all of the options
click to copy

DBMS → Database Architecture 2

_______ allow us to identify uniquely a tuple in the relation.
superkey
click to copy
UML is stands for
unified modeling language
click to copy