#databasesize
Explore tagged Tumblr posts
brioteq · 5 years ago
Text
Scripts to find table, schema and database size:
Scripts to find table, schema and database size:
Application team will ask ORACLE DB’s to take export backup of tables, schema and database to import in another place. To take backup, we need to know what is the size of the table or schema or database. So that we can check if we have enough space at file system level for saving export backup. Below are SQL Queries,commands and scripts to find schema size, table size and database size.
To find…
View On WordPress
0 notes
toppersexam · 5 years ago
Text
GATE Computer Science Syllabus, Paper, Books, Notes, Online Mock Test, MCQ at Toppersexam.com
GATE Computer Science Syllabus, Paper, Books, Notes, Online Mock Test, MCQ The Graduate Aptitude Test in Engineering is an examination that primarily tests the comprehensive understanding of various undergraduate subjects in engineering and science for admission into the Masters Program of institutes as well as jobs at Public Sector Companies. GATE Computer Science Online Mock Test Crack GATE Computer Science Recruitment exam with the help of online mock test Series or Free Mock Test. Every Sample Paper in GATE Computer Science Exam has a designated weightage so do not miss out any Paper. Prepare and Practice Mock for GATE Computer Science exam and check your test scores. You can get an experience by doing the Free Online Test or Sample Paper of GATE Computer Science Exam. Free Mock Test will help you to analysis your performance in the Examination. GATE Computer Science Online Mock Test : Available Now GATE Computer Science MCQs and Paper Buy the question bank or online quiz of GATE Computer Science Exam Going through the GATE Computer Science Exam Question Bank is a must for aspirants to both understand the exam structure as well as be well prepared to attempt the exam. The first step towards both preparation as well as revision is to practice from GATE Computer Science Exam with the help of Question Bank or Online quiz. We will provide you the questions with detailed answer. GATE Computer Science MCQs and Paper : Available Now GATE Computer Science Books : Click Here GATE Computer Science Syllabus GENERAL APTITUDE Verbal Ability : English Grammar, Sentence Completion, Verbal Analogies, World Groups Instructions, Critical Reasoning, and Verbal Deduction, etc. Numerical Ability : Numerical Computation, Numerical Estimation, Numerical Reasoning and Data Interpretation, etc. Computer Science and Information Syllabus Discrete Mathematics : Propositional and first-order logic. Sets, relations, functions, partial orders and lattices. Groups. Graphs : connectivity, matching, coloring. Combinatorics: counting, recurrence relations, generating functions. Linear Algebra : Matrices, determinants, system of linear equations, eigenvalues and eigenvectors, LU decomposition. Calculus : Limits, continuity, and differentiability. Maxima and minima. Mean value theorem. Integration. Probability : Random variables. Uniform, normal, exponential, Poisson and Binomial distributions. Mean, median, mode and standard deviation. Conditional probability and Bayes theorem. DIGITAL LOGIC : Boolean algebra, Combinational and sequential circuits. Minimization. Number representations and computer arithmetic (fixed and floating point). COMPUTER ORGANIZATION AND ARCHITECTURE : Machine instructions and addressing modes. ALU, data‐path and control unit. Instruction pipelining. Memory hierarchy: cache, main memory, and secondary storage; I/O interface (interrupt and DMA mode). PROGRAMMING AND DATA STRUCTURES : Programming in C, Recursion. Arrays, stacks, queues, linked lists, trees, binary search trees, binary heaps, graphs. ALGORITHMS : Searching, sorting, hashing. Asymptotic worst-case time and space complexity. Algorithm design techniques: greedy, dynamic programming and divide‐and‐conquer Graph search, minimum spanning trees, shortest paths. THEORY OF COMPUTATION : Regular expressions and finite automata. Context-free grammars and push-down automata. Regular and context-free languages, pumping lemma. Turing machines and undecidability. COMPILER DESIGN : Lexical analysis, parsing, syntax-directed translation. Runtime environments. Intermediate code generation. OPERATING SYSTEM : Processes, threads, inter‐process communication, concurrency, and synchronization. Deadlock. CPU scheduling. Memory management and virtual memory. File systems. DATABASESER : model. Relational model: relational algebra, tuple calculus, SQL. Integrity constraints, normal forms. File organization, indexing (e.g., B and B+ trees). Transactions and concurrency control. COMPUTER NETWORKS : Concept of layering. LAN technologies (Ethernet). Flow and error control techniques, switching. IPv4/IPv6, routers and routing algorithms (distance vector, link state). TCP/UDP and sockets, congestion control. Application layer protocols (DNS, SMTP, POP, FTP, HTTP). Basics of Wi-Fi. Network security: authentication, basics of public key and private key cryptography, digital signatures and certificates, firewalls. GATE 2021 Computer Science Exam Pattern Duration : 180 Mint Negative Mark : 0.66 SectionNo. of QuestionsMarksMarks/QuestionsTotal Marks General Aptitude5 55 51 25 10 Technical, Engineering, Mathematics25 3025 301 225 60 Total65  100 #GATEComputerScience #GATEComputerScience2020 #GATEComputerScienceExam #FreeTestSeries #QuestionsBank #GATEComputerScienceSyllabus #OnlineTestSeries #OnlineMockTest #ImportantQuestionPaper #ImportantQuestion #ImportantQuestion
0 notes