What is a data dictionary?, A collection of database tables, A DBMS component that stores metadata about data, A program used to create websites, A backup copy of the database, Which of the following is an example of metadata stored in a data dictionary?, Student's actual name, Student's actual phone number, The data type of the Student_ID field, The student's examination mark, Which of the following is NOT a use of a data dictionary?, Supporting data analysis and database design, Monitoring database security, Ensuring naming standards are followed, Storing actual customer transaction records, A system catalog describes the objects within a database. Which information can be found in a system catalog?, Table names, Field names, Data types and constraints, All of the above, Which constraint ensures that a field must contain a value?, UNIQUE, CHECK, NOT NULL, FOREIGN KEY, Which constraint uniquely identifies each record in a table?, PRIMARY KEY, FOREIGN KEY, CHECK, NOT NULL, What is the purpose of a FOREIGN KEY?, To uniquely identify every record in the same table, To connect a table to another table, To prevent duplicate values in every field, To ensure a field cannot be empty, LINE (INV_NUMBER <PK, FK>, LINE_NUMBER <PK>, P_CODE <FK>, LINE_UNITS, LINE_PRICE). Which field is a composite primary key?, INV_NUMBER only, LINE_NUMBER only, INV_NUMBER and LINE_NUMBER, P_CODE and LINE_PRICE, In a relational database, what is a tuple?, A column, A table, A row/record, A database constraint, What is an RDBMS?, A collection of programs that manages a relational database, A type of primary key, A data dictionary containing metadata, A programming language used to create databases

DATA DICTIONARY & RDBMS

by
Print
Embed

Leaderboard

Visual style

Options

Switch template

Continue editing: ?