A list consists of last names, first names, addresses and pin codes. If all people in the list have the same last name and same pin code a useful key would be
the pin code
the last name
the compound key first name and last name
Tr from next page
Correct Answer :
C. the compound key first name and last name
Related Questions
For using a specific database …………… command is used.
use database
database name use
Both A & B
None of them
Create a table with the following attributes: Employee(EMPNO integer, EMPNAME of 10 characters)
Create table Employee(EMPNO int, EMPNAME char(10));
Create table Employee(EMPNO integer, EMPNAME String(10));
Create table Emplo(EMPNO number, EMPNAME string);
Create table Emp(EMPNO int, EMPNAME char(10));
_____clause is an additional filter that is applied to the result.
Select
Order by
Group-by
Having
_____ command can be used to modify a column in a table
alter
update
set
create
Which of the following is a reason to model data?
Understand each user's perspective of data
Understand the data itself irrespective of the physical representation
Understand the use of data across application areas
All of the above
A logical schema
is the entire database
Describes how data is actually stored on disk.
is a standard way of organizing information into accessible parts.
All of the above
An advantage of the database management approach is
data redundancy increases
data is dependent on programs
data is integrated and can be accessed by multiple programs
none of the above
______contains information that defines valid values that are stored in a column or data type.
Default
Index
Rule
View
In multiple granularity of locks SIX lock is compatible with
IX
IS
S
SIX
What are the desirable properties of a decomposition
Partition constraint.
Dependency preservation.
Redundancy.
Security.
The fact that information in the data warehouse changes far less often and may be regarded as non-real-time with periodic updating; This implies that data warehouses are _______
Volatile
Non - Volatile
Logical
Physical
An advantage of views is
Data security
Derived columns
Hiding of complex queries
All of the above
A _____ is used to define overall design of the database
code
data definition language
application program
schema
Shadow paging has
no redo
no undo
redo but no undo
neither redo nor undo
Which of the syntax is correct for insert statement?
i) insert into values
ii) insert into (column list) values
ii) insert into
i-only
ii-only
Both of them
None of them
What is data integrity?
It is the data contained in database that is non redundant.
It is the data contained in database that is accurate and consistent.
It is the data contained in database that is secured.
It is the data contained in database that is shared.
The normal form that is not necessarily dependency preserving is
2NF
3NF
BCNF
4NF
Grant and revoke are _____ statements.
TCL
DCL
DDL
DML
_____ First proposed the process of normalization.
Edgar. W
Edward Stephen
Edgar F. Codd
Edward Codd
A data type or format is specified for each _________
Relation
Tuple
Database
Domain
SQL server stores index information in the _____system table
system indexes
syst indexes
sys indexes
sysind
For correct behaviour during recovery, undo and redo operation must be
Commutative
Associative
idempotent
distributive
A ______ module is typically designed so that it will run on a user workstation or personal computer.
Software
Server
Program
Client
DBMS is a collection of _____ that enables user to create and maintain a database.
Keys
Program
Translators
Language Activity
If both the functional dependencies : X�Y and Y�X hold for two attributes X and Y then the relationship between X and Y is
M:N
M:1
1:M
A relation is in attribute of other composite key. if an attribute of a composite key is dependent on an
2NF
3NF
BCNF
1NF
The keyword to eliminate duplicate rows from the query result in SQL is
DISTINCT
NO DUPLICATE
UNIQUE
None of the above
In SQL the statement select * from R, S is equivalent to
Select * from R natural join S.
Select * from R cross join S.
Select * from R union join S.
Select * from R inner join S.
The drawback of shadow paging technique are
Commit overhead
Data fragmentation
Garbage collection
All of these
The set of all values that can be taken by the attribute is called as _______ of the attribute.
Tuple
Cardinality
Degree
Domain