The raw facts and figures are:
Data
Data field
DBMS
DBASE
Correct Answer :
A. Data
Related Questions
Relational Algebra is
Data Definition Language.
Data Manipulation Language
Procedural query Language
None of the above
DBMS utility which allows to reconstruct the correct state of database from the backup and history of transactions
Backup
Recovery
Grant
Troubleshooting
Data fragmentation is performed by the …… and each fragment is stored at…………..
DBMS, same site
OS ,same site
DBMS ,different site
OS ,different site
A …………… is a memory area where data are processed.
view
trigger
cursor
none of the above
Data Manipulation Language DML) is not to
Create information table in the Database
Insertion of new information into the Database
Deletion of information in the Database
Modification of information in the Database
In client/server computing data are
sent only upon the client's request
sent in complete copies for the client to filter and sort
never sent to the client machine
sent in very large sections to save processing time
B-Tree is used for
searching data
storing data
both A and B
none of these
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
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 class based addressing is known as
Classless addressing
Classful addressing
Classified addressing
Classical addressing
A data manipulation command the combines the records from one or more tables is called
SELECT
PROJECT
JOIN
PRODUCT
In ………… paging we make copy of the current page table.
physical
logical
shadow
duplicate
Which of the following is not an Aggregate function?
Min
Max
Select
Avg
Which topology requires a central controller or hub?
Ring
Tree
Switch
Graph
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
The output of the Data Definition Language is stored in the
view table
schema
metadata
all of the above.
The control of concurrent execution is left with the
operating system
controller unit of the kernel
concurrency control component of the database system
none
Expand the acronym OLAP
Object Linked Access Program
Organizational Architecture Processing
Online Analytical Processing
none of these
The raw facts and figures are:
Data
Data field
DBMS
DBASE
In an Entity-Relationship Diagram Diamonds represents
Attributes
Multi-valued attributes
Weak entity set
Relationship sets
Disk storage is referred to as
sequential access storage
direct access storage
random access storage
none of the above
State which of the following statements are True
i) TCP is connection oriented but unreliable
ii) UDP is connection oriented but unreliable
iii) TCP is connectionless but reliable
iv) UDP is connectionless but reliable
i and ii only
ii and iii only
i and iii only
None of these
Which of the following is also known as Offline storage ?
primary storage
secondary storage
tertiary storage
none of the above
Tertiary storage
magnetic tape
juke box
optical disk
All of the above
Noiseless channel has ……… types of protocols.
2
3
4
5
Select the incorrect statement(s)
i) Shared locks are compatible with each other.
ii) A relation which is in 3NF may have redundancy due to composite keys.
iii) A table in a database can have multiple indexes.
i only
ii, only
ii, iii only
none of the above
RAID
Redundant Arrays of Independent Disks
Redundant Arrays of Independent Drives
Redundant Arrays of Interconnected Drives
Redundant Arrays of Interconnected Disks
In an Entity-Relationship Diagram Ellipses represents
Attributes
Weak entity set
Relationship sets
Multi-valued attributes
The ________ states that a foreign key must either match a primary key value in another relation or it must be null.
entity integrity rule
referential integrity constraint
composite attribute
action assertion
Related fields in a database are grouped to form a
data file.
data record.
menu.
bank.