Sawaal
  • Home/
  • Searching for u

 Searching for "u"

Q:

 Which of the following is the original purpose of SQL?

A) To specify the syntax and semantics of SQL data definition language B) To specify the syntax and semantics of SQL manipulation language
C) To define the data structures D) All of the above.
 
Answer & Explanation Answer: D) All of the above.

Explanation:

SQL is a domain-specific language used in programming and designed for managing data held in a relational database management system, or for stream processing in a relational data stream management system.

 

Purpose of SQL are ::

* To define the data structures

* To specify the syntax and semantics of SQL manipulation language

* To specify the syntax and semantics of SQL data definition language

Report Error

View Answer Report Error Discuss

Filed Under: Database
Job Role: Analyst , Database Administration , IT Trainer

Q:

Using OQL, you may do which of the following?

A) Return an entire collection of elements including duplicates. B) Return a collection of elements without duplicates.
C) Return a specific subset of elements using a given criteria. D) All of the above.
 
Answer & Explanation Answer: D) All of the above.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

Q:

 The object definition language (ODL) is which of the following?

A) Used to develop logical schemas B) A data definition language for OODB
C) A method to implement a logical schema D) All of the above.
 
Answer & Explanation Answer: D) All of the above.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

Q:

 A distributed database is which of the following?

A) A single logical database that is spread to multiple locations and is interconnected by a network B) A loose collection of file that is spread to multiple locations and is interconnected by a network
C) A single logical database that is limited to one location. D) A loose collection of file that is limited to one location.
 
Answer & Explanation Answer: A) A single logical database that is spread to multiple locations and is interconnected by a network

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

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

Q:

 A goal of data mining includes which of the following?

A) To explain some observed event or condition B) To analyze data for expected relationships
C) To confirm that data exists D) To create a new data warehouse
 
Answer & Explanation Answer: A) To explain some observed event or condition

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

Q:

 Stored procedures have which of the following advantages?

A) It takes a longer time to write them as compared to writing Visual Basic. B) Data integrity improves as multiple applications access the same stored procedure.
C) Network traffic increases D) Result in thicker client and thinner database server.
 
Answer & Explanation Answer: B) Data integrity improves as multiple applications access the same stored procedure.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

Q:

 A benefit of the three-tier architecture is which of the following?

A) New modules can be built to support specific business needs B) Performance improves for compiled SQL statements
C) Results in a thinner client and database server D) All of the above.
 
Answer & Explanation Answer: A) New modules can be built to support specific business needs

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database