Join Us ::

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

Technical :: All Aptitude Test ::

Home » Technical » Aptitude Test - 34
Hassan
1.Which of the following is not a integrity constraint ?
A. Not null
B. Positive
C. Unique
D. Not null
2.Which of the following is not a integrity constraint ?
A. Not null
B. Positive
C. Unique
D. Not null
3.SQL standard allows a clause initially deferred to be added to a :
A. Uniqueness specification
B. Atomicity specification
C. Constraint specification
D. Uniqueness specification
4.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
5.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
6.Constraints are the preferred method for enforcing data :
A. data topple
B. data integrity
C. data inheritance
D. data topple
7.By including integrity constraints in existing relations we use?
A. update table
B. alert table
C. delete table
D. update table
8.Which one are not the integrity constraints?
A. identical
B. not null
C. unique
D. identical
9.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
10. 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’;
11.Which of the following _____is preferred method for enforcing data integrity?
A. stored procedure
B. constraints
C. cursor
D. stored procedure
12.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
13.CREATE TABLE course ( . . . FOREIGN KEY (dept name) REFERENCES department . . . ); The following code is used.
A. delete
B. delete tuple
C. delete cascade
D. delete
14.Referential integrity constrains are also called?
A. superset dependencies
B. subset dependencies
C. functional dependencies
D. superset dependencies
15.Is oracle sport complex check condition.
A. yes
B. does not suport
C. no
D. yes
16.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
17.The following is used to uniquely identifies the element in relation.
A. secondary key
B. primary key
C. candidate key
D. secondary key
18.Constraints are the preferred method for enforcing data :
A. data topple
B. data integrity
C. data inheritance
D. data topple
19. 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
20. 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
21.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
22.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+
23. 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
24. 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
25. 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
26. 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
27.The entity types, super classes and sub classes are classified as
A. ER schema overlapping
B. ER schema functions
C. ER schema objects
D. ER schema overlapping
28.In UML class diagrams, the inheritances that are permitted includes
A. single inheritance
B. multiple inheritance
C. shared schema inheritance
D. single inheritance
29. In 3NF, which form of dependency is removed _____?
A. Functional
B. Non-functional
C. Associative
D. Functional
30.A primary key that consists of more than one attribute is called a _____?
A. Foreign key
B. Composite key
C. Multivalued key
D. Foreign key
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]