MTA LinkedIn Learning Quiz || 100% Correct Answers.
The ________ supports a highly structured and efficient storage mechanism that allows you
to enter, organize, protect, and retrieve information.
a. file
b. system
c. SQL
d. DBMS correct answers d. DBMS
A _________ database is a simple spreadsheet or table that follows straightforward
organization rules.
a. server file
b. flat file
c. row line
d. column file correct answers b. flat file
True or False: Anything that can't be illustrated with a branching tree diagram would be a
good fit for a hierarchical database design. correct answers False
By using unique identifiers for each record, you can relate one table to another. These
identifiers are called _______ fields.
a. row
b. main
c. column
d. key correct answers d. key
One of the basic rules of storing data in a database is you want to store information that can
be calculated from other attributes that you're already storing.
a. true
b. false correct answers b. false
A database _______ can either be a dedicated machine or a virtualized machine that is
running the database management software.
a. table
b. server
c. administration
d. file correct answers b. server
The default Authentication mode in order to log in to the SQL server is _______
authentication.
a. server
b. local
c. mixed
d. Windows correct answers d. Windows
,Which of the following is not true about SSMS?
a. It will handle hardware connections.
b. It will allow us to maintain all aspects of our database server.
c. It will handle inputting raw data directly into the tables.
d. It will handle the creation of individual databases and database objects. correct answers a.
It will handle hardware connections.
How do you restore a database from a backup file in SSMS?
a. right-click Databases > Restore Database > Database > choose backup file from the hard
drive
b. right-click Databases > Restore Database > Device > choose backup file from the hard
drive
c. right-click System Databases > Restore Database > restore to > choose backup file from
the hard drive
d. right-click System Databases > Restore Database > Device > choose backup file from the
hard drive correct answers b. right-click Databases > Restore Database > Device > choose
backup file from the hard drive
How do you create a new database in SSMS?
a. right-click System Databases > New Database > General > Input database name
b. right-click Databases > New Database > File Groups > Input database name
c. right-click Databases > New Database > Options > Input database name
d. right-click Databases > New Database > General > Input database name correct answers d.
right-click Databases > New Database > General > Input database name
How do you create a new table in SSMS?
a. Databases > Tables > Add Table
b. Databases > Tables > Table
c. Databases > Tables > New Table
d. Databases > your database name > Tables > Table correct answers d. Databases > your
database name > Tables > Table
How do you modify an existing table in SSMS?
a. Databases > your database name > right-click your table name > Modify
b. Databases > right-click your table name > Table
c. Databases > your database name > right-click your table name > Design
, d. Databases > right-click your table name > Design correct answers c. Databases > your
database name > right-click your table name > Design
How to delete an existing database in SSMS?
a. Databases > right-click database name > remove > select close exiting connections
b. System Databases > Delete > choose database name
c. Databases > right-click database name > Delete > select close exiting connections
d. none of these answers correct answers c. Databases > right-click database name > Delete >
select close exiting connections
The mechanism that SQL Server uses to recombine data from multiple related tables on the
fly is called a ________.
a. combining
b. Sequel
c. view
d. relations correct answers c. view
The _______ database is what SQL Server uses to manage its own instance and
configuration.
a. model
b. master
c. msdb
d. tempdb correct answers b. master
The _______ database is essentially the template for all new databases that are created on the
server.
a. model
b. tempdb
c. msdb
d. master correct answers a. model
How do you add rows to an existing table using SSMS?
a. right-click tablename > choose script table as
b. right-click tablename > choose Select top 1000 rows
c. right-click tablename > choose Edit top 200 rows
d. right-click tablename > choose Design correct answers c. right-click tablename > choose
Edit top 200 rows
The ________ supports a highly structured and efficient storage mechanism that allows you
to enter, organize, protect, and retrieve information.
a. file
b. system
c. SQL
d. DBMS correct answers d. DBMS
A _________ database is a simple spreadsheet or table that follows straightforward
organization rules.
a. server file
b. flat file
c. row line
d. column file correct answers b. flat file
True or False: Anything that can't be illustrated with a branching tree diagram would be a
good fit for a hierarchical database design. correct answers False
By using unique identifiers for each record, you can relate one table to another. These
identifiers are called _______ fields.
a. row
b. main
c. column
d. key correct answers d. key
One of the basic rules of storing data in a database is you want to store information that can
be calculated from other attributes that you're already storing.
a. true
b. false correct answers b. false
A database _______ can either be a dedicated machine or a virtualized machine that is
running the database management software.
a. table
b. server
c. administration
d. file correct answers b. server
The default Authentication mode in order to log in to the SQL server is _______
authentication.
a. server
b. local
c. mixed
d. Windows correct answers d. Windows
,Which of the following is not true about SSMS?
a. It will handle hardware connections.
b. It will allow us to maintain all aspects of our database server.
c. It will handle inputting raw data directly into the tables.
d. It will handle the creation of individual databases and database objects. correct answers a.
It will handle hardware connections.
How do you restore a database from a backup file in SSMS?
a. right-click Databases > Restore Database > Database > choose backup file from the hard
drive
b. right-click Databases > Restore Database > Device > choose backup file from the hard
drive
c. right-click System Databases > Restore Database > restore to > choose backup file from
the hard drive
d. right-click System Databases > Restore Database > Device > choose backup file from the
hard drive correct answers b. right-click Databases > Restore Database > Device > choose
backup file from the hard drive
How do you create a new database in SSMS?
a. right-click System Databases > New Database > General > Input database name
b. right-click Databases > New Database > File Groups > Input database name
c. right-click Databases > New Database > Options > Input database name
d. right-click Databases > New Database > General > Input database name correct answers d.
right-click Databases > New Database > General > Input database name
How do you create a new table in SSMS?
a. Databases > Tables > Add Table
b. Databases > Tables > Table
c. Databases > Tables > New Table
d. Databases > your database name > Tables > Table correct answers d. Databases > your
database name > Tables > Table
How do you modify an existing table in SSMS?
a. Databases > your database name > right-click your table name > Modify
b. Databases > right-click your table name > Table
c. Databases > your database name > right-click your table name > Design
, d. Databases > right-click your table name > Design correct answers c. Databases > your
database name > right-click your table name > Design
How to delete an existing database in SSMS?
a. Databases > right-click database name > remove > select close exiting connections
b. System Databases > Delete > choose database name
c. Databases > right-click database name > Delete > select close exiting connections
d. none of these answers correct answers c. Databases > right-click database name > Delete >
select close exiting connections
The mechanism that SQL Server uses to recombine data from multiple related tables on the
fly is called a ________.
a. combining
b. Sequel
c. view
d. relations correct answers c. view
The _______ database is what SQL Server uses to manage its own instance and
configuration.
a. model
b. master
c. msdb
d. tempdb correct answers b. master
The _______ database is essentially the template for all new databases that are created on the
server.
a. model
b. tempdb
c. msdb
d. master correct answers a. model
How do you add rows to an existing table using SSMS?
a. right-click tablename > choose script table as
b. right-click tablename > choose Select top 1000 rows
c. right-click tablename > choose Edit top 200 rows
d. right-click tablename > choose Design correct answers c. right-click tablename > choose
Edit top 200 rows
