Database Questions

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 4254
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 4097
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 4030
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 3981
Q:

The command to eliminate a table from a database is

A) REMOVE TABLE CUSTOMER; B) UPDATE TABLE CUSTOMER;
C) DELETE TABLE CUSTOMER; D) DROP TABLE CUSTOMER;
 
Answer & Explanation Answer: D) DROP TABLE CUSTOMER;

Explanation:

The SQL DROP TABLE statement is used to remove a table definition and all data, indexes,...

Report Error

View Answer Report Error Discuss

4 3909
Q:

 Which JDBC driver Type(s) is(are) the JDBC-ODBC bridge?

A) Type 1 B) Type 2
C) Type 3 D) Type 4
 
Answer & Explanation Answer: A) Type 1

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

0 3866
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 3801
Q:

88%of 370 +24% of 210-x =118 find x

Answer

From the given equation,


88x370/100 + 24x210/100 - 118 = x


=> x = 325.6 + 50.4 - 118


x = 258.

Report Error

View answer Workspace Report Error Discuss

Subject: Database Exam Prep: CAT , Bank Exams , AIEEE
Job Role: Bank PO , Bank Clerk

7 3783