A relation that has no partial dependencies is in which normal form
First
Second
Third
BCNF
Correct Answer :
B. Second
Related Questions
Secondary storage
magnetic disk
magnetic tape
juke box
cache
The overall design of a database is called
Subschema of the database
Schema of the database
Structure of the database
View of the database
The command used to delete a particular column in a relation
UPDATE
DROP
ALTER
DELETE
File organization that provides fast access to any arbitrary record
Hashed file
B-tree
Ordered file
Unordered file
The access protocol used by traditional Ethernet
CSMA/CA
CSMA/CD
CSMA
Token ring
Specialization is a
top-down approach.
bottom-up approach.
left-right approach.
none of the above
The syntax to select all column from the table is
select all from tablename
select * from tablename
select from tablename
none of these
DECLARE is a(an)
executable statement.
declarative statement.
Ordered file
none of the above
Extended Entity Relationship model consists of which of the following
i) Specialization
ii) Generalization
iii) Categorization
i and ii only
ii and iii only
i and iii only
All i, ii iii
What is the result of the following SQL statement ?
SELECT A.emp_Name, B.ph_num
FROM emp A LEFT OUTER JOIN phone B
ON A. emp_ID = B.emp_ID
A list of employees phone number
A list of all employees that have spouses, with phone number included in the list
A list of all employees names, including the phone number if they have one
Two lists : One list of employees, the other of phone numbers
Which of the following operator preserves unmatched rows of the relations being joined?
Inner join
Outer join
union
Intersect
Database locking concept is used to solve the problem of
Lost Update
Uncommitted Dependency
Inconsistent Data
All of the above
By default a user who has been granted some form of authorization
is allowed to pass them to others
is not allowed to pass them to others
may be or may not be allowed to pass them to others
none
Related fields in a database are grouped to form a
data file.
data record.
menu.
bank.
Repeaters operate in
i) Physical layer
ii) Datalink layer
iii) Transport layer
iv) Network layer
i and ii only
ii and iii only
ii only
i only
A logical description of some portion of database that is required by a user to perform task is called as
System View
User View
Logical View
Data View
Data independence means
data is defined separately and not included in programs.
programs are not dependent on the physical attributes of data.
programs are not dependent on the logical attributes of data.
both B) and C).
Which of the following concurrency control schemes is not based on serializability property?
Two-phase locking
Timestamped based locking
Graph-based locking
none of the above
In which of the following transmissions, we can send data by grouping n bits at a time instead of a single bit?
parallel
serial
analog
digital
The physical path over which a message travels
Thermal
Medium
Protocol
Impulse
In ………… paging we make copy of the current page table.
physical
logical
shadow
duplicate
Which of the following produces the relation that has attributes of R1 and R2
Cartesian product
Difference
Intersection
Product
The index table has …… Columns.
1
2
3
4
Which of the following Key is used to represent relationship between the tables?
Primary key
Secondary Key
Foreign Key
None of these
Data fragmentation is performed by the …… and each fragment is stored at…………..
DBMS, same site
OS ,same site
DBMS ,different site
OS ,different site
Every Boyce-Codd normal form is in
3NF
2NF
1NF
none of the above
The transaction consists of all statements executed between
the begin transaction and end transaction
the start transaction and end transaction
the begin transaction and finish transaction
none of the above.
The physical location of a record is determined by a mathematical formula that transforms
a file key into a record location is :
B-Tree File
Hashed File
Indexed File
Sequential file.
Tertiary storage
magnetic tape
juke box
optical disk
All of the above
Full form of CIDR
Classful Inter Domain Routing
Classless International Domain Routing
Classless Inter Domain Routing
none of these