The syntax to select all column from the table is
select all from tablename
select * from tablename
select from tablename
none of these
Correct Answer :
B. select * from tablename
Related Questions
Which command is used to cancel privileges granted through the GRANT command ?
CANCEL
OVER
STOP
REVOKE
The degree of the table with 500 rows and 7 columns is
500
7
3500
none of these
In E-R diagram Generalization is represented by
Circle
Rectangle
Hyperbola
Triangle
DBMS utility which allows to reconstruct the correct state of database from the backup and history of transactions
Backup
Recovery
Grant
Troubleshooting
In RDBMS, Data is presented as a collection of
Relation
Table
Attribute
Entity
The output of the Data Definition Language is stored in the
view table
schema
metadata
all of the above.
An advantage of the database management approach is
data is dependent on programs.
data redundancy increases.
data is integrated and can be accessed by multiple programs.
none 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
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
Select the incorrect statement
BCNF is stronger than 3NF
Relational algebra is a non-procedural language
Every conflict serializable schedule is view serializable.
none of the above
Primary storage
magnetic disk
magnetic tape
juke box
cache
Technique used in log based recovery
Immediate database modification
Graph-based recovery
key dependencies
none of the above
The left outer join takes all tuples
in the left relation which didnt match with any tuple in right relation
in the left relation which matched with a tuple in right relation
in the right relation which didnt match with any tuple in left relation
in the right relation which matched with a tuple in left relation
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
An entity set which have sufficient attributes to form a primary key
Tree structure
Subtree structure
Strong entity set
Table structure
Which of the following is/are error-free channel(s)
i) Noisy channel
ii) Noiseless channel
i only
ii only
Both
None of these
.................. is the loss of energy as the signal propagates outward, where the amount of energy depends on the frequency.
Noise
Delay distortion
Attenuation distortion
Dispersion
The statement
Every foreign-key value must match a primary-key value in an associated table
Is related to
View
Cursor defination
Referential intergrity
Trigger
A logical schema
is the entire database.
is a standard way of organizing information into accessible parts.
describes how data is actually stored on disk.
both A) and C)
The number of cursors depend on the
number of queries
number of attributes
size of memory area
none of these
Event condition action model is related to
Views
Cursors
Triggers
None of these.
A data manipulation command the combines the records from one or more tables is called
SELECT
PROJECT
JOIN
PRODUCT
What is the max data capacity of STP?
1 Gbps
56 Mbps
100 Mbps
256 Mbps
Select the correct statement
i) Aggregate functions work on a group of data and return a single value.
ii) ODBC connects the frontend with the database without considering its compatibility
iii) View definition cant be used at multiple places through with clause .
i and ii only
ii and iii only
i and iii only
i only
Noisy channel has ……… .. types of protocols
two
three
four
none
A DBMS query language is designed to
support end users who use English-like commands.
support in the development of complex applications software.
specify the structure of a database.
all 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
Unwanted energy from source other than the transmitter.
Attenuation
Distortion
Delay
Noise
Cross Product is a:
Unary Operator
Binary Operator
Ternary Operator
none of the above
Log into a computer across an internet
IMAP
TELNET
POP3
Infrared