Solved MCQ on Database Normalization set-1

1. A ..................... specifies the actions needed to remove the drawbacks in the current design of database.

A) 1 NF

B) 2 NF

C) 3 NF

D) Normal form

2. A relation is in ........................... if an attribute of a composite key is dependent on an attribute of other composite key.

A) 2NF

B) 3NF

C) BCNF

D) 1NF



3. Fifth Normal form is concerned with

A) Functional dependency

B) Multivalued dependency

C) Join dependency

D) Domain key



4. A table is in the ....................... if only candidate keys are the determinants.

A) functional dependency

B) transitive dependency

C) 4 NF

D) BCNF



5. In 2NF

A) No functional dependencies exist.

B) No multivalued dependencies exist.

C) No partial functional dependencies exist

D) No partial multivalued dependencies exist.

6. The normal form that is not necessarily dependency preserving is

A) 2NF

B) 3NF

C) BCNF

D) 4NF



7. The ................. is related to the concept of multi-valued dependency.

A) fourth normal form

B) fifth normal form

C) boyce codd normal form

D) third normal form



8. Which normal form is considered adequate for normal relational database design?

A) 2NF

B) 5NF

C) 4NF

D) 3NF



9. Dependency preservation is not guaranteed in

A) BCNF

B) 3NF

C) 4NF

D) DKNF



10. A relation is ................... if every field contains only atomic values that is, no lists or sets.

A) 1 NF

B) 2 NF

C) 3 NF

D) BCNF

Answers:

1. A ..................... specifies the actions needed to remove the drawbacks in the current design of database.

D) Normal form

2. A relation is in ........................... if an attribute of a composite key is dependent on an attribute of other composite key.

B) 3NF

3. Fifth Normal form is concerned with

C) Join dependency

4. A table is in the ....................... if only candidate keys are the determinants.

D) BCNF

5. In 2NF

C) No partial functional dependencies exist

6. The normal form that is not necessarily dependency preserving is

A) 2NF

7. The ................. is related to the concept of multi-valued dependency.

A) fourth normal form

8. Which normal form is considered adequate for normal relational database design?

D) 3NF

9. Dependency preservation is not guaranteed in

A) BCNF

10. A relation is ................... if every field contains only atomic values that is, no lists or sets.

A) 1 NF

 Related Posts:

• Solved MCQ of Database Management System (DBMS) Set - 1
• Solved MCQ of Database Management System (DBMS) Set - 2
• Solved MCQ of Database Management System (DBMS) Set - 3
• Solved MCQ of Database Management System (DBMS) Set - 4
• Solved MCQ of Database Management System (DBMS) Set - 5
• MCQ of Database Management System (DBMS) with answer set-6
• MCQ of Database Management System(DBMS) with answer set-7
• Solved MCQ of Database Management System (DBMS) Set - 8

Solved MCQ on C++ Programming Language set-7

1. What is required in inheritance to initialize the data members of the base class through derived class?

A) Object declaration

B) Destructor

C) Constructor

D) Inheritance


2. In which case is it mandatory to provide a destructor in a class?

A) Almost in every class

B) Class for which two or more than two objects will be created

C) Class for which copy constructor is defined

D) Class whose objects will be created dynamically


3. Which of the statements is true in a protected derivation of a derived class from a base class?

A) Private members of the base class become protected members of the derived class

B) Protected members of the base class become public members of the derived class

C) Public members of the base class become protected members of the derived class

D) Protected derivation does not affect private and protected members of the derived class


4. When the access specifier of the base class in the derived class definition is public, the base class is ..

A) Publicly inherited

B) Protectedly inherited

C) Privately inherited

D) None of the above


5. A pointer to the base class can hold address of

A) only base class object

B) only derived class object

C) base class object as well as derived class object

D) None of the above


6. A template class

A) is designed to be stored in different containers

B) works with different data types

C) generates objects which must be identical

D) generates classes with different numbers functions


7. The constructor and the destructor of a class are automatically invoked when memory is allocated and deallocated to an ....

A) Data type

B) Copy constructor

C) Object

D) None of the above


8. A pure virtual function is a virtual function that

A) has no body

B) returns nothing

C) is used in base class

D) both (A) and (C)


9. A class defined within another class is

A) Nested Class

B) Inheritance

C) Containership

D) Encapsulation


10. Which variable stores the memory address of another variable?

A) Reference

B) Pointer

C) Array

D) None of the above

Answers:

1. What is required in inheritance to initialize the data members of the base class through derived class?

C) Constructor

2. In which case is it mandatory to provide a destructor in a class?

D) Class whose objects will be created dynamically

3. Which of the statements is true in a protected derivation of a derived class from a base class?

C) Public members of the base class become protected members of the derived class

4. When the access specifier of the base class in the derived class definition is public, the base class is ..

A) Publicly inherited

5. A pointer to the base class can hold address of

C) base class object as well as derived class object

6. A template class

B) works with different data types

7. The constructor and the destructor of a class are automatically invoked when memory is allocated and deallocated to an ....

C) Object

8. A pure virtual function is a virtual function that

D) both (A) and (C)

9. A class defined within another class is

A) Nested Class

10. Which variable stores the memory address of another variable?

B) Pointer

Related Posts:

• Solved MCQ of C++ Set-1
• MCQ of C++ with answer Set-2
• MCQ Questions of C++ With Answers set-3
• Solved Multiple Choice Questions of C++ set-4
• Solved MCQ of Programming in C++ set-5
• Objective type questions in c programming language set-6
• Solved MCQ of C set-1
• Objective Questions of C with answer set-2
• Solved MCQ of Programming in C set-3

MCQ on c++ Programming with Answers set-6

1. If a class C is derived from class B, which is derived from class A, all through public inheritance, then a class C member function can access.

A) Protected and public data only in C and B

B) Protected and public data only in C

C) Private data in A and B

D) Protected data in A and B


2. Overloading the function operator

A) requires a class with an overloaded operator

B) requires a class with an overloaded [ ] operator.

C) allows you to create objects that act syntactically like functions.

D) usually make use of a constructor that takes arguments.

3. What is a constructor?

A) A function called when an instance of a class is initialized.

B) A function that is called when an instance of a class is deleted.

C) A special function to change the value of dynamically allocated memory

D) A function that is called in order to change the value of a variable.


4. Mechanism of deriving a class from another derived class is known as .........

A) Polymorphism

B) Single Inheritance

C) Multilevel Inheritance

D) Message Passing


5. RunTime Polymorphism is achieved by ..........

A) friend function

B) virtual function

C) operator overloading

D) function overloading


6. Which of the following is the proper declaration of a pointer?

A) int x;

B) int &x;

C) ptr x;

D) int *x;


7. In multiple inheritance

A) the base classes must have only default constructors

B) cannot have virtual functions

C) can include virtual classes

D) None of the above


8. for (; ;)

A) means the test which is done using some expression is always true

B) is not valid

C) will loop forever

D) should be written as for( )


9. The compilers converts all operands upto to type of the largest operand is called as ............

A) typeconversion

B) expression

C) evaluation

D) precedence


10. The keyword FRIEND does not appear in

A) the class allowing access to another class

B) the class desiring access to another class

C) the private section of a class

D) the public section of a class

Answers:

1. If a class C is derived from class B, which is derived from class A, all through public inheritance, then a class C member function can access.

D) Protected data in A and B

2. Overloading the function operator

A) requires a class with an overloaded operator

3. What is a constructor?

A) A function called when an instance of a class is initialized.

4. Mechanism of deriving a class from another derived class is known as .........

C) Multilevel Inheritance

5. RunTime Polymorphism is achieved by ..........

B) virtual function

6. Which of the following is the proper declaration of a pointer?

D) int *x;

7. In multiple inheritance

C) can include virtual classes

8. for (; ;)

C) will loop forever

9. The compilers converts all operands upto to type of the largest operand is called as ............

A) typeconversion

10. The keyword FRIEND does not appear in

C) the private section of a class

Related Posts:

• Solved MCQ of C++ Set-1
• MCQ of C++ with answer Set-2
• MCQ Questions of C++ With Answers set-3
• Solved Multiple Choice Questions of C++ set-4
• Solved MCQ of Programming in C++ set-5
• Solved MCQ of C set-1
• Objective Questions of C with answer set-2
• Solved MCQ of Programming in C set-3

objective type questions in c programming language set-6

1. Which symbol is used as a statement terminator in C?

A) !

B) ~

C) #

D) ;


2. If the size of the array is less than the number of initializes then, ..........

A) extra values are being ignored

B) generates an error message

C) size of array is increased

D) size is neglected when values are given


3. In C, if you pass an array as an argument to a function, what actually gets passed?

A) Value of elements in array

B) First element of the array

C) Base address of the array

D) Address of the last element of array


4. How many times the following loop be executed? { .. ch='b'; while (ch>='a' && ch<=='z') ch++; }

A) 0

B) 25

C) 26

D) 1


5. If a=8 and b=15 then the statement x=(a>b) ? a:b;


A) assigns a value 8 to x

B) gives an error message

C) assigns a value 15 to x

D) assigns a value 7 to x


6. What is the output of the following code. int n=0, m=1; do { printf("%d", m); m++; } while (m<=n);

A) 0

B) 2

C) 1

D) 4


7. A C program contains the following declaration int i=8, j=5 what would be the value of following expression? abs(i-2*j)
A) 2

B) 4

C) 6

D) 8


8. The output of the following is . int a=75; printf("%d%%", a);

A) 75

B) 75%%

C) 75%

D) None of the above


9. How many times the following program would print ("abc")? main( ) { printf("\nabc"); main( ); }

A) Infinite number of times

B) 32767 times

C) 65535 times

D) Till the stack does not overflow


10. Which of the following is the correct usage of conditional operators used in C?

A) a>b?c=30:c=40;

B) a>b?c=30;

C) max=a>b?a>c?a:c:b>c?b:c

D) return (a>b)?(a:b)

Answers:

1. Which symbol is used as a statement terminator in C?

D) ;

2. If the size of the array is less than the number of initializes then, ..........

B) generates an error message

3. In C, if you pass an array as an argument to a function, what actually gets passed?

C) Base address of the array

4. How many times the following loop be executed? { .. ch='b'; while (ch>='a' && ch<=='z') ch++; }

B) 25

5. If a=8 and b=15 then the statement x=(a>b) ? a:b;

C) assigns a value 15 to x

6. What is the output of the following code. int n=0, m=1; do { printf("%d", m); m++; } while (m<=n);

C) 1

7. A C program contains the following declaration int i=8, j=5 what would be the value of following expression? abs(i-2*j)
A) 2

8. The output of the following is . int a=75; printf("%d%%", a);

D) None of the above

9. How many times the following program would print ("abc")? main( ) { printf("\nabc"); main( ); }

A) Infinite number of times

10. Which of the following is the correct usage of conditional operators used in C?

C) max=a>b?a>c?a:c:b>c?b:c

Related Posts

 

• Solved MCQ of C set-1
• Objective Questions of C with answer set-2
• Solved MCQ of Programming in C set-3
• MCQ on C Programming With Answers set-4
• Solved MCQ on C Programming Language set-5 
• Solved MCQ of C++ Set-1
• MCQ of C++ with answer Set-2
• MCQ Questions of C++ With Answers set-3
• Solved Multiple Choice Questions of C++ set-4
• Solved MCQ of Programming in C++ set-5

Solved MCQ on C Programming Language set-5

1. What will be output of the following C program? #include int main() {int goto=5; printf("%d",goto); return 0;}

A) 5

B) 10

C) **

D) compilation error


2. Output of the following C program fragment is. x=5; y=x++; printf("%d %d", x,y);

A) 5, 6

B) 5, 5

C) 6, 5

D) 6, 6


3. What will be output of the following C program? #include int xyz=10; int main() { int xyz=20; printf("%d", xyz); return 0;}

A) 10

B) 20

C) 30

D) compilation error


4. Following program fragment. main(){ printf("%p\n", main( ) ); }

A) Prints the address of main function

B) Prints 0

C) Is an error

D) In an infinite loop


5. What will be output of the following program? #include int main() {int a=2, b=7, c=10; c=a==b; printf("%d",c); return 0;}

A) 0

B) 7

C) 10

D) 2


6. What is the output of the following program segment? main( ) { long i=65536; printf("%d\n", i); }

A) 0

B) 65536

C) -1

D) 65


7. What will be the output of the program? # include int main() {int a[5]={5,1,15,20,25}; int i, j, m; i=++a[1]; j=a[1]++; m=a[i++]; printf("%d, %d, %d", i,j,m); return0;}

A) 2, 1, 15

B) 1, 2, 5

C) 3, 2, 15

D) 2, 3, 20


8. What is the output of the following program segment? main( ) { int=1; do { printf("%d . . ", i); } while (i--); }

A) 0 . . 1 . .

B) 1 . . 0 . .

C) 0

D) -1


9. Output of the program below is. int i; main( ) { printf("%d", i); }

A) 1

B) 0

C) -1

D) Null


10. What will be the output of the following program? main( ) { int i=5; printf("%d", i=++i==6); }

A) 0

B) 7

C) 6

D) 1

Answers:

1. What will be output of the following C program? #include int main() {int goto=5; printf("%d",goto); return 0;}

A) 5

2. Output of the following C program fragment is. x=5; y=x++; printf("%d %d", x,y);

C) 6, 5

3. What will be output of the following C program? #include int xyz=10; int main() { int xyz=20; printf("%d", xyz); return 0;}

B) 20

4. Following program fragment. main(){ printf("%p\n", main( ) ); }

A) Prints the address of main function

5. What will be output of the following program? #include int main() {int a=2, b=7, c=10; c=a==b; printf("%d",c); return 0;}

A) 0

6. What is the output of the following program segment? main( ) { long i=65536; printf("%d\n", i); }

A) 0

7. What will be the output of the program? # include int main() {int a[5]={5,1,15,20,25}; int i, j, m; i=++a[1]; j=a[1]++; m=a[i++]; printf("%d, %d, %d", i,j,m); return0;}

C) 3, 2, 15

8. What is the output of the following program segment? main( ) { int=1; do { printf("%d . . ", i); } while (i--); }

B) 1 . . 0 . .

9. Output of the program below is. int i; main( ) { printf("%d", i); }

B) 0

10. What will be the output of the following program? main( ) { int i=5; printf("%d", i=++i==6); }

D) 1

Related Posts

 

• Solved MCQ of C set-1
• Objective Questions of C with answer set-2
• Solved MCQ of Programming in C set-3
• MCQ on C Programming With Answers set-4
• Solved MCQ of C++ Set-1
• MCQ of C++ with answer Set-2
• MCQ Questions of C++ With Answers set-3
• Solved Multiple Choice Questions of C++ set-4
• Solved MCQ of Programming in C++ set-5

MCQ on C Programming With Answers set-4

1. 'C' is often called a ....

A) Object oriented language

B) High level language

C) Assembly language

D) Machine level language


2. Each C preprocessor directive begins with ....

A) #

B) include

C) main()

D) {


3. C allows arrays of greater than two dimensions, who will determine this?

A) programmer

B) compiler

C) parameter

D) None of the above


4. The << operator is used for

A) Right shifting

B) Left shifting

C) Bitwise shifting

D) Bitwise complement


5. Set of values of the same type, which have a single name followed by an index is called

A) function

B) structure

C) array

D) union


6. Which of the following header file is required for strcpy() function?

A) String.h

B) Strings.h

C) file.h

D) strcpy()


7. scanf() can be used for reading ...

A) double character

B) single character

C) multiple characters

D) no character


8. A variable which is visible only in the function in which it is defined is called

A) Static variable

B) auto variable

C) external variable

D) local variable


9. In the loop structure logical expression is checked at the ....................of the loop.

A) first

B) end

C) middle

D) second


10. If an array is used as function argument, the array is passed

A) by value

B) by reference

C) by name

D) the array cannot be used as function argument


11. If is necessary to declare the type of function in the calling program if

A) Function returns an integer

B) Function returns a non-integer value

C) Function is not defined in the same file

D) Function is called number of times


12. Which escape character can be used to begin a new line in C ........

A) \a

B) \m

C) \b

D) \n


13. Input/output function prototypes and macros are defined in which header file?

A) conio.h

B) stdlib.h

C) stdio.h

D) dos.h


14. What is the purpose of fflush() function?

A) flushes all streams and specified streams

B) flushes only specified stream

C) flushes input/output buffer

D) flushes file buffer


15. What does the following declaration mean?int(*ptr)[10].

A) ptr is array of pointers to 10 integers.

B) ptr is a pointer to an array of 10 integers

C) ptr is an array of 10 integers

D) ptr is an pointer to array

Answers:

1. 'C' is often called a ....

B) High level language

2. Each C preprocessor directive begins with ....

A) #

3. C allows arrays of greater than two dimensions, who will determine this?

B) compiler

4. The << operator is used for

B) Left shifting

5. Set of values of the same type, which have a single name followed by an index is called

C) array

6. Which of the following header file is required for strcpy() function?

A) String.h

7. scanf() can be used for reading ...

C) multiple characters

8. A variable which is visible only in the function in which it is defined is called

D) local variable

9. In the loop structure logical expression is checked at the ....................of the loop.

A) first

10. If an array is used as function argument, the array is passed

B) by reference

11. If is necessary to declare the type of function in the calling program if

B) Function returns a non-integer value

12. Which escape character can be used to begin a new line in C ........

D) \n

13. Input/output function prototypes and macros are defined in which header file?

C) stdio.h

14. What is the purpose of fflush() function?

A) flushes all streams and specified streams

15. What does the following declaration mean?int(*ptr)[10].

B) ptr is a pointer to an array of 10 integers

Related Posts

 

• Solved MCQ of C set-1
• Objective Questions of C with answer set-2
• Solved MCQ of Programming in C set-3
• Solved MCQ of C++ Set-1
• MCQ of C++ with answer Set-2
• MCQ Questions of C++ With Answers set-3
• Solved Multiple Choice Questions of C++ set-4
• Solved MCQ of Programming in C++ set-5

How to validate required field in a form using javascript

In a wave form, fields are needs to validate at the time of entry or on submission of form. Generally in a form it needs to validate user has left required fields empty or not, user has entered valid e-mail address or not, user has entered a valid date, user has entered text in a numeric field or not and other also. 

Here is a function below to validate if a required field has been left empty. If the required field is blank, an alert box alerts a message and the function returns false. If a value is entered, the function returns true.

 Function to validate required field in a form using javascript

function validate_required(field, alerttxt)
{
with (field)
{
if (value==null||value=="")
	{alert(alerttxt); return false}
else {return true}
}
}

Full script, with the HTML form to validate required field 

<!DOCTYPE html>
<html>
<head>
<script>
function validate_required(field, alerttxt)
{
with (field)
{
if (value==null||value=="")
	{alert(alerttxt); return false}
else {return true}
}
}

function validate_form(thisform)
{
with(thisform)
{
if(validate_required(email, "Email must be filled out!")==false)
	{email.focus();return false}
}
}
</script>
</head>

<body>
<form action="submitpage.htm" onsubmit="return validate_form(this)" method="post">
Email:<input type="text" name="email" size="40">
<input type="submit" value="submit">
</form>
</body>

</html>

Preview of the above code, to validate required field 

Email:

Related Posts

• How to Create a Digital Clock in JavaScript?
• How to Detect Visitor's Browser Using JavaScript?
• What are the Different Ways to Redirect Page in JavaScript?
• How To Create Simple Image Slideshow Using JavaScript ?
• How to Create Simple JavaScript Fade Effect Animation?
• Image Slideshow with Navigation Buttons Using Javascript
• How to Create JavaScript Image Slideshow with Links
• Simple JavaScript Fade Effect Animation Using Jquery