A data manipulation command the combines the records from one or more tables is called
SELECT
PROJECT
JOIN
PRODUCT
Correct Answer :
C. JOIN
Related Questions
The host part in a class A type of an IP address has
12 bits
16 bits
24 bits
28 bits
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 two-phase locking protocol the two phases are
growing phase and shrinking phase
execution phase and blocking phase.
running phase and sleeping phase.
none of the above
Which of the following aggregate function doesnt ignore NULLs in its results?
COUNT
COUNT(*)
MAX
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
Which of the following is the unit of signaling speed or modulation rate or the rate of symbol transmission?
Data rate
Bit rate
Signal to Noise Ratio
Baud rate
The syntax to select all column from the table is
select all from tablename
select * from tablename
select from tablename
none of these
The raw facts and figures are:
Data
Data field
DBMS
DBASE
Which of the following is not a database object?
index
sequence
cursor
trigger
DBMS helps achieve
Data independence
Centralized control of data
Neither A) nor B)
both A) and B)
As a side-effect of database update ,the system automatically executes a statement called
a view
a grant permission
a trigger
all of the above
The overall design of a database is called
Subschema of the database
Schema of the database
Structure of the database
View of the database
Which of the following is not a constraint on a single relation?
check
unique
not null
is duplicate
DECLARE is a(an)
executable statement.
declarative statement.
Ordered file
none of the above
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
Commit operation …………… writes the changes made to the database.
temporarily
permanently
none of these
all of the above
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
Which of the following statements is not true about two tier client server database architecture?
SQL statements are processed on tier server
SQL statements may be processed on some of the clients
Business logic is mostly processed on clients
Business logic may be processed on the server
What is ACID properties of Transactions?
Atomicity, Consistency, Isolation, Database
Atomicity, Consistency, Isolation, Durability
Atomicity, Consistency, Inconsistent, Durability
Automatically, Concurrency, Isolation, Durability
The maximum number of children in a B-tree of order m is
m+1
m
m-1
m/2
View never contains derived columns.
True
False
Cant say
none
Which of the following is true statement ?
SQL permits attribute names to be repeated in the same relation.
a SQL query automatically eliminates duplicates.
a SQL query will not work if there are no indexes on the relations
None of these
Database locking concept is used to solve the problem of
Lost Update
Uncommitted Dependency
Inconsistent Data
All of the above
In E-R diagram Generalization is represented by
Circle
Rectangle
Hyperbola
Triangle
The control of concurrent execution is left with the
operating system
controller unit of the kernel
concurrency control component of the database system
none
Transaction processing is associated with everything below except
producing detail, summary, or exception reports.
recording a business activity.
confirming an action or triggering a response.
maintaining data.
In which of the random-access method, stations do not sense the medium?
ALOHA
ETHERNET
CSMA/CA
CSMA/CD
Generalization is a
top-down approach.
bottom-up approach.
left-right approach.
none of the above
A table that displays data redundancies yields ____________ anomalies
Insertion
Deletion
Update
All of the above
In two-phase locking
the data items are locked in growing phase.
the data items are released in shrinking phase.
Both A and B are true
Both A and B are false