Which preprocessor directive is used to include a custom header file?

The correct answer is B: #include "filename". Custom/local header files are included using double quotes: #include "filename". Standard library headers use angle brackets: #include . The compiler searches for quoted files in the current directory first.

What will be the output of the following C code? int main() { int x = 5; int *p = &x; int **q = &p; printf("%d", **q + 1); return 0; }

The correct answer is A: 6. The correct answer is 6 because **q is a pointer to pointer that points to p, which points to x. When we dereference **q, we get the value of x (which is 5), and then adding 1 gives us 6, which is printed. The key concept here is understanding pointer dereferencing: a single asterisk dereferences on

In machine learning, what does overfitting mean?

The correct answer is B: The model learns training data too well, including noise, reducing generalization to new data. Overfitting occurs when a model learns the training data including its noise and irregularities, performing poorly on unseen test data.

Which of the following is true about the 'break' statement in C?

The correct answer is B: It exits the loop or switch statement. The 'break' statement is used to exit or terminate a loop or switch statement immediately. It transfers control to the statement following the loop or switch.

In database normalization, what does the Boyce-Codd Normal Form (BCNF) address that 3NF might miss?

The correct answer is B: Removal of anomalies from composite candidate keys. BCNF handles edge cases in 3NF where anomalies can occur with composite candidate keys where determinants are not candidate keys themselves.

Home

Home › Subjects › Computer Knowledge › Database/SQL

Computer Knowledge
Database/SQL

Programming, networking, database and OS questions

32 Q 2 Topics Take Mock Test

Difficulty: All Easy Medium Hard 31–32 of 32

Topics in Computer Knowledge

All C Programming 200 Database/SQL 100

Q.31 Easy Database/SQL

What is the time complexity of a binary search algorithm on a sorted array?

A O(n)

B O(log n)

C O(n²)

D O(n log n)

Correct Answer: B. O(log n)

EXPLANATION

Binary search divides the search space in half with each iteration, resulting in logarithmic time complexity O(log n).

Test

Q.32 Easy Database/SQL

Which normal form eliminates transitive dependencies in a database table?

A Third Normal Form (3NF)

B Second Normal Form (2NF)

C Boyce-Codd Normal Form (BCNF)

D First Normal Form (1NF)

Correct Answer: A. Third Normal Form (3NF)

EXPLANATION

3NF removes transitive dependencies where a non-key attribute depends on another non-key attribute. BCNF is stricter but 3NF is the standard answer for eliminating transitive dependencies.

Test

1 2 3 4

All Subjects & Topics

Govt. Exams

Entrance Exams

Teacher Exams

Subjects

Quick Links

Computer Knowledge Database/SQL

Computer Knowledge
Database/SQL