5. which of the following is true regarding table views? A. datasheet views show
ID: 3804925 • Letter: 5
Question
5. which of the following is true regarding table views?
A. datasheet views shows a detailed view of the table design you can add edit and delete records using design view
B. changes made in datasheet are automatically saved when you move the insertion point
6. which of the following utilities is used to recover in the event of loss or damage?
A. compact and repair databse
B. Encrypt database
C. back up database
D. database Spltter
which of the following would be matched if you use a selection filters exact match option for the name Ann?
A. Ann, ANN, and ann
B. Danny, Ann, and Anny
C. Ann (but not ANN)
D. both a and b
Explanation / Answer
5-changes made in datasheet are automatically saved when you move the insertion point. because table views are basically virtual tables which are a result of an sql query. when we put a query to a table and the result is stored in another table with diffrent name that table is called as a view. so when insertion point is moved changes made in datasheet are automatically saved.
6- backup database utility is used in case of a damage or loss to the data base. data reconstruction is achieved using media recovery. various operations are performed in order to reconstruct the data. there are various ways of backing up data.You can make physical backups with either the recovery manager utility or operating system utilities. In contrast logical backups contain logical data for ex tables and stored procedures extracted with an oracle utility and stored in a binary file. you can use logical backups to supplement physical backups.
7-Ann (but not ANN) because we are searching for the exact match for the Ann so the sql server will search only for Ann nut not ANN or ann.
we will write query as
Select * from tablename where name='Ann';
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.