Join Us ::

Menu Home Classes GK Engineering Past Papers Current Affairs Technical GAT Subject Programming Medical Papers

Database :: All Aptitude Test ::

Home » Technical » Database » Aptitude Test - 13
1.The relationship between the two tables are created using __________?
A. Candidate Key
B. Primary Key
C. Foreign Key
D. Candidate Key
2.Which of the following statement(s) is/are FALSE about primary key?
A. There can be more than one primary key for a table
B. Columns with string data types cannot be made Primary Key because they are large
C. Both A and B
D. There can be more than one primary key for a table
3.Referential triggered action clause in Standard Query Language is attached to constraint called :
A. primary key constraint
B. stamped key constraint
C. interval notation constraint
D. primary key constraint
4. If the referential integrity constraint is violated then the specific action clause attached by the database designers other than by default action is classified as :
A. referential triggered action
B. foreign key triggered action
C. primary key triggered action
D. referential triggered action
5.Which of the following is not a integrity constraint ?
A. Not null
B. Positive
C. Unique
D. Not null
6.Which of the following is not a integrity constraint ?
A. Not null
B. Positive
C. Unique
D. Not null
7.SQL standard allows a clause initially deferred to be added to a :
A. Uniqueness specification
B. Atomicity specification
C. Constraint specification
D. Uniqueness specification
8.When a referential-integrity constraint is violated, the normal procedure is to :
A. Continue with flow
B. Accept the action
C. Reject the action
D. Continue with flow
9.The most easily tested constraints of a new data entered is into a database is called?
A. referential constraints
B. domain constraints
C. assertion
D. referential constraints
10.Constraints are the preferred method for enforcing data :
A. data topple
B. data integrity
C. data inheritance
D. data topple
11.By including integrity constraints in existing relations we use?
A. update table
B. alert table
C. delete table
D. update table
12.Which one are not the integrity constraints?
A. identical
B. not null
C. unique
D. identical
13.The key is the one in which the primary of one relation is referenced to another relation is called :
A. primary key
B. foreign key
C. candidate key
D. primary key
14. Following is the right syntax for assertion?
A. create assertion ‘predicates’;
B. create assertion check ‘predicate’ ‘assertion name’;
C. create ‘assertion-name’ check ‘predicates’;
D. create assertion ‘predicates’;
15.Which of the following _____is preferred method for enforcing data integrity?
A. stored procedure
B. constraints
C. cursor
D. stored procedure
16.Which of the following command in SQL is used to create a table?
A. MAKE TABLE
B. DLETE TABLE
C. UPDATE TABLE
D. MAKE TABLE
17.CREATE TABLE course ( . . . FOREIGN KEY (dept name) REFERENCES department . . . ); The following code is used.
A. delete
B. delete tuple
C. delete cascade
D. delete
18.Referential integrity constrains are also called?
A. superset dependencies
B. subset dependencies
C. functional dependencies
D. superset dependencies
19.Is oracle sport complex check condition.
A. yes
B. does not suport
C. no
D. yes
20.An SQL standard Allows a clause initially deferred to be added to a :
A. isolation specification
B. constraint specification
C. atomicity specification
D. isolation specification
21.The following is used to uniquely identifies the element in relation.
A. secondary key
B. primary key
C. candidate key
D. secondary key
22.Constraints are the preferred method for enforcing data :
A. data topple
B. data integrity
C. data inheritance
D. data topple
23. Why do we have to create a primary index on a primary key:
A. Ease of searching
B. Sequential ordering of a file
C. Both (a) and (b)
D. Ease of searching
24. In context with relational Algebra. Which of the following are unary operatiors.
A. 1 and 3 only
B. 2 and 4 only
C. 1 and 2 only
D. 1 and 3 only
25.Which of the operations constitute a basic set of operations for manipulating relational data?
A. Predicate calculus
B. Relational calculus
C. Relational algebra
D. Predicate calculus
26.Which of the following statement is correct?
A. F |= x ---> x iff y ⊆ x+
B. F |= y ---->x iff y ⊆ x+
C. F |=x --->y iff x+ ⊆ y
D. F |= x ---> x iff y ⊆ x+
27. Let R is a relation schema, R(A, B, C, D) and F = {A —> B, B --> C, C —> A) is the set of functional dependency. Determine the key of relation ?
A. A
B. B
C. C
D. A
28. The type of classes which specifies the operations and attributes but the corresponding classes are not available are classified as
A. abstract classes
B. leaf node classes
C. overlapping node classes
D. abstract classes
29. The kind of class whose entities belongs to some other data class is called
A. concrete classes
B. abstract classes
C. leaf node classes
D. concrete classes
30. According to enhanced-entity relationships, the association between super class and subclass is as
A. super class is subset of subclass
B. subclass is subset of super class
C. subclass is partial joint of super class
D. super class is subset of subclass
Related Subjects

Date to Date Current Affairs 2022

PakMCQs.net

Quick Links

GAT Subject



   Computer Science    English Mcqs    Agriculture    

Engineering



   Computer Science    Civil Engineering    

Technical



   Networking    Electronics    Database    

Past Papers



   Model Papers    FPSC Papers    
Our Team | Career | Contact | JoinUs | Privacy Policy | DMC

© 2020-2024 by Pak-MCQs.net All Rights Reserved.

Email: [email protected]