Q. In ER modeling, what does a diamond shape represent?
-
A.
Entity
-
B.
Attribute
-
C.
Relationship
-
D.
Weak entity
Solution
In ER modeling, a diamond shape represents a relationship between entities.
Correct Answer:
C
— Relationship
Learn More →
Q. In the context of ASP, what does the term 'server-side scripting' refer to?
-
A.
Code executed on the client machine
-
B.
Code executed on the server before sending to the client
-
C.
Code that runs in the database
-
D.
Code that is compiled into an executable
Solution
Server-side scripting refers to code that is executed on the server before the results are sent to the client, which is a key feature of ASP.
Correct Answer:
B
— Code executed on the server before sending to the client
Learn More →
Q. What does ODBC stand for?
-
A.
Open Database Connectivity
-
B.
Open Data Base Connection
-
C.
Object Database Connection
-
D.
Open Data Base Connectivity
Solution
ODBC stands for Open Database Connectivity, which is a standard API for accessing database management systems.
Correct Answer:
A
— Open Database Connectivity
Learn More →
Q. What is a transaction in the context of a DBMS?
-
A.
A single unit of work that must be completed in its entirety
-
B.
A method of data retrieval
-
C.
A type of database schema
-
D.
A way to create indexes
Solution
A transaction is a single unit of work that must be completed in its entirety to maintain data integrity.
Correct Answer:
A
— A single unit of work that must be completed in its entirety
Learn More →
Q. What is ADO primarily used for?
-
A.
Data access in web applications
-
B.
Database design
-
C.
Data normalization
-
D.
Creating database backups
Solution
ADO (ActiveX Data Objects) is primarily used for data access in web applications, allowing developers to interact with databases.
Correct Answer:
A
— Data access in web applications
Learn More →
Q. What is the main function of a DBMS architecture?
-
A.
To provide a user interface for data entry
-
B.
To manage data storage and retrieval
-
C.
To perform data analysis
-
D.
To create reports
Solution
The main function of a DBMS architecture is to manage data storage and retrieval, ensuring efficient access and manipulation of data.
Correct Answer:
B
— To manage data storage and retrieval
Learn More →
Q. What is the main purpose of normalization in databases?
-
A.
To reduce data redundancy
-
B.
To increase data redundancy
-
C.
To improve query performance
-
D.
To create indexes
Solution
Normalization is the process of organizing data to reduce redundancy and improve data integrity.
Correct Answer:
A
— To reduce data redundancy
Learn More →
Q. What is the primary function of a DBMS architecture?
-
A.
To manage data storage and retrieval
-
B.
To create user interfaces
-
C.
To perform data analysis
-
D.
To design database schemas
Solution
The primary function of a DBMS architecture is to manage data storage and retrieval efficiently.
Correct Answer:
A
— To manage data storage and retrieval
Learn More →
Q. Which of the following is a concurrency control mechanism?
-
A.
Two-phase locking
-
B.
Data normalization
-
C.
Indexing
-
D.
Entity-relationship modeling
Solution
Two-phase locking is a concurrency control mechanism that ensures transactions are executed in a way that prevents conflicts.
Correct Answer:
A
— Two-phase locking
Learn More →
Q. Which of the following is a feature of ASP.NET compared to classic ASP?
-
A.
Supports server-side scripting only
-
B.
Uses a compiled model for better performance
-
C.
Does not support web forms
-
D.
Is limited to Microsoft SQL Server
Solution
ASP.NET uses a compiled model, which provides better performance compared to classic ASP, which is interpreted.
Correct Answer:
B
— Uses a compiled model for better performance
Learn More →
Q. Which of the following is a primary purpose of OLE DB?
-
A.
To provide a uniform interface for accessing data from different sources
-
B.
To manage database transactions
-
C.
To perform data normalization
-
D.
To create ER diagrams
Solution
OLE DB is designed to provide a uniform interface for accessing data from various sources, including relational and non-relational databases.
Correct Answer:
A
— To provide a uniform interface for accessing data from different sources
Learn More →
Q. Which of the following is NOT a feature of ASP?
-
A.
Server-side scripting
-
B.
Database connectivity
-
C.
Client-side data storage
-
D.
Dynamic web page generation
Solution
ASP (Active Server Pages) is a server-side technology and does not provide client-side data storage features.
Correct Answer:
C
— Client-side data storage
Learn More →
Showing 1 to 12 of 12 (1 Pages)
