Database Questions

Q:

 In a 1:N relationship, the foreign key is placed in:

A) the parent table. B) the child table.
C) either table without specifying parent and child tables. D) either the parent table or the child table.
 
Answer & Explanation Answer: B) the child table.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

0 4631
Q:

 A distributed database can use which of the following strategies?

A) Totally centralized one location and accessed by many sites B) Partially or totally replicated across sites
C) Partitioned into segments at different sites D) All of the above
 
Answer & Explanation Answer: D) All of the above

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

0 4565
Q:

 The first step in database development is which of the following?

A) Enterprise data modeling B) Logical database design
C) Physical database design and definition D) Database Implementation
 
Answer & Explanation Answer: A) Enterprise data modeling

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

0 4533
Q:

Cloud computing uses Server virtualization.

A) TRUE B) FALSE
Answer & Explanation Answer: A) TRUE

Explanation:

Cloud computing :: 


Cloud computing is an information technology (IT) paradigm that enables ubiquitous access to shared pools of configurable system resources and higher-level services that can be rapidly provisioned with minimal management effort, often over the Internet.


 


Server virtualization :


Server virtualization is a virtualization technique that involves partitioning a physical server into a number of small, virtual servers with the help of virtualization software. In server virtualization, each virtual server runs multiple operating system instances at the same time.


cloud-computing_server_virtuaization1532503685.jpg image


 


Server virtualization is more for a good reason. It offers the potential to dramatically save space and improve server efficiency. Vendors are in fierce competition to offer the most advanced tools that they hope will earn them the virtualization crown.


 


Hence, the given statement that 'Cloud computing uses Server virtualization.' is TRUE.


 


 

Report Error

View Answer Workspace Report Error Discuss

37 4448
Q:

Which of the following are goals of OLE DB?

A) Create object interfaces for DBMS functionality pieces only. B) Increase flexibility only.
C) Object interface over any type of data only. D) All of the above as goals of OLE DB.
 
Answer & Explanation Answer: D) All of the above as goals of OLE DB.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

0 4425
Q:

Which of the following describes a relational database?

A) It retrieves data related to its queries B) It provides a relationship between floats
C) It provides a relationship between integers D) It consists of separate tables or related data
 
Answer & Explanation Answer: D) It consists of separate tables or related data

Explanation:

A relational database is a digital database based on the relational model of data, a database structured to recognize relations between stored items of information. A software system used to maintain relational databases is a relational database management system.

 

Computer database in which all data is stored in Relations which (to the user) are tables with rows and columns. Each table is composed of records (called Tuples) and each record is identified by a field (attribute) containing a unique value. Every table shares at least one field with another table in 'one to one,' 'one to many,' or 'many to many' relationships. These relationships allow the database user to access the data in almost an unlimited number of ways, and to combine the tables as building blocks to create complex and very large databases.

Report Error

View Answer Report Error Discuss

36 4392
Q:

The capacity to change the conceptual schema without having to change external schemas or application programs is called

A) Physical Data Independence B) Logical Data Independence
C) Both A and B D) None
 
Answer & Explanation Answer: B) Logical Data Independence

Explanation:

LDI is the capacity to change the conceptual schema without having to change external schemas or application programs.

Report Error

View Answer Report Error Discuss

Filed Under: Database
Job Role: Database Administration

0 4373
Q:

An Oracle System Change Number (SCN):

A) is a value that is incremented whenever a dirty read occurs. B) is incremented whenever a deadlock occurs.
C) is a value that keeps track of explicit locks. D) is a value that is incremented whenever database changes are made.
 
Answer & Explanation Answer: D) is a value that is incremented whenever database changes are made.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

0 4237