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 → Indexes 3

In the section relation which of the following is used as a foreign key?
course_id
click to copy
The algorithm that takes a set of dependencies and adds one schema at a time, instead of decomposing the initial schema repeatedly is
3nf synthesis algorithm
click to copy
Which of the following is a valid uniform resource locator?
http://www.acm.org/sigmod
click to copy

DBMS → Transactions 3

To replace the relation section with some other relation the initial step to be carried out is
drop section;
click to copy
Which normal form is considered adequate for normal relational database design?
3nf
click to copy
HTTP defines two ways in which values entered by a user at the browser can be sent to the Web server. The            method encodes the values as part of the URL.
get
click to copy

DBMS → Concurrency Control 3

Select distinct Dept_name from instructor ; How many row(s) are displayed ?
4
click to copy
Relation R with an associated set of functional dependencies, F, is decomposed into BCNF. The redundancy (arising out of functional dependencies) in the resulting set of relations is
more than zero but less than that of an equivalent 3nf decomposition
click to copy
A                      is a program running on the server machine, which accepts requests from a Web browser and sends back results in the form of HTML documents.
web server
click to copy

DBMS → Deadlock 3

Which function is used to find the count of distinct departments?
dist
click to copy
Which of the normal form is based on multivalued dependencies?
fourth
click to copy
The application program typically communicates with a database server, through                        or other protocols, in order to get or store data.
all of the mentioned
click to copy

DBMS → Database Security 2

Which function is used to identify the title with Least scope?
min(credits)
click to copy
                           can help us detect poor E- R design.
functional dependencies
click to copy

DBMS → PL/SQL 2

A domain is              if elements of the domain are considered to be indivisible units.
atomic
click to copy
What is the best way to represent the attributes in a large database?
concatenation
click to copy

DBMS → Introduction to DBMS 2

Identify the composite attributes
none of the mentioned
click to copy
Designers use which of the following to tune the performance of systems to support time-critical operations?
denormalization
click to copy

DBMS → Database Architecture 2

Which one is based on multi-valued dependency:
fourth
click to copy
Thus a                of course data gives the values of all attributes, such as title and department, of all courses at a particular point in time.
snapshot
click to copy

DBMS → Data Models 2

If every non-key attribute is functionally dependent primary key, then the relation will be in
second normal form
click to copy
Representations such as the in the dept year relation, with one column for each value of an attribute, are called                they are widely used in spreadsheets and reports and in data analysis tools.
cross-tabs
click to copy

DBMS → ER Model 2

The term for information that describes what type of data is available in a database is:
metadata
click to copy
An approach to website design with the emphasis on converting visitors to outcomes required by the owner is referred to as:
persuasion
click to copy

DBMS → Relational Model 2

A data type that creates unique numbers for key columns in Microsoft Access is:
autonumber
click to copy
A method of modelling and describing user tasks for an interactive application is referred to as:
use case
click to copy

DBMS → Normalization 2

A dependency exist between two columns when
together they constitute a composite key for the table
click to copy
Information architecture influences:
site structure
click to copy

DBMS → Functional Dependency 2

In the                      normal form, a composite attribute is converted to individual attributes.
first
click to copy
Also known as schematics, a way of illustrating the layout of an individual webpage is a:
wireframe
click to copy

DBMS → SQL Basics 2

A table on the many side of a one to many or many to many relationship must:
have a composite key
click to copy
A graphical or text depiction of the relationship between different groups of content on a website is referred to as a:
sitemap
click to copy

DBMS → DDL Commands 2

Functional Dependencies are the types of constraints that are based on             
key
click to copy
Blueprints are intended to:
indicate the structure of a site during site design and as a user feature
click to copy

DBMS → DML Commands 2

A relation is in                          if an attribute of a composite key is dependent on an attribute of other composite key.
3nf
click to copy
Storyboards are intended to:
prototype typical customer journeys or click streams through a website
click to copy

DBMS → Joins 2

What are the desirable properties of a decomposition
dependency preservation
click to copy
Which of the following occupies boot record of hard and floppy disks and activated during computer startup?
boot sector virus
click to copy

DBMS → Views 2

R (A,B,C,D) is a relation. Which of the following does not have a lossless join dependency preserving BCNF decomposition?
a->bcd
click to copy
A graphical or text depiction of the relationship between different groups of content on a website is a:
site map
click to copy