#theredo

[joyffree]

NewRelease avail. in #KindleUnlimited

Title: The Redo Author: Max Monroe Genre: Romantic Comedy Release Date: July 17, 2022 Cover Photographer: Wander Aguiar Photography Cover Model: Andrew Biernat

Put a finger down if you’ve ever been a single woman who got stuck in a New York City elevator in the middle of a summer blackout with your former high school sweetheart—whom you haven’t seen in years—while pregnant with a baby that isn’t biologically yours. And you can’t believe how handsome that blast from your past is, so you unwittingly flirt with him a little even though your life is so crazy complicated you’re barely keeping your head above water, but everything about him makes you think you could totally still be in love with him.

puts a finger down

What? Just me?

@authormaxmonroe Hosted by Enticing Journey Book Promotions

[mindischaefer]

#polingbaconclassic5k #theredo #2019 @cassandra.rny.yoga #teampolinglaw (at Glacier Ridge Metro Park) https://www.instagram.com/p/B1BoHe-AStQIyCriDpDGr_W8X9E3-rBEMWhboc0/?igshid=1ecjpwz28cixi

[elegantmakerartisan]

the Arlo Pro 3

Hi, folks. This is Gabe at Security Baron, and Arlo isback at again bringing you some 2K action. Today, we’re checking out the Arlo Pro 3. [background music] Gabe: In today’s review of the Arlo Pro 3,we’re going to go over some pros and cons, its design, its feature set, the installation,and mobile app experience before answering some common questions and letting you knowwho we think this device is for. If you want to see the full details on theArlo Pro 3 and check out some smart home integrations, head over to securitybaron.com. Let’s kick off our review of the Arlo Pro3 going over some pros and cons, beginning with the pros, beginning with that video quality. It can record it up to 2K but even the 1080looks solid on whatever device you happen to be using.best home outdoor wireless security camera 

That 2K is gorgeous, really clear and youalso get 160-degree field of view HDR. It’s just really bring in the heat. Now that extends to its night vision whereit ups the ante with having a surprisingly solid vision with just two infrared LEDs. If you add on that spotlight it gets evenbetter where you have this color night vision that makes it seem almost as if the middleof the night is as clear as day. We’re really impressed with the video qualityelement in that way. Beyond that, you have the wireless elementof the Arlo Pro 3 and the durability. That means you can place it both indoors andoutdoors. It’s weather resistant and you can handlesun, snow, sleet, rain, you name it and still work really well to make sure you’re capturingeverything that’s taking place in your home or outside of it. When it comes to cons to Arlo Pro 3, I thinkthe issue of 2K is really representative of the overall experience. We had issues getting the 2K to work initiallyand we never essentially got the 2K to work when it comes to manual recording. That was an issue that to do with the faultyhub and a mobile application that is not always the most intuitive. Overall, yes, I think that Arlo has a lotof depth, a lot of robust features that you can really dive deeply into, but it’s justnot effortless in terms of getting to them like we’ve seen with some of the other camerason the market. [music] Gabe: Now that we’ve gone over the pros andcons, let’s talk about the design on the Arlo Pro 3 in which I’m actually a really big fan. The Arlo Pro 3 is the first one that we’vegotten in the nice black, but it isn’t really glossy black. You’re definitely going to get your fingerprintson it, but just a really solid looking device, really sleek, really elegant. When it comes to mounting, it has a lot ofoptions. You can, of course, thread as in mount intothe back of the device itself, but we like this nice little magnetic mount that givesyou a lot of flexibility. You can put it in a lot of different ways,it’s just going to work for you. It’s really strong and if you don’t want tohave that on for a moment, you can take it off, you can place it simply down, somethinglike this. You’re wondering, “How do I charge this device?” Really easy to put that initial battery in,but actually once you have your battery inside and have this thing set up, you can closethis and really never open it again, because there is a magnetic mount on the bottom ofthe device. You’re thinking, “I hope I don’t have to unscreweverything each time that I want to charge it.” You don’t. Take it off the magnet, take your magneticcharger, and voila, you’re ready to go. That’s it, you charge it, give it a few hours,and you’re good for another few months. Note that you also have the Smart Hub. The Smart Hub itself has gotten a bit of anupgrade since the Arlo Pro 2. It’s also nice and sleek, it’s thinner, ithas a good look to it. It will basically blend into anyone’s homedecor, it’s in that nice white with your Arlo insignia, and you get this nice little LEDlight to know when it’s on and off. The final element I’ll talk about with yourArlo Pro 3 itself is the fact that it’s almost completely flush. You have your lens, you’ve got microphone,speaker, and you have your spotlight. This is a pretty thin spotlight that’s bringinga lot of light. It’s going to be really bright with just thislittle bit here. Overall, big fan of not only the design onthe Arlo Pro 3, but the Arlo Smart Hub. [music] Gabe: Hold on. I hope you’re enjoying today’s review of theArlo Pro 3. If you want to be kept up to date on the newestin smart home security cameras, smart home security in general, cybersecurity, bluetoothtrackers, and more, subscribe to our channel, Security Baron. We’re dropping new content weekly. Let’s get back to the video. [music] Gabe: Now that we’ve gone over the pros andcons and the design of the Arlo Pro 3, let’s talk about its feature set, beginning withthat video quality. It can capture motion events in 2K and itjust looks amazing. It’s capturing things in 2K with a 160-degreefield of view, HDR, and it’s just got a really lovely crisp and clear video quality to it. It even means that it can do that in nightvision, where we have a solid infrared LED perspective that can be enhanced by colornight vision with the spotlight that comes equipped on your Arlo Pro 3, allowing youto see things in the middle of the night in that nice vivid color perspective. This clarity with the Arlo Pro 3 extends tothe audio experience.best home outdoor wireless security camera 

I was able to have really clear conversationswith people on the other side. It has a microphone and a speaker embeddedinside of it. In terms of the conversation capacity or capability,it’s really high with the Arlo Pro 3. Automated Voice: I can hear you. Sounds good. Sounds good. Gabe: When it comes to saving these audio/videoclips, you have a few different options with your Arlo Pro 3, including local storage withyour Arlo Smart Hub. You can install a SD card, up to 128 GB, whichwill allow for you to save those directly to your Smart Hub itself. Additionally, you can get the cloud storagewith your Arlo Pro 3 in an Arlo Smart Plan. Fortunately, you do get three months of theArlo Smart Plan for free whenever you buy your Arlo Pro 3. One thing to note about the Arlo Pro 3 andArlo Smart Plan is that it’s going to give you 30 days’ video history, basically anysmart plan. The real key here is you get a number of advancedfeatures as well. There are multiple offerings that can geta bit complicated. For full details, go check it out at securitybaron.com. Let’s talk about some of those advanced features,like activity zones. In addition to motion sensitivity that canbe adjusted within the app, you can also set up activity zones that will only give youa motion alert when it detects motion in those particular spaces that you’re looking for. I can build my own in the app, multiple, multipleactivity zones. What types of motion can it distinguish between? This is where that artificial intelligencecomes into play. The Arlo Pro 3 is capable of distinguishingbetween people and animals and vehicles. It even has some degree of package detection,which is pretty impressive. The Arlo Pro 3 also integrates with the twomajor smart platforms out there — Amazon and Google. I can use my voice and the linking of my Arloand Google and Amazon Virtual Assistant to watch my footage wherever I want. I can send a live stream to something likemy Google Chromecast just using my voice. Overall, the Arlo Pro 3 is really great, anice, robust and deep feature set to the home security camera game. [music] Gabe: Now that we’ve covered the feature setwith the Arlo Pro 3, let’s talk about the installation process. Here, I’ve got somewhat mixed feelings. When it comes to installing the device,

best home outdoor wireless security camera it’spretty straightforward. You’re going to have your Smart Hub done first. Plug in your Ethernet cable, plug in yourpower adapter. Once that’s up and set, you’re going to gothrough the process with your Arlo Pro 3. You’re going to be navigating it using themobile application. Make sure your battery is charged here atthe bottom. Boom. You’re done. You can probably be finished in a matter ofminutes, with adding any extra time deciding if you want to mount your magnetic mount outdoors,indoors, wherever you decide to put it. Overall, that part of the process is prettystraightforward. Where we ran into issues is when it comesto making sure you get the full capacity of your Arlo Pro 3. Remember, this is a 2K device. In order to get that 2K, you have to makesure, for one, you’re on the most recent version of the Arlo Smart Hub. We had one of those because we had the ArloUltra. However, we found out that our version wasfaulty. It took a long conversation with Arlo to finallycome to that conclusion, and then we had to get a replacement. Of course, to get the 2K recording, you haveto ensure that you have an SD card installed here at the bottom. Overall, that entire process took a littlebit longer than we think it needed to. It is a really important part of getting thefull capability out of your Arlo Pro 3. Otherwise, very straightforward, easy setupwith your Arlo Pro 3. [music] Gabe: Now that we’ve got our Arlo Pro 3 installed,let’s check out its mobile application, the Arlo app Generally speaking, people seem to have agood experience with it. It has a 4.5 in the Apple App Store and a3.8 in the Google Play Store. Let’s go ahead and check it out on my iPhone7 Plus. Here I am, checking out the Arlo Pro 3  inthe Arlo mobile application. Let’s go ahead and jump directly into thatlive stream. You note that it takes a minute to jump intothe live stream. It’s not immediate. Even now that we’re in the live stream, theredoes seem to be a delay. There’s a lag on what happens that’s a littlebit longer, I’d say about four to five seconds at times, than many of the competitors. You also note that we’re not actually streamingin 2K. This is not a 2K-enabled device, but evensometimes when I’m on 2K-capable devices, we noted that it did not actually give usthat live stream in 2K. You’ll see there are a number of icons atthe bottom. I have the speaker on the bottom left. I’ve got the microphone for two-way talk. I’ve got the ability to take a snapshot, turnon that spotlight in the far right-hand bottom corner, and then I can just record. You see here, I’m recording now, and thisis a pretty useful element. You can record that live stream. One thing we want to note as we’re recordingthis live stream, is that we have had issues with it actually recording live stream, somanual recording in 2K. It does do motion detection, things of thatnature in 2K, but in our personal experience, it would not actually do live recordings in2K no matter which device we happen to be using. Let’s go ahead and look at our event history,and just look at our history in our library. Go down to the bottom and you see here, nowwe have our manual recording that we just did. We’ve got various motion recordings in 2Kthat it was capable of doing. If you look at the top, we have a history,so I can go to the 15th, go to the 14th. I got package options. I got 18th, 19th. You can just look at a host of different thingsgoing on here. If you look at the filter in the top, youcan actually filter by the type of notification — people, vehicle, animal, package, smokealarms, motion alarms, audio — which is really useful. If we were to go to today, let’s just sayI wanted to download this 2K motion detection. I can watch it here. You can see me blowing out. [laughs] I can download the video directlyto this device. I can share it. I can send this video off to someone I’d liketo through message, or email, or shared album. It is great that you do have the ability tocontrol your recordings pretty quickly and easily. Now we can jump back out of that. Let’s go ahead and check out some of theseother elements of the Arlo Pro 3, beginning by just looking at the video settings. Of course, when you’re in the device settings,you’ll note that it has the ability to tell you how much battery life you have. It tells you which Smart Hub you’re connectedto. If you go into your motion detection setting,this actually allows you to decide how sensitive you want your cameras to be. This is one element that typically is notunder something called “device utilities” in a mobile application, so it did take usa little while, initially, to find out exactly where to find these elements of controllingour Arlo Pro 3. Low, medium, and high are your options. Let’s go check out some of our video settings. Now we have the ability to change our brightness. It’s currently at 50 percent. We could take it up to 75 percent, 100 percent. to know more   best home outdoor wireless security camera 

[jayuice125]

View this post on Instagram

A post shared by dj jay-u-ice (@djjayuice)

GRIND TIME TUES @officialwuworldwidedjcoalition NO CORONA VIRUS THE SHOW MUST GO ON & THIS WHAT #realdjs DO KEEP THE #undergroundhiphop MUSIC MOVIN & GROOVIN THA SAGA CONTINUE!!! THANKS @prime237 in his words!!! Afternoon fellas. Got my last "hurrah" in last night before the #Ohio shutdown of clubs and restaurants. Our Monthly Vinyl party called #TheReDo went out with a bang. Did an all 45 set. @werocxr920 @wuworld #salutetha7s #OFFICIALWUWORLDWIDEDJCOALITION #officialwuworldwidedjcoalitionlovestheworld #OfficialWuWorldwideDjCoalitionlovethekids https://www.instagram.com/p/B91cAHIH4J6/?igshid=90xf2r4kmij8

[jayfederjewelers]

View this post on Instagram

A post shared by Jay Feder Jewelers (@jayfederjewelers)

Sound on for the Heirloom commercial! Version 3 in our series of commercials telling the JFJ story ❤️❤️ @cestlestyle_ @jencic @spectruminnovations @colleenchambersofficial #jayfederjewelers #whosyourjeweler #theredo #heirlooms (at Jay Feder Jewelers) https://www.instagram.com/p/BsJxM8DFyLK/?utm_source=ig_tumblr_share&igshid=i36fnc13l7zk

[smartstudioakron]

#MuseumMonday ‘The Redo’ by Femke Hiemstra #MuseumCats #Repost @femtasia ・・・ Full view of my latest piece 'The Redo', loosely based on my recent move to another town, and the changes that come with it. Acrylics on paper, © Femke Hiemstra, 2018.⠀ Made for the 13th annual BLAB! group exhibition curated by Monte Beauchamp at Copro Nason Gallery, Santa Monica, CA, USA. Opening September 8th, 2018.⠀ ⠀ #femkehiemstra #femtasia #acrylics #spotlessjaguar #beingoneself #yetnotquitethesame #theredo #blab! #copronason (at Santa Monica, California) https://www.instagram.com/p/Bni9HL6gTi2/?utm_source=ig_tumblr_share&igshid=17k7vtabqjubl

[mrstorme]

#Cratedigga #TheReDo

[awesumestofall]

Laila's been making that face since 2008, lol. #theredo #nowvsthen #pussnbootsmakesacomeback #shestillsalty

[soraxtm]

Gardening At Night

1:50 AMtoo earlydrift backlistening aboutancient greek battlethat apparently hasn’t reallybeen written about enough 3:30 AMgardeningfuck REMI don’t really care It used to seeminterestingto wonderwhat people might thinkabout someone out theregardening at night Freedom to do.No time to do. I don’t reallygive a shit aboutthat anymorei am just out theredoing something thatseems to need to be done

[chibiisukee]

Psss, hey

Yes, you right there

Do you like the Frontier girls? Do you wish there was more content for them?

Well, here’s the chance! There’s a Frontier Week gearing up and the organizers have even made a blog for it!

Check out @frontierweek for more details!

And Onwards, to Frontier!

[joyffree]

🎉 𝗖𝗢𝗩𝗘𝗥 𝗥𝗘𝗩𝗘𝗔𝗟 𝗗𝗔𝗬 ⬇️

🔥 𝐓𝐇𝐄 𝐑𝐄𝐃𝐎  by Max Monroe is releasing 𝐉𝐮𝐥𝐲 𝟏𝟕𝐭𝐡 𝐏𝐫𝐞𝐎𝐫𝐝𝐞𝐫 your copy today on 𝐀𝐦𝐚𝐳𝐨𝐧 ➜ mybook.to/TheRedo_Ebook

𝗖𝗼𝘃𝗲𝗿 𝗣𝗵𝗼𝘁𝗼𝗴𝗿𝗮𝗽𝗵𝗲𝗿 ➜ Wander Aguiar Photography 𝗖𝗼𝘃𝗲𝗿 𝗠𝗼𝗱𝗲𝗹 ➜ Andrew Biernat

Put a finger down if you’ve ever been a single woman who got stuck in a New York City elevator in the middle of a summer blackout with your former high school sweetheart—whom you haven’t seen in years—while pregnant with a baby that isn’t biologically yours. And you can’t believe how handsome that blast from your past is, so you unwittingly flirt with him a little even though your life is so crazy complicated you’re barely keeping your head above water, but everything about him makes you think you could totally still be in love with him.

*𝘱𝘶𝘵𝘴 𝘢 𝘧𝘪𝘯𝘨𝘦𝘳 𝘥𝘰𝘸𝘯*

🎧 𝗟𝗶𝘀𝘁𝗲𝗻 𝘁𝗼 𝘁𝗵𝗲 𝗣𝗹𝗮𝘆𝗹𝗶𝘀𝘁 ➜ https://spoti.fi/3N0d43W 📕 𝗔𝗱𝗱 𝘁𝗼 𝗚𝗼𝗼𝗱𝗿𝗲𝗮𝗱𝘀 𝗧𝗕𝗥 ➜ https://bit.ly/3Rj99mn 📖 𝗔𝗱𝗱 𝘁𝗼 𝗕𝗼𝗼𝗸𝗯𝘂𝗯 ➜ https://bit.ly/3yCVCyv

Hosted by Enticing Journey Book Promotions

[x-heesy]

Full view of my latest piece 'The Redo', loosely based on my recent move to another town, and the changes that come with it. Acrylics on paper, © Femke Hiemstra, 2018.⠀ Made for the 13th annual BLAB! group exhibition curated by Monte Beauchamp at Copro Nason Gallery, Santa Monica, CA, USA. Opening September 8th, 2018.⠀ ⠀ #femkehiemstra #femtasia #acrylics #spotlessjaguar #beingoneself #yetnotquitethesame #theredo #blab! #copronason Femke Hiemstra, instagram.com

[teaminterval]

Owe your existence to the Ozone up thereDo not destruct, but protectSeptember 16-world Ozone day.....TeamINTERVAL INTERVAL

[taochild]

He said She said

He said She said

I swear she’s part cow!

Here is a nifty chart to ease communications with Brown Dog. Follow this simple guide and life will be easier for all concerned. 

Human says:Human means:Cooperative Brown Dog hearsUNcooperative Brown Dog hears“sit”sitwanna treat?ignore me“stay”stay therestay theredo what you want“come”come herewanna treat?ignore me“wanna play?”wanna play?wanna play?wanna…

[sundancepoetry]

Galaxies of women… Galaxies of women, theredoing penance for impetuousness   ribs chilled   in those spaces    of the mind Adrienne Rich, 'Planetarium'

[siva3155]

300+ TOP Memory Management Interview Questions and Answers

Memory Management Interview Questions for freshers experienced :-

1. What is the significance of having storage clause? We can plan the storage for a table as how much initial extents are required, how much can be extended next, how much % should leave free for managing row updations etc. 2. What is the functionality of SYSTEM table space? To manage the database level transactions such as modifications of the data dictionary table that record information about the free space usage. 3. How does Space allocation table place within a block? Each block contains entries as follows Fixed block header Variable block header Row Header,row date (multiple rows may exists) PCTEREE (% of free space for row updation in future). 4. What is the role of PCTFREE parameter is storage clause? This is used to reserve certain amount of space in a block for expansion of rows. 5. What is the OPTIMAL parameter? To avoid the space wastage we use OPTIMAL parameter. 6. What is a shared pool? The Shared Pool environment contains both fixed and variable structures. The Fixed structures remain relatively the same size, whereas the variable structures grow and shrink based on user and program requirements. Used To Store Most Recently Executed SQL Statements Most Recently used Data definitions It Consists of two Key performance - related memory structures Library Cache & Data Dictionary Cache Shared Pool is sized by SHARED_POOL_SIZE 7. What is mean by Program Global Area (PGA)? It is area in memory that is used by a Single Oracle User Process. 8. What is a data segment? Data segment are the physical areas within a database block in which the data associated with tables and clusters are stored. 9. What are the factors causing the reparsing of SQL statements in SGA? Due to insufficient Shared SQL pool size. Monitor the ratio of the reloads takes place while executing SQL statements. If the ratio is greater than 1 then increase the SHARED_POOL_SIZE. LOGICAL & PHYSICAL ARCHITECTURE OF DATABASE. 10. What is Database Buffers? Database buffers are cache in the SGA used to hold the data blocks that are read from the data segments in the database such as tables, indexes and clusters DB_BLOCK_BUFFERS parameter in INIT.ORA decides the size.

Memory Management Interview Questions 11. What is dictionary cache? Dictionary cache is information about the databse objects stored in a data dictionary table. 12. Which parameter in Storage clause will reduce number of rows per block? PCTFREE parameter Row size also reduces no of rows per block. 13. What is meant by free extent? A free extent is a collection of continuous free blocks in tablespace. When a segment is dropped its extents are reallocated and are marked as free. 14. How will you force database to use particular rollback segment? For perticular transaction Alter system set rollback segment 'name'; For database, we can set in pfile. Rollback_segment='name' . 15. How can we organize the tablespaces in Oracle database to have maximum performance? Store data in tablespaces to avoid disk contension.system tablespace-recursive callsuserdata-users objectsindex tablespace-for indexesrollback segmnets-undo tablespace or manual rollback segmentsplace application specific data in respective tablespaces.Place all these tablespaces in saperate disks.Try to implement raid-0 (striping) for better performance. 16. How will you swap objects into a different table space for an existing database? Export the user Perform import using the command imp system/manager file=export.dmp indexfile=newrite.sql. This will create all definitions into newfile.sql. Drop necessary objects. Run the script newfile.sql after altering the tablespaces. Import from the backup for the necessary objects. 17. What is redo log buffer? Changes made to entries are written to the on-line redo log files. So that they can be used in roll forward operations during database recoveries. Before writing them into the redo log files, they will first brought to redo log buffers in SGA and LGWR will write into files frequently. LOG_BUFFER parameter will decide the size. 18. What is meant by recursive hints? Number of times processes repeatedly query the dictionary table is called recursive hints. It is due to the data dictionary cache is too small. By increasing the SHARED_POOL_SIZE parameter we can optimize the size of Data Dictionary Cache. 19. How can we plan storage for very large tables? Limit the number of extents in the table Separate Table from its indexes. Allocate Sufficient temporary storage. 20. How will you estimate the space required by a non-clustered tables? Calculate the total header size Calculate the available dataspace per data block Calculate the combined column lengths of the average row Calculate the total average row size. Calculate the average number rows that can fit in a block Calculate the number of blocks and bytes required for the table. After arriving the calculation, add 10 % additional space to calculate the initial extent size for a working table. 21. It is possible to use raw devices as data files and what are the advantages over file system files? Yes. The advantages over file system files. I/O will be improved because Oracle is bye-passing the kernnel which writing into disk. Disk Corruption will be very less. 22. What is a Control file? The Control File is a small binary file necessary for the database to start and operate successfully. Each Control file is associated with only one Oracle database. Before a database is opened, the control file is read to determine if the database is in a valid state to USE. The Control file is not accessible, the database does not function properly. 23. How will you monitor rollback segment status? By using dictionaray view's called v$rollstat,dba_rollback_segs. 24. How will you monitor the space allocation? This can be monitored in DB_data_files. 25. Why query fails sometimes? Due to syntax errors. 26. How the space utilization takes place within rollback segments? By correctly fixing optimal size. 27. How will you create multiple rollback segments in a database? create rollback segment roll1tablespace roll1. 28. What is a rollback segment entry? When ever changes happend to the database previous change will be there in the rollback segment. 29. What is hit ratio? Hit Ratio is the ratio of shared SQL and PL/SQL items found in the Library Cache versus physical storage.It can also be defined in a mathematical expression as 1 - ((physical reads) / (db block gets + consistent reads)). 30. What are disadvantages of having raw devices? We should depend on export/import utility for backup/recovery (fully reliable) The tar command cannot be used for physical file backup, instead we can use dd command which is less flexible and has limited recoveries. StumbleUpon Digg Delicious Twitter FaceBook LinkedIn Google Yahoo MySpace Tell Your Friend 31. What is use of rollback segments in Oracle database? When a user updated a particular table (for example 100 rows) the old value will be retained in the roll back segments(Oracle 8) and now it is Undo segment (oracle 9i). If the user issue a rollback command the old value will be taken from the rollback segment(that too if undo_retention parameter set properly in the parameter file). 32. What is advantage of having disk shadowing / mirroring? Shadow set of disks save as a backup in the event of disk failure. In most Operating System if any disk failure occurs it automatically switchover to place of failed disk. Improved performance because most OS support volume shadowing can direct file I/O request to use the shadow set of files instead of the main set of files. This reduces I/O load on the main set of disks. 33. How redo logs can be achieved? LGWR process wirtes all change vectors from theredo log buffer to online redo log file sequentially. 34. What is redo log file mirroring? Multiplexing Redo log file called Mirroing. ( Keeping multiple copies in different disks) 35. How to implement the multiple control files for an existing database? Edit init.ora file set control_files parameter with multiple location shutdown immediate copy control file to multiple locations & confirm from init.ora contol_files parameter start the database. run this query for changes confirmation - select name from v$controlfile; 36. What is SGA? How it is different from Ver 6.0 and Ver 7.0? The System Global Area in a Oracle database is the area in memory to facilitates the transfer of information between users. It holds the most recently requested structural information between users. It holds the most recently requested structural information about the database. The structure is Database buffers, Dictionary cache, Redo Log Buffer and Shared SQL pool (ver 7.0 only) area. 37. What is a Shared SQL pool? The data dictionary cache is stored in an area in SGA called the Shared SQL Pool. This will allow sharing of parsed SQL statements among concurrent users. 38. What is mean by Program Global Area (PGA)? It is area in memory that is used by a Single Oracle User Process. 39. List the factors that can affect the accuracy of the estimations? The space used transaction entries and a deleted record does not become free immediately after completion due to delayed cleanout. Trailing nulls and length bytes are not stored. Inserts of, updates to and deletes of rows as well as columns larger than a single datablock, can cause fragmentation and chained row pieces. 40. What are the different kind of export backups? Full back - Complete database Incremental - Only affected tables from last incremental date/full backup date. Cumulative backup - Only affected table from the last cumulative date/full backup date. 41. What is cold backup? What are the elements of it? Cold backup is taking backup of all physical files after normal shutdown of database. We need to take. All Data files. All Control files. All on-line redo log files. The init.ora file (Optional) 42. What is a logical backup? Logical backup involves reading a set of database records and writing them into a file. Export utility is used for taking backup and Import utility is used to recover from backup. 43. What is hot backup and how it can be taken? Taking backup of archive log files when database is open. For this the ARCHIVELOG mode should be enabled. The following files need to be backed up. All data files. All Archive log, redo log files. All control files. 44. What is the use of FILE option in EXP command? To give the export file name. 45. What is the use of GRANT option in EXP command? A flag to indicate whether grants on databse objects will be exported or not. Value is 'Y' or 'N'. 46. What is the use of INDEXES option in EXP command? A flag to indicate whether indexes on tables will be exported. 47. What is the use of ROWS option in EXP command? Flag to indicate whether table rows should be exported. If 'N' only DDL statements for the database objects will be created. 48. What is the use of PARFILE option in EXP command? Name of the parameter file to be passed for export. 49. What is the use of ANALYSE ( Ver 7) option in EXP command? A flag to indicate whether statistical information about the exported objects should be written to export dump file. 50. What is the use of FULL option in EXP command? A flag to indicate whether full databse export should be performed. 51. What is the use of OWNER option in EXP command? List of table accounts should be exported. 52. What is the use of TABLES option in EXP command? List of tables should be exported. 53. What is the use of RECORD LENGTH option in EXP command? Record length in bytes. 54. What is the use of INCTYPE option in EXP command? Type export should be performed COMPLETE,CUMULATIVE,INCREMENTAL 55. What is the use of RECORD option in EXP command? For Incremental exports, the flag indirects whether a record will be stores data dictionary tables recording the export. 56. What is the use of ROWS option in IMP command? A flag to indicate whether rows should be imported. If this is set to 'N' then only DDL for database objects will be executed. 57. What is the use of INDEXES option in IMP command? A flag to indicate whether import should import index on tables or not. 58. What is the use of GRANT option in IMP command? A flag to indicate whether grants on database objects will be imported. 59. What is the use of SHOW option in IMP command? A flag to indicate whether file content should be displayed or not. 60. What is the use of FILE option in IMP command? The name of the file from which import should be performed. 61. What is use of LOG (Ver 7) option in EXP command? The name of the file which log of the export will be written. Memory Management Questions and Answers Pdf Download Read the full article