Intro Database
This is metadata in which definitions of database objects such as base tables, views (virtual tables), synonyms, value ranges, indexes, users, and user groups are stored.
What is Catalog database?
This is used when the value in a column is unknown or missing.
What is Null value.
This SQL operator allows you to specify multiple values in a WHERE clause and is a shorthand for multiple OR conditions.
What is the IN operator?
This is how many whole records fit into a block.
What is a blocking factor?
This is a well-established software application architecture that organizes applications into three logical and physical computing tiers.
What is three-tier architecture?
This framework is used to describe the structure of a specific database system and is also called ANSI/SPARC architecture.
This is three-schema architecture.
This is a general class that is extended by one or more subclasses.
What is superclass?
This command is used to test for empty values, i.e., NULL values.
What is "IS NULL"?
This creates a multi-level tree structure that breaks a database down into fixed-size blocks or pages. All nodes have data pointers.
What is a B-tree index?
This is based on the cost of the query that to be optimized for query.
What is a cost-based optimization (CBO)?
This is the structure of a database described in a formal language supported by the database management system (DBMS).
What is database schema
This is a relationship between two entities in which an instance of a child entity is identified through its association with a parent entity.
What is an an identifying relationship?
This operator should be used in SQL statement to make it same as Relational Algebra.
What is DISTINCT operator?
This is an m-ary tree with a variable but often large number of children per node and is used for indexing structure in DBMS. Only leaf nodes have data pointer.
What is a B+-tree?
This join scans the first, or outer table, and then joins each of the rows that pass table filters to the rows found in the second, or inner table.
What is nested loop join?
This is the information technician responsible for directing and performing all activities related to maintaining a successful database environment.
Who is a database administrator (DBA)?
This is a minimal super key or a super key with no redundant attribute.
What is a candidate key.
What is a trigger?
This is a variable-length record in which the length of the record can exceed the size of a block.
What is a spanned record?
Durability is the final aspect of the ACID approach to database management.
What is durability?
This is non-tabular databases and store data differently than relational tables
What is NoSQL database?
This is an attribute, which is a part of the prime-key, is known as a prime attribute
What is a prime attribute?
This is a set of Structured Query Language (SQL) statements with an assigned name, which are stored in a relational database management system (RDBMS) as a group, so it can be reused and shared by multiple programs.
Wha is a stored procedure?
This is an ordered file whose records are of fixed length with two fields and the first field of the index replicates the primary key of the data file in an ordered manner.
What is a primary index?
This is an advanced version of 3NF (third normal form).
What is BCNF(Boyce Codd Normal Form)?