Sawaal
36
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:   D) DROP TABLE CUSTOMER;



Explanation:

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

Subject: Database
Exam Prep: AIEEE , Bank Exams
Job Role: Analyst , Bank PO , Database Administration , IT Trainer , Project Manager
Related Questions
Q:

The FROM SQL clause is used to 

A) specify what table we are selecting or deleting data FROM B) specify search condition  
C) specify range for search condition   D) None of these
 
Answer & Explanation Answer: A) specify what table we are selecting or deleting data FROM

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

40 3123
Q:

A data dictionary is a special file that contains

A) The width of all fields in all files B) The data type of all fields in all file
C) The name of all fields in all files D) All of the above
 
Answer & Explanation Answer: D) All of the above

Explanation:

A data dictionary is a special file that contains a set of information describing the contents, format, and structure of a database and the relationship between its elements, used to control access to and manipulation of the database.

Report Error

View Answer Report Error Discuss

Filed Under: Database
Exam Prep: Bank Exams
Job Role: Analyst , Bank Clerk , Database Administration , IT Trainer

44 7721
Q:

Cloud computing is not suited for situations

A) where complex legacy systems have to be ported B) characterized by limited-time tasks
C) involving offloading of expensive computing tasks D) with no existing regulatory compliance issues
 
Answer & Explanation Answer: A) where complex legacy systems have to be ported

Explanation:

Cloud computing is not suited for situations where complex legacy systems have to be ported.

Report Error

View Answer Report Error Discuss

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

36 3765
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 Report Error Discuss

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

38 16528
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 Report Error Discuss

Filed Under: Database
Job Role: Database Administration , IT Trainer , Project Manager

34 10139
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

Subject: Database
Job Role: Database Administration , IT Trainer , Network Engineer

37 4582
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

Filed Under: Database
Exam Prep: Bank Exams
Job Role: Analyst , Bank Clerk , Bank PO , Database Administration , IT Trainer , Project Manager , Software Architect

36 4641
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.

 Which_of_the_following_is_not_a_database_object_in_MS_Access1558073404.png image

Report Error

View Answer Report Error Discuss

Filed Under: Database
Exam Prep: Bank Exams
Job Role: Project Manager , IT Trainer , Database Administration , Bank Clerk , Analyst

42 37098