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
3 852
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 containsa 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
6 3057
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 situationswhere complex legacy systems have to be ported.
Report Error
View Answer Report Error Discuss
Filed Under: Database
Job Role: Analyst , Database Administration , IT Trainer
3 1841
Q:
Which of the following is not true about cloud computing?
| 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
6 13915
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.
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.
Workspace
Report Error
View Answer Workspace Report Error Discuss
Subject: Database
Job Role: Database Administration , IT Trainer , Network Engineer
3 2580
Q:
Which of the following describes a relationaldatabase?
| 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
4 2736
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
Filed Under: Database
Exam Prep: AIEEE , Bank Exams
Job Role: Analyst , Bank PO , Database Administration , IT Trainer , Project Manager
3 3267
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 Report Error Discuss
Filed Under: Database
Exam Prep: Bank Exams
Job Role: Project Manager , IT Trainer , Database Administration , Bank Clerk , Analyst
14 24499
