Q-230
Incorrect
A.TRUE(Missed)
B.FALSE
Q-231
Q-232
Correct
In Relational database Data is stored as record types and the relationship is represented by set types
A.True
B.False
Q-233
Q-234
Correct
In Hierarchical database to get to a low-level table, you start at the root and work your way down the tree until you reach your target data.
A.True
B.False
Q-235
Q-236
Incorrect
A.True
B.False(Missed)
first create conceptual schema and than creat relational model ..
Q-237
Incorrect
Logical database design describes describes base relations, file organizations, and indexes that are used to achieve efficient access to data.
A.True
B.False(Missed)
Q-238
estion 23 / 31
Correct
A.True
B.False
Q-239
Incorrect
A.True(Missed)
B.False
Q-240
Correct
A.True
B.False
Q-241
Incorrect
A.True
B.False(Missed)
Q-242
Correct
A traditional database stores just data – with no procedures
A.True
Q-243
Q-244
Correct
A.True
B.False
Q-245
Q-246
| << Previous | Next >> |
Specialization is denoted by ________ in ER diagram1- Triangle labeled IS A - Rectangle labeled IS A - Rectangle Labeled HAS A - Triangle labeled HAS A ass- 1 | |
Q-247
Degree of relationships is
Options
- number of participating entity types
- number of participating relations
- number of participating attribute types
- number of participating constraints
CORRECT ANSWER : number of participating entity types
Q-248
- number of participating entity types
- number of participating relations
- number of participating attribute types
- number of participating constraints
CORRECT ANSWER : number of participating entity types
Q-248
A schedule for a set of transactions must
Options
- consist of all instructions of those transactions
- Preserve the order in which the instructions appear in each individual transaction.
- Both a and b
- None of these
CORRECT ANSWER : Both a and b
Q-249
- consist of all instructions of those transactions
- Preserve the order in which the instructions appear in each individual transaction.
- Both a and b
- None of these
CORRECT ANSWER : Both a and b
Q-249
Partial dependency is removed in ______ normal form
Options
- First
- Second
- Third
- Fourth
CORRECT ANSWER : Second
- First
- Second
- Third
- Fourth
CORRECT ANSWER : Second
note-- in 3nf - transitive dependency removed
bcnf-removal of functional dependency
4nf- removal of multivalued dependency
Q-250
Prev LSN in database log is constructed using________ data structure
Options
- Tree
- Graph
- Link List
- Queue
CORRECT ANSWER : Link List
- Tree
- Graph
- Link List
- Queue
CORRECT ANSWER : Link List
Q-251
Which is not the relational algebra operator?
Options
- set difference
- Cartesian product
- Rename
- Join
CORRECT ANSWER : Join
- set difference
- Cartesian product
- Rename
- Join
CORRECT ANSWER : Join
Q-****252
To create a PRIMARY KEY constraint on existing table “EMPLOYEE” on "EMPID" column and currently column does not contain any value , which is the correct SQL syntax from the following
Options
- Alter table EMPLOYEE Add Constraint PK-EMPID Primary Key, EMPID;
- Update table EMPLOYEE Add Constraint PK-EMPID Primary Key (EMPID);
- Alter table EMPLOYEE Add Constraint PK-EMPID Primary Key (EMPID);
- Alter table EMPLOYEE Add Constraint PK-EMPID Primary Key, (EMPID);
CORRECT ANSWER : Alter table EMPLOYEE Add Constraint PK-EMPID Primary Key (EMPID);
- Alter table EMPLOYEE Add Constraint PK-EMPID Primary Key, EMPID;
- Update table EMPLOYEE Add Constraint PK-EMPID Primary Key (EMPID);
- Alter table EMPLOYEE Add Constraint PK-EMPID Primary Key (EMPID);
- Alter table EMPLOYEE Add Constraint PK-EMPID Primary Key, (EMPID);
CORRECT ANSWER : Alter table EMPLOYEE Add Constraint PK-EMPID Primary Key (EMPID);
Q-253
Match the following
A)Composite attribute ------i) Attribute whose value is calculated from other attributes
B)Multivalued Attribute ----ii)Attribute that can be further subdivided to yield additional attributes
C)Derived Attribute --------iii) Attribute that can have more values
Options
- A-i ,B-ii, C-iii
- A-ii ,B-i, C-iii,
- A-ii ,B-iii, C-i,
- A-iii ,B-ii, C-i,
CORRECT ANSWER : A-ii ,B-iii, C-i,
Q-254
- A-i ,B-ii, C-iii
- A-ii ,B-i, C-iii,
- A-ii ,B-iii, C-i,
- A-iii ,B-ii, C-i,
CORRECT ANSWER : A-ii ,B-iii, C-i,
Q-254
A transaction state changes from active to______, after the transaction has been rolled back and the database restored to its state prior to the start of the transaction
Options
- Partially committed
- Committed
- Aborted
- Failed
CORRECT ANSWER : Aborted
Q-255
- Partially committed
- Committed
- Aborted
- Failed
CORRECT ANSWER : Aborted
Q-255
Q-256
Q-257
Q-258
Q-259
Q-260
Q-261
Q-262
Q-263
Q-264
Q-265
Q-266
Q-267
sdaskjdas
