11
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:   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

Q:

Which of the following is not true about cloud computing?

which_of_the_following_is_not_true_about_cloud_computing1539240737.jpg image

A) Cloud-based management platforms cannot support internally hosted server platforms B) Cloud-based management platforms can support multiple cloud-virtual server vendors
C) Cloud-based management platforms can support multiple cloud-virtual server operating systems D) Cloud-based management platforms can support change management methodologies
 
Answer & Explanation Answer: A) Cloud-based management platforms cannot support internally hosted server platforms

Explanation:
Report Error

View Answer Workspace Report Error Discuss

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

0 435
Q:

Which of the following is true about cloud computing?

A) Cloud computing has brought about a drop in hardware and software sales, while augmenting service revenues B) You can access your data from any computer in the world, as long as you have an Internet connection.
C) Both A & B D) It's always going to be less expensive and more secure than local computing.
 
Answer & Explanation Answer: C) Both A & B

Explanation:
Report Error

View Answer Workspace Report Error Discuss

0 349
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

1 417
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 Workspace Report Error Discuss

1 746
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 Workspace Report Error Discuss

2 919
Q:

Which of the following is not a database object in MS Access?

A) Reports B) Relationships
C) Tables D) Queries
 
Answer & Explanation Answer: B) Relationships

Explanation:

Queries, reports and tables are all related to database and relationships are not the database object and it is related to functions in mathyematics.

Report Error

View Answer Workspace Report Error Discuss

0 1238
Q:

A collection of interrelated records is called a

A) Datasheet B) Spreadsheet
C) Database D) Utility File
 
Answer & Explanation Answer: C) Database

Explanation:
Report Error

View Answer Workspace Report Error Discuss

5 1580
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

6 1792