Explanation:
In SQL, the TRUNCATE TABLE statement is a Data Definition Language operation that marks the extents of
a table for deallocation. The result of this operation quickly removes all data from a table, typically bypassing
a number of integrity enforcing mechanisms.
Explanation:
The correct answer is
Update
Explanation:
The correct answer is
SELECT * FROM Persons
Explanation:
The correct answer is
SELECT FirstName FROM Persons
Explanation:
The correct answer is
SELECT
Explanation:
If autocommit mode is enabled, each SQL statement forms a single transaction on its own.
Explanation:
SQL Server AVG () function is an aggregate function that returns the average value of a group.
Explanation:
The SQL TRUNCATE TABLE command is used to delete complete data from an existing table. You can
also use DROP TABLE command to delete complete table but it would remove complete table structure
form the database and you would need to re-create this table once again if you wish you store some data.
Explanation:
Primary and foreign keys help create structure in relational databases. A primary key ensures unique row
identification. This results in faster sorting, searching, and querying operations. A foreign key creates a
link between two tables.
Explanation:
A relational database management system (RDBMS) is a program that allows you to create, update, and
administer a relational database. Most relational database management systems use the SQL language to
access the database.
Explanation:
Embedded SQL is a method of combining the computing power of a programming language and the
database manipulation capabilities of SQL. Embedded SQL statements are SQL statements written
inline with the program source code, of the host language.
Explanation:
The correct answer is
Fields
Explanation:
The correct answer is
DELETE FROM SalesData
Explanation:
The SQL CASE Statement. The CASE statement goes through conditions and returns a value when the first
condition is met (like an if-then-else statement).
Explanation:
A multi-dimensional database is structured by a combination of data from various sources that work amongst
databases simultaneously and that offer networks, hierarchies, arrays, and other data formatting methods. In
a multidimensional database, the data is presented to its users through multidimensional arrays, and each
individual value of data is contained within a cell which can be accessed by multiple indexes.
Explanation:
DB2 is a database product from IBM. It is a Relational Database Management System (RDBMS). DB2 is
designed to store, analyze and retrieve the data efficiently. DB2 product is extended with the support of
Object-Oriented features and non-relational structures with XML.
Explanation:
A relational database is a collection of data items with pre-defined relationships between them. These items
are organized as a set of tables with columns and rows. Tables are used to hold information about the objects
to be represented in the database.
Explanation:
Normalization is the process of organizing data in a database. This includes creating tables and establishing
relationships between those tables according to rules designed both to protect the data and to make the
database more flexible by eliminating redundancy and inconsistent dependency.
Explanation:
Oracle database is a relational database management system. It is also called OracleDB, or simply Oracle.
It is produced and marketed by Oracle Corporation. It was created in 1977 by Lawrence Ellison and other
engineers. It is one of the most popular relational database engines in the IT market for storing, organizing,
and retrieving data.
Explanation:
Data mining is a process of extracting and discovering patterns in large data sets involving methods at the
intersection of machine learning, statistics, and database systems. Data mining is an interdisciplinary subfield
of computer science and statistics with an overall goal to extract information (with intelligent methods) from
a data set and transform the information into a comprehensible structure for further use.
Explanation:
SQL, or Structured Query Language is the set of instructions used to interact with databases. An
incredibly simple definition for such a complex subject. SQL is a special purpose programming
language designed for managing data stored in a relational database management system.
Explanation:
A very large database (VLDB) is a type of database that consists of a very high number of database records,
rows and entries, which are spanned across a wide file system. VLDB is similar to a standard database but
contains a very large amount of data. As such, it requires special management, maintenance and technologies
to operate.
Explanation:
A Data Dictionary is a collection of names, definitions, and attributes about data elements that are being used
or captured in a database, information system, or part of a research project. It describes the meanings and
purposes of data elements within the context of a project, and provides guidance on interpretation, accepted
meanings and representation.
Explanation:
Open Database Connectivity (ODBC) is an open standard application programming interface that allows
application programmers to access any database. The main proponent and supplier of ODBC programming
support is Microsoft, but ODBC is based on and closely aligned with The Open Group standard Structured
Query Language ( SQL ) Call-Level Interface (CLI).
Explanation:
COUNT() - returns the number of items in a set.
SUM() - returns the sum of all or distinct values in a set
AVG() - returns the average of a set.
ABS() - Acrylonitrile butadiene styrene
