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
Correct Answer :
C. Business logic is mostly processed on clients
Related Questions
The privilege lists include
i) select
ii) insert
iii) update
iv) delete
only i)
only i) ii)
only i) ii) iii)
i) ii) iii) iv)
Which of the following Key is used to represent relationship between the tables?
Primary key
Secondary Key
Foreign Key
None of these
Every Boyce-Codd normal form is in
3NF
2NF
1NF
none of the above
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
The mode in which data item may be locked
Partner
Mutual
Exclusive
Atomic
Datalog is
procedural query language
nonprocedural query language
scan(), write()
none of the above
A relation is said to be in ………. If it doesnt contain partial dependency
1NF
2NF
3NF
BCNF
Log into a computer across an internet
IMAP
TELNET
POP3
Infrared
Range variables are designed using the
TO clause
FROM clause
RANGE clause
none of the above
In RDBMS, Data is presented as a collection of
Relation
Table
Attribute
Entity
Select the incorrect statement(s)
i) Foreign key values can be left blank
ii) In SQL duplicates may be present
iii) Theta join operation doesnt remove duplicate columns.
iv) NULL value means string of blank characters.
i ,iii only
ii, iv only
iii, iv only
ii, iii, iv
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 table that displays data redundancies yields ____________ anomalies
Insertion
Deletion
Update
All of the above
Aggregate functions are also called
serial functions
non-serial functions
row functions
column functions
The method by which the structure of the database is modified to eliminate hidden dependencies and replacing groups is
Normalization
Indexing
Enforcing referential integrity
Enforcing data integrity
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).
Triggers are also called
active rules
passive rules
inferences
none of the above
The statement in SQL which allows to change the definition of a table is
Select
Update
Create
Alter
A subschema expresses
the logical view.
the physical view.
the external view.
all of the above.
Secondary storage
magnetic disk
magnetic tape
juke box
cache
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
The minimal set of super key is called
Primary key
Secondary key
Candidate key
Foreign key
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
Which of the following is also known as Offline storage ?
primary storage
secondary storage
tertiary storage
none of the above
In case of entity integrity, the primary key may be
not Null
Null
both Null & not Null.
any value.
A transaction which completes successfully is called
Granted
Committed
Compensated
Accomplished
A lock that allows concurrent transactions to access different rows of the same table is known as a
Field-level lock
Row-level lock
Table-level lock
Database-level lock
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 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 number of cursors depend on the
number of queries
number of attributes
size of memory area
none of these