Tag: databases

Back up the current transaction log. Restore the database with a different name and stop at

Back up the current transaction log. Restore the database to the point just before the data loss.

Restore the database from the existing backup files to a time just before the data loss.

Restore the database to the point of the last full backup.

Execute DBCC CHECKFILEGROUP for each filegroup.

Execute DBCC CHECKCATALOG.

Execute DBCC CHECKDB.

Execute DBCC CHECKTABLE for each table.

nvl(mgrno,0)

nvl(mgrno,'none')

nvl('mgrno',0)

nvl(mgrno,'0')

control files

password files

parameter files

redo logs

buffer cache

large pool

java pool

all the above

True

False

select ename||',is the'||job from emp

select ename,||'is the||job from emp

select 'ename'||'is the'||'job' from from emp

select ename||concat('is the',job) from emp

Source file

Directories

Binary files

All the above

It is a dynamic view.

It is a rule determine which versions of an element are visible in the new view

None of the above.

All of the above.

Check-In

Check-Out

Deliver

Retrieve