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
Correct Answer :
C. Both of them
Related Questions
The normalization was first proposed by .
Code
Codd
Boyce Codd
Boyce
A _____ is used to define overall design of the database
code
data definition language
application program
schema
The ______ key of a relation is the attribute (column) or collection of attributes, which uniquely identify a given tuple.
Primary
Foreign
Candidate
Alternate
Which of the following ensures the atomicity of the transaction?
Transaction management component of DBMS
Application Programmer
Concurrency control component of DBMS
Recovery management component of DBMS
The middleware databases in which the business rules act are applicable to _______ tier architectures
Single
Three
Two
None
E-R Modeling is achieved by using ____ diagrams
DFD
Flowcharts
Gantt Charts
E-R
Which of the following is not a property of transactions?
Atomicity
Concurrency
Isolation
Durability
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
The collection of information stored in a database at a particular moment is called as ......
schema
instance of the database
data domain
independence
The rule that a value of a foreign key must appear as a value of some specific table is called a
Referential constraint.
Index.
Integrity constraint.
Functional dependency.
Which one is correct statement?
Logical data independence provides following without changing application programs:
(i) Changes in access methods.
(ii) Adding new entities in database
(iii) Splitting an existing record into two or more records
(iv) C
(i) and (ii)
(iv) only
(i) and (iv)
(ii) and (iii)
_____ is a utility to capture a continuous record of server activity and provide auditing capability.
SQL server Profile
SQL server wizard.
SQL server service manager
SQL server setup
The division operator divides a dividend A of degree m+n by a divisor relation B of degree n and produces a result of degree
m - 1
m + 1
m * m
m
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
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.
What are the desirable properties of a decomposition
Partition constraint.
Dependency preservation.
Redundancy.
Security.
An advantage of views is
Data security
Derived columns
Hiding of complex queries
All of the above
Protection of data from unauthorized Disclosure results in loss of _______
Integrity
Availability
Confidentiality
Discretionary Security
In a relational schema, each tuple is divided into fields called
Relations
Queries
Domains
All of the above
____ table store information about database or about the system.
SQL
System
Nested
None of these
For correct behaviour during recovery, undo and redo operation must be
Commutative
Associative
idempotent
distributive
Whenever two independent one-to-many relationships are mixed in the same relation, a __________ arises.
Functional dependency
Multi-valued dependency
Transitive dependency
Partial dependency
Which of the following aggregate functions does not ignore nulls in its results?.
COUNT .
COUNT (*)
MAX
MIN
A relational database developer refers to a record as
an attribute
a tuple
a criteria
a relation
Drop Table cannot be used to drop a table referenced by a ______ constraint.
Primary Key
Local Key
Foreign Key
Composite Key
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
In an E-R diagram double lines indicate
Total participation.
Multiple participation.
Cardinality N.
None of the above.
An outstanding functionality of SQL is its support for automatic_____ to the target data.
programming
navigation
functioning
notification
The common column is eliminated in
theta join
outer join
natural join
composed join
When an E-R diagram is mapped to tables, the representation is redundant for
weak entity sets
weak relationship sets
strong entity sets
strong relationship sets